application won't run
Mon, 3 Nov 2008 17:44:04 -0800
I bought a new computer. XP Home and Office 2003. I copied my access files
over to new computer. When I open my access files I get 2 errors. First I get
a message wanring me about " This file may no be safe if it contains code
that was intended to harm your computer. Do you want to open this fileor
cancel th ...
|
Run Macro
Mon, 3 Nov 2008 09:13:00 -0800
I have 2 macros set up to automatically export information to an excel
template. When I go to tools and to run macro, neither macro shows up. In
order to run the macros I have to go into VBE and run them from there. Any
clues as to what I am doing wrong? Thanks for any input.
Shelli ...
|
How to Overwrite Existing Records Using Import of TransferSpreadsh
Mon, 3 Nov 2008 07:24:02 -0800
When using a TransferSpreadsheet action in a macro, how do you overwrite
existing records instead of appending to the table? Once the macro is
complete, I would like for only the header fields to remain (no data). Is
there a means to delete the records (not the table) at the end of the macro
execution? ...
|
How to Link to an Excel File By Prompting the User for the FileNam
Sun, 2 Nov 2008 05:44:03 -0800
I have an Excel spreadsheet that is updated weekly. Weekly, new records are
added to the file that need to be compared to a data file in Access. Since
the file is changed weekly, I want to prompt the user to provide the file
name that needs to be linked to the Access database so that the queries and
assess ...
|
macro commands not allowed
Sat, 1 Nov 2008 16:18:11 -0700
Some macro commands I used in 2003 (send keys, etc.) are not avialble or
won't run in 2007. I know it's because Access thinks the database is not
trusted but I've added the database location to trusted location and enabled
all macros. Is there anything else I can try. Thanks
--
Rick ...
|
Import/Export Multiple Excel Files to Access
Fri, 31 Oct 2008 14:58:03 -0700
I have roughly 500 invididual Excel files that are sent to me via the IT
department. Each file has roughly 5 - 10 thousand lines on them. What I am
wondering is, is there a Access VBA Macro that I could use to inport each one
of these 500 Excel files into a Access database while looping through them in
one ...
|
excel macro
Fri, 31 Oct 2008 14:51:00 -0700
Could some one please tell me what file extension excel macros are listed
under, and where they are stored. I have some work in excel that I would like
to move to a new computer, and I would like to make sure I can also move my
macros to the new computer. ...
|
|
|
SetValue from a subform to a new form
Thu, 30 Oct 2008 16:45:01 -0700
I have a form "frmBusinessMarketing" with a subform
"subfrmBusinessContactsMarketingDate". In the sub form I need to pick up the
first and last name of the business contact. I have the SetValue working to
pick up the business ID from the form but everytime I run the macro to pick
up the names from the subfor ...
|
Access 2007 and SaveAsOutlookContact.
Thu, 30 Oct 2008 15:27:01 -0700
Using access 2007 the Northwind DB shows a form (Employee Details) with a
macro that uses the runCommand action and the argument is
SaveAsOutlookContact.
It works perfectly fine in that database but when I attempt to reproduce the
commands I get an error message that says "the command is not available at
...
|
Macro
Thu, 30 Oct 2008 14:44:02 -0700
I would like the macro i am creating to open a sheet/form/query and hide the
sheet/form/query. What function and syntax would i use for this
Many Thanx ...
|
