How to align a text in an email
Tue, 09 Dec 2008 15:04:49 GMT
Hi,
First of all thank you so much in advance.
I am doing a mass mailing using access 2003.
I have this code which works great. When the email is sent the .HTMLBody
appears in one line. I want the email body to appear like the following:
Center the first line "The Next......"
Leave a blank line
Cente ...
|
Button to backup
Tue, 9 Dec 2008 06:25:18 -0800
I need to backup the database, Candidates, five days a week. I would like to
have a button to press which will backup Candidates to "J:\bak\Backup (Tue)",
"J:\bak\Backup (Wed)", etc., so it needs to determine the current day and
execute the backup.
Thanks MUCH! ...
|
Bells & Whistles
Tue, 9 Dec 2008 03:55:00 -0800
I have a form with 2 subforms embedded. The first subform is datasheet view
and I use conditional format to highlight a field in that form based on a
condition. The condition is a rare condition so I would like to place a lbl
on the main form that will explain what the highlight means. Basically make
visi ...
|
Iif function not functioning in another computer
Tue, 9 Dec 2008 03:21:01 -0800
I have a few unbound text boxes in my form wich show totals from the form'
subforms. The formula (in general names) is:
=IIf([Subform].[Form].[RecordsetClone].[RecordCount]>0,[Subform].[Form]![Total],0)
When I copy the DB to the user' computer, I get #Name?. The formula is
working, though, if I leave only [ ...
|
Option Group Option Buttons
Tue, 9 Dec 2008 03:06:09 -0800
I have created on a Form in my Database an Option Group with 3 Option
Buttons, so that for each Record I can select 1 of these Options to have its
value stored in a particular Field of the Databbase Table. However, I do not
know, and have been unable to find a solution through MS Access Help, how to
program ...
|
Command button to open EXCEL path
Mon, 8 Dec 2008 15:30:02 -0800
How do I code a command button to open a specific EXCEL sheet or file located
in a specific location each time I click the command button? Is this
possible? I understand that I can output to EXCEL, but in this case, I only
wish to open then print an EXCEL file. This file acts as a data collection
form. It w ...
|
1 Main for 2 Subforms
Mon, 8 Dec 2008 14:45:01 -0800
I truly Apologize for this, but I can't find an answer for this at all.
Ok, I posted a similar question, but I am not sure I explained myself enough
in order to get the correct answer.
I have three forms I am working with. I have a main form with two subforms
in it. I have a combo box on the main form th ...
|
|
|
vba yes no code
Mon, 8 Dec 2008 13:56:24 -0800 (PST)
I have an excel export button that works fine, i would like to add a
prompt that when I click the export to excel a yes/no prompt comes up,
yes to export no to exit prompt, this way i can eliminate accidental
clicks. Thanks in advance.
Ryan ...
|
VB Error
Mon, 8 Dec 2008 13:51:01 -0800
The error must be the loop because Access just crashes when the loop is on, i
use the loop in other Subs, also productQuantity is 45.
Any suggestions?
Sub chkDelete_Click()
Dim Mydb As DAO.database
Dim QryDat As DAO.Recordset
Set Mydb = CurrentDb()
productID.SetFocus
product ...
|
how to use list box contents as query criterion
Mon, 8 Dec 2008 13:37:00 -0800
Good day all,
I have a list box of invoice IDs that I'd like to use as criterion in a
query that returns records matching the invoice ID(s) selected by the user.
Here's what I have so far which generates an error (run time 3265 Item not
found in this collection) pointing to the DELETE command;
Dim iDb A ...
|
