I created a database to track my travel expenses. One of the reimbursement
categories is mileage on my own vehicle. The reimbursement rate is not
static, it changes periodically. In light of that, while filling out my
expense form, I would like to click on a button and have ...

I'm a New Access Developer learning to create a Tracking Data Application
with MS Access with VBA. I'm stock with my project because I can't see any
result in my coding. Would you please help  to write a VBA code into Ms
Access 2003 to calculate difference days between days minus ...

I'm trying something new and not sure if I'm on the right track. I have an
unbound text box on a form and I'm trying a calculation in the AfterUpdate
event:
Private Sub BlankArea_AfterUpdate()

I have a form (frmVocalArrangments) with a button that when pressed
opens another form (frmDiscs) in data add mode - but keeps
frmVocalArrangments open.
On frmDiscs, when the new record is added, I have a "Return" button

I have a linked table to an SQL server.  If I save the record on my form with
a button and then try to edit more info I get the following error: "The data
has been changed.  Another user edited this record and saved the changes
before you attempted to save your changes.  Re-edit ...

In the following code, I would like to set the sub form but get an
application error with the second line. frm, frmsub and strTab are all
declared prior to this. What is the correct syntax? Thanks so much!!
   Set frm = Forms("frmBrMain2")

I am facing a problem after disabling the text box based on the value of
another text box.
The problem is the text boxes appear disabled or enabled based on the last
form selection of the text. I have used the following code for the same. And

I can't seem to find much info at all on this one.. I'd like to to
bind to a disconnected recordset on my parent form and use the chapter
to bind to in the subform. I thought this would acheive automatic
synchronization since navigating through the parent set filters the

In Access 2000, I have a multi-select list box on a form.  This list box has
3 columns, 1 hidden.
I want to execute a query that can select a criteria for the list box.  I
don't want to write the query in code.  I don't know hoe to write the

Hello,
  I was wondering if you guys could help me out. Im currently working in
Access 2007. I have a picture of my companies floor plan. What they want to
be able to do is click a workstation and see a Hardware inventory of that

I have a form that opens in Continuous Forms view. In the detail section is
a textbox called [stmt_datee], and in the form header is a textbox called
[recs] with control source =Count([ID1]) (ID1 is the key field from the
underlying table, so [recs] is a reliable count of the ...

What am I missing? Do I have the syntax correct?
Is there something required in the filter property of the form to be
opened?
The field [FileNumber] is the field on frmSearch to be double clicked.

One table out of 5 suddenly will not allow any additional rows to be
added to it.
Is there anyway to find corrupted records in Access?

In the following code, I get an error "type mismatch" on the last line where
I am trying to establish a new recordset. What do I need to change?
Public Function fblnRecordNav2(frmActive As Form, _
   intDirection As Integer) As Boolean

I have a form (Form1) in datasheet view that is made from Table1, and has a
field (which is the primary key in the table and is an autonumber) named
"ISSUEID".  This shows all the records of Table1.  
I have also created Form2 which shows a single record from table1( This also