How to lock records until specific conditions are met?
Wed, 3 Dec 2008 08:26:40 -0800
Look at the table (tbl_Main) below. The first 6 records are Locked because
they have Null in Date_Completed. Records 7-19 & 25 are not locked because
The Date_Completed is Not Null. This is easy enough and I can implement it
with a Lost Focus event on the Date_Completed control.
However, for records 20 & 21 ...
|
Use a string as a field name
Wed, 3 Dec 2008 07:46:01 -0800
I am looking through a recordset at individual records, when i call
rs1![Field 1] its fine
however, i want to be able to use a variable name instead, which contains
the name of the field as a string e.g.
rs1!Variable1
Note: The String may contain spaces.
How do i get this to work?
Thanks
Tom
...
|
How ofted should one compact and repair?
Wed, 3 Dec 2008 07:34:07 -0800
Hello all,
What is a good timeframe for carrying out the compact and rapair task on a
split database (compacting the back end). I am guessing it depends on how
much a database is being used, but would like to get some input.
What are some indications of a need for compacting and repairing a database?
...
|
Passing Variable Value
Tue, 2 Dec 2008 15:33:02 -0800
I have very little experience passing variables between forms, modules, etc.
I haev experimented with creating public variables in a forms declaration,
but have not had any luck.
I would simply like to populate a field on an open form with a value after a
record in another form is created, but I only want ...
|
Determine current directory
Tue, 2 Dec 2008 15:03:02 -0800
When I use the CurDir function the value returned is only 2 levels. The
application is infact on the fourth level. Is it possible to determine 4 or
more levels deep?
--
Tony ...
|
Network access
Tue, 02 Dec 2008 14:14:52 -0800
I have an Access VBA app on a network folder that I'd like to run
simultaneously by multiple users. I can run one instance over the
network, but not two at once, unless the second instance is from the
folder in which the app resides. The second instance doesn't even get
to the security warning. I can run ...
|
Copying Form from one Access db to another.
Tue, 2 Dec 2008 13:59:00 -0800
Hello,
I'm new to VBA Access. I have 2 databases that have the same information.
One db is a staging db and the other db is production. I created a form in
the staging db and it successfully executes everything I want it to do.
However, when I copy the form to production, I get a compile error,
"User- ...
|
|
|
Updating Excel links from Access Vba
Tue, 2 Dec 2008 13:54:01 -0800
I thought I had this issue resolved about a month ago, guess not. What I
have are 5 different spreadsheets that have links to external sources.
Unfortunately non of them are the same format and aren't compatable with
access in there current format. So what the code is supposed to do is open
up the Excel w ...
|
VBA code problem
Tue, 2 Dec 2008 12:38:02 -0800
If [FunctionHours] = Null Then
[DateCompleted].SetFocus
If [DateCompleted].Value > 0 Then
Response = MsgBox("When a completed project date is entered,
Total Function Hours must be entered. 0 is allowed. ", vbOKOnly, "Completed
Project Warning")
...
|
Save a Word document as .txt from within Access
Tue, 2 Dec 2008 10:33:00 -0800
Is there a way to save a Word document as a .txt file using VB code? I don't
want to ask my users to "save as" because they will be working with
thousands of documents on many different servers.
--
Carol ...
|
