Recent content by claudebo

Thank you for the assistance! I presume your statement "self-healing" mean that each time the a form needs one of these variables then the function “CurrentUserDefault.userID” gets used/updated. I wanted to get away from pulling the data out of the tables each time a variable is because...

ditto to Remou advise. I don't think you can specify which worksheet you are exporting to, but a linked sheets could be made to work.

I have created a type called : Type userDefaults userID as Integer useraddress as string userpermissions as string End type There is a login screen called frmlogin in there is a function call to : Call getUserDefaults(Me!UserID) The Module getUserDefaults looks like this...

I would like to create a timer to find bottlenecks in forms queries and code and also to try different code snippets. Any ideas on how to do this? thanks Claude

Hi I would like to use the statistic functions from Excel in Access. I have added “Microsoft Excel 5.0 Object Library” to the references. I have tried: ________________________________________________________________ Dim obj As Object Set obj =...

It worked!!! Thanks Kotaro24 Claude

Hi I there any way to make a copy of an Original.mdb file while Original.mdb is open. I tried : Dim SourceFile, DestinationFile SourceFile = "C:\Original.mdb" ' source file name. DestinationFile = "C:\Backup.mdb" ' target file name. FileCopy SourceFile...

Hi I have a number of queries that are passed criteria via code Query view: |Field |CusLastName | etc. |Table | CusTable | |Criteria |Queryprop("Pass")| Example Code: "Function Queryprop(Prop) As String Queryprop = Currentprop End Function" This works...