I purchased a new Compaq computer with Windows XP Home Edition. I installed Microsoft Access XP. Things worked great. It then became necessary to upgrade to...

Hi all I am developing a client management database and I have several command buttons set to open word. What I need is for the buttons to open word directly...

i have a one to many relationship for a customers and orders table. how do i get the last entered order for each customer

I would like to use a QBF in which I only need the basic functionality of the Autofilter in MS Excel, nothing more. The people using the database will...

My Access books do a pretty good job of telling you how to design and create a database from scratch, using lots of tables, primary keys, etc. I've found that...

I am a new MS Access user. Previously, I used MS Excel for several years. Ever since I was a kid, I needed to "visualize" almost everything in order to learn...

Thanks in advance I am trying to set up a tracking database that needs to track several stages. Each stage captures the same type of information: Stage1 =...

Hi all, When designing forms, is it best to based the forms on queries or directly with the tables? Thanks

I'm trying to import a csv file, however, I cannot use comma delimited because there are commas in the product descriptions (Not sure if this matters). ...

Hi all, Is it possible to open a form based on a main form and subform? I have a main form with a subform (in datasheet view) and I need to have a third form...

I'm trying to retrieve the autonumber field after an insert and have tried the following different versions Set objRecordset =...

Anyone know how this is done. When my db is opened, my mgr would like our company logo to appear. I've seen this before, years ago, where you embed a...

I have the following piece of code trying to pass 3 parameters to a query but get the error message 'Object Variable or With Block variable not set' on the set...

I'm trying to create a recordset based upon a query called QueryAv that is a SELECT so that I can then update the records. What are the declarations and...

If I create the following query and run it I get no records: SELECT AVAILABILITY.BookingDate FROM AVAILABILITY WHERE AVAILABILITY.BookingDate=#07/09/2004# ...

If I have a query such as : PARAMETERS NEWID IEEEDouble; UPDATE AVAILABILITY SET AVAILABILITY. = NewID WHERE (((AVAILABILITY.BookingDate)=Forms!!BookingDate)...

I'm trying to do something like the following but keep getting error messages like type mismatch. What should this look like? Dim rs As ADODB.Recordset Set rs...

My update isn't updating the table. Why? Code is: strSQL = "Update AVAILABILITY " & _ "Set AVAILABILITY. = " & varNewID & _ " WHERE AVAILABILITY.BookingDate=...

With regard to the following code it doesn't update the table: strSQL = "Update AVAILABILITY " & _ "Set AVAILABILITY. = varNewID " & _ "WHERE...

Hi, On my form I have one field of "City", and this in turn needs to effect "Township". When township is selected, the next field is distance, and for every...