I’ve inherited a database that auto populates a field by a macro that I don’t
quiet understand how it works.  The macro name is “input by” and here's its
definition.
condition:    [Forms]![Log_Form]![Input By] Is Null

I am importing a text file that has a  "<" at the beginning and a ">" at the
end of each data field.  The field lengths vary from 4 characters to 50
characters.  I need to find a way to clean up the beginning and ending
character of each.

I am trying to create a condtional macro that prompts a message and gives the
option of opening a form if the text entered in a particular text box does
not auto populate other text boxes (relational database) e.g. By entering in
a non-existing customer id, no customer details ...

I have a maro that runs a number of functions. Before running, I would like
it bring up a MsgBox advising the user what is about to happen and whether
they are sure they want to run and include a YES and NO option.
Right now, the MsgBox function only has the OK button and there ...

I presently have a macro that is run via clicking a form button. I need to
automate the process by replacing someone having to manually click the button
with an input from a photo eye switch, or proximity switch. My initial
thought is for Access to constantly monitor for a 0 or 1 ...

I am writing a database that runs XCOPY to copy files to another drive using
RunApp
in a macro. I need to pause the macro until the files are copied and XCOPY
closes, or alternatively, write another macro which launches when XCOPY

Hi All--
I'm having trouble using the Database Window hotkey {F11} in mircos. When I
call SendKeys, I think the key is sent but nothing happens. The key works
outside macros but I have to HOLD F11 DOWN; I can't just tap it. Who knows

I have one macro with about 35 actions in it - all with conditional
statements (if recordset is equal to 0) dont run it.
Problem = Many of my actions are not running, only a few of them are. When i
remove the conditional statments on the bottom half they start to run. But it

I'm using Outlook and ACCESS 2003 for this application.
I am trying to use the SendObject command in a macro to send a HTML version
of a report that I have created in ACCESS 2003.
Everything works fine w/1 exception.  Manually running the macro I get the

How do u change text into uppercase in a macro in access? I can't not
remember how to do this it was some time ago.
Thanks
Jonathan Carroll

I have set up a macro that emails a sheet and retains the name of the
workbook in the subject line when Outlook is opened.  I would like for it to
retain the name of the workbook, but I want to add the data from a particular
cell to the subject line as well.

In Lotus Approach I have always been able to use a case number or ssn
number as an ID to link databases.  You could enter the case number in
the Main database and if you had a field named case number in the
Detail database it would automatically put that number in the Detail

I have a Main table with basic client data, and a Employments table
with data on employment information.
I have created a Main form and then included the Employments form as a
subform in the Main form.

How would i make a bracket by just using pictures?  Im doing a bracket with
cars but i cant seem to get it to work?

I have built a series of tables in my database, one for each person on my
sales team.  I want to have a macro set up so that I open a form with a drop
down of all their names.  They select the name and click a button.  The
button is linked to a macro that uses conditions.  I'm ...