Recent content by andymartin3186

  1. A

    Open a form and insert data SQL

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

    Open a form and insert data SQL

    That works, thank you!
  3. A

    Open a form and insert data SQL

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

    Open a form and insert data SQL

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

    Control format disappears when clicked

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

    Control format disappears when clicked

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

    Update of stock quantity

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

    Update of stock quantity

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

    Update of stock quantity

    Amazing!!! Thank you so much
  10. A

    Update of stock quantity

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

    Text wrapping in subform

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

    Save a Report as a PDF with custom filename

    Many thanks for your help (y)
  13. A

    Save a Report as a PDF with custom filename

    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, , , ...
  14. A

    Save a Report as a PDF with custom filename

    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, ...
  15. A

    Save a Report as a PDF with custom filename

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