Latest activity
-
Mike Krailo replied to the thread Automatic field update.I am assuming you mean store the color name associated with each category in the color field of the Data table. The Data table is the... -
-
You're so full of TDS, you don't make any sense. Does it upset you that there are laws that call for significant civil and criminal... -
AAngelSpeaks replied to the thread DOGE.You're so full of TDS, you don't make any sense. Does it upset you that there are laws that call for significant civil and criminal...
-
theDBguy replied to the thread Capturing 2 signature on form from 2 user.I didn't get that error when I was using it. Can you try to duplicate the error and tell me step-by-step what you did to reproduce the... -
Ttheinviter replied to the thread Capturing 2 signature on form from 2 user.HI: got Run time error3188: could not update: currently locked by another session on this machine. once i click on Debug highligh the...
-
XPS35 replied to the thread Automatic field update.If a field can be automatically update, you do not need to store it. Use a query to show the related value. -
JJosef P. replied to the thread Update query doesn't like value formatted for a different region..Use Str(...) SqlText = "UPDATE [Order Details] SET ODHaulageRate = " & CStr(1.2345) & " Where ..." Debug.Print SqlText ' => 1,2345...
-
CChrisLeicester replied to the thread Compile error again.Hi Thanks everyone, progress is being made. using the ? in the immediate box, I can see the SQL line and checked each variable and each...
-
This is not a datatype issue, it cannot find [days remaining]. Step away from the report. Open the query the report is based on. Does... -
DHookom replied to the thread Compile error again.Sorry, my autocorrect wrote Current DH (my current initials) rather that CurrentDB.
-
EEdgar_ replied to the thread Solved Backup after 6x.Strategies in order of convenience: 1. Log sessions in a table 2. Log sessions in an external file 3. Log sessions in a registry key 4...
-
If that line reads like this: Current DB.Execute strAppSQL, dbFailOnError then your problem is that "Current DB" is a bad variable...
