I have a database with lots of products, and i would like to have a form for
each product with the correspondent picture.
each product as a unique ID and the .bmp file has the same name.
For example:

I need to assign a value from a table to a declared variable in VBA (a
declared variable "Number" takes on a value from table X) It's probably not
hard, but i'm confused about the syntax

I am an access novice and would like to create a validation rule for an
email address in Access 2000.
Is there any one out there that could help me??
Your assistance is greatly appreciated.

I have a form that I would like to add a sort button to. I tried the command
button wizard but I did not see any choice for sort.
What is the best (easiest) way to make a sort button that I can put on a form?
Thanks

I ran in a problem when executing series of queries.
   Dim Cnxn As New ADODB.Connection
   Cnxn.Open CurrentProject.Connection
   Dim lngRA As Long, lngOptions As Long

happy thursday. SQL 2k5, access 97
I am in the process of migrating my db to SQL. FE is currently in A97.
I created a stored procedure identical to my query, except the query
has a parameter of report month as mmm-yy. Now what is the easiest way

I've got a query and I am trying to find and remove duplicates from it with
another query.  I used the wizard to do it, but its not working properly.  
Any thoughts on how I can make it work properly.  My initial query has 2
columns of data (player 1 and player 2) and I'd like to ...

I share MS Access 2000 over a windows 2003 server.
If a MS Access db is opened up by another user the only way I can open
it at the same time is by opening the MS acesss program then use the File >
Open option.

I need to be able to round values to this specification using vba in Access2003
As the law requires that £0.005 or less is disregarded, we only look at the
third
decimal place in calculating NICs due where such calculation results in more

I used to know how to do this in Office 2003...But I am using Access 2007 now
and when my db opens, it goes dirtectly to the Switchboard.  How can I get
out of the Switchboard and go to the tables, queries, macro's, ect???  Sad
thing is I developed this db a few months ago!!

Do any of the VSS versions integrate with Access 2003?
I was using the VSS 6.0 add-in tools successfully, but for some reason it
has stopped working (no SourceSafe items in Tools menu any more). I've tried
uninstalling Office, reinstalling Office and VSS add-in tools, no luck.

How can I construct a Query in order to replace all the records from
my Tbl TempInfo_Tbl:
DIR Dups V.1.0\
DIR Dups V.1.0\bas\2006\

I'm working with link tables that have a connection in the ODBC.
when I change the DB I want to work on, in the ODBC. I need to go to "Linked
Table Manager" and then select all the tables and choose
"Always prompt for new location" and choose the ODBC connection I did

I'm designing my first database and have run into the following problem;
In a report I am designing I would like to have a calculation at the end of
the report that multiplies a sum that has been calculated in the same report
with a value that has been calculated by a specific ...

where is compact and repair database in access 2007?
Pat Cantey