Recent content by DrallocD

Why did you include "AND LEN(@strInprocess) > 16" ? I looks like this will fail if the length is less than 16 chars.

Try converting the Long Filename to a short one. The link explains how: http://support.microsoft.com/kb/175512

RibbonstartFromScratch needs to be ribbon startFromScratch The double quotes need to be replaced with the usual ascii version You are missing a close double quote after false (on tabHelp)

Seems like a reasonable approach provided: 1. One user per front end db 2. You want the data to persist if the db is closed and reopened. I guess you can always create a Class_Terminate to remove the properties if this feature is not wanted.

My first post (#24). For anyone who wants to reproduce this create a module with the following code: 'Public ShowValues As Variant 'uncomment to cause a compile error due to ambiguous name Public gTest As String Public Sub SetValues(Optional blnError As Boolean = False) gTest = "Global...

:banghead: The form isn't called form and the control/field isn't called Value.

>>And like the claim that errors cause variables to be reset, nobody can produce the slightest evidence yet they refuse to back down and go on to repeat the myth in subsequent threads despite detailed dmonstrations of the reality. << Galaxiom, did you read my post where I gave 2 examples of how...

Galaxiom, which version of Access are you using? When I went from 2003 to 2010 I hit lots of issues where I had to change form.Value to form!Value to differentiate between controls and underlying recordset. What used to work in 2003 stopped working in 2010. I never renamed controls but this...

Chris, I am happy to discuss for as long as this thread remains constructive. >>1. You did not mention it and…<< You are correct, I did not presume that everyone is delivering a single user compiled front-end. Access is a multiuser database that can be used either compiled or not. I would argue...

Chris, Agreed, but I have 2 sets of users. The first set sometimes share an ACCDB which they customize and change/add code at will. The second set use an ACCDE copied locally with data held centrally. I don't get too many support calls from the second set! The database needed to be robust...

Is it related to this thread? http://www.access-programmers.co.uk/forums/showthread.php?t=252603

TempVars seem to be a good alternative to this. I use the same approach as you with a SessionID since the global variables are reset if there is an unhandled error and the user selects "End" in the Debug dialogue, or if there is a compile error in the debugger. In both of these cases the TempVar...

It may be a bug in FindUserName(). This could happen if it is not trimming the result correctly. Can you post your the FindUserName() code?

To identify the source of the error, I would comment out lines of code one by one until it starts working, I would start with lines 950 and 960 where you are affecting the combobox that you are in the event of.

Try something like this: Private Sub Command14_Click() On Error GoTo ErrorHappened Dim sqlstr As String Dim dbs As Database Set dbs = CurrentDb Dim sqlstr2 As String 'Save a reading into the readings table and refresh sub form sqlstr = "INSERT INTO tbl_SuppliersList (...