In MS Access 2000 I am trying to include a method that checks to see if
the Fiscal Year (FY) and Fiscal Month (FM) already exist in Table1
before it appends new data.  I was thinking that it should give the
user the option to abort the action.

I'm using Access 2007 and running into a problem with the combo boxes. I have
a combo box on form B that has three columns ID, First Name, Last Name from
table A. I'm displaying the First Name and Last Name and want to update one
field in table B with both the First Name and Last ...

I have a form I use for bank deposits and I need to show the total for the
deposit for that day. If I put the text box in the form footer it totals up
all the deposits in the table. If I put it in the page footer, neither the
label or text box shows up even though they are both ...

Let’s say there are a pair of date fields called ‘Printed’ and ‘Received’.
The idea is that when the user clicks the ‘Print’ form command, the current
date is entered into the former. When the form is circulated and returned to
the user, the user is expected to enter the date ...

This is my control source for a text box on a form.  Could you please tell me
how to add a title for each item?
=IIf([PV_NUMBER] Is Null,Null,Trim([PV_NUMBER] & ", " & [PV_GROUPNO] & "  "
& [PV_GROUPNAME]))

I currently have this code
ME.WD_FULL_HRS.VISIBLE = TRUE
ME.TX_FULL_HRS.VISIBLE = TRUE
ME.ITAG_FULL_HRS.VISIBLE = TRUE

I'm having trouble getting a listbox to requery.  What I have is a listbox
bound to a query.  Typically, when the user opens the form there are no
records to show in the listbox, so I hide it and display a text box on top
of it that says "No Records".  After the user runs some ...

How can I validate the data in an unbound textbox to not have any special
charactors but allow alpha-numeric?

I keep getting an "Object Required" error. I have very little experience in
VBA and could use some help.
Private Sub PrintButton_Click()
On Error GoTo Err_PrintButton_Click

I'm getting an error in the following code, which attempts to connect
to a recordset:
 Set rstReportPage1 = New ADODB.Recordset
 strQuery1Name = "qryResultsPage1_FormInput"

Hi Ppl,
Any1 knows a program that generate an EXE file from an Access form?
If anyone have a solution post here, plz!
My apreci@te!

Who can tell me where I can get the Windows "My documents" directory? Must
be somthing like stPath=office.system.path.....
Thx alot,
Ludovic

I have two tables called tbl Contacts and tbl Employees respectively. Both
the tables have fields called last name and first name. tble employees has an
extra field called e-mail which contains employee email addresses I would
like a query that would match similar First Names and ...

Good morning
Access 2003 (object=form)
How can I change the form view to datasheet view programmatically?
I mean, the form is open in form view and then, one click on the button and

I am trying to split a field called UserName into two seperate fields. The
field contains records in the following format Doe, John Where Doe is the
surname and John is the First Name. I would like to create two new fields in
Table called Surname and FirstName in the employee table ...