DoCmd.CopyObject Error 2501
Mon, 24 Nov 2008 09:46:02 -0800
I'm using Access 2007 on Vista.
I have a form with a command button that I use to view a second form. The
second form is always being programmatically modified so I have a default
form that I want to start with every time, copy it, then make the changes to
the form and open it. Here's the code I was using:
...
|
formating spreadsheet
Mon, 24 Nov 2008 09:10:06 -0800
I've been running this code for awhile without problems and am now getting a
"subscript out of range error" number 9. I can run the code fine if I skip
the spreadsheet formatting so the error is somewhere in there. I can't see
the problem so maybe someone here can. Thanks.
Public Function JobCodeAndOpti ...
|
ARRAY QUESTION...
Mon, 24 Nov 2008 08:19:01 -0800
Hi everyone...
I'm working on a database right now and am writing a macro that will perform
a number of simple append queries in addition to some more complex
statistical analysis. I'm not good at all with arrays and have no idea how
to use them, but I know they could drastically improve my code's efficien ...
|
Open DB from another DB using shortcut work group
Mon, 24 Nov 2008 06:53:03 -0800
Have a DB with the following shortcut for a secure login:
"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE"
"C:\GoDoers\Executive_Go_Doers.mdb" /WRKGRP "C:\GoDoers\Security.mdw"
I'm not having any luck using the following to open the DB:
Application.FollowHyperlink "c:\GoDoers\Executive_Go_Doers.m ...
|
Using cdo in MS Access VBA to automate email
Mon, 24 Nov 2008 06:23:01 -0800
I am trying to use cdo to send emails with attachments from Access 2003 sp3.
I am able to establish a mapi session and to specify the message, subject,
and attachment and I am able to add recipients. When I try to specify the
recipient's address, I get an invalid argument error even though the
documentatio ...
|
Get "Open File" dialog
Mon, 24 Nov 2008 04:38:01 -0800
I want to select a file by opening tha standard Windows "open file" menu -
i.e. be able to go through a folder structure and then select a file.
Please show VBA sample code for that.
I think it is something like using the GetOpenFileName Function - but the
sample code found so far is quite comprehensive - ...
|
Open External File
Sun, 23 Nov 2008 23:44:00 -0800
I would like to be able to have the user click a button on the form which
will open a file in a specified directory which matches criteria on the
selected record. The target file will probably be a pdf file. I'm not
looking to import any data from the target file, just open it for review.
Thanks. ...
|
|
|
Automating Excel to run an auto open macro in the sheet.
Sun, 23 Nov 2008 12:37:01 -0800
Is it possible to get an excell sheet to open and run a macro that is set in
the auto open part of the excel sheet.
When I automate a worksheet to open it seems to bypass the autoopen macro
imbeded in the sheet.
The autoopen macro takes two cells and pastes them on a worksheet.
The values of the cells is fr ...
|
Half hour interval impacts
Sun, 23 Nov 2008 06:45:03 -0800
I am trying to come up with a way to identify the half hour impact from
several exceptions across multiple days.
The fields that are used would be a start moment ( 9/3/2008 3:45:00 PM),
stop moment (9/3/2008 4:30:00 PM), and total minutes (45). I have hundreds
of exceptions with the above data and I ne ...
|
How to Create My Own Self Define Icon in BUTTON
Sun, 23 Nov 2008 04:14:12 GMT
Hi,
1.Just to make my application more user friendly, I like to create an icon
with my own define pics..
(Eg: Button with Handphone Symbol?)
2. Anyone knows how to do it ?
Edison
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200811/1
...
|
