In my form i have Beginning Mileage, Ending Mileage, Total Daily Mileage. As
of now I have to enter Beginning Mileage, my Ending Mileage is =Nz([AR],0)+Nz
([LA],0)+Nz([TX],0)+Nz([MS],0)+Nz([OK],0)+Nz([Other])+[Beginning Mileage].
my Total Daily Mileage is =Nz([AR],0)+Nz([LA] ...

I am lost.  Please direct me.
In the Microsoft Access 2007 Help, under Access Developer Home >
Access Macro Actions > OpenForm Macro Action the following reference
excerpt exists:

I have a macro that runs several appencd queries once a command button on the
Switchboard is clicked and updates 5 separate tables with "current" data.  
Although this database in only used by about 4 people overall (and mostl of
the time by only one person),  there is a distinct ...

Is it possible to show a Form Header on a Datasheet form ?
Thanks

Hello.  I have a  field in a form that I want to check whether it is a
hyperlink or not.  I was thinking I could just check if the string
contained "http://" or "https://", but I could not find a way to see
if a partial string is contained within a string.  I have been

I have a database that generates work orders of tasks that are performed at
certain frequencies. For example, check oil in truck - frequency every 4
weeks. How do I create a report (in form of a work order) that will print
automatically when that date comes up?

I would like to create a form that has button on it that when clicked will
populate another form with generic text. ie. when a button is clicked it put
a set of data (sentence) into another form. can this be done???

I tried compacting and repairing my database but lost my connection to the
network where the database is stored. Now when I try to open it, I get an
error saying "Not a valid bookmark."
What happened and how do I fix it so I can use my database again?

I have an excel spreadsheet that people fill in with their order and email to
me - they either do this as an attachment or some put it in the body of their
email.
It would be great if i could put a button on my access order form which

I have a Product table with fields Oldcode and Newcode.  Now I need to
replace the ProductCodes in the Order table, the old Codes with the
corresponding New codes.
How can i do this other than tediously using Find & replace?  Is there a way

Hi All,
Please assist, when it comes to statements i am an idiot.
I need a statement that will add values together in a textbox.
It goes like this...

I am trying to export a file to .txt using TransferText.  My code
looks as follows:
<snippet>
DoCmd.TransferText acExportDelim, "Query1ExportSpecification",

Dear Sirs,
I have two select queries.
I would like to combine the data from this two, into one query (something
like merging the data) - query 1 + query 2 = query 3

I just created Supplier Invoices tracking database. It works ok, but now my
people said for one particulair supplier he can not see anymore all invoices
that he had input.  Invoicetable is linkied to the supplier table. What I
suspect he did, is because there are 2 suppliers with ...

I have created a reoprt that uses a memo field. The problem I am having is
that not all of the text in the memo field is showing up in the txtbox of the
report. I have set the properties of the report field (data source
qry!memofield) to can grow "yes" and have made the text ...