I'm fiddling with a function and I'm encountering something strange - what's
going on?
It seems the decimals are off.
Function MyRound(sngNumber As Single) As Single

Is there a way to run a query when a table is closed.  I know information
should be added throught a form, but necessity dictates adding right into a
table at this time.  I want to run a check duplicate query each time the
table is closed.

Hi...
If I copy a query manually (by selecting it in the Database Window, then
Ctrl + C), I can then paste the results into Excel by simply pasting. Is
there a way of doing this from VBA- e.g.

Does anyone have a good equivalent routine to the excel Days360 function?  I
am using Access 2003.  Thanks, John

I have a dat file (which I am changing to a txt format before import) in
which the customer sends date fields in the following format
061231061201
This is two dates 12/31/06 & 12/01/06, Unfortunately it's in European

To all,
I'm working on automating data from a query in Access to Excel and having a
difficulty in formatting the data.  
Basically, I want to display any zip code that begins with zero as a text in

I have a form that I enter a date and click an Ok button.  Once that button
is clicked another form opens that requires data.  After that data is entered
a button is clicked that starts the macro which runs for quite a while.  
While that macro is running, I want the date to show ...

I'm making a sales and invoicing system, but I'm struggling with the credit
notes.
So far, I have set up the sales orders and sales order lines in two separate
tables.

I have the following code that allows the user to select items in a list box
and show them in a text box.  However, if the user comes back to a record and
wants to add additional names to the text box, it clears out the previous
selection.

How do i use a SQL Server Scalar-valued function in MS Access ADP?
I have a function "fGrantAccess" in the SQL Server Database and i would like
to use it in an Access Project.  The function returns a GUID from a table
depending on two parameters: user id and password.

I wanted to write a module to split a rather large table into multiple
smaller tables.
i.e. source table has 200.000 records, and I want to split it into tables by
blocks of i.e. 10.000 records.

I have an after udpate event that is supposed to write the updated value to
an audit log.  The code does update the correct record, but it updates it to
a time field.  For example, the updated record should read 8/1/2007, instead
it reads 12/30/1899.  If I select that field, the ...

Forgive the potentially duplicative question, however, I feel it is unique.
I appreciate all the work done by Steven Lebans and his Browse CallBack,
however, in order to prevent errors, it must reside in the form.
I have many forms and it appears I must have lots of duplicative ...

Public Function Comando001_Click()
Dim mySQL As String
mySQL = "SELECT Numerario.Numerario FROM Numerario WHERE
(((Numerario.Data)=Date()))"

For several months I have used a database I will call DB1 on my own drive.  I
also have an Excel report that imports a query from this DB and all was
working fine.  I copied DB1 and the Excel report to a Department Folder on
the shared drive so others could run the report.  When ...