Search results

Hi, Just an update I decided to develop this further. Rather than clicking a button and it opening the main form at a new record with prefilled data from code, I decided to firstly open a small form which asks for key required data - customer, contact, description, ref etc and upon a button...

That works, thank you!

I've tried that but still nothing. I've tried setting default customer and contact ID's to 1 but no change When the form loads its like its not created the record yet as everythiing is blank including the autonumber and the check boxes are all ticked, once you click into a field an autonumber...

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

Many thanks for your help. Both worked great for me.

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 All, As always thank you for your support and guidance. So, to clarify, I shouldn't be storing "qtyinstock" inside the component table, instead I should create another table called stocktake, create a relationship with the components table and store the qtyinstock in this table along with the...

Thank you for the help on this. As my system is dealing with services rather than supply of goods its a little different to a system that orders goods and ships them out. For the interim I think the existing system will suffice with how it is designed. One question I would like to ask is, if a...

Amazing!!! Thank you so much

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

Many thanks for your help (y)

Got it! Dim Filename As String Dim FilePath As String Filename = "Quotation" & " " & "M" & Format(Me.JobID, "00000") FilePath = "C:\Users\Andy\Desktop\" & Filename & ".pdf" DoCmd.OutputTo acOutputReport, "Quotation", acFormatPDF, FilePath, , , ...

I've decided to use VBA to do this rather than macros Dim Filename As String Dim FilePath As String Filename = "Quotation" & " " & Me.JobID FilePath = "C:\Users\Andy\Desktop\" & Filename & ".pdf" DoCmd.OutputTo acOutputReport, "Quotation", acFormatPDF, FilePath, ...

Just as a side note if I leave the output file field blank, it saves correctly after asking me where to save.

Apologies Could you elaborate what you mean with that? I'm reasonably new to Access

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

I tried changing the subform to Allow Additions Yes and that stops the error for now and the box is blank. It would be nice for it to show £0.00 when the other box is blank but not sure how to do it

Why doesnt the parts total box display an error but the box which points to parts total does? The other box just has =[Job Subform].[Form]![PartsTotal] and this is the one which shows #error. I don't know how to add an IsNull statement to this as its just referencing the other box?

This is the code I put into the box for the line total. Does the code need to go into the other box which is showing the error? Currently this box just points to the other control