Search results

  1. C

    Sequential Order ID on Form

    Yep the import file does have ORD..and I have to store it as ORD sa well.
  2. C

    hey, please check the thread about the sequential id! :) thanks

    hey, please check the thread about the sequential id! :) thanks
  3. C

    Sequential Order ID on Form

    Tried the "ORD"# but it didnt work. See ive got some dummy data im using. I tried putting the field as a Number and set Format to what yo said above..but then when importing it didnt let me. Nor did it let me add a new order with ORDXXX. No! :( I cant actually do this! I have no idea about...
  4. C

    Sequential Order ID on Form

    I changed the instances of "OrderNum" to orderid and "Table1" to "tblOrder". "Private Sub Form_Current() Dim strOrdNum As String If Me.orderid = 0 Or IsNull(Me.orderid) Then 'check if this record already holds and order number strOrdNum = Nz(DMax("orderid", "tblOrder"), 1)...
  5. C

    Sequential Order ID on Form

    Need to store the record with ORD. Do you want a copy of my database to see what Ive done till now? (Including that code you gave me?)
  6. C

    Sequential Order ID on Form

    Thanks! - Hope I get this sorted today. :S
  7. C

    Sequential Order ID on Form

    No, its not that - his advice is really good, but Im doing this in an exam and I have to store it as ORDXXX.
  8. C

    Sequential Order ID on Form

    But I have to store it in the table as ORDXXX :S, thats a must in this case. Can I speak to you on MSN or something?
  9. C

    Sequential Order ID on Form

    Cant put it as Number..its ORD111, so it has to be Text. I have to store the id as ORDXXX, and I cant get into using Strings and stuff..has to be something simpler.
  10. C

    Sequential Order ID on Form

    Ok no prob I fixed that somehow, but I got another error I changed the field name to "orderid" instead. I substituted it on the form, and now when I open the form i get Compile error: Method or data member not found.
  11. C

    Sequential Order ID on Form

    Read my last reply :)
  12. C

    Sequential Order ID on Form

    UPDATE: I used the following code after editing: "If Me.Order_number = 0 Or IsNull(Me.Order_number) Then 'check if this record already holds and order number Me.Order_number = Nz(DMax("Order_number", "tblOrder") + 1, 1) End If" Access already had some extra stuff so the final code was...
  13. C

    Sequential Order ID on Form

    Problem is..im not too familiar with editing code and stuff.. have you got MSN/Skype so we can sort this quicker? Thanks
  14. C

    Sequential Order ID on Form

    Hi, Thanks, but im not too familiar with using Codes, thus I try sort the problem out by doing queries etc. Do you think you could re-read what Ive said and try figure out a solution via queries and stuff? I think what ive done up till now is good, but im missing something! - thats why I cant...
  15. C

    Sequential Order ID on Form

    Hi everyone, Its my first thread here! :) Let me describe the database Im doing... Consist of 4 tables - customer, order, supplier and product Customer can have many orders, one order can only have one product, and a supplier can supply many products. What I want to do: Create an Order Form...
Top Bottom