subtracting a figure from the same column
Mon, 18 Aug 2008 05:40:02 -0700
I'm trying to subtract two figures from the same column (ex: a figure from
line 11 column B - a figure from line 10 column B) and then put the total in
a field on a form. Can someone help me with the expression I need to put in
the event for that field. I'm thinking it should go in the OnCLick property ...
|
how can I get text in a control to flash?
Mon, 18 Aug 2008 03:53:00 -0700
Using Access 2003 on Windows XP SP3.
I want to highlight a warning on a form if Boolean field has the value "True".
I would like to get the control that displays the value to Flash on-and-off.
Any ideas?
Thanks ...
|
Two Part - complicated question (To me at least...)
Sun, 17 Aug 2008 19:23:07 -0700
Hi
I have a Form that is designed using a tab control. Page 1 of the tab
control is of benefactors, page 2 of the tab control is of the deceased.
Basically, when benefactors call they do so to request prayer for the
deceased. Therefore, their name is added and the deceased person is added
(fields inclu ...
|
New record problem in sub-form
Sun, 17 Aug 2008 13:57:02 -0700
I have main form based on a table, linked to a sub-form based on a junction
table. Everything is working pretty well except: The PK of the junction table
is an auto-number field and it is displayed in the subfrm. When I tab from
the main form to the subform, the autonumber field (PK of subfrm) is blank
until ...
|
Filtering subform combo from main form combo
Sun, 17 Aug 2008 18:36:06 GMT
Hi Everyone
There is something i am missing here.
I have a sub form on a main form.
I have set the combo on the main to filter the combo on the sub form and its
working all right.
code:
Private Sub cboProgram_AfterUpdate()
Dim strSql As String
strSql = "SELECT lk_Indicator.IndicatorID, lk_Indicator.Indicat ...
|
Close subform but leave main form open
Sun, 17 Aug 2008 06:43:01 -0700
I have a main form in datasheet view called MainForm. On MainForm is a
subform called DataSubForm. DataSubForm has a Close command button on it.
When I open the subform and enter my data I want to be able to click the
Close button on the subform to close it (collapse it out of the way) and
leave MainForm ope ...
|
tab entry vs. command button entry
Sat, 16 Aug 2008 20:28:14 -0700
I have a form that has text boxes and combo boxes bount to a table. If i add
my data and tab all the way through the form it enters the data into the
table. I would like to change this behavior to require a command button to
enter the data.
I know i can unbound the form data and do something like this...
...
|
|
|
Using only one record
Sat, 16 Aug 2008 18:08:00 -0700
I have a database that the user enters in information related to customer
name, address, etc., along with selecting the item to purchase (a storage
building in this case). Additional combo boxes allow the user to select the
options and the number of each option, new or used, discounts, colors, full
purchase ...
|
switchboard problem
Sat, 16 Aug 2008 11:21:01 -0700
Hi any idea why my switchboard stays on top of my open ojects when i use it
to go to an object. the exampl is, when i click on my contacts table it does
ope but stays behind the switchboard. any help will be much appreciated
thanks guys for your continius support ...
|
Pulling information from master/detail tables for report
Sat, 16 Aug 2008 10:45:00 -0700
The heading basically says it all. I have finished the master and detail
tables and forms. Now I need to be able to print a report based on my
selection from the master table, obviously including the corresponding info
from the detail table.
I'd like to be able to do my selections from within a new form. A ...
|
