Recent content by goldres

Hi I have a form that has three checkboxes (IDDocument, DrivingLicence and Certification) on it. What the form is looking to do is based on the selection it will open a scanned document of the requested documents. There are 5 permutations that could be selected (either first on only, second one...

Hi Thank you for your response. I have tried using the TempVars.Add but it does not allow me to use a variable as the data. I am trying to pass the userid on my login screen (called CurrentUserID) as the tempVar so that I can use it in all the forms in my system. That is where I am...

Using TempVars with Login form I have been looking at the Northwind example database and would like to use the login dialog screen as the base login for my application. I would like to add a password for the user to log on with. I have managed to get the process of the enter of the user name...

No worries I have solved this problem myself

The original "mainform.zip" was an example of a form I am trying to use. I have modified it and now it is in mainform.accdb The code here and the attached mainform.accdb are the code that I am actually trying to use. Here is what I am trying to do. I have a system that has a lot of pdf...

The code I used is: Private Sub Deviation_Form_Click() Call Frame8_Click End Sub Private Sub Frame8_Click() Dim Form1 As String Form1 = "D:\Hamba Kusasa Forms\Deviation Form.pdf" MsgBox "about to open form" DoCmd.OpenForm "Mainform", acNormal, , , , , Form1 MsgBox...

I downloaded Checkbox open form.zip from this site (thank you Ansentry)and looked at the code. it is exactly what i needed to use thank you. It uses option group for teh checkboxes It runs perfectly when I double click in access but i would like to use this in vba when called from another...

Hi john I downloaded and looked at your code. it is exactly what i needed to use thank you. It runs perfectly when I double click in access but i would like to use this in vba when calledfrom another form. When i put the code in and try to run it I get the error: Compile Error Method or...