Form entry order
Tue, 30 Dec 2008 11:16:08 -0800
I have a subform which records entries in reverse order. (I am referring to
the record number in the bottom left corner of the form).
For example, I enter record number 1 then click the right arrow to go to the
next record entry. However, instead of advancing to record 2, it goes to a
blank record 1, meanwhi ...
|
Filtering a Form with a Query
Tue, 30 Dec 2008 11:11:01 -0800
I am trying to apply a filter to a form based on a query. I have four fields
that I would like the user to input from before applying the filter. I am
having difficulty getting the filter to display the desired result. The user
can input from 1 to 4 variables, in this case they are;
- Supplier Code
- Bu ...
|
Type MisMatch Error Associated With Dlookup Function On Form
Tue, 30 Dec 2008 10:10:01 -0800 (PST)
Any ideas why I would get a Type Mismatch error when I try to run this
via code?
Dim MyInt As Long
MyInt = Me.SelectUnAppTicket.Column(1)
Me.UnAppST = DLookup("[Start Time]", "UnapprovedTickets", MyInt =
"[UnapprovedTickets]![PTID]") ...
|
DLOOKUP - Multiple criteria
Tue, 30 Dec 2008 09:42:01 -0800
Happy Holidays!!
I want to auto fill a text box using two other text boxes as criteria, but
my DLOOKUP results in unrelated data.
The data I need is VendorName
The criteria are Invoice# in tblMASTER (to coincide with Text40 on the form)
and Vendor# in tblMASTER (to coincide with Text52 on the form)
...
|
Expression Builder Help
Tue, 30 Dec 2008 08:42:01 -0800
good morning to all,
I was asked to help with a problem.
we have 1 form (based on 1 table) and want to have 1 text box based on a
field in another table. Using this " = [Viable Tissues]![specimen comment]
" Where "Viable Tissue" is the name of the 2nd table and "specimen comment"
is the field.
w ...
|
Limit access to tab control page with field
Tue, 30 Dec 2008 16:30:03 GMT
Im trying to block users access to certain fields unless another field (combo
box) contains the word "complaint". The combo box "InspectionType" is on one
page (Inspection Information) of a tab control and all the fields that I dont
want users to access are on another page (Complaint Information) of the
control. ...
|
error message on open form
Tue, 30 Dec 2008 07:49:01 -0800
Hello, I have a click event that references a function in a module, but
everytime i use it i get the following error
This error occurs when an event has failed to run because Microsoft Office
Access cannot evaluate the location of the logic for the event. For example,
if the OnOpen property of a form is set ...
|
|
|
Northwind 2007 login form?
Tue, 30 Dec 2008 06:54:09 -0800
I'm creating an inventory database and I would like to use the Northwind 2007
login form. I've created an identical form with the same combo box and login
button. I've recreated the macro on the login button exactly, but when I use
my version, it won't take me to the record I have selected in the combo box.
...
|
Need help creating a volunteer time tracking database
Tue, 30 Dec 2008 06:12:00 -0800
I have a form set up with a drop down box for them to chose their name and
then I have a sign in button and sign out button but I'm not sure how to
configure them so that it will log the time in when they click the sign in
button and log the time out when they click the sign out button and be able
total up t ...
|
Subform counts records in reverse order
Tue, 30 Dec 2008 05:57:01 -0800
I have a subform which records entries in reverse order. For example, I enter
record number 1 then click the right arrow to go to the next record entry.
However, instead of advancing to record 2, it goes to a blank record 1,
meanwhile the first record I entered is now record 2.
If I enter a new record and ...
|
