Help with VBA "DoCmd.TransferSpreadsheet acImport ......."
Wed, 30 Jul 2008 17:13:05 -0400
2003
I would like the data imported into a table in a non-current() database.
DoCmd.TransferSpreadsheet acImport, , strTableName, myPath & strTableName & ".xls", True
(The above command works but .... I want the data to go to strTableName in another database]
Any coding help appreciated
TIA EagleOne ...
|
Selecting Record for Report Macro
Wed, 30 Jul 2008 10:21:01 -0700
I have a command button that is programmed to run reports when clicked. How
can I change the code below to select only the current record for printing?
Private Sub Print_Reports_Click()
On Error GoTo Err_Print_Reports_Click
Dim stDocName1 As String
Dim stDocName2 As String
Dim stDocName3 As S ...
|
sending emails
Wed, 30 Jul 2008 07:29:05 -0700
I have a databsae that includes the invoices of different companies. I have
created a sendobject macro for each indvidual company that send emails to
their company if they have not paid for their invoice. I have also created a
macro that sends all the emails at once with just the click of that one
macro. My ...
|
Macros with Print Preview
Tue, 29 Jul 2008 11:05:01 -0700
Will a macro close print preview. I had a macro perform other tasks, and then
open in print preview, however it will not close the preview.
--
Cheryl/ ...
|
Credit/Debit value in table based on form entry
Tue, 29 Jul 2008 07:27:16 -0700 (PDT)
Hi,
I am trying to create an Inventory Log and I would like for the
quantity of parts entered in the form to either increase or decrease
the value in the table, but I'm not sure if I need a macro to do this
or what exactly I need.
I am a newbie to access, so I don't understand any code. Please help!
Ama ...
|
VBA help From db1.dbf have module to create then import Text
Tue, 29 Jul 2008 06:39:06 -0700
2003
I am not sure which Access group is the best for help below:
The VBA module exists in Tools.mdb
So I run NewAccessDatabase() from Tools.mdb
I get pieces parts to work but not the whole thing.
The issue revolves around which database is the CurrentDb
The code below creates: Recordset("STARS ...
|
Array Disappearing after first For...Each
Mon, 28 Jul 2008 14:07:01 -0700
I ran into a puzzling problem that I haven't been able to figure out. I have
several functions, that when called, iterate through each of 9 tables and
process data from them into 9 other tables as needed, through append or
update queries. I am creating the SQL string via code, to avoid saving off 36
queries ...
|
|
|
Office 2007 TransferSpreadsheet Import
Mon, 28 Jul 2008 11:54:21 -0700
FYI - I'm using Office 2007 saving my Excel files in the 2003 format. The
Access database I'm working with is in 2000 format.
I'm attempting to use import functionality of the TransferSpreadsheet macro
as part of an autoexec macro.
To create my Excel document, I'm exporting data from a financial system an ...
|
Closing Print Preview with macro
Mon, 28 Jul 2008 10:26:19 -0700
I recorded a macro that I wanted to close the print preview option at the
end. It will perform all of the other tasks, including going to the print
preview, but it will not close the preview and go back to the document. What
can I do?
--
Cheryl/ ...
|
setvalue macro
Mon, 28 Jul 2008 02:38:01 -0700
I would like to create a setvalue macro that populates a field based on the
value selected from a combo-box in another field.
I would set the value of the field based on the result of a saved query.
I'm not quite sure of what I should place in the 'expression' of the macro.
Thus far, I have
Action: set ...
|
