Search results

Hello Everyone, I would like to run one query that can accommodate entering twelve possible date ranges and output the data all in one query. I could accomplish that by writing 12 queries and attaching each one to a start and end box on a form and then doing a Union Query to obtain one result...

Thanks for you help! I tired it but had some errors, actually changed your code slightly to the following: 'Close logon form and open splash screen Dim tmpaccess As String tmpaccess = DLookup("strAccess", "tblEmployees", "[lngEmpID]=" & Me.cboEmployee.Value) If tmpaccess = "Admin" Then...

Hello, I have the attached database with a logon screen. I would like to be able to open a separate form for anyone logging in as an Admin. Bellow is the following VB code used to open the WelcomeForm once they authenticate the logon. Is there a possibility to add that anyone accessing with...

Hello, I have the attached database with a logon screen. I would like to be able to open a separate form for anyone logging in as an Admin. Bellow is the following VB code used to open the WelcomeForm once they authenticate the logon. Is there a possibility to add that anyone accessing with...

Hello, I have the attached database with a logon screen. I would like to be able to open a separate form for anyone logging in as an Admin. Bellow is the following VB code used to open the WelcomeForm once they authenticate the logon. Is there a possibility to add that anyone accessing with...

Makes sense! I actually figured out in the query. I had the Name stored as a Text and connected to the ID as a number and was giving me a Mismatch message. I changed the name to number and is working great now! Thanks

Hi Bob, Thanks! but I would like to save the employee name under the Advice Table as the Name of the employee. I have a problem getting qurries and reports to be generated with the Autonumber created by Access.

Hello Everyone, I have created an access database with a simple login screen. Once the user is authenticated the database brings the user to the Advice Form. I have a code On Load built for the Advice Form to have the Employee name populated automatically. However, when I complete this form and...