Is it possible to override menu functions with custom codes when there is no
database loaded in the Access window?

I need button1 to pop a function (fx).
for example : application.worksheetfunction.CountA
Thanks...

I need to write a if statment to compare to fields. the one field is in a
subform. I was told to use the following:
[me!]subformcontrolname.form!controlname
Im not sure about the syntax, can u please help.

The application has Access with linked tables(SQL Server) It has VBA code
that uses linked tables to select and do some calculation and update access
tables. Sql server accessed through DSN and queries are executed using
'DoCmd.RunSQL'.

Does someone know how to get all the table names of the current db ....
Thanks,
Gina

I've an Access db with a table that records the state of an electricity
meter on successive moments, say every last day of month. Now I want to
compute the electricity use over the months. In order to do that I have to
sort the records by date and loop through the table and ...

Would anyone know how to write a code to send a file to a "public folder" in
Outlook? The code would read:
Outlook.CopyFile "PathofFile","DestinationPath"
Any help on this would be appreciated. Thank you!

I have over a thousand record in table. i want to check from table and
extract the specify records to report. but i want to add one more field in
report for easier to read. The field could be automated gen. the number from
1 to end. Would you helpand teach me how to do it or code ...

Is it possible to retrieve the date an excel spreadsheet was modified outside
of Access using code? I want to use it for comparison in a function.

I have a form in Acces and have some textbox to enter date which will be
insert to a field with date format in Access. However, if user does not enter
date in date textbox (key in nothing) when I try to save Access table there
ia an error 'Type mismatch'. I think the error is ...

I am trying to access the fields in an access table, through an ado
recordset, (which works), but I am trying to loop through the filenames in
the table progamatically. The fieldnames are as follows...
Mon_type1

I'm trying to import a text file.  Here's a sample:
"89","000000","890828","01","PER","        .00","        .00","END="
"89","000001","890828","01","PER","        .00","        .00","END="
"89","000002","890828","01","PER","    2755.12","    2755.12","END="

Can I get Access (2k) to move 'down' a directory to where some of my files are,
then go 'back up', so it can go back 'down' into the next?  If so, how?
Thanks in advance,
Tom

I am trying to create a report that shows information on people assigned to
projects. They can be assigned either as the Assignee or as the Originator of
the project. I have one query that contains the project info (including both
the Assignee and Originator fields). The report ...

I should know this, but obviously I don't...
If I envoke error handling using On Error [Whatever: Goto, Resume, etc.]
is there a statement that I can execute which will negate the On Error
command? Once the section of code that the On Error handles is finished,