Search results

Hi All Hoping someone can help. I would like to create a stored procedure in SQL server which I can call from an access front-end application to determine what the role of the logged in user is to allow me to enable / disable application controls based on roles. I have the following code...

Hi All I have the following SQL string: strSql = "INSERT INTO t_ClientDemographics(client_FirstHCTVisitDate, client_ClientCode, client_FirstName, " & _ "client_LastName, fk_EmploymentStatusID, client_ClientEmployee, client_JobTitle, " & _...

Hi All Attached is a quick application which shows a method I use to create an audit trail of changes made to my forms. Just run the form, make changes to the various fields and the changes are recorded in the audit trail table. Comments and suggestions on how to further improve on this would...

Hi All I would just like to find out how long it takes before a sample submitted to the samples forum is approved. I submitted a database about 2 days ago and I see that nothing has shown up on the forum. Regards

Hi All I am wanting to use a barcode scanner to input data into a field and bring up details based on the barcode. This is simple enough as long as the field you want to scan into has focus. Is there a method which will automatically populate the correct field with the scanned data no matter...

Hi Hoping someone can help me here. I have a form which is maximised on startup which also has the min/max and close button disabled. What i'd like to do is also prevent the user from restoring the form to ie. click the restore button which then makes the form smaller as i'd like the form to...