Open form and filter form & subform using combo-boxes
Thu, 25 Dec 2008 16:03:00 -0800
Hi, (Using Office 2003, but in Access 2000 format)
I have a form that has 14 or so combo-boxes that allow a user to open
another form and filter the records based on their combo-box selections and
clicking the command button. I've had this working perfectly, but have
decided to add in a subform which now c ...
|
capacitor
Thu, 25 Dec 2008 08:05:14 -0800 (PST)
A capacitor is an electrical/electronic device that can store energy
in the electric field between a pair of conductors (called "plates").
The process of storing energy in the capacitor is known as "charging",
and involves electric charges of equal magnitude, but opposite
polarity, building up on each plate.
...
|
Dynamic field
Thu, 25 Dec 2008 05:07:00 -0800
there are 4 fields in a table/form (3 of them are checkbox and one text) so
the question is:
How i can store a value for each time user puts a checkmark on individual
fields.
Example:
option1 (yes/no checkbox)
option2 (yes/no checkbox)
option3 (yes/no checkbox)
result (text)
when user puts a checkmark ...
|
Allen Browne Calendar Code
Thu, 25 Dec 2008 12:19:27 +0000
I am using the Popup Calendar from Allen Browne.
Does anyone know why the line :-
'On Error GoTo Err_Handler
is remmed out on the cmdToday_Click, Form_KeyDown and Form_Open events
on the frmCalendar form. It probably doesn't matter but just wondering
if there is a reason for this.
Peter Hibbs.
...
|
Customize Autonumber
Wed, 24 Dec 2008 13:02:00 -0800
Hello,
I am trying to make an autonumber have IN(yy)-nnn, I have used the forms
BeforeInsert function to write the code, but nothing I have tried is working.
Any help out there would be appreciated. ...
|
Modifying Command Button
Wed, 24 Dec 2008 09:50:01 -0800
I'd like to add a command buttons so that each one is dedicated to Find in a
specific data field, eg a button to search for last name, another to search
for company name. And so there'd be a macros for each button. How do I
modify the script so that it goes to a specific field? Below is the default
script ...
|
data base connection runtime error 3211
Wed, 24 Dec 2008 07:24:00 -0800
i am building an application for our help desk to improve response time for
answering questions regarding insurance information. have an option group
that allows the help desk person to choose a specific region. based on that
option, a combo box generates a list of system names from our legacy systems.
base ...
|
|
|
Using a Query in a Form
Wed, 24 Dec 2008 06:42:05 -0800
MERRY CHRISTMAS EVERYONE!
I just had to do that. Well, on to the problem. I've got a form for data
entry with the control source as the main table...I've also created a
duplicate of the same form with the control source as a query in order to
find data by the primary key and edit the record. I don't like th ...
|
Modifying Delete Button code
Wed, 24 Dec 2008 06:14:04 -0800
In my form I have Delete Button coded by the wizard with some modification as
follows:
Private Sub btnDeleteAsset_Click()
On Error GoTo Err_btnDeleteAsset_Click
If MsgBox("Are You sure You want to delete this asset?", _
vbYesNo + vbExclamation, "Attention!") = vbNo Then
Me.Undo
Cancel = True
...
|
Error 13 type mismatch
Wed, 24 Dec 2008 06:13:00 -0800
I have the following code and I keep getting a type mismatch error. I've
tried every possiblity that I can think of to no avail. I haven't been able
to find anything that seems to relate to my situation.
Dim strOldPosition As String
Dim strNewPosition As String
Dim intOldPosition As Integer
...
|
