I am using Access 2000 and I'm trying to have the City and State fields
auto-populate from the Zip Code Combo box linked to a table with prefilled
data. I would also like to know how to have the table update with new Zip
Codes when I enter a new one.

I have a sub form that I would like to put a cmd_btn on so that the user does
not need to copy data from the parent form.
I would like to copy the following from the parent form:
Form: Dep Loss add

(also posted in the Access forms newsgroup)........
Hi,
I have a form that, on startup, runs code that imports data from a dbase
application.  Because we use the dbase for order creation, and the access

Hello! I have inherited a DB containing dates as nvarchar 50!! Is there a
function to convert this to a genuine datetime datatype?

I have the following code behind a Command Button that is supposed to:
1)  Save the current record
2)  Open a different form
3)  Allow me to enter a New record on the form opened in #2

Hi I have the following which works but it will not put in the vehicle make,
it just puts in the model.
What am I doing wrong?
Private Sub Registration_Number_AfterUpdate()

I need to create a sub form in code - depending on data displayed in my main
form. I'm new to Access and VB

I have successfully used the method at:
http://www.mvps.org/access/api/api0001.htm
to create a browse function for my form.(User can browse to find the name of
an image file he wants to include in the table the form is based upon.)

One of my columns in a list box contains numbers. I want to show them on the
form 526 250 and not 526250,36. Is it possible to get the numbers to look
"proper"?
Thanks Wayne and John for beeing helpfull on my recent post regarding

I have an application where a Files name & Path are stored & then have the
ability to have a User open them.
First I was using Application.FollowHyperlink & it works fine except
sometimes I get the following Default Access Msgbox

I have created a form called frm_GrantPot with
tbl_GrantPot as the record source.
The form consists of the following fields:
GrantPotNumber, GrantPotName, AvailableGrant,

Under the Properties>>>Control Source for field Test under table 2
this is what I have given
=IIf([table1]![field5] Like [field4],"OK","CHECK")
What I need is that it should check if both fiedd from Table 2 and Table1 is

I have a scheduling form which has several unbound controls so the user can
identify the schedule they want to work with.  Due to the "crosstab with
extras" nature of the scheduling process, I've resorted to using a temporary
table and a Save button (hangs head in shame) that ...

I have a cboordertype that I use for my orders, what I want to do is that
when "Program" is selected from the cbo box, a field designname become
visible, else visibility = false.
Any ideas?

I have a tracking database.
The main field are  Requestor Name and how may Tapes.
The user has an excel spreadsheet with a list of tape numbers in one
column. He wants to make sure that the list matches the requestor name  on a