Can someone tell me why i can't find the record source from text box
under properties?
The reason is i want to select a query source for my unbound text box.

I have a table «Customers» linked to a table «Zip Codes». The idea is that
when I enter a zip code in the Customers form, it gives me the respective
city from de «Zip Codes» table.
When I add a new record to the Customers table, and if I close the form

Help!  I am using a command button from a subform to open form and I am
getting an error.  It says "the table tbleActivityNote is already opened
exclusively by another user, or is already opened by the user interface and
cannot be opened programically".  I have this same concept ...

I have a form (MS Access 2003 frontend) that had worked well before and then
now when I open that form, suddently there is an error message pop up,
"Undefined function 'date' in expression". I have another database with
similar designing that works just fine!

hi..
   im having a hard time making a database system using only full access..
im not allowed to use any VBA codes.. now im having difficulty on calculation
fields in a form.. it is said that calculation fields are not stored in a

Got following problem:
I have a form to insert data. (= creates new records)
I have another form to search existing records.
When a record is found, I select and open it to edit it.

We have a form in a database for viewing records.
If Records -Data Entry is clicked, we get a blank form to enter data, and
the record count shows 1 of 1.
However it seems impossible to get back to the normal view. If the form is

I have a text box entry where the month, Day and year "OTDLdaTe" in required,
but after reviewing the data in the table I noticed that the year entry may
be incorrect. What could one do to the text box to make sure they year entry
in the OTDLdate text box is that of the current ...

How would I make this happen?  I have two tables, Company Information, and
Products.  On a single form, I want to have two command buttons that will
filter these tables.  One will filter Company information, and the other will
filter Products.

I am attempting to assign a default value to a field on a form by using the
following expression: =[Forms]![FormName]![FormField]. This expression is
designed to return the values: A, B, C, D, E, or F depending on the active
field on another form from which it is getting this ...

I have a table like below
Date, Qty
1-Jan, 10
2-Jan, 10

Can we multiply two fields from two different forms without using a query.
Example from one table the value and from the second table the VAT(in order
when the VAT changes
to amend only the VAT field)

Is it possible to have the new entry in a subform be on top of the page
instead of the bottom
?
Any help appreciated.

I have a combo box that queries from a table of people to get a list of names,
ordered lastname, firstname, peopleID.  There are several people in this list
that have the same last name, and no matter which person I choose with that
last name, Access chooses the first person with ...

I have a program where my Access MDB creates a new MDB file and
exports certain into it.  It then sets a database password and some
other features.  The user needs to fTP this file to a designated
location.  Currently we have the users opening up WS_FTP and doing the