I posted this in the new users section but got no answer so I am also posting
it here.
I am in the formative stages with Access 2007. My output will be a DB
administered by me, used by about 6-8 other persons that are not

I am using 2 combo boxes that allow input on a form.  I am trying to set up a
query that that allows me to select a name and then a [between] date.   The
query runs the between dates but will not work for the name.  I am using  -
Like "*" & [Associate Name] & "*" - but it does ...

Is there any way to get the HD serial number (or any other data to identify
the hard disc) using API from VBA?
Thanks in advance for your answers.
Regards.

Can someone explain to me the benefit of an MDE.  
It looks to me like it's a one way street:  Develop an app, release it,
never do anything with it again.  You can't even get the data out for an
upgrade...

How to calculate new year date when the year from year 2006 to 2007, after
my Access 2000 program get new year date and automatically set var value to
0.
Thanks

I'm using Access 2007.  I open a file in C:\Student.  I close the file.  I go
to open another file and I'm looking in My Documents.  I want to be back
looking in student.  I don't want to change the default directory - it's just
that my work at the moment is all in a different ...

I have an Access 2000 DB that will need to be converted into SQL 2000. Is
there a simple way of just using a tool that will convert it? Or do I have to
recreate the tables than import that data from Access? If the latter is the
only way, is there a guide available that will help ...

Does Microsoft provide any avenue for upgrading an academic version of MS
Office to a retail version?

I am trying to make a database for invoices generated. Within each
invoice, is another table with the invoice details. Both tables are
linked. When a user enters data for an invoice, I would like the
subform (the invoice details) to enter the counter for each new

I used the code on the website: http://www.vbusers.com/code/codeget.asp?ThreadID=146&PostID=1&NumReplies=0
to have the user click on a button in the form, go through the files,
and select one image.
Now, the image the user selects, I don't know what happens to the

I have option buttons in my forms where the user can select either one
of two i.e. Confirmed or Dropped.
When the user selects one, the value in the table comes to either 1 or
2.

My company exports to different countries. So when the orders come,
the order currency can be US $, Pounds or Euros.
How can I set it that the user is able to select what currency the
order is in?

How do I create a report for the last created record? My DB has all
company's invoices and I want the user to enter the invoice details in
the form, and then go to the reports and print it. For a novice user,
having a whole bunch of invoices show up will soon lead to someone

I have never split a data base but have read several articles on the
web and I think I understand how to do it.
A couple of questions,
1. Do I load the font end onto all the computers that I want to use

My combo box has the following 3 columns:
FabricID (which is an autonumber), Pattern, Color
Typical data could look like this:
1, Plaid, Green