Recent content by Jab331

I have managed to populate the images but that is not the code i require. The images i want to display are in thousands of different folders across different drives so whenever a record is loaded on to the form a hidden text box includes the hyperlink to the correct folder full of relevant...

I've had a play about and to be honest i am completely lost...Sorry. I think this is way more complicated than anything i am asking for?

I have a hidden textbox in a form that contains a link to a folder full of pictures. I have created a small button on the form that i would like to follow the link in the hidden textbox and bring up the relevant pictures. What is the code needed for this?

Hi Gina, I have created a list box and entered just a few of the customer names for now just until i have a working model, i have also create an ID field giving each customer a number. The list box is called "Customer_List", the Report is called "Customer_Report" and the field name is called...

Thank you for your reply. I'm really sorry but i wouldn't really know where to start with trying to implement that, prior to this project i have only ever been an end user of access databases, rather than a creator. Thanks, Jack

Hi everyone, I need to create a button on a database switchboard to "Tool List Via Customer" so basically i would like to be able to click the button which will then bring up a list of customers with check boxes (doesn't need to be a check box, just a selectable list) so one can be selected...

I think i have solved it! I realised that the query was searching int he first column so i need the ID column to be in that position. That seems to have resolved it. Thank you for the help everybody! I'm sure i will be back for many more questions though.

Can i just change it to one of the headers from the list box? For example if i change the code to "Tool Number =" will that filter on the selected tool number?

I changed the names of the listbox and the form but i did not change the "IDField =" portion of the code, could this be causing the issue?

I'm still getting the enter parameter box rather than the record information when i double click. Thank you for all your help so far!

Sorry i misunderstood what you meant earlier, i now have a singe form showing information for each record. Now when i double click a result in the listbox i get a pop up telling me to enter parameter values for ID field and Tool number? rather than the information for the record.

Okay, i think i am getting there slowly, i have added the code to the listbox so that it opens the new form when double clicked. i am now struggling to get the correct information in this form, how would i set the form up to show the information from the table without one record at a time?

Thanks for the reply but i am a genuine amateur when it comes to access. I guess i need to create the form id like to pop up before adding this code, how do i ensure the information shown in the form is the information for the item that has been double clicked? Sorry for asking the basic stuff...

This is exactly what i'm trying to do. Double click the item in the listbox and then get the further information from there.

Hi all, Very new to access so i apologise in advance if i ask stupid questions. I am creating a database and have managed to create a form with a search bar that then populates a listbox below the search bar as a query searches the database table. What i would now like to do is allow the user...