Search results

Hi, Can anyone help identify where the issue is here. I've created a query to pull job data to create a CSV to export to Xero which will automate invoicing my jobs. The query runs fine on its own and displays everything I need correctly. Some fields are "" as Xero requires them present as a...

Hi I have a field on my form called Manufacturer which was a standard text box. I decided to change it to a combo box with a row source as: SELECT DISTINCT Manufacturer FROM Job ORDER BY Manufacturer It works great, and suggests manufacturers whilst typing which is exactly what I wanted it to...

Hi, I'm trying to open a form from my main menu to a new record and pre insert some fields. The form opens at a new record however I'm not sure why nothing happens from there on, it opens with everything blank including the autonumber, is there something I need to add to create the record...

Hi, I have a textbox formatted to put a prefix letter PUR and make it 5 digits total so ID 7 for example would be PUR00007 The textbox displays fine, but when clicked to copy this, the "PUR" formatting disappears leaving just 00007 This is a nuisance when I need to copy and paste from the box...

Hi Everyone, I'm sure this has been asked before so if needed please just point me to a video or thread that I need to study. I have a job form where I can search for parts from a parts table, and add them to the job (jobparts table). In the screenshot the top subform is a search lookup from the...

Hi Everyone, I have a simple issue here that I cannot see the property difference between the 2 subforms that is causing the bottom subform to push the text onto a new line rather than continue off the far right side. Does anyone know what property I need to change to stop it going underneath...

Hi Guys I've tried to create a macro based on another users post from 2020. I want to click a button on my job form, which saves the single report matching the current displayed jobID and saves it as a PDF on the desktop. I would also like the filename formatted as Quotation M00000 where the...

Hi everyone I currently have a job form, which has a job parts subform which looks up components from a components table. There is currently part number, description, manufacturer, more specifics, supplier price etc and you look up a part to add by the part number which is a combo box. This...

Hi Everyone I have a job system which the main table stores information about a current job, in this it stores the serial number of that job item The main form shows all the data about the current job including the customer and contact. I would like it to have an area where it displays any...

Hi Ive created a database which is a job system I have a customer table and each customer can have many contacts which are stored in a separate table. The customer form has a subform and this works showing all associated contacts The issue I have is when it comes to creating a job. The job table...