Help needed.
I have created a master form (Employees) with a subform (Service Record).  
The Service Record subform has fields ServiceRecordID, EmployeeID,
DepartmentName, JobTitleName, DateStart, DateEnd, and WeeksService.  I want

I have a form for injury claims.  When I click a button to close the claim,
the form needs to requery to update all the closed claim information.  When I
requery, it brings me back to the first record instead of the one I was
working on.

Here's a diller, folks.
I'm passing a command line, "/cmd Demo" to an Access XP app.  In my startup
code I use a test like this:
If Command = "Demo" then

I'm working with a membeship database with a series of dates on it. I
want to create a list in a listbox of member's names based on the
dates entered. The list would then be used to select one individual to
display in a form with a subform showing rows from an associated table

Hi...
I have a need to save some text record in a file external to Access.  I
write them out, and read them back in again from different forms in my
Access application.

I'm trying to get hold of some mysterious behaviour when opening one
form (F2) from another form (F1). By doubleclicking in the first form
(F1) in a datasheet view subform (SB1F1) and attaching code to the
doubleclick event I open the second form (F2) and navigate to the

I am trying to base the text in a Textbox based on a Combobox selection. I
have the value of the combobox tied to a query I built in the query builder.
I can get it to display the first value i select, but it won't do anything
aftet this. I have tried requery commands in VBA but ...

I know I close. It displays the number of the first column which is the
autonumber. I want it to display the text in the field called FileLocation.
Private Sub CboFileName_AfterUpdate()
Me!txtFileLocation = Me!cboFilename

I have an event that I need to use to open a file as well.  Here is the code
and the file location is F:/MyExcel
Private Sub Command63_Click()
On Error GoTo Err_Command63_Click

I have a main form (frmManuscripts) with a subform (sfrmAuthors). If I
want to add an author to the subform then I click a button on the main
form which opens a new form (frmAddAuthor). When frmAddAuthor closes I
requery the subform.

I have a query which has the following in the SQL
INSERT INTO Atendee ( Person, Event )
SELECT FirstName+' '+LastName AS Person, Forms!eventgenerate!
cboselectevent AS Event

Hi... I have MS Access 2003.  I am creating a database (or attempting to :-)  
).  In the form screen, I wanted to make it so that when I enter the name of
a company (I already have the tables set up) in one area of the form, that
their information will automatically come up (i.e. ...

Using Access 2007.  Here's the code i have for the on_click event of a
comand button:
Private Sub OpenCustomer_Click()
On Error GoTo Err_OpenCustomer_Click

Does anyone have any information on where I can obtain a few courses
on programming with vba? I am 43 and do not want to change my career
nor enter into a 4 year degree. I have some basics with access and vba
and basically I want to enhance some expert skills to complete my db.

I have an access subform that used to have a recordsource of a SQL Server
View.  I am running into sorting issues with SQL Server 2005 and need to
change the view to stored procedure.  The stored procedure returns a sorted
recordset without requiring any parameters.  I change the ...