Search results

  1. C

    Call up Module Function

    Hiya EraserveAP All in all, I have an append query in place to copy a record from Quotes to Workorders. I have the main form working with the append, but not the Subform. From my understanding over the posts, I need to retrieve the WorkorderID that the append created and have it in the subform...
  2. C

    Call up Module Function

    Hiya Wayne Thanks for the reply m8 Right, lets see if I got this I just copy the Function script into a module and save it On my main form where I want the command to run, I click on button Props, and ONClick VBA - enter this Dim varTest As Variant varTest = ShowIdentity() And rename to...
  3. C

    Call up Module Function

    lol thanks for the reply Unfortuantly, I have no idea where to start ________ SC2 TERRANER REPLAYS
  4. C

    Call up Module Function

    Hiya I have this module Function ShowIdentity() As Variant Dim db As DAO.Database Dim rs As DAO.Recordset > Set db = DBEngine(0)(0) db.Execute "INSERT INTO MyTable ( MyField ) SELECT 'nuffin' AS Expr1;" > Set rs = db.OpenRecordset("SELECT @@IDENTITY AS LastID;") ShowIdentity = rs!LastID...
  5. C

    Autonumber Next Increment

    Was looking through the threads in VBA Script etc, and found this - http://www.access-programmers.co.uk/forums/showthread.php?t=166789 Is this something I could use, and without a module? ________ Zoloft lawyer
  6. C

    Autonumber Next Increment

    So, anyone who has had a look been able to get the WorkorderID going? Still banging my head off a wall here lol ________ Coach purses
  7. C

    Autonumber Next Increment

    Hmmm very strange I didn't set a password, never do Try it again with this one ________ Universal Health
  8. C

    Autonumber Next Increment

    Hiya paul What you mean Password - Can't look? ________ ASS
  9. C

    Autonumber Next Increment

    Thats it, I give up now lol had enough.. Access has won Doesn't matter what I do, what I read, I just can't get the autonumber bit working Anyone feel free to play around with it and gives a shout lol I'm off to bang my head of the wall for a few hours ________ The Cigar Boss
  10. C

    Autonumber Next Increment

    lol 3/4 way there.. feel much further away than that.. At the breaking point now lol, sat here since 4pm today, now 2:16am and still at the same point lol ________ Fx
  11. C

    Append Query

    Anyone help with the AUtonumber thing? Need to find the autonumber that I just appended? ________ BlackRosse
  12. C

    Autonumber Next Increment

    Hmmm, ok I think I'm slowly getting this now lol at least eh You able to stick around a wee bit and guide me on this one? ________ Herbal Health
  13. C

    Autonumber Next Increment

    lol fair enough m8 I'm still very confused on this whole thing, Think the easiest way is to have it with the subform, and find the increment number of the new record, Get that working and everything will be fine.. Tried it manually and it works perfectly, so just need to figure out the...
  14. C

    Autonumber Next Increment

    Where would I put this code? Just Oncurrent? ________ TOYOTA AVALON (CONCEPT) HISTORY
  15. C

    Autonumber Next Increment

    Hiya Paul Thinking about it now, I think you did, I'm sure I have it printed somewhere. Did you get the last update on the problems I've been having? ________ Vermont Medical Marijuana
  16. C

    Autonumber Next Increment

    Hiya Trying to find the next Autonumber for WorkorderID Getting stuck on the SELECT Statement Function ShowIdentity() As Variant Dim db As DAO.Database Dim rs As DAO.Recordset Set db = DBEngine(0)(0) db.Execute "INSERT INTO Workorders (CustomerID, EmployeeID...
  17. C

    Append Query

    ok been looking at all these posts again Now I can almost understand alittle more as my DB is now simple ok, I create the Customer, then Create a Quote and the materials needed. A QuoteID is created using autonumber - Then I run the append Query which will copy the Quote to the Workorder...
  18. C

    Append Query

    Ok so now I've created the basic forms I created the Quotes as an Append Query, seems to transfer to the record OK, So, what do I do now for the subform to go? Or am I still getting confused on this one lol, sorry I have the Materials table now, which is the same on BOTH Quote & Workorders...
  19. C

    Append Query

    Hiya Bob Again, thanks for the time to reply I'm currently building a sample from scratch with just A Customer, Quotes, Workorders and Materials and see how I go I'm going to attempt to have just one Material table for Both, I suppose for this to work, I should add in the WorkorderID and...
  20. C

    Append Query

    Hiya Cheers for the sample However, in my own form, I need the subform to be working to list all the materials for the job Also, in your sample, I noticed that once I click on the Workorder Convert from the quote, it doesn't store the record in the quote, but sends it to workorders? I...
View older results
Back
Top Bottom