I've created a form consists of data fileds: licenceNo, NoOfValidDays
and now wanted to create a macro with MsgBox which can auto - check if the
field of "NoOfValidDays" <= 45 days, then a message box would appear.
Msg Box should contains the information such as "the licene no.

Can someone tell me how to write a macro so that I can copy a field and paste
it elswhere in a form when I push a command button. I am not a programmer, so
please be patient
Thank you

Help!!!
Here's what I'm trying to do:
There is Field A, which is the date a project is due, and Field B, which is
the later of today's date or Field A.

I have a macro that I need to have the user type in the file name that the
macro is going to import.  I have been thrown into development of a database
that is to import certain files from excel, but have a different designation
according to location.  example:  XYZ03262008.xls ...

Macro example: Condition- [Sat Score]="180+", SetValue- Item:[SatOpenB
Score], Expression:"180". this is used in a form. the purpose is to be able
to add the 180 with another field(control) to get a total for the 2 fields.
Problem: When I enter the 180+ in the Sat Score control ...

I am currently making a database for my A-level ict using microsoft
access. I have recently hit a dead end and require some dire
assistance.
How can you copy a record on a form to a seperate table in the same

I'm trying to write a macro for access to automatically email clients a file
using the sendobject method. This file will be sent to clients based on a
query already written. How would I go about inputting this.
Thanks in advance for the responses!

I would like to "filter" a lookup table list appearing in combo box by
matching a lookup table field to a control already entered in the form.  For
example, a combo box of ZIP codes limited by a state code match.  
I've used the combo wizzard and then modifed the resulting query ...

I'm trying to write a macro for access to automatically email clients a file
using the sendobject method.  This file will be sent to clients based on a
query already written.  How would I go about inputting this in VBA editor.  
Thanks in advance for the responses!

Help!
I'm designing a form that will open on entry to my database.
The form will contain command buttons to direct the user to where they want
to go.

I want to know if there is a way to automate a macro or VBA for exporting
data into Excel. I'm not too familiar with Access or programming. I need all
the help I can get.
Chris

I have created a control on a form to enter data and wanted to create a
macro which checked if the data entered appeared on a query. If the data
entered did appear on the query then a message box would appear. I assume
this would be a before update event (or after update?) on the ...

Hi there,
I am a medical transcriptionist with very little programming experience, but
have written a series of macros to copy/paste Word reports into my client's
Word-based document.  Unfortunately, although I've written some steps into

I have a macro that opens a query, runs the app and then transfers the table
to Excel. Is there a way to transfer the table to a specific tab in my Excel
sheet and and to a specific cell in the worksheet. For example I would like
my access table transferred to the Jones tab in ...

In Access 2007, I have a macro that uses "Output To" to write a text
file.   How can I get the macro to export a simple CSV file with NO
headers and just the delimited data (no  -----------  line separating
each row).