Search results

?? Missing reference libraries? (I once had a perfectly good statement using the Left() function error because a referenced object library-- one with nothing to do with "Left()"-- was missing on a particular computer.)

My proposed solution is faulty. The GotFocus for a control for a Pop-up form will not fire when the form activates if that control had the focus the previous time the popup was active. So again my original question: how to get an event to fire when an open popup form becomes the top-most...

Can you provide some details? Are you looking at a form in datasheet view, or directly at a table (or query)? Are you setting a variable? As in... SomeVariableName = Me.NameOfControl If so, what is the data type of the variable (variant, string, etc.).

Another straw to grasp, are you sure ConnectStr is correct? If Access is telling you 'value invalid or not set' it could be referring to either tdf.Connect or to ConnectStr. ConnectStr = ";DATABASE=" & db_Prefs("Path") & db_Prefs("DB") For Each item In tables table =...

Please accept apologies for a very long question... I wish to display all the forms and reports (in a database with 40+ forms) as popups, just because I think the user interface will be better if the form windows are not bound to the main Access window. Most of the forms are opened using an...

GalaxiomAtHome's method may work... I'd have to think about it. Another simple method might be to use a Timer Private Sub Form_Open(Cancel As Integer) 'or Sub Form_Load Me.TimerInterval = 1 'timerinterval is in milliseconds, but anything > 0 ought to work End Sub Sub Form_Timer...

I like lagbolt's response. I've experienced the same issue. To answer the question why, I've found that codeCurrentProject.Forms("frmDetail").SetFocus causes a run-time error if frmDetail is a Popup. Best I can figure is "DoCmd close" attempts to close the form that has the focus. But, as...

Doubt this is it, but here's all I can think of... Is the field actually named "SCF_ID"? Or is it "SCF ID" (no underscore)?