|
Need code to run on DB close
Is there a way to have a method/code run when an access database is closed?
I need something like AUTOEXEC but when exiting the database.
Thanks for any and all help
ben...
|
10 |
01.09.2006 04:22:52 |
|
full version office 2003 proffesionel disk ses E:\is not essecib.
my full version office 2003 proffesionel disk said E:\is not eccesible...
|
2 |
01.09.2006 04:15:35 |
|
MS Access Installation / Won't load
I've un installed MS Office XP Professional and reloaded it. All the
applications work with the exception of Access.
When I attempt to launch the application the following window is displayed:
*********************************************************
Microsoft Office XPProfessional with Frontpage
Please wait while windows configures Microsoft Office XP Professional with
Frontpage.
**...
|
1 |
31.08.2006 11:51:02 |
|
How to set a relative path with linked table
Hello,
1) I need to know if a relative path can be configured for linked tables. I
want to separate the code from the tables so I can work on the code off
line. I want to put the back end database with tables in the same directory
as the application database with the code.
2) I have that I should not be using a shortcut to a common front end for
mutliple users. Why is that?
Tha...
|
3 |
31.08.2006 00:11:27 |
|
How to save the Page Setup margin value?
Dear all,
In one of my queries, I've used the datasheet view to view the result, and I
would like to print it out for reference. However, the problem is that in
such datasheet, it seems that I can't set the Page Setup and change the
margin. The problem is that I've changed the margin value this time, but next
time the margin value will be returned to the default value, it's so
inconvenient f...
|
2 |
29.08.2006 15:44:01 |
|
Working with a Split Database
I have split our database with a font end and back end. The back end
contains all of the tables and resides on the file server. Each user has a
copy (not a shortcut) of the front end which contains all of the forms,
queries and reports. Now I have a few questions:
1. I update this database regularly. Each time, I must email everyone to
make a new copy of their computer. Is there a...
|
12 |
29.08.2006 02:33:01 |
|
Access95 Out of Memory
I have MS Access 95. It does what I need and I am not interested in
upgrading.
I got a new computer with 1Gb RAM (Windows XP). I installed Access 95 and
it ran fine.
Then I had to do a system recovery that reformatted my hard drive, so I had
to reinstall everything. Now it will not run. I get an "Out of memory"
error which the knowledge base implies is due to having 1Gb RAM and an ol...
|
5 |
26.08.2006 17:45:23 |
|
Corrupt Database Locking??
Last week my company upgraded from Office 97 to Office 2003. Everything has
been working ok this week, but last night I was unable to update records in a
database. After looking at it today, I discovered that when I open the .ldb
file the only thing listed is "䅌䑎å…㉗Kâ€ â€ â€ â€ â€ â€ â€ â€ â€ â€ â€ æ‘æ¥n†††††††††††††", nothing
else. I can go to another...
|
4 |
25.08.2006 20:44:01 |
|
Tools
In Tools - Options - View tab you can click on the option to show windows in
taskbar. Everytime I close out my DB I have to set that. I've clicked apply
each time, but it still resets when I close out and get back in. Is there a
way to fix that so I don't have to reset it every time?
Thanks in advance
KimP
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums...
|
2 |
25.08.2006 19:45:02 |
|
MS Access Database File Size smaller from previous version
I am novice to MS Access Development,
I regularly back my access database every 2, 3 days ...today when I was
going to back my database I saw the access file on the network drive was only
9 MB in size, while the backup files that I had saved few days back were 258
MB in size.
Can anyone suggest something why or how I can track what happend or a way to
compare the backup database with...
|
2 |
25.08.2006 19:25:02 |
|
How to open a database password protected in Access 2000
Hi there!
I have trouble opening an access 2000 protected with password.
I am automating the access 2000 in VB6. My code starts like this....
....
x = getobject(,"Access.application.9")
x.opencurrentdatabase(dbname,...)
....
I found no way to open it except in access 2003 where in the
opencurrentdatabase it included the pwd parameter.
Is there another way to open it?
...
|
2 |
25.08.2006 17:30:20 |
|
I have Office 2003 installed, and need to install MSAccess 2000
i own Office Premium with Access 2000. Currently, I run Office 2003, no
Access. Now I want to use Access, but when I try to custom install only
Access from the 2000 disk, after a long while, the "Installing Microsoft
Office 2000" window installation process displays an uninformative error (the
text is along the lines of "Installation failed - encountered an error."
It seems that this sh...
|
3 |
24.08.2006 21:41:09 |
|
Access 2003 + ODBC + Postgres configuration question.
Hi all,
I need to use Access 2003 to connect to a remote Postgres database (it is on
a network, but I PUTTY'd in and forwarded ports so that it shows up locally
for me if that makes a difference) via ODBC. I used the MIS version of
psqlODBC and have that installed. I just need to know how get it all working
together.
Any help would be appreciated. Thanks for reading.
...
|
1 |
22.08.2006 19:31:03 |
|
time & billing template
I am trying to set up an invoice in the Time & Billing Template in Access.
Instead of billing by project, I need to bill all projects from a client. Can
I just change the Invoice by Project for my use, and if so, how? Or how do I
set up a new invoice. I am somewhat familiar with Access, but not macros....
|
1 |
21.08.2006 18:07:02 |
|
Multiple msaccess (adp) sessions
I have developed a msaccess 2000 project database. The db works fine on all
put one pc (windows xp) which will open one session but no more. The user
should be able to open multi sessions of the db ?. Is there an entry in
options etc which may not allow another session of the db from opening (no
code to disable this has been used)?....
|
1 |
21.08.2006 13:45:01 |
|
how do i install switchboard manager in ms access 2003
when i go to menu tools>add-in manager>
i get a dialog withe *empty* list of addins.
if i click 'new' button, it attempts to explore a folder on my hard disk
which does not have any addins.
i already tried re-inserting the cd, and add/remove features, making sure
that both 'typical' and 'additional' wizards are selected.
i do not get *any* wizards. the switchboard wizard is supposed ...
|
2 |
20.08.2006 20:34:58 |
|
MS Access 2000 Command Button Wizard
I am trying to place a button on a form but the Command button Wizard
will not open. I have already checked to see that the Magic Wand is
selected on the tool bar. Is there something else I need to check on
the setup? What am I missing?
Jimbob
...
|
2 |
19.08.2006 22:27:31 |
|
access 2003 wizards
I need to install the additional wizards - specifically the subform/subreport
one
but am unable to figure out how to do it
could someone pls help
...
|
2 |
19.08.2006 21:43:36 |
|
Install wizards in Access 2003
How do you install the additional wizards (ie SubForm wizard) after the
original installation...
|
2 |
19.08.2006 21:43:05 |
|
licence areement every time I open word or outlook?
just installed office 2003, registered, and every time I open it the licence
aggreement pops up and it is quite annoying...
|
4 |
19.08.2006 16:03:01 |
|
How do I transfer Office 2003 to a new computer? Online order
How do I add Office 2003 to my new desktop? Ordered online for my wireless
but have no disk....
|
4 |
19.08.2006 14:52:31 |
|
template trouble
i need to change a template from a 3 row to a 2 row and not lose my work? how
do i transfer over the work from one template to the other without losing my
work and having to type it over......
|
2 |
18.08.2006 00:33:30 |
|
how do I recover an error in the saved web doc with ny trial code
Server Error in '/OfficeStandardEdition' Application.
--------------------------------------------------------------------------------
Runtime Error
Description: An application error occurred on the server. The current custom
error settings for this application prevent the details of the application
error from being viewed remotely (for security reasons). It could, however,
be viewed by...
|
2 |
17.08.2006 12:59:41 |
|
hp ipaq6500
...
|
1 |
17.08.2006 12:59:02 |
|
flag/trigger
Hi,
I have a form that tracks software information such as date purchased,
amount and expiry date. I was wondering if there was anyway to flag/trigger
the system to notify me when the expiry date is near. An email if possible
if not any other way. I would like this so that I know when the expiry date
is near and I need to reorder.
Thanks, any help would be appreciated....
|
2 |
15.08.2006 22:42:42 |