Deselect MS Access properties programmatically
Wed, 8 Oct 2008 00:20:01 -0700
Hi,
Can I change properties' values programmarically ?
1. deselect "Open databases using record-level locking" property
2. deselect "Windows in Taskbar" property
3. In Office 2007, Add New Location (folder) in Trust Center tab in Trusted
Locations and select "Subfolders of this location are also trusted" o ...
|
Filter by option group
Tue, 7 Oct 2008 20:01:01 -0700
I have a form that I would like to filter by the status on the form. There
statuses on the combo box are open inprocess accounting and closed. I would
like to have an option box which the user would filter on the option
selected and then only those records would appear. ...
|
start time end time
Tue, 7 Oct 2008 18:06:01 -0700
Thanks for reading this.
I'm looking for a routine that will compare two times. What I want it to do
is have the program accessable between the hours of 5:30am and 5:00pm, or
05:30 to 17:00 only.
I just can't grasp on how to do this.
Thanks,
I hope I can read the reply. Sometimes the message board wi ...
|
Public Variable
Tue, 7 Oct 2008 17:43:00 -0700
I have an Access 2003 *.mde database with front end loaded on local PCs.
There are several tasks that I only want 1 person to perform at a time. I
set public variables and when a user clicks a task's button, it sets the
variable to TRUE. If the variable is TRUE when the next user clicks on it
exit the Su ...
|
MS Outlook VBA Editor
Tue, 07 Oct 2008 22:58:26 GMT
Hello everyone,
I have created an access database for our employees to use and it resides
on a shared data server. I would like create a macro in MS outlook 2003 that
will open the access database. How would I write a code to make this happen?
...
|
Using tables to create code
Tue, 7 Oct 2008 11:48:48 -0700
I read once that you can create code automatically by using tables. Is there
a site that describes how this is done. Seems like I write a lot of
repetitive code, especially property 'get' and 'Let' statements with forms.
Thanks ...
|
Changing Function
Tue, 7 Oct 2008 11:20:04 -0700
Database tracking points based rewards system for a mall.
One table keeps rules for calculation how many points are rewarded for a
given purchase. There could be a hundred rules that change from month to
month. They include things like points per dollar spent, rewards that apply
only to one store, upper l ...
|
|
|
Advanced Functionality through VBA
Tue, 7 Oct 2008 11:04:01 -0700
Welcome to the world of MS Access. MS Access is a wonderful program that
allows intermediate office users to create simple applications for storing
data and manipulating it.
Most users want to do similar things. They want to have combo boxes that
filter other combo boxes (commonly called cascading combo b ...
|
Create Linked Table to Another Network
Tue, 7 Oct 2008 10:38:09 -0700
I have a split db that I develop on my local pc. Is there a way for me to
change the table links to a given path prior to delivering to my client so
that I do not have to do on-site?
QB ...
|
Using SendObject from Access 07 - need help with OL 07 warning
Tue, 7 Oct 2008 09:08:15 -0700
Using Office 2007 and exchange server...
Previously posted in Outlook VBA and in General Questions ...
I finally found a vb script that will email out my reports to individual
recipients. Works great! Now I'm encountering the dreaded warning message
about "A program is trying to automatically send email on y ...
|