Mi R4ultra ds me va muy bien
Wed, 7 Jan 2009 13:04:21 +0100
...
|
Displaying attached Printers in a List Box
Wed, 07 Jan 2009 07:52:20 GMT
Hello,
I have a list box on a form that displays the printers attached to the
computer. The lst box is called lstPrinters and I use the following code in
the form's Open event to populate the list box:
For Each prt In Application.Printers
Me!lstPrinters.AddItem prt.DeviceName
Ne ...
|
Checking if form is a sub-form
Tue, 6 Jan 2009 16:32:00 -0800
I designed a form that should only ever be used as a sub-form in another
(parent) form.
It all works well except that I thought I would ensure it is never opened
directly and only ever as part of the parent form.
In the sub-form's Form_open event I thought I'd be able to just check
whether the sub-form's P ...
|
Message appear while Access is thinking/working
Tue, 6 Jan 2009 15:06:06 -0800
Hi All,
While data are being retrieved and records are being written to forms,
Access is â??frozenâ? (aka thinking/working), during that time â?¦ do you know if
we can have a message â??Updating employee information in progressâ?¦â?¦.â?? After
the updating is completed, then another message appears "Empl ...
|
If statment based on more than one factor
Tue, 6 Jan 2009 13:00:01 -0800
I currently have the following code on one of my forms
Private Sub EarTag_AfterUpdate()
If (DLookup("CalfSex", "tblBirthInformation", "[EarTag]='" & Me![EarTag] &
"'") = "C") Then
DoCmd.OpenForm "frmTHE"
End If
End Sub
The code looks at the Eartag (text) that was entered into
frmDispositionRecordIndID, ...
|
Decimal number with ListCount in the expression
Tue, 6 Jan 2009 10:30:21 -0800
Hi,
I have a text box on a form (ChangeOrderSeq) where I would like to display a
number based on the count of records and a the result from a yes/no box
(NoteOnly). For sorting purposes I need that number to be have one decimal
place precision. I can't get the number to show decimal places. The table
fie ...
|
create a popup calendar
Tue, 6 Jan 2009 10:11:03 -0800
I want to be able to click a button on form1 and cause a popup form with
calendar control and when a date is selected the popup closes and form1
filters the records based on the date value. I think the only help I need
now is how to get the date selected from the popup into the filter statement.
Can someon ...
|
|
|
Copying back-end files from the front-end.
Tue, 6 Jan 2009 09:36:41 -0800
I have a split database, in which it would be particularly convenient if
front-end code could be used to copy tables in the back-end. So far, though,
I have been unable to achieve the desired results.
1. If the command â??DoCmd.CopyObject, â??tbl_Targetâ?, acTable, â??tbl_Sourceâ? is
run in the front-end, ...
|
keyboard instead of button
Tue, 6 Jan 2009 19:13:29 +0200
Hi!
I am working on a form for my work, and i wonder if one cane execute a macro
or a module with a keystroke (e.g. F5) instead of clicking on a button.
Does it need some vb know how?
thnx
Irene
...
|
There is an invalid use of the .dot or ! or invalid parenthses
Tue, 6 Jan 2009 08:11:01 -0800
Hi,
I am using the following code in the form load event to lock a field on a
form based on values of fields in the main and the subform. However when I am
running this form I am getting the above error:
There is an invalid use of the .(dot) or ! operator or invalid parenthesis
I cannot figure out why I am ...
|
