Hi, I am very new to coding in MS Access/ VB Code and I need help binding
controls on a form to a table. Hence, now my controls are unbound. I've been
trying from the property of the control- ControlSource so that when I hit the
drop down arrow I get fields to bind it too. When I ...

I'm trying to build a query that pulls information from a form
On the form, there's a text box that I would like the user to type in "<3000"
for example. How do I build the query to pull this in as a criteria?
For Example If the user types in "<3000" into the revenue text box,

downloaded a Access 2003 template for orders management and recv'd the
following error--- please help.
"Access can't find the database file 'c:\users\scott\documents\orders
management database.mdb"

I have imported a table from excel called IMPORT. It has a column of
reference numbers and a column called ASIN
My existing database is called Rec,
I need to add the ASIN column from my IMPORT table to my Rec table.

I am trying to create a file of orders received by email. I've got a program
that strips out the text of an email and stores it in csv format. When I try
to import that into Access, it creates separate records for each bit - ie
when the line ends (carriage return or line feed). ...

how to execute a subroutine on a subform?
tried this and get errors:
Me.frmFreezerInventory.Form.FillSlots(0)
is there a way to do this?

hi to all.
firstly this is my first db in access since i was at college 9 years ago -
and access has changed greatly! so im confused hehe
all i need to do for this first simple project is to create a form that

I'm having a heck of a time here trying to sort some code out in an attempt
to convert a few VBA modules from 97 to 2003 and compile them.
At the moment I'm getting this error:
Error: Object variable or With block variable not set

I have a form that has a subform (datasheet).  One of the columns in the
subform is the date field from the underlying query.
When I click on the date column, then right-click, Access "encountered a
problem" and crashes.  I have tested this on a variety of sample dbs, and it

I have a C++ application that I am porting - switching from using SQL Server
as the
back end to using a local Access 2007 database. The API is ODBC. I was able
to do

I'm having a problem with a PrintOut command in my application.
The following code works correctly until I add the arguments for printing.
DoCmd.PrintOut works until I add acPages,1,1,acLow,1,False -
Then I get an error message saying the application can't find the form

I need to set up a tracking system for Firefighter Certification Classes. I
have a "Firefighters" Table; Classes Table; Certification Table. Each
firefighter takes many required Classes to achieve a Certification. There are
many Certifications that each Firefighter is in the ...

I recently inherited a new client with an Access front end to mySQL data.  I
am a long time developer in many languages but this is my first real need to
understand Access.  Can someone recommend a good reference book for Access
for an experienced programmer?

This is so easy in excel and I cannot figure out how to do it in access

Being new I have a basic question. In setting up a table that includes
addresses should I set the default value to "unknown" (or some other default
value) if a complete address is not given? For example, some address will be
provided without the county or without a second line ...