|
A2K Runtime Crashes on DoCmd.Quit
Hi;
Using A2K Runtime on XP Pro PC. Have all of the updates for XP and Access
Runtime including SP-3 for both.
The app opens to frmLogin correctly. On that form there are 2 cmd buttons.
Continue & Exit.
Can log in as USER or sa, (System Administrator) but when clicking either
cmd button get Access Runtime Crash.
"Execution of this application has stopped due to a run-time error....
|
26 |
1/1/2009 1:14:35 AM |
|
|
Guaranteed Millionaires
http://guaranteedmillionaires.blogspot.com/...
|
1 |
12/31/2008 10:09:44 PM |
|
|
Stop dialog box
I have some code that does the following:
kills a spreadsheet if it exists,
opens a template,
saves it,
opens the spreadseet,
transfer data to it,
runs a macro
then I save it...
I am using the following to save the spreadsheet:
xlBook.SaveAs DirPath & xlsfname
xlBook.Close
I have two problems, one is that when I use xlBook.Save, I get a complie
error: wrong number of argum...
|
1 |
12/31/2008 6:18:58 PM |
|
|
Working with Excel from Access both in Office 2003
I am trying to delete, open, save and transfer data to excel I am using the
following code but I am getting some errors... could someone suggest what is
wrong with the code...
Many Regards - PR
My Code:
Function export_aga()
On Error GoTo export_aga_Err
Dim db As Database
Dim objApp As Excel.Application
Dim ObjBook As Excel.Workbook
Dim objSheet As Excel.Worksheet
Dim Path As Stri...
|
5 |
12/31/2008 12:36:06 AM |
|
|
Automating reports
Hi all,
I am sure it is my lack of searching-capabilities but I am looking for
some code sampels that help me develop the folling scenario:
A user is not in the office but he urgently needs a certain report
He/she send an email message to a specific email-account with the
report name in the subject
When the message arrives, a program receives the email, runs the Access
report and sen...
|
2 |
12/23/2008 4:47:52 PM |
|
|
Which method is fastest?
Hi.
To select/find data in a table, what will be the fastest method:
1. By query: "SELECT * FROM Table WHERE Field1=""" & Me!txtField1 & """ AND
""" Field2=""" & Me!txtField2 & """;"
And loop through the records found (if any).
Or
2. Select the table in whole.
And .FindFirst "Field1=""" & Me!txtField1 & """ AND """ Field2=""" &
Me!txtField2 & """" and loop using .FindNext
I guess ...
|
7 |
12/21/2008 5:06:01 PM |
|
|
Function For Percentile
Greetings,
I am somewhat of a novice, so please bear with me. I am trying to come up
with a user defined function that will allow me to find the xth percentile on
a group of records within a query. Scouring the net, I found the code below.
I have put this into a module in my DB and have tested it using the
immediate window, with the returned results giving me what I expected.
Howe...
|
2 |
12/19/2008 8:05:02 PM |
|
|
Losing handles to form and control objects in Access 2007 VBA modu
I have a library of classes that I use to manipulate MS Access UI objects
(forms, subforms, controls, etc.). My code has been bullet proof for the
past several months in Access 2003. Now I am migrating to 2007 and
everything has broken.
What I am encountering is the error message "The expression you entered
refers to an object that is closed or doesn't exist" when I try to get or set ...
|
8 |
12/18/2008 8:39:00 PM |
|
|
Anyone use Visual Studio ?
Hello,
I apologize for posting this here but I can't get any response to a question
on the VStudio group so I thought I would post this question here. The
Access groups are usually the best source of help for any kind of question
under the sun. I want to do a website slideshow (it was easy with Access)
and can't get the images to refresh. Here is the VB code I used:
Protected Sub...
|
9 |
12/17/2008 10:23:12 PM |
|
|
MS Access 2007 cannot execute event code
When I attempt select an item in a form combo box to activate an
'AfterUpdate' event, I get the following error:
"The expression After Update you entered as the event property setting
produced the following error: A problem occured while Microsoft Office Access
was communicating with the OLE server or ActiveX Control
* The expression may not have result in the name of a macro, the name...
|
3 |
12/17/2008 6:12:08 PM |
|
|
Launch Access From URL Link
I want to launch an Access application from a variety of URL links embedded
in a Word or PDF document, and enter Access with a variety of parameters. I
know that msaccess.exe can have a parameter list, but how do I pass the list
from a URL link, or is it even possible to pass any parameter with URLs?
Thanks....
|
4 |
12/17/2008 5:48:24 AM |
|
|
SQLDMOScript_Default
Can anyone tell me what the default options are in SQLDMOScript? The
description in any of the help files I've been able to find say only
"SQLDMOScript_PrimaryObject" or "Generates script with all default options" -
both of which are remarkably un-informative.
Any help would be GREATLY appreciated!...
|
1 |
12/10/2008 2:47:02 PM |
|
|
Time data entry restriction
All,
I am trying to restrict TimeOut field to the times indicated below.
Obviously it is not working and I can't see why. The formating on that
field is Medium Time.
If Me.txtTimeOut >= "12:00 AM" And Me.txtTimeOut <= "05:00 AM" Then
MsgBox "You MUST enter a time between 6:00 am and 11:59 PM!",
vbInformation, "AM/PM"
Me.txtTimeOut = Null
End If
Ex...
|
10 |
12/9/2008 3:38:36 AM |
|
|
Name strSource As strTarget
P.S.
I am also not married to using the following code, or the logic behind
it, to create the new file:
Name strSource As strTarget
as I just realized that this line was moving, rather than creating a
copy, of my file.
Thank you,
Jeff Bassett...
|
5 |
12/2/2008 7:33:42 PM |
|
|
Image Resize and Save with VBA code
Greetings:
Currently I am working on adding photos to my real estate database
(the current market conditions have given me some free time) and I am
stuck on one portion of the code. I cannot figure out how to resize
the selected JPG file prior to saving that file in a centralized
directory.
For clarity I have attached my code below, but in a nut shell what I
would like to have happen i...
|
2 |
12/2/2008 6:11:01 PM |
|
|
Code in Visual Basic
Hope this is the right group to post this in. I copied a macro from one
workbook to another which draws data from an access database to a worksheet
in Excel. Everything looked right until I ran the macro. I got a compile
error and the line that was highlighted is below:
Dim cnn As New ADODB.Connection
What does this mean? How do I fix it?
...
|
5 |
12/2/2008 3:44:06 PM |
|
|
Execute console command and capture output
Running A2K3 (under either W2K, W/XP or W/Vista), I would like to code a
module that executes a "console command", waits for completion, checks the
return code, and is able to capture the console command's output (from a
disc file somewhere) to read it back in and analyze the results.
I seem to have it working where I execute the command and wait for
completion. But I'm not sure how to...
|
19 |
11/23/2008 3:20:04 PM |
|
|
Custom message text from file using SendObject
I am just on my way to learning VBA, and it's been great so far. I wondered
if anyone had an idea of how to load the message text field (using SendObject
command in Access 2007) from a file or other source (like a text file),
instead of a fixed message?...
|
3 |
11/23/2008 12:51:49 AM |
|
|
Printing just one label - how to ?
Hi all :)
I have an Access 2007 application where I want people to fill in a form with
6 text fields and one field that contains the number of copies.
Those text fields are not related to any table.
When they are done filling in the fields , they can press the print button
and those 6 text lines should end up on some label-printer's label.
Now I thought I could somehow make a report wi...
|
5 |
11/20/2008 6:25:06 PM |
|
|
Unable to generate email with upgrade
I have upgraded my laptop from XP SP2 to Vista SP1.
Since I have upgraded, I am unable to send these simple reports in an
access program I have created. I was able to do this for well over a
year before upgrading to Vista.
If you need more info, or questions please ask. I need to resolve
this quickly.
CODE 1:
Dim db As Database
Dim rs As Recordset, rs2 As Recordset, strClause As St...
|
2 |
11/20/2008 5:43:00 AM |
|
|
Edit/Update methods not effective
Hello,
I am posting data from a Form and Subform to a Table and Subtable. In the
code below line 1000 and 2000 show the main table being updated and that is
ok, not problem. Line 3000 and 4000 show the subtable being updated but the
updates aren't holding. When I walk through the code and check the field
values being assigned before the update they are correct but the changes
just...
|
6 |
11/19/2008 12:27:26 PM |
|
|
Folder Naming from Access
How would you get the computer to take the names from a column in Access
table and open a folder of pdfs and rename the pdfs using the sequential
names in the Access table?
--
Janet A....
|
7 |
11/17/2008 3:46:01 AM |
|
|
How to get disk serial number in vista?
I have an Access 2003 .mdb file that gets the disk serial number (not
volumne number) of the disk it is running on using CreateFile and other
routines. I do this to stop people from copying my program to other
computers. It seems to have problems when running on Vista. I was
thinking I might need to use the WMI interface to get the disk serial
number but I am not sure how to do it. There...
|
9 |
11/16/2008 8:56:00 PM |
|
|
Access 2003 on Vista Breakpoints even stop in code not working
HI Everyone
I have recently installed Access 2003 onto a Vista Business Platform and
when I attempt in VBA to place breakpoints although they are marked with the
Brown Dot the code doesn't break!
Suggestions?? Its exceptionally difficult not being able to single step in
code..
...
|
3 |
11/12/2008 5:19:13 PM |
|
|
Setting background transparent in VB and save as GIF (PPT 2007)
Hello,
In PowerPoint 2003 I successfully use Visual Basic code to save a Powerpoint
Slide into GIF format with a transparent background. This does not seem to
work anymore in PowerPoint 2007. I have selected the option "Save as
PowerPoint 97-2003".
This is the code:
Sub TestTransparency(PPT As PowerPoint.Application, Pres As
PowerPoint.Presentation)
Const FileName = "TestTranspar...
|
7 |
11/11/2008 8:58:02 PM |