Recent content by Bahamas

Instead of the DoCmd.OpenForm line, put this in: MsgBox Prompt:="Message here", Buttons:=vbCritical, Title:="Title here" Or if you're lazy: MsgBox "Message here", vbCritical, "Title here"

Try This: Private Sub h_afterupdate() Me.tot_secs = (Me.h * 3600) + (Me.m * 60) + Me.s If Me.tot_secs = 0 Then DoCmd.OpenForm "SecsOn", acNormal, , , acFormReadOnly, acWindowNormal End If End Sub Private Sub m_afterupdate() Me.tot_secs = (Me.h * 3600) + (Me.m...

You can still use a For Loop, but structure it like this: For j = 0.1 To dblHighest Step 0.1 Next

Ok, I have a little more information now. It is crashing at this line: cat.Tables.Append tbl and here is the error message: Run-time error '-2147467259 (80004005)': Object invalid or no longer set The LinkTable function that this code is in usually works, it's just once a day that it seems...

My issue is still not solved. The program calls the LinkTable function below. Every morning, it doesn't link for her, so I have to go over and manually (that is, through Access UI , External Data, instead of VBA) link it. I've tried running the LinkTable function separately, and it still didn't...

The FrontEnd is stored on a network drive, and the users click a batch file that copies the FrontEnd to their C: Drive. You hit it on the head - I was just told that it was due to an audit request in order to not have the data be persistent.

Thanks - I'm leaning towards removing the code that unlinks the tables. Just wasn't sure if there would be any consequences.

We have an access program that unlinks a table after certain functions, and relinks it in others. Is there a need for this? For one user, the table does not link, so we have to manually go over and link it for her everyday. I am wondering why it was built to unlink and relink - shouldn't the...