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 ...
|
UI freezes on DoCmd.Close
Fri, 12 Dec 2008 18:51:02 -0800
I have a bound Form which does not close properly with a DoCmd.Close (fired
from the OnClose event of a "Close" button on the form). When this executes,
the Form does close (because pressing Enter will open it again from the
selected control on the form beneath which launched it in the first place)
but the A ...
|
fields on form 'shift' when record is saved?
Fri, 12 Dec 2008 16:51:57 -0800 (PST)
Would anyone know why when data is entered into a form and then the
record is saved that a couple of fields shift to the left? The align
is set to center and all but two of the fields stay centered. If
someone could help on this, I'd appreciate it. Thank you. ...
|
Searching/Modifying/Deleting Records on a Subform
Fri, 12 Dec 2008 13:33:30 -0800
I want to be to change or delete records on a subform based on whether or
not they contain certain text strings.
How do "search" for the relative records (i.e., the records that contain
certain strings)?
How do I obtain the ItemID from that record?
How do I change the value of one or more fields in that r ...
|
Differenc between Lost Focus and On Exit
Fri, 12 Dec 2008 13:14:00 -0800
Can someone explain the difference between these two events for me please? I
want to creat an event to move the cursor to the first input box on the form
when the user clicks the New Record button.
Thank you,
--
Jacqueline ...
|
|
|
Save record on lost focus
Fri, 12 Dec 2008 13:06:00 -0800
Hi,
In a countinuous form, I have 2 controls ctrA and ctrB that make up a set of
records. I have control ctrC on the form footer counting the records if ctrA
has a value regardless of the ctrB's value.
ctrC counts the records only after the user moved to the next line or to
another set of record. So in a s ...
|
Ac 2007 Timer hangup in ACCDE
Fri, 12 Dec 2008 12:46:07 -0800
Why would a timer event work fine in an ACCDB but not in the ACCDE compiled
version? This very same programming worked fine in Access 2000 to 2003 MDE
versions. The specific problem is that the timer event is not being run at
the 'Timer Interval" setting. The initial setting freezes on the screen. Is
this a ...
|
Check textbox value before change
Fri, 12 Dec 2008 11:43:31 -0800 (PST)
I have a form called Edit Application which is used to pull a record
from the tblCreditApplicationInput table and display the record for
Editing. One field is called Date Rcvd, which was created when the
application is created. Another field is called status which uses a
combo box to pull 4 values-Draft, IN Pro ...
|
