I have a FE, BE database on my home computer and a duplicate on the office
computer. Both use Ak2 on Windows XP. The one at home appears normal.
The BE consists of about 50 tables with numerous relationships and the FE 9
tables (fixed set up stuff) + the 50 linked table from the ...

I have a form that is set to "continuous forms" view.
Several rows of data are shown to the user at the same time.
I want to set FieldX and FieldY to true and show them only if the
txtEmailAddress control is not null and contains an address.

Has anyone ever had experience with data moving from one record to another?
I have a form in which I'm using the FMS rich text control ("Total Access
Memo"). Several times when there has been an error (such as the user unable
to print, or other error), the user finds that data in ...

This is driving me crazy. I have a table called tblClients - very
simple, has the following fields:
taxID (PK)
ClientName

I have a form with a combobox and a list box.  I have many selections in the
list box (company names) and one selection in the combo box, Parent company
ID.
I need a query to stuff the company name and the parent company ID into a

I should clarify the I can iterate through the list box and get that part of
the query fine,  I just can;t get the value from the combo box into the
query as a constant.
Again thanks

I want to make my database read-only for the masses, and have a
(preferably single) password in order to unlock the database to be
used for that person in full Admin rights.
Any help you could provide would be greatly appreciated.

For software you build for others, do most of you sign your macros and
if so how or do you set macro security to low?
Bob

Probably a simple problem but i'm pulling my hair out!
I have 3 tables(Consultant name, hospital and medical department).
Consultant name is joined to the other two by their primary key. I want
to create a form with 3 drop down menus.

well I am trying to get around looking at all the buttons with a case
statement so I was trying this.
Public Sub looking(ctlname)
Dim ctl As OptionGroup

i have a database that users enter datai into
i am tempted to try and make this a web appliction
What would be the best way to go about this?
any ideas

I have set up an access database that I communicate with through Excel and
VBA.
The purpose is to do auditing of staff.
Because there are several audits, each audi has differing criteria to mark

I have a database that produces different "cuts" of data for the user
to export into excel. The database essentially opens queries using
different criteria to filter the data as the user wants it. The user
can then print or export to excel depending on the need.

I am trying to create a report that takes a value from the field on a
table as a group category. But
The value on the report takes an id number (auto increment, and the
first column) instead of second column.