RunCommand - Exit
Tue, 22 Jul 2008 13:15:13 -0700
Many of my macro routines in Access 2003 end by closing the MS Access
Application with RunCommand - Exit. In Access 07 this generates an error. The
07 macro command "Close Database" works to close the database file but leaves
the application running and the next task starts a new session of MS Access.
Not go ...
|
Auto execution of macro
Tue, 22 Jul 2008 12:56:01 -0700
I have a macro for OpenQuery, my DB resides on network. Is there a way that I
run that macro whenever the condition gets true, i.e. whenever the table gets
updated.
Can anyone help me with auto execution of macro?
Thanks
--
Amod Goyal
IT System Developer
NSK Precision America ...
|
Export Excel Data
Tue, 22 Jul 2008 12:02:02 -0700
Hi
I am trying to write a macro to export my data in Excel as a text file. The
followings are my codes. However, the macro works only when I am running it
manually on Excel. The macro fails to run when I schedule it to run. It
stops when the Export window pop up. What should I change in my macro to
m ...
|
Type mismatch
Tue, 22 Jul 2008 07:23:02 -0700
On opening a database I have created, I have an auto exec macro which runs a
report to tell me when I have expired records in my database. This then runs
another macro which if the expired records total more than 1 pings a pop up
message to tell me i have expired records. Howver if there are no expired
recor ...
|
noob Creating a macro to convert to csv.
Tue, 22 Jul 2008 06:57:21 -0700 (PDT)
Hi
I am new to macros and access but this is what i want to acheive:
I have an access table that contains over 50 columns (A to ZZ) which i
am currently converting in a macro to a csv file for importing later
into a mysql database.
The actions in my macro are as follows:
TransferDatabase (makes a copy ...
|
Hide Label
Tue, 22 Jul 2008 13:56:30 GMT
I am trying to create a macro that will hide a label on the form until the
form's date passes today's date, then I want it to display a label saying
that the record has expired. Is there any way I can do this in Access 2003?
Thanks In Advance.
--
Message posted via AccessMonster.com
http://www.accessmonst ...
|
Referencing Signature Lines in Word document
Tue, 22 Jul 2008 06:36:00 -0700
I have the following problem:
i have a word document with two signature lines, that are not signed
i want to set the details (signer name, title, email) for the lines via
macro but i can't get a reference to the lines using the
ActiveDocument.Signatures property since the property only contains signed
line ...
|
|
|
help with Update Query in VBA code
Tue, 22 Jul 2008 07:17:56 -0500
Private Function UpdateOffDayFields() As Long
'Define Database Objects...
Dim rs As ADODB.Recordset, sSQL As String, lCount As Long, iEndTime As Integer
Set rs = New ADODB.Recordset
Set oDB = CurrentProject.Connection
sSQL = "SELECT SegmentID, CohortID, SourceID, PromoID, RptDate, MIN(StartHo ...
|
Launch a form under the condition that field is not null
Mon, 21 Jul 2008 07:31:23 -0700 (PDT)
I would like to prevent accidental overwriting of data in my database.
I don't want to absolutely restrict overwriting, because in some cases
it may be necessary, but I'd like to prevent accidental errors.
My strategy is to have a popup that warns the user that they are about
to change a field that already has ...
|
How to call my macro
Mon, 21 Jul 2008 06:50:01 -0700
Hi,
I am having a problem calling my macro. I am setting up a search command in
a lookup form to call a certain macro if a certain criteria equals one thing
or call a different one if it equals something else. Either nothing happens
because I am not calling the macro right or I get an error message about t ...
|
