Search results

Here's my nightmare. I'm doing development on a large Access program (lots of VBA). One day I open the Access file and my forms are completely messed up. Property sheet values have changed everywhere... in the forms themselves and also in the controls. Actually this has happened several...

I'm trying to write to a file using a combination of DoCmd.TransferText (to a temp file) and DOS commands. Problem is, the lines are getting written out of order! Here's a snippet (this is actually part of a loop): strCmd = "cmd /c echo " & strHdr & " >> " & strPath Shell (strCmd)...

[Note: This pertains to an Access Data Project (ADP).] I modified a stored procedure on SQL Server, and later discovered that my changes had disappeared. I'm wondering if there's any possiblity that my Access ADP might have been the culprit. I would think the answer is no. When I open an ADP...

How do I programmatically force an error dialog to make a certain choice? I'm able to trap the dialog via the following code: Private Sub Form_Error(DataErr As Integer, Response As Integer) If DataErr = 7787 Then 'record updated by another "user" (subform) MsgBox "Error trapped!"...

I have a subform which makes a change to a field on the main form. When focus is returned to the main form, the BeforeUpdate and AfterUpdate events fire. Why? I thought from the form's perspective, the subform is just another control. BTW, I get the same behavior if I modify the field from...

I'm supporting some Access/VBA code which includes the following behavior: When an update is made in a (linked) child form, the current date/time is written to a textbox on the main form via Me.Parent!txtMod = Now Likewise, the BeforeUpdate event of the main form updates the same field...