|
References code placement
I am working on an Access 2000 project. If the user tries to open the db,
there is a reference missing. I have the following code that I believe should
reset the reference but cannot figure out where to put it to reset the
reference when the project opens. I have put it in the OnOpen, OnLoad of the
startup form, put as the first function at the beginning of the Autoexec
macro. Any sugges...
|
3 |
11/20/2005 10:51:58 PM |
|
|
Workaround to SendObject in Access 2000
This is my second posting on this, but I'm hitting my head against the wall
so I'm hoping someone can help. Thanks in advance -
I have code that sends a Lotus Notes email from a button on an Access form
(which I'm using because SendObject in Access 2000 has a bug). Everything
works fine in the code except I need to send a screen shot of the form that
the button resides in, much like ...
|
2 |
11/18/2005 10:47:32 PM |
|
|
Open pulisher from Access
Hi
I am aware that you can open excel and word from access and reference
documents to be printed.
Does the same function exist for Publisher and if so how do i go about
opening it and print a document and then closing it again.
I am using Access 2000 on windows 2000 if that's of any relevance.
Thanks in advance for any help
Gillian...
|
10 |
11/18/2005 7:20:56 PM |
|
|
DAO reference problems
Hi
I have copied a database we designed for one of clients to be re-used again.
For some reason the module has lost the reference to DAO 3.6 and every time
i try to reselect this reference i get a fatal msaccess.exe error and it
boots me out.
I can't really post my code as there is pages and pages of it.
Does this problem sound familiar to anyone?
Any help would be greatly appre...
|
3 |
11/18/2005 4:35:47 PM |
|
|
SQL string hangs when executing
When the first string runs, it takes 45 seconds to execute. When I run the
second string, it runs immediately. Any idea why??????
SELECT * FROM qryDonationSearchOutput
WHERE (donationID IN (SELECT dtDesignation_FdonationID FROM tblDTDesignation
WHERE dtDesignation_FdesignationTypeID = 2) AND ((parentName LIKE
'*candace*')))
OR (donationID = 970)
ORDER BY donationID DESC
SELECT * FRO...
|
5 |
11/17/2005 5:17:56 PM |
|
|
The specified module could not be found
When I astart the Access 2000 application, I recives the error message
"The specified module could not be found". If I click the debug button
the VBA code points to
rst.Open strSQL CurrentProject.Connection, adOpenForwardOnly,
adLockReadOnly
In reference I select "Microsoft AvtiveX DataObject 2.1 Library".
Can any one please help.
...
|
6 |
11/11/2005 7:55:45 AM |
|
|
Button not working
I am at wits end.
I deploy my application by giving the end users the latest Front End as an
MDE. This has worked for many years.
Last week, I did a new installation and this time some of the buttons will
not work at this particular site. The OS (XP or 2000) and Office (2002 or
2003) are the same. I have installed at other sites since, and they all work,
bar that one.
Has anyon...
|
4 |
11/7/2005 8:51:03 PM |
|
|
multiple "INSERT INTO" queries
Hopefully all of you can once again help me with a problem I am having
running multiple INSERT queries in my VBA code. My code looks
something like this:
' Form condition 1
If condition1 = True Then
CurrentDb.Execute "INSERT INTO tblTable " & _
"(Field_1, Field_2, Field_3)" & _
"VALUES (Val_1, Val_2, Val_3)"
End If
' Form condition 2
If condition2 = True Then
...
|
3 |
11/5/2005 8:00:38 PM |
|
|
Recordsetclone problem
Hi ,
My need in the form I'm talking about is very simple. I say this
because I've seen posts that say recordset clone can be used in a snap
to find a record.
I have not used access before. The little db work I did used oracle 8i
or sql server. So the "user friendliness" of Access just doesnt work
for me.
Scenario:
I have a form with 6 fields. These are 6 fields that are bound to e...
|
6 |
11/1/2005 5:32:56 PM |
|
|
Index, appendix, the whole world....
ISSUE 1:
I have two tables with a one-many relationship.
I have designed a report with a group header for the one side and the many
side spanning to each detail section. something
like:
p.1
category header: food
---------------------
roast beef
chicken salad
category header: drinks
--------------------------
lemonade
beer
page break (using keep together: whole group)
p.2
...
|
4 |
11/1/2005 3:11:34 PM |
|
|
Add Tables to the realtionship Window with VBA
Hello world (;>)...
I am searching for a code fragment to add Tables to the relationship Windows
with the help of VBA.
I know how to add realations with VBA, I know the way to show them in the
relationship windows.
But:
The user has to add the tables manually to the window to show the
releations.
Is there a resolution to do this with VBA ??
Many thanks and greetings from ...
|
1 |
10/30/2005 5:42:26 PM |
|
|
encryption FE and BE
I have an application split into Front End and Back End, running for the last
3 years. It works well.
I have both the FE and BE encrypted. Also both the FE and BE are
passworded.
One drawback is that the encrypted files cannot be compressed with ZIP and
now I am thinking that the FE files need not be encrypted (leaving the BE to
be encrypted). Since I only keep temp files in t...
|
1 |
10/30/2005 12:53:02 AM |
|
|
Linking to a dbase
Hi,
I am wanting to use access to develop a number of reports with the data
source being IBM DB2. I am wondering if someone can tell me what is involved
in creating a link from access to the source. Note: I know nothing at all
about DB2.
Any advice greatly appreciated. In real dummy language even better.
--
Thanks...
|
1 |
10/29/2005 5:41:01 AM |