I have the following code in an Event Procedure in a "on Current" part of the
form.
I have two datasheets, one a subform of another where I select an item on
the first datasheet and information is shown on that item in the second

I am trying to use a field in a query to fill a txtfield when I open a form.
The txtbox is 'txtMaxRecordIntblEMEARepairs'  I have a query
'qryMaxRepairRecord' that is simply looking at a table and finding the max
value in a field called 'fldRepairRecordNumber' which is an Auto ...

Im trying to import a spreadsheet where the column headings are on row 2 and
the data on row 3+. I have tried (with no luck) the following:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9,
"BindersTaken1", Directory, True, "Binders$2:65536"

I have a database that has a couple of hundred fields, most are text but I do
have some that I want to set for currency.
Problem:  the currency input mask that access has is not what I need.  I
would like to just input numbers, then when I press tab, have those numbers

I have a form with clientid Lastname firstname (cLIENTS fORM). in this form i
have a select record commond button. wHEN I CLICK ON THIS BUTTON I WANT IT TO
OPEN THE dATA ENTRY FORM WITH THE CLIENTS ENTIRE INFORMATION. wHAT CODE DO I
NEED IN ORDER TO DO THIS

I recently found out about returning several values from a function using a
private type like:
Private Type ABresult
   A as string

I am using a custom DB property to control an expiration date of a demo
version of an Access app. In order to avoid errors, though, I must first
check to see if the property exists (before I attempt to set its value).
Currently, I am enumerating the entire properties collection ...

I have a report that I want to filter out certain records when the user
enters a specific number of a field in a table.  So far I'm at the
point where I can enter in which value that I would like to filter when
I open the report.  The big problem at the moment is that no matter

This is probably a simple question...all I want to do is to display the
current date & time (Now()), but just the numbers.  For example, 01/01/2006
09:20:33 AM would be 01012006092033
Is there an existing function for this. I looked around a bit but didn't find

Please see this example code:
Public Function helloworld()
   Dim hello(3) As Variant
   hello(0) = 24

I currently update a Receipt table with the following Query, where
TblReceipts has an AutoNumber field ReceiptNumber
INSERT INTO TblReceipts ( mem_ID, EntDate, FullName, Address, Amount, sent,
IssueDate )

I have a function I'm coding which copies two files from the server to a
location on the local drive, imports them into Access (I have to copy the
files because they aren't saved as .txt files on the network, even though
they're in text format, so Access won't import them unless ...

How do I test for the existance of files with a .txt in a given folder?
Thank you.

I have a query that produces membership information, used for posting on the
internet. If we run the query to export as HTML, the output is loaded with
HTML tags, that really aren't necessary. I can cut the file size by 75% by
removing these tags.

Good afternoon,
I'm having trouble getting my SQL Update Query to read a variable value into
the field specified (or any field for that matter).  This is my first Access
application in over a year (still working on the Vacation Planner, but have