Creating a Module with this coding
Wed, 20 Aug 2008 12:34:21 -0700
How can I change the below coding that was in a form, to now work from a
module so I can use it on other forms with the same field names?
Private Sub Form_Unload(Cancel As Integer)
If [cost] <> 0 And [process] = "closed" Then
MsgBox "Make sure the cost field is has data entered."
Cancel = True
End If
Tha ...
|
Run Time Error 2450
Wed, 20 Aug 2008 06:05:01 -0700
Hello,
I am trying to send an email from Access utilizing MS Outlook utilizing the
email addresses that are in the form "frm Mail". (Access & Outlook 2003)
I get the following message:
Run time error '2450"
Ms Office Acces can't find form "frmMail" referred to in a macro expression
or Visual Basic co ...
|
<no subject>
Tue, 19 Aug 2008 20:48:45 -0500
I do not get this group
...
|
Access 2007 SendObject ACReport Runtime Error 2501
Mon, 18 Aug 2008 07:36:01 -0700
I use sendobject (acSendNoObject) with no problem in an Access 2007 DB. I am
now attempting to email a report using sendobject (acReport). Each time I
attempt to run the code from a button it fails with a runtime error 2501
after the email has been canceled. I don't know why the email is being
cancelled b ...
|
hdmi uitbreiding hdmi kabel test grafikkarte hdmi hdcp hdmi kabels 10m hdmi op dvi kabels
Fri, 15 Aug 2008 03:23:03 -0700
hdmi uitbreiding hdmi kabel test grafikkarte hdmi hdcp hdmi kabels 10m hdmi op dvi kabels
+
+
+
+++ BILLIGE HDMI KABEL KAUFEN +++ BILLIGE DVI KABEL KAUFEN +++
+
+
http://HDMI-KABEL.BUYONLINE24.INFO
http://HDMI-KABEL.BUYONLINE24.INFO
http://HDMI-KABEL.BUYONLINE24.INFO
http://HDMI-KABEL.BUYONLINE24.INFO
...
|
NPV
Thu, 14 Aug 2008 15:59:01 -0700
Hi, I am trying to use the NPV function in access, but can't figure out how
to use it. If anyone knows how to use array, you can probably help me to
figure this out.
Here is how the table looks like:
Product Year Cash_Flow
A 1 -50
A 2 50
A 3 1 ...
|
Access 2000
Wed, 13 Aug 2008 12:26:01 -0700
Need info on
Error 3320
Function is not available in expressions in table-level validation expression
This is happening on a new user logon change of password ...
|
|
|
Open Word from Access
Wed, 13 Aug 2008 13:46:14 -0400
I think this is the correct newsgroup for this question..The wizard creates
the following code for putting a command button on a form to open Word:
Dim oApp As Object
Set oApp = CreateObject("Word.Application")
oApp.Visible = True
I have both Office 2003 and 2007 installed. Presently it opens 20 ...
|
holle
Wed, 13 Aug 2008 11:01:36 +0800
Hi,I'm a boy .I'm is Zhang Zezhen.14 years old.Need to meet you.
...
|
handling mixed quote marks
Tue, 12 Aug 2008 12:23:22 -0700
This code works:
Dim strSQL$
strSQL = "INSERT INTO Performers ( Height ) SELECT ""5'3"""""";"
DoCmd.RunSQL strSQL
It puts the value 5'3" in the Height field of the Performers table.
How do I get the following to work?
Dim strSQL$, strHeight$
strHeight="5'3"""
strSQL = "INSERT INTO ...
|
