I am trying to do a carriage return but for some reason it is not working in
my code.
There is no error other than it does not appear on the next line.
subject = "Corrective Action Request " & [CarId] & " has been issued."

Quite some time back I put together some VBA code to create an Outlook 2003
distribution list from an MS Access 2003 database.  Pretty straight forward:
name and e-mail.   In short, the code created an empty distribution list and
blank message.  It then added recipients to the ...

I have a form that I create a new record on.  The record has an primary key
that is defined with an IDENTITY property (this is an adp project).
I want to insert this new record into another table while I am still on the
original form.  I have code to do this but I need the PK ...

I have a continuous form subform where I need to place a button (on each
record) that will email the information from the selected record.  How would
I go about setting this up?
Thank you,

I am using the above mentioned function to import information from Excel. The
first time I tried it Access created a table with a list of the items it had
problems importing. I deleted the imported information and fixed my
formatting and all but one record imported correctly. The ...

From a form we are finding a customer, we use like for a wildcard option;
When we enter a seach string, for example "mich*" - it will seach for
michael, michelle etc... If no match is found it creates a new record....
What we want is to do is display a message if no match is found ...

**Pulling hair out**
I have the following code for an "Exit" button to do three things:
1. If yes is clicked, then save everything and close the application
2. If No is clicked, then prompt to just close the form, if yes, then close

I am trying to do a search form. I have a text box on the form so people can
but the name of what they are trying to search for and then press the button
and it pullls up a form with the information. I have created a form already
with the information about each item. Thank you to ...

I have a form that I create/edit orders on.  I also have a form that I
create/edit vendors on.
On the orders form there is a drop down list of vendors to assign to the
order.  There is also a button I can click to open the vendor form. If there

This isn't returning a value...I'm sure it's my syntax.
I think it might be the CDDiscountWhere = 'A' part but then again.....
Any help appreciated.
Thanks

I need to send the current form as an attachment to the email.
Any ideas?

This is what I have:
             Main Form       Subform2                       Control in sub2
Forms!frmEditProject!frmProjectsCyclesSub.From!DateComplete = Date
Sytax:

I have four people on my email list.  I want to send one email each of the
four people with a list of accounts over due, embodied within the email.  So,
for instance, jeff will be sent an email that shows in the body of the email
all of his accounts that are over due:

Is this correct? I need to run a DCount where the Info is in another db.
Thanks
DS
Me.TxtSubFX = Nz(DCount("ChkFXSep", "tblChecks IN

So, if I look in my code Builder, I have all of my forms and tables listed,
with code in most of those. Suddenly today, I have a module that doesn't have
Form_ or Report_ in front of it, just a name that matches a delted report.
When I try to click on it to delete, ACcess shuts ...