Search results

  1. C

    Append Query

    Hiya Paul Cheers for the reply I'm not sure which method would be easier, either of them I'm getting lost and confused with lol Like I said before, I'm not the best with Access yet but I do keep trying. If you are able to guide me through then I'm happy to sit and learn, or if you would...
  2. C

    Append Query

    Hiya Paul Just wondering if you managed to get a chance to have a look at this? Cheers m8 CCK ________ Rhode island marijuana dispensary
  3. C

    Append Query

    Ok cheers m8 Again, the only thing I can't seem to get working is the main subform that holds all the materials for that job Hopefully, we'll get this working lol The append query I made is called Quotes Query2 lol keeping it simple Please ignore the mess of all other tables & quotes, I...
  4. C

    Append Query

    Will you be able to have a look at the DB just now with the working version so far and see what I'm missing exactly? I do appreciate all the time and help your given me so far ________ Roll Blunts
  5. C

    Append Query

    Oh yeah, also, Using the append query in Quotes to Workorders, its copying all records from quotes, rather than just one Do you have msn where we can chat direct? Mines is duc_ati@hotmail.co.uk ________ CoedCutie
  6. C

    Append Query

    Hiya Paul Yeah I got the Append Query working almost perfectly with the main form (Quotes to Workorders) and it now creates a new workorderID, but I just can't get the Subfrom from Quotes across to the Workorders for Materials ________ IOLITE VAPORIZER - CORDLESS PORTABLE VAPORIZER
  7. C

    Append Query

    Hiya I have an append query working based on a Table called Quotes I want to copy the Quotes to Workorders, I managed to get that working and it creates a new WorkorderID etc But the Main form, holds a subform with the following two forms - Materials & Labour How could I copy that into...
  8. C

    Insert into

    Cheers for the reply Any ideas on how I do this tho? ________ Zoloft settlements
  9. C

    Insert into

    Hiya Access 2007 Can I use the INSERT INTO command to copy a record from one subform to another subform on a differnt record? Want to copy the Entire form and subform to another form and subform? ________ Weed Vaporizers
  10. C

    Autofill form

    Cheers for the reply What kind of field would I need to perform a convert from Quote to Workorder and how would I do this? I would assume I would need to create a new field in the Materials Table as an autonumber field? As it is, Materials listed for Quotes is linked to the Material by...
  11. C

    Autofill form

    Still having no luck with this.. Anyone offer further help? ________ Xxx amateurs
  12. C

    Print Single Report

    Hiya My report is built from these 2 forms - Schedule & Schedule Subform The main report is showin all the records, but on the form, I just want to be able to click a print report button and have print the record matching the single record on the form. What am I missing? Cheers CCK...
  13. C

    Autofill form

    Anyone lol ________ MUSIC FESTIVAL
  14. C

    Autofill form

    Hiya m8 Cheers the reply Any chance of wot the code would be? Or any help with a step by step guide lol sorry, not the smartest at VB yet ________ Roll Blunts
  15. C

    Autofill form

    Hiya (Access 2007) I have two forms (Quotes) & (Workorders) The first form quote would be stage one. The user would fill out the quote information for the customer. print it off and post, email to customer. Wait for the quote to be accepted and then fill out the Workorder, for the work to...
  16. C

    Dlookup

    Hiya Thanks for the reply Yeah my way of explaning without the DB isn't easy lol I am sorry I'll seeif I can express more The form (Workorder) has a field called RepairNotes. which is a memo field. Obvisouly each record would have different text inside. I want to be able to send this...
  17. C

    Dlookup

    Hiya I am working on 2 forms in my DB. 1 called Workorders and the other being Schedule. What I need to do is:- Pull the table or form field (RepairNotes) from Workorders and put it in automatically (WorkSummery) in Schedule? The workorder form isn't open. I currently have it as -...
  18. C

    Can't get form to link Data

    Update Got it working fine now The fix I needed was simple and I couldn't believe I missed it. For me to link the data from the current form to the other form on WorkorderID, I just needed to enter the default value on the form field for workorderID So simple, it was overlooked Cheers...
  19. C

    Can't get form to link Data

    Hiya m8 Had a look at your post, and although it was helpful, it hasnt really resolved anything on my DB. Is there a way I can do this? The forms are as follows Workorders by Customer (main form) Workorders hold the workorder Schedule (Should hold the work carried out per day on that...
  20. C

    Can't get form to link Data

    Hiya m8 Yes sounds like same problem we're stuck on I did notice however, if I creat a Workorder from the workorder form, and have on that form a basic schedule (without the subform) I can create the schedule and enter the workorderID manually. Then when on the main page of the DB...
Back
Top Bottom