Find Record Button Question
Sun, 7 Dec 2008 20:46:40 GMT
Hi,
I'd be grateful for some help. I'm using Access 2003.
I've created a button on a form to find a record in my db, using the wizard,
based on a person's surname.
Looking at the VB under "Build Event" the code shows the following:
Private Sub Find_Surname_Click()
On Error GoTo Err_Find_Surname_Click
...
|
Correct Syntax for Function Call
Sun, 7 Dec 2008 10:31:01 -0800
I have a form with a sub form.
I have an object on the main form that is bound to the Ward_ID field in a
table. The object's name is txt_Ward_ID.
I have another text box ("Totals") on the form that I want to populate using
a function. The function does a sum of data entered through the sub-form.
When I use ...
|
Copy Paste Form Data
Sat, 6 Dec 2008 15:55:00 -0800
I would like to copy data I enter in a form's field(s) and paste it into
another form's field(s). The purpose is to copy and paste time and miles for
a transport log. The (cntrl ') will not work since the records are not in
sequential order. Is there a way to make a command button one "Copy" and
another "Pas ...
|
Can't Rename Form in AC 2007
Sat, 6 Dec 2008 18:44:31 -0500
I try to rename a form by right clicking and selecting Rename.
After I rename it and hit enter I get the following error message:
'Module not found'
I haven't the foggiest.,
James
...
|
Looking for generic QBF template...
Sat, 6 Dec 2008 15:39:53 -0800 (PST)
Folks
I'm looking for some sort of generic Query by Form UI, i.e. a very
typical form where the user would be able to select search criteria
and see the results in a list.
I have developed a few custom apps which are working relatively well
for this purpose but I now want to try a generic approach, i.e. hid ...
|
Copy Data from Subform
Sat, 6 Dec 2008 12:40:17 -0800
I need to select a record in a subform and have a field in that record
copied to an unbound control on the main form. Using a command button and
macro I can go to the unbound control, but can't figure out how to insert
the data.
The main form is a tab-control form. It opens to an unbound text box called
W ...
|
Right click menus Pivottable..?
Sat, 06 Dec 2008 20:10:42 GMT
Hi all,
I can not figure out why the full right-click-menus doesn't show when a
form is set to Pivottable.
I would like to se "Sort by" and "Fieldlist".
Right now I only get "Properties".
Where do I set this?
Kent J.
...
|
|
|
check boxes
Sat, 6 Dec 2008 19:32:56 +0200
Hi there
I have a form with some fields on it. Now i would like to add a few check
boxes to my form. but when I check
them, they are not checked when i return to that specific record?
Please could someone assist me
thank you
Melissa
...
|
how to retrieve multiple colums from a table using a listbox?
Sat, 6 Dec 2008 09:04:02 -0800
Access 2007- form
I am using a lookup file with multiple columns.
I use the table to populate a listbox.
I want to have the user click on an entry and retrieve multiple columns from
the lookup table.
For example:
Choosing 'physical exam' from listbox and i want to retrieve pay type, code,
and fee col ...
|
Data entry
Sat, 6 Dec 2008 13:47:31 -0000
Hello
The database in question has a Menu where the user can choose several
options one of which is a form which displays his own data in a list. In
that form he can then choose the record he wants to work with which opens
the main form. ('Clients')
I'd like to add in the Menu a command to Add a new Client ...
|
