Command button to open form and find record
Mon, 6 Oct 2008 22:02:21 -0700
Access 2007
I have a continous form frmIncomplete. I put a command button in detailed
section. When clicked, I want to open frmMaster and locate the same record
by ID (primary key AutoNumber).
Private Sub cmdEdit_Click()
DoCmd.OpenForm "frmMaster", , , "[ID] = " & Me![ID]
End Sub
Above code will o ...
|
Time Counter
Mon, 6 Oct 2008 20:29:00 -0700
Hi, I have a VBA code running a set of queries. How can I add a time
ticker/counter - Day, Hours, Minutes and Seconds starting like Day: 0 Hours:0
Minutes: 0 Seconds: 0. Cheers ...
|
Capture Form Data to Populate Table
Mon, 6 Oct 2008 15:10:57 -0700
I have a table (tbl1) already defined, but with no data in the table, some
fields have lookup to tables, and some fields have a LOV, used to limit our
users choices.
I have created a form based on table (tbl1) and 2 other tables.
What I want to do is have our users fill out the form and then I would like
...
|
Aggregrate Amount in updateable query
Mon, 6 Oct 2008 14:16:05 -0700 (PDT)
Hi,
I want to have a form based on a query which has all updateable fields
except one which will contain a quantity joined in from an aggregate
query. I understand that joining in this field would make the rest of
the fields not updateable. I also wanted to sort the results based on
this aggregate field.
T ...
|
I Can't edit moveable field
Mon, 6 Oct 2008 14:02:09 -0700
I can't edit the movable field when creating a form. I need to be YES and
it's stuck on NO ...
|
What is wrong with my code?
Mon, 6 Oct 2008 12:52:07 -0700
This code does not pause and allow the user to pick a sort method on form
"area form." I brings it up for a second and goes right on to the report.
What do I need to do? Even if I pick "no" it briefly shows the area form and
then goes right on to the report. Thanks!!!
Private Sub Command25_Click()
On Error G ...
|
new subform entry for existing record
Mon, 6 Oct 2008 11:13:03 -0700
Hi
I have my mainform with 2 subforms. If a record in the main table already
exists, it can have multiple events attached to it in other tables. Using the
form, if a user enters an already existing primary key the form will
automatically call up data in the subforms. However the mainform does not
bring up t ...
|
|
|
How to play .wav file in form
Mon, 6 Oct 2008 09:38:01 -0700
Does anyone know how I can have a wav file play when a command button is
clicked in a form? ...
|
Editing SQL Server data using an Access Form
Mon, 6 Oct 2008 09:33:02 -0700
Hi,
One of our established tools has an Access front end to SQL Server data. For
some time, users have sucessfully read data from that tool and added records
to the SQL tables using append queries.
I am trying to add another feature which enables them to edit the data
contained within one of the SQL ta ...
|
Select which set of data a form uses
Mon, 6 Oct 2008 09:20:03 -0700
Hello,
MS ACCESS 2003 on XP PRO.
Here's what I am trying to do. I have a Fuel Card inventory. It has a
History table that knows when a fuel card was assigned and when it was
unassigned.
FCNo, Assign, Unassign.
I want to fill a form (columnar, one record shown at a time.) with the
results of on ...
|
