**SORRY, NOT TRYING TO DOUBLE POST!
THIS JUST SEEMS LIKE A BETTER PLACE TO ASK THIS**
I have a form with three main components:
1) A listbox of employees. (this list is collected from a different form)

I have the following code
MsgBox "Please select a Form or Report", 64, "Incomplete Request"
I would like to put more text in the message but I want it on two lines
rather than just 1 long line.

I have a bit of a perplexing Query that I am trying to put together,
hopefully you may be able to shed some light on it!
Ok here is the scenerio......I have a mock hotel database, the four fields
are CUSTID, TRANSACTIONDATE, ARRIVAL, and YEARUSAGE. What I am trying to

Hi.  I am using Access 2003.
I have a text box that is populated by the user with a date.  After the date
is updated, another date in a different text box is calculated based on a
number of select statements.  The calculations work fine.  However, when a

When I try to run a section of VB code, I get an error that I don't
understand, since I am not asking it to look in another file.  Here is the
error:
Could not find file "C:\....\tblFUTURE_AUDITS.MDB"  

In my database, I’ve built a main form called frmVIEW which is linked with a
sub form called sfrmDUP. In the frmVIEW, it shows one record in tbl_FileInfo
in a time (a singular form), and two important fields are included to be
shown:

I was given this code to allow me to add a new record and add seven days
from the previous record.
With Me.RecordsetClone
    .AddNew

I have this code that was used to insert fields from a form to a table, when
I click on the button to add the data to the table I am getting an error
"Error in INSERT TO Statement"  
I have copied this code from another form that it worked in, just changed to

This is a question I asked yesterday:
I have a form with three fields; "Loan Amount", "Amount Outstanding" and
"Available Funds to Disburse". What I need to do is this:
If the Loan amount fields shows $500,000 and Amount outstanding is $100,000

I have a Query that works, however I want to replace Query 1 with what
Query 1 actually is in this SQL statement.  How would I do this?
This Query 1 in SQL
SELECT MenuDetails.TerminalID, MenuDetails.StartDay, MenuDetails.MenuID,

I would like to ask if it is possible to remove the blank record at the
end of a continous form.  I.e.using the example below:
1     Data1-1     Data2-1     Data3-1
2     Data1-1     Data2-1     Data3-1

I found this code on Ken Snell's website, which is great for use by one of my
clients, where the user can scroll to the next employee, using this format.
Works great, however, I would like to add some code, where, when the last
employee has been reached, the arrow gets ...

I'm trying to populate a contiuous form based on a filter; however I
would like the filter to be based on the filtering of muliplie fields
(i.e. return records based on Field1 = Value1 and Field2 = Value2).
How would one perform this via SQL command and visual basic.  Does

I have a module containing a public function named FaxText that evaluates
vendor data regarding CertificateType, ExpirationDate, UpdateRequested, and
so forth.  If a certificate's expiration date is coming due, the code
generates an integer (intStatus) of 1.  If an update has ...

I’m pretty sure my problem is syntax.
MainForm is frmRHCF1
SubForm is RHCF1
Control on SubForm is Unit