Code not assigned to form
Tue, 2 Dec 2008 09:58:00 -0800
I want to run a delete query if someone clicks the x in the upper right-hand
corner of the Access application instead of clicking the quit button on my
form. I'm sure this is very simple, but I'm not sure how to do it.
Can someone show me the proper syntax? Also, what module should this code
be written t ...
|
Random number initializing
Tue, 2 Dec 2008 08:54:28 -0800
How do I initialize the random number function to return different random
numbers for each Access session?
Thank you
Dave
...
|
eval function and command function in access 2007
Tue, 2 Dec 2008 08:07:02 -0800
In previous Access versions i used :
strResult=eval(strTest)
with strTest containing :
instr(command(),"TSE")
since access2007 this doesn't work !
I get error 2425 "Unknown function name"
with tests in debug window i found the issue is in
eval("command()")
The command() function outside eval works but not in ...
|
Callback function
Tue, 2 Dec 2008 06:55:01 -0800
Hello
I've a form that has a button. When I click that button I want to open
another form
in dialog mode to some user data input.
After that the user clicks close on that dialog form and i need to refresh
the main
form.
Is there any callback funcionality in access that i can use to overcome this?
What ...
|
Access 2007 Runtime Issues
Tue, 2 Dec 2008 06:47:02 -0800
I've run into an issue packaging the Access 2007 runtime and a database
program using the ADE.
I'm working with a full version of Access 2007 SP1 under Windows Vista on
the development PC. The database itself is in the 2007 format, converted
from a 2000 format database. The test PC that will be running th ...
|
How to identify the type of query?
Tue, 2 Dec 2008 06:15:02 -0800
Hi folk,
Is is possible to identify the type of query via vba? For example: select
query, delete query, update query?
Thanks in advance.
Tim. ...
|
Add Built in functions in Expression Builder
Tue, 2 Dec 2008 03:33:00 -0800
When I create a query in my works database using the expression builder,
under Functions, Built-In Functions, General.... I can see a list of
functions (Command$, Environ$ and many more). This is an Access 2003
database.
I use Access 2007 at home and have my own database in which I want to use
the Enviro ...
|
|
|
Compare Records & Move to new table in VBA
Tue, 2 Dec 2008 01:11:01 -0800
I want to make a loop whereby i can compare the first record with every other
record until i find a 'True' comparison, if i find this, move the records
into a new table, otherwise, move onto the second record and repeat.
I figured i would do this with a for next loop, i have done them in excel,
but im not c ...
|
Tab Control select issue
Mon, 1 Dec 2008 17:16:01 -0800
I have a tab control with the following proceudre for on the On Change Event:
Private Sub TabCtl0_Change()
DoCmd.Requery
End Sub
Everything work perfectly until someone clicks a SECOND time on the tab/page
that is ALREADY selected. The tab gets a light dashed line around it and many
of t ...
|
Determine office version that is running on users machine
Mon, 1 Dec 2008 13:58:17 -0800
I'm in a situation where I have multiple users of a database application that
are using different versions (2003, 2007) of the same application.
I've got a "front end updater" that I'm trying to give the additional
functionality of downloading the correct version of the database. This is
easy if they alr ...
|
