Code for turning a subform visible with criteria
Mon, 27 Oct 2008 17:58:08 -0700
I have frmMain with frmSub1 (datasheet) and frmSub2 (single, set to
invisible). Both suforms are linked to the frmMain by the ClientID field and
have OrderID in their underlying queries.
I want to turn frmSub2 visible and OrderID-wise filter it by double-clicking
OrderDate value on frmSub1.
So far I've bee ...
|
enter parameter value
Mon, 27 Oct 2008 13:36:50 -0700
When I try to open one of my forms I am asked to "enter parameter value". If
I created this prompt, it was by accident. Right now it is asking for a
value that is of little concern to me. I would like to change it to ask for
the phone number. Because I don't know how I got this prompt in the first
place, ...
|
query help
Mon, 27 Oct 2008 10:13:19 -0700 (PDT)
is it possible to create a query that will have a column that will
contain a concatenated value?
my query consists of a couple of joins right now, but the users want
to see a value the will create several redundant rows so they want
this value displayed in one column.
so i'll be using a column found into the ex ...
|
calculation in form and subform AfterUpdate
Mon, 27 Oct 2008 09:35:03 -0700
I am trying to perform calculations in an imbedded sub form using a field in
the main form.
Both forms are built on queries.
Main form=frmEmployees
Built on query=qryEmployees
Built on table=tblEmployees (key) Field lngempEmployeeNo
Imbedded sub form=frmEmpHours
Built on sub query=qryEmpHours
Built on sub t ...
|
NEED TO ENTER NUMBERS AND LETTERS IN SAME BOX IN ACCESS
Sun, 26 Oct 2008 19:11:00 -0700
I am creating an automotive inspection form and need to enter numbers and
letters in the same box to fill in license plate numbers and also for vehicle
identification numbers (V.I.N. #'s).
Thank You,
Rich Kamphaus ...
|
Access 97 - When opening, returning a form to the prior state when the ap was closed
Sun, 26 Oct 2008 20:54:00 -0500
About 8 years ago when I last used Access 97 I wanted to be able to store
the key fields (autonumber/long integer) into a table which could be read
again after startup. This would restore the user to the place on a form
where he left off in a prior session.
When frmMain first opens after the ap is started ...
|
How copy from a compact disc onto hard drive?
Sun, 26 Oct 2008 18:26:13 -0700
I need to copy a programme (on CD) I am taking. It is about Microsoft Office
XP but NOT IN Microsoft Office. I have Windows 2000. ...
|
|
|
Graphs in forms
Sun, 26 Oct 2008 18:10:10 -0700
I have a Mainform (based on tblClientDetails) with subform (linked on
ClientID and based on some cubersome query with totals). The data in the
subform is conditionally formated (3 colours dependant on the groupnames).
Then I've created graph-Form based on the same query as the subform and
wanted to to put it ...
|
Open and maximixe frmMain when Access starts
Sun, 26 Oct 2008 15:52:26 -0500
I have a desktop ap that opens to display the various object windows when it
starts. How do I make frmMain visible and maximized what Access starts? I
think that once there, F11 returns to the object windows. I want to take
the user directly to where he/she will work.
...
|
calculate mode in access
Sun, 26 Oct 2008 13:08:03 -0700
calculate mode in access ...
|
