Search results

Hi, I've created a report to print a single dymo label to my 550. The labels I'm using are 2112283 25mm high x 54mm wide and when using the dymo software they come out of the printer narrow edge first with the text 90 degrees on so the label is landscape when viewed. I've attached a photo of one...

Hi, I have a form where I can choose a customer, and then a subform displays all jobs currently set to "For Delivery" I have added a control on the subform which is an unbound yes/no check box. A query then looks at this check box status to decide whether to include this item on the delivery...

Hi I have created a small dashboard showing certain statistics of my business. This is comprised of small subform squares on my main menu. These subforms are based off queries, and the forms control performs a count or totals this various data. Attached screenshot 1 showing a blank subform, 2...

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