I recently was put in charge of a database someone else did, and since then
has left.
I'm confused as to why this person did this. There is one table that is
basically the main table or parent table and then there is a child table with

All of a sudden, the combo boxs in all my Access 2003 forms stop displaying
data. They open, but no selections are displayed. They worked until a few
days ago then stopped. They still display properly in my 2000 version. Any
ideas as to why?

I'm using the following code in the onCurrent.  I would like to check if in
field aaa the value starts with NP-66 then label403 be visible.  Can anyone
provide me with the correct code?
Thanks.

I use a Microsoft XP Professional computer and foolishly deleted some
important pictures.I hope some one can tell me how to restore them.

I have a table of 5 columns whereby field values are either positive,
negative or level. I've constructed a query whereby the results are then
converted to either "P" for positive, "N" for negative or "L" for level.
What I want to be able to do is count all of the "P"'s in say ...

I recently posted about problems displaying TIFF files on one or two
computers using an Access application. I was advised to source and
install the Office XP version of the Office converter pack, which I did
and successfully used on a PC which was exhibiting the symptoms despite

I have a record in one table on my database with #Deleted in every field.  I
have tried to delete the record in table datasheet view but when I open the
table again, I see the #Deleted.  I have looked at linked tables, but cannot
find where any other related value is.  I am using ...

i am trying to write some code that will open a table and filter it (in this
case all apps where the date in is >=01/01/2008
like this
Public Sub filter()

I need to obtain a total for a group of people with 2 criteria.  I need to
find the grand total of people in on a certain team if they are currently on
the treatment.  I wasn't sure how to just exclude people who are not on
treatment, so I have an option for treatment where 1=yes ...

I have been using Access for years as just a simple customer database (name,
address etc), with some queries to sort by state, club members ec.
I have heard that you can do invoicing using Access, but I can't find any
basic information on how to do it.  I have no idea!  Is it ...

I am using Access 2007 and normally it works perfectly. The Microsoft Office
Button has all the normal commands on most daabases. But when I open one
particular  old Access database (I believe it is 97) the MOB only has Close
and Exit. Any suggestions?

I made a form using the wizard and as usual everything was entered as text
boxes.  I want to change one of them to a combo box.  I used the 'right
click'-'change to' feature, but when i try to see the box options it is just
blank.

i have an access 2003 database created on xp that i have put onto 2 seperate
vista machines. the database being in mde format. when i delete the old mde
file and replace it with a new mde file with the same name. the old deleted
file always opens. im unable to replace the old mde ...

Danny Seager was kind enough to show me how to link an Access table to MS
Exchange to get Display Name, Alias, and a few more fields from our exchange
GAL by creating a linked table of type=exchange.  One field I can not seem to
get is SMTP address (the one you get if you double ...

I developed a Access 2003 project with MSSQL back end.   I made a ADE file to
remove the code on the copy that is distributed to client workstations.  
Users who are not administrators on the local machine receive an message when
opening the ADE file: