I would like to set up a macro to require data entry.
I have a form that has Main form and sub form.
One of the fields that located on the main form is CALL (yes/No type)
One of the fields located in the subform is CALLDATE field. It is wonderful

When I open a macro I get an error message saying
"The macros in this project are disabled. Please refer to the online help or
documentation of the host application to determine how to enabl macros."

I currently use the transfer text action in macros to import delimited text
files into an Acces Database. What I am trying to do is setup a macro to
transfer or export the information from those tables into dbIII files. Is
this possible???

I want to wrote a macro using VBA in access such that it opens a word
file. How I can do it?
Surena

I have an Access database with a visual Basic module run by a macro.
The macro runs fine until I use the VB editor. If I just open and close the
VB editor
I get “Run Time error 13 Type Mismatch” on the following line.

It seems that the command prompt runs along BUT the rest of the macro keeps
executing rather than waiting on the command prompt to finish.
Is there a way to force the command prompt to finish before the rest of the
macro executes?

I really need your help now.. I have got form with tabular view.
I generate the code below and test it, what is happened is that the form only
count the val for the first row only.
I think I should use LOOP, but I don't know how..

Hi there, have a batch file I have created that when I open through Windows
Explorer, it will launch a programme and write the export files.
How can I get this batch file to run as part of a macro to automate the
batch process, have tried loads of ways, but no joy.

I need to write a macro that will delete records from the output of a query,
based on the value of one of the fields.  
The main problem I am having is that the criteria for deletion is over 2700
'things' long.  Is there a way I can compare the value of the field to this

Can someone tell me what the VBA is if I want to start off a compact and
repair. I want to put it behind a button on a form.
Thanks for any help
Dave

I want to create a macro that will upon double-clicking a control.. set the
value of the control to Todays Date.  I want to create ONE macro that can be
called from any control that I assign it to.
In the macro window I think I want to use the SETVALUE action.

I have aprrox 50 queries that all have one field on common (Division). I need
to run each query for each division (10 of them).  Fortunately, I was ably to
write VBA code in Excel that automatically runs and down loads the queries to
an excel sheets. Unfortunately, each time I ...

I would like a report to be sent to the Top Management at 9.00PM Daily
without anyone running the Macro. I had already set a Macro for Sendobject.
But, the report is sent only when the Macro is run. I want to run it (send
the report ) on a daily basis at 9.00PM automatically. ( ...

Suppose I have numerous tabs in a spreadsheet and let's say one is call "Co
1".  If another tab has Co 1 in cell A1 and Co 2 in cell A2.  If I am in cell
B1, is there a way to use the contents of cell A1 to link to tab "Co 1"?

I'm using Access 2003. I downloaded the Issues template. When I open Edit
Contacts and attempt to select a report by double clicking a specific report
for that contact I get an error message that "Issues can't find the macro
1stReports: On Dbl Click in macro group View Reports ...