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 ...
|
|
|
What is wrong with my code?
Fri, 12 Dec 2008 10:51:01 -0800
The code below works on some computers and does not on others. all computers
are on the same net work. the code breaks on ".send" and gives me an error
message "user send error". I am using Access 2003 so are the others.
any idea?
Sub Mail_CDO(strTo As String, strFrom As String, strSubject As String,
str ...
|
acPasteAppend Adds Record Instead of Update Record
Fri, 12 Dec 2008 09:45:01 -0800
Is there a way to use the acPasteAppend to update a record instead of adding
a new one? On my form I have a "Copy" button and a "Paste" button. This is
the code:
On the copy button (Command2) this code in the Click Event:
Private Sub Command2_Click()
DoCmd.RunCommand acCmdSelectRecord
DoCmd. ...
|
Mouse button Pop Up
Fri, 12 Dec 2008 09:38:02 -0800
In Access 2000 and Windows XP, I have a label with no caption. I use it so
that an admin can right click on the form and some command buttons become
visible. If the admin right clicks again the command buttons become
invisible.
The problem is that when you right click on the form you get a pop-up menu
w ...
|
