Update textbox via subroutine call
Sun, 14 Dec 2008 12:11:01 -0800
I need to update a field (textbox) on several very similar forms. To reduce
the amount of code and to preclude having duplicate code to do the
calculations in each form I want to use a subroutine to perform the
calculations.
I want to call the subroutine with several parameters and have it return the
res ...
|
before update event
Sun, 14 Dec 2008 10:39:00 -0800
I have a form and subform. In the subform, I want to allow entry only if one
of the fields in the main form has one of two values. This is the code I put
in the BeforeUpdate event of the subform but nothing happens. Any
suggestions would be great - especially if there was a way I could disable
the locatio ...
|
Validation rule using calculated value from another subform
Sun, 14 Dec 2008 08:47:00 -0800
I have form with 2 subforms.
1st subform shows assets' names (securities etc) and its overall
possessions(calculated sums of all transactions money-wise and units-wise)
and is based on query using tblTransactions
2nd subform is TransactionForm - with controls for AssetName,
TransactionKind (Buy-Sell), Price ...
|
Capturing the first keystroke
Sat, 13 Dec 2008 21:55:00 -0800
What form event do I use to trap a users first keystroke on an unbound form?
I have placed breaks on KeyUp, KeyDown and KeyPress but none of the events
seem to trigger with a keystroke. If I could work this out I would then moove
on to the following problemwhich someone may be able to help me with also.
I hav ...
|
Programmer - an organism that turns coffee into software.
Sat, 13 Dec 2008 21:20:56 -0800
http://www.quotegarden.com/programming.html
--
Are your loved one's OK?
http://www.onecalladay.com/
...
|
Open database from child form
Sat, 13 Dec 2008 19:27:01 -0800
Hi,
I have a subform and a button that I want to click to enter a new record on
the subform. I've tried the following but it doesn't do anything. When I
click the 'Add New Record' on the bar at the bottom of the subform, it opens
to a new record; this is the action that I want to replicate on my button.
How ...
|
Imbedded Macros
Sat, 13 Dec 2008 18:34:01 -0800
Does any one know if you can attache an event (insert date in date field) to
an imbedded macro that triggers from a command button?
The command button: "Save Record"
Action wanted: Insert current date into date field in addtion to save
record.
Thanks for the help. ...
|
|
|
Handling Bugs
Sat, 13 Dec 2008 12:15:01 -0800
I develop software for schools. The system is quite an extensive database.
It contains over 100 forms with an average of about 8 printed pages of coding
per form. I distribute the software with a runtime version of Microsoft
Access 2000.
With all these forms and coding, I'm being haunted my minor bugs th ...
|
Frustrated - Creating Auto Number
Sat, 13 Dec 2008 09:35:01 -0800
I've tried so many times to get this without asking for help.
I have a number field containing the current date in yyyymmdd format (this
is being used as a reference number). Then, there is a customer number of
that day (we are taking orders) formatted 000 (first order of that day is
001, second is 002, et ...
|
Function Call ?
Fri, 12 Dec 2008 19:45:00 -0800
Hello all,
I want a public function that I can call from any procudure. All it does is
display a message. The trouble I'm having is in the call itself. I just
want to be able to execute it when needed wherever required.
How does one call a function that passes no values?
-S ...
|
