I have a placeholder  value that prints a row of text across the columns on
every spreadsheet for each department.    I want to comment out the code so
it deletes the row at the end of every sheet for ea dept without harming the
procedure that prints an Excel repport.   I found 3 ...

How do I create a macro that will run a make table query?

I have a loop within a loop in a macro. It is working, however this causes an
error if it loops more than the allowed 20 times.  I am not a coder, but may
have to do this with code.  Can someone help with code?  Or maybe I am just
doing this all wrong.  Need to run report for ...

I hope someone can help me, whit my problem.
There is an number field (User ise typing a price). I need a macro to
check if typed number is between 0-2000 or 2000-5000 or 5000-10000.
If it is between 0-2000 then = typed price + 1000

I have a field that for a number of reasons needs to be entered as FirstName
LastName in access. I have a second field which is the field that I use to
sort. Is there a way to automatically take the first field data, convert to a
lastname, firstname format, from which I can stick ...

I have some code that I want to use to "pause" my macro, and in the macro
designer I see where I can set a RunCode to call a function, but where
exactly do I put the code for the function so the macro can call it?
the simplest of frustrations... :)

I have a macro that calls a query that I need to update. The Edit Mode on the
macro is set to 'Edit' but no changes can be made... would someone please
advise what else I should check on ? Thanks!

Please Help
I am working with an Access database that was developed using Office 97 and
was converted to the 2002-2003 Access file format.  On this one form there
are 26 text boxes (representing yearly pay periods) and on the “On Lost

I have set up a macro to grab a cell from Excel and store it in a table. It
is the only value in that table. I now want to set up a macro that takes that
value, and applies it to a filter. I have tried using the ApplyFilter macro,
but have not been able to get it to function. I ...

I have a form for which I was trying build a button that would print the
selected record. I dumped the information into a report to make reading
easier.  The report narrows the information down, but the whole report prints
instead of the single record. I tried the GoTo Record ...

Hi again :)
Is it possible to create a macro that imports a file without VBA? What
I specifically want it to do is to let a user specify what file he/she
wants to import. From what I have noticed the macro "generator" forces

Hi I have typed this macro in my access database and didn't work. I just want
to know how would I do if I get any nymbers or 0 value for the feild  avarage
failed size.
(([Average Win Size]/[Average Fail Size," "])*((([Winning Trades]/([Winning

A2003
All my forms are maximised OnOpen - Dcmd.Maximise.
I have a Menu Form (Auto resized and centered) which can be called up from
the Toolbar. When the Menu is opened, it minimises all open froms.

I've created an AutoExec macro, that, eventhough I deleted the macro it
still loads upon opening my Access project. Any ideas as to how to
disable this "ghost macro" completely?
Tom

If I execute a Macro within another Macro will it return to the original
macro once complete?
Macro runs a Query, a macro, a Query, a Report.
Thanks for your help?