Recent content by SteveMcL

Thanks for the ByRef suggestion, but this is more of an in-out situation. So staying with the model Public Function RegisterCaseFile(FieldToReturn As String) As RegistrationRecord 'FieldToReturn Arguements: ' "DocumentID" return .DocumentID ' "IncidentID" return .IncidentID ' "All"...

Thank You. I had declared the User Type, but had not yet declared a variable as that User Type. And yes, there was a conflict with User Security's Documents & Containers objects. The end purpose was to return two values from a function. However I found that I couldn't pass that function an...

:banghead: This is one area I've never been able to succeed in. I would like to declare a User Type in order to return to values from a function. The declaration is made in a module as follows Public Type Document DocumentID As Long IncidentID As Long End Type...

I don't think we'll be able to track this one down. I did retype the 2 into the table field, suspecting the same thing, but getting the same result. However, I haven't been able to replicate the issue as I changed the number type of the field to Double, changing the values that existed...

I came across something interesting this morning, and haven't been able to find anything on it I was querying a field which was search a field set as a Single data type, and I was not able to use a direct equivalence ([lbs]=2) but had to use the Like operator ([lbs] Like '2'). This...

I have created 10 User Group Accounts, and have set Permissions for the first 7 successfully. However, no Permission settings are being saved for any subsequent Groups. (Access 2010 managing a 2003 mdb file, Front and Back client)...