Max Function in Row Source Coding
Fri, 12 Dec 2008 09:00:09 -0800
I am having a minor problem with some coding I have for the Row Source in a
database. The current code is based on filtering the dropdown list an the
last month's data:
SELECT tblA.REVCENTER, tblA.FACILITY, Sum(tblA.TOTAL_AMT) AS SumOfTOTAL_AMT
FROM tblA
WHERE (((tblA.MONTH)=DateSerial(Year(Date()),Month( ...
|
Data from a subform into a query
Fri, 12 Dec 2008 08:44:21 -0800 (PST)
Hello all:
I have a form with multiple tabs displaying subforms. I want to use
data from both my main form and a subform as the criteria for a query.
The result set for this query will be passed to a process to create
indvidualized letters.
How can I get the data from the subform into the query. I use the
...
|
Triggering a sub-form linked to the record
Fri, 12 Dec 2008 07:47:01 -0800
We have a form that has a drop list that contains a value that when selected
will activate a command button. The sub form has a field that links to an
identifying number on the original form. I need to know how to activate a
button based on a combo box selection, How to keep the button deactivated for
all ...
|
When A User Brings Up Access, Is There A Way To Hide The Office
Access background?
Fri, 12 Dec 2008 07:09:14 -0800 (PST)
Hi,
I have an access database application and I would like to hide the
actual program so the user can only see the form he is currently on.
Is that possible? I really hope so... ...
|
Create a form with fields from multiple tables
Fri, 12 Dec 2008 06:56:04 -0800
How do I create a form for each record in a table that also pulls information
from other tables? ...
|
Click record to open form
Fri, 12 Dec 2008 06:48:04 -0800
How do I click on a record and have it open that record's form? ...
|
Align Controls by Center or Middle
Fri, 12 Dec 2008 06:38:03 -0800
Is it possible to align selected controls by their middle or center (as in
other layout programs)? This is possible in Excel Userform Design..
Thanks,
Matthew Pfluger ...
|
|
|
Special Object
Fri, 12 Dec 2008 06:07:01 -0800
Hi guys,
How can I created an object to select record, like the ones used to choose
the records to create reports in access, those that you select the record
from a list, press the arrow and the record move to another list to the right
and those to the right are the ones you are working with, you can also r ...
|
syncronizing forms
Fri, 12 Dec 2008 05:22:48 -0800 (PST)
hi
I want to synchronize two forms that have the same record source one
data sheet the other single form in an unbound form
I used this code in the load event
Set ajobs_sht.Form.Recordset = ajobs_form.Form.Recordset
I'm getting run time error 424
object needed
i'm using access 2003
is there another way to do ...
|
Macro Not displayed
Thu, 11 Dec 2008 21:20:00 -0800
I have a small database. In it, I have a form set up so that when I enter a
score(number) in a certain text field (eg: 190+) a maco is set up to put the
same number in a number field, without the +(here it would be 190 without the
plus). This 190 number is added with another number for a total score
(obvious ...
|
