I have a cell of product numbers some delimited by carriage returns but it
also has stray commas.  I need to get rid of where in the access macro it is
putting the comma in the product number cells.  I want the program/product
numbers to be delimited by just a carriage return.  ...

I have a batch file which runs a macro.
Due to security issies, the macro can not be run until I confirm a security
notice on opening the access file: "Secutiry Warning: This file may not be
safe if it contains code that was intended to harm your computer. Do you want

I have been able to get the query results to export to the desired file path,
but when I go to open it I get a dialog box "Windows cannot open this
file"..."To open this file windows needs to know what program created it"
I specified in the OutputTo action to use Excel

I am using Access 2003 and have a report I need to generate in .html format -
which I can do - but it is one page at a time with a Next - Previous etc at
the bottom of each page - and I don't want these end of page breaks.
I have a macro generating the report but the format is ...

I have the following macro attached to a textbox used to find records in a
database.  It's used as a condition to display a msgbox if there are no
records found.  The condition reads:
    [Last]<>([txtSearch] OR "*" &[txtSearch] OR "*" &[txtSearch]&"*" OR

I'm creating a process to compare like data from one month to another by
building a table for each month to compare one to the other. There are
multiple fields that can change from month-to-month. How can I return only
rows where one or more of these fields has changed from one ...

Report open event:
Macro1 runs. It brings up a form for a client ID range.
I have Macro2 that should bring up a form for a DATE range in the same
report.

I have a macro which use several RunCommands with different command arguments
Two of command arguments are disabled (greyed)-- OutputToText and
OutputToExcel when running application. But, They are available in the debug
mode. Is there any special permissions or settings required ...

I run a macro everyday which imports a txt file that goes through some
manipulation then exports out.  The problem is that the import file varies in
size so that macro run time varies as well.  What I want to do is add a timer
to the macro that records the amount of time the ...

I am currently using a macro to export a table as a .csv file and sending the
resulting .csv. Unforuntately the size of the .csv file is reaching 7MB our
internal attachment size limit. Is there anyway I can use a function to
winzip (or other comperssion) of the .csv file prior ...

I created a Macro that ran a few action queries and imported data (using the
TransferText action).  I had SetWarnings set to NO.  When I did a test run
the file to be imported was missing.  This caused an error message to be
displayed (which was fine) and the macro to stop (also ...

I have form which the user enters data into.  Upon clicking a "Finish"
button, a query is run which takes the information from the form,
queries it against a linked table, and appends the results to an
internal table.  The button also then takes the user to the next record

I have creaded a command button to run the following to export my reports and
save them each with a name in one of the fields.  It works but it comes up
with an error at the end because it tries to go to the next record and one
doesn't exist.  I need it to either stop at the last ...

By using TransferText Action running inside the macro, the text file will
have text qualifiers like this
"7412","000000","000000000","7612","29000","100","100","0000","000000","00000",0.00,0.00,5246380.38,0.00,"","",0,""
Is it possible to elimiate those text qualifiers like this

How do I convert text that is in all upper case to lower case with the first
capitalized