Search results

Hi ridders. That works fine, so adding "Application" makes the difference. Thanks again

Thanks the quick reply and for that info. The code crashes on "FollowHyperlink Me.txtAudit_files", so obviously I am doing something wrong. The filepath to my folder is D:\...............\.............\required folder, so where does this go? I have experimented with the textbox hyperlink...

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...

Many thanks Gasman and ypma. The solution you suggest works fine. Thanks again

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...

Many thanks Minty. I had the ORDER BY clause at the end in quotes but didn't include the space between the clause and its quotes. Really appreciated. Chris

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...

Thanks Minty that's really useful. I'll try it out. Chris

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...

Thanks everyone for your help on this one.

Thanks Minty. That make some sense. So am I right in thinking the query SQL is written into the List RowSource, so it is not until the Form opens that it can run and have access to the txtTraining on the Form. Is the answer to only assign the query string to the RowSource with Form load() ?

Hi Minty. Thanks for the reply. No the Form is not open. When I close the Parameter box (without entering a value) the database continues to open normally. Thanks MarkK I'll try that code.

Thanks ByteMyzer. I have tried that but the problem persists. The database opens normally if I leave the parameter blank and click ok.

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...

Thanks Mark. I understand what you are saying about the simplicity of the SQL, but my background is programming and my knowledge of applying SQL is limited. Hence using the list in the way I have suggested, which is the easiest way for me at the moment. I can see what your SQL is doing but I am...

Hi Thanks for the replies. Each time an item is selected from the combo, it is added to the list. When all the required items have been added, the command button sends the items to the table. The List is just a way of seeing what has been selected before it is written to the table. I have...

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