Search results

Hi. I am trying to add an unbound textbox to an Access Form to create a hyperlink that opens a folder located outside the Database. The following code provided as a solution to another member's problem. On adding a textbox to my form and trying the code, I found it opens the file explorer ok...

Hi. I would be grateful for any help with the following query design. I have a table of registered Clients (tblClient) who require training, and this table is linked by Job_No to a table (tblTraining) that holds training session data for Clients. A Client firsts registers, and their information...

Can anyone help with ORDER BY problem please. The following Function resides in an Access 16 Module Public Function ShowTrainingHistory(intJobNo As Integer) Dim strTrainingHistory As String strTrainingHistory = "SELECT Training_date, SubjectToday, Training_ID, Job_No...

Can anyone tell me how to assign the following SQL to a string variable in MS Access 16 so that it can be assigned to a ListBox RowSource. I’ve tried it unsuccessfully but I think my syntax is wrong. SELECT tblSubjectToday.SubjectToday, tblSubjectToday.IsPending...

When I load my Assess database I am being presented with an unwelcome dialogue box labelled “Enter parameter value: Forms!frmTraining!txtTrainingID”. I am aware this is a common problem caused by object naming errors, but I have checked everything, so I would really appreciate any help with...

Hi. I would appreciate help on how to do this: I am running MS Access 16 and I have a Table (tblPurchase) and a Form containing the following 3 controls: ListBox (lstThisPurchase) ComboBox (cboProductRange Command Button (cmdUpdateRecords) Operation: Items will be added to...

Hi. Been using Access for a while but need to get more into the programming side so that I can do more advanced work