I have an order detail table....when you select the catagory combo box the product combo box should update with the relevant products in that catagory.I have used the following code in the afterupdate even
Private Sub cbocatagory_AfterUpdate(
   Me!cboProduct.RowSource = "SELECT ...

I'm trying to Query for a condition and eliminate matches
in a second query.  Can't seem to get the unmatched query
to work.

Hey all,
If anyone's interested, I'm selling a complete copy of Paradox 2.0
with all disks and manuals plus a reference book entitled "Using
Paradox" by George Chou.

I have a basic problem that someone must have had to work through before.
I had Microsoft Office97 Pro installed on my Dell 2650  under Windows XP
Home.  Did absolutely nothing fancy other than to insert the CD and do the
autoinstall.  Worked fine.  Had a too-close of an encounter ...

I have an old version of MS Office 97 Developer Edition Tools (ODE).
The version was designed for Windows 95/NT. I assume therefore that
the runtime version will only generate code suitable for these OS.
Questions: 1. What are the implications/side effects if I were to load

I am trying to import a text file pipe delimited into
access. I have set up a specs in the import bit in access
but it only allows up to 255 fields....I have 369. Does
anybody know how I might get round this. There is not a

I would like to fix it so that I can permanently change the way in whic
the information is sorted in a subform.  
Each time I review a record I have to sort my subform by one of th
columns.  Since I would prefer that the data always be sorted by tha

I have several yes/no fields in a table, and find that I can't change the
display size of the check box.  It is much smaller than the letters in the
other fields.  I would like it to appear in a box the same size as the other
boxes  (same height).  Can I do that somehow?

I've been working on  an Access file and I didn't have any problem opening it and working on it in the past,  but now  I can't open the file at all,  it's giving me an error message stating "unrecognized database format."  Do you have any suggestion on how I can fix this problem.

Is there a place online..or even a library book that has
projects in order to practice more than just the 2 or 3
projects given in the text book?

Could someone help with what I am sure is a simpe string function?
I have a table with values that tend to fall into the falling three kinds of
formats in the field keywords:
1) xxxxx- xxxxxx - xxxxx - xxxx

I use A2K
On a frm, I have a cmdBtn that goes to the next rec OnClick.
What is the vba needed to account for what happens when the last rec is
reached

Using 04/03/04, 23:00 and 04/04/04, 23:00 as the dates.  How would I get this to read in hours, I tried setting the field format to short but then I get 0:00.  The format that I have used on the date fields is:  mm/dd/yy", "hh:n
Dim strdate As Dat
Dim enddate As Dat
strdate = Me ...

I have a form that tracks a newborn's weight in Access 2002. Could I get
suggestions about how best to create my fields so I can do a calculated
conversion. Traditionally the nursey will log it as pounds and ounces so do
I write two fields with pounds then ounces? If I do that how ...

I need to upgrade my notebook to ACCESS 2003, but I still have a few MS
ACCESS 2000 MDBs that need to stay in version 2000 now. Is it possible in MS
ACCESS 2003 to open and make changes on an ACCESS 2000 mdb and still be able
to save it in ACCESS 2000 version ?