Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. nadir66

    One icon starts a97 and a2k

    Hi I need to find a solution that i can use the same icon to start access97 and 2000 (XP, 2003??) I tried to create something like an router that will recognise the files but i failed. can anyone help? Thank you in advance nadir
  2. nadir66

    replace 2 conected sets of data

    Hello I need some help with this issue. I have a table with formulations looking like this: name, code, item1, item2,....item qty1, itemqty2,..... i need to be able to change item2 and the coresponding itemqty2. Also i nne to do a calculations wit a factor for itemqty2. so instead item2 i need...
  3. nadir66

    Track overtime - who's next - based on senority and who worked last

    Hi I am also trying to create something similar. I would appreciate a copy of the same file. Thanx npehadzic@hostmann-steinberg.net
  4. nadir66

    Update sub form!

    thank you. For some stupid reason i allowed access to do it. thanx again. nadir
  5. nadir66

    Update sub form!

    thank you. i am trying that. my problem is also that my subform is called tbl_process_order subform. i always have the problem to present it properly. does it go like this: (tbl_process_order subform) or ("tbl_process_order subform") thx nadir
  6. nadir66

    Update sub form!

    Sorry, i am using the requery method. Private Sub Form_AfterUpdate() Forms("tbl_process_order").Requery End Sub The data on the subform is acctually a querry that reads from 1 table.
  7. nadir66

    Update sub form!

    ok. sorry. I have a form where i have 2 subforms. On th eform i have a combobox, with items. The same items decided what is visible on subform1. (process). On form 1 is a button that opens a pop-up (order) where some data is from subform1. Once the data is filled (address, name etc) on closing...
  8. nadir66

    Update sub form!

    Hi I ahve a problem with a subform. The design: Form1 cbo to choose item Order button Subform one option to order subhform 2 show the order all are conected through the cbo value. click on order, pop-up shows with info, choose Qty and close. at this point the sub2 shoul be populated with data...
  9. nadir66

    Error converting database to Access 97

    i have a similar problem When i convert back to 97 from 200, my forms stop working. i have subform that refreshes on popup close, and once converted it stops working...
  10. nadir66

    Help with e-mail report delivery

    Hi I have a problem that keeps me up the last 2 days. I would like to e-mail 3 diff people (To, CC, BCC) a report cretaed on the basis of a form. the 3 e-mail adresses are populated by choice of the operator. How can i do that. i tried many of the choices available here...but still nothing. I am...
  11. nadir66

    help needed. Network creates autonumber crash. why????

    Hi Yes, Pd was a mistake, meant to be pc.yes be is backend. Well, the error stopped on this line: Set rst = db.OpenRecordset("tblFlexAutoNum", _ dbOpenTable, dbDenyWrite + dbDenyRead) nadir thanks.
  12. nadir66

    help needed. Network creates autonumber crash. why????

    the error is that he loops and cannot add assign number. It also said that due to a control it cannot save the record. thx
  13. nadir66

    help needed. Network creates autonumber crash. why????

    Hi I built the autonumber using various help, it works on my pd, but when i place it into the BE, i get an error msg. Here is the module: Public Function acbGetCounter() As Long ' Get a value from the counters table and ' increment it Dim db As DAO.Database Dim rst As...
  14. nadir66

    Prevent duplicate ID

    Hi I have a system that works as e-docket (order) system. I have at max 7 users on at the same time. I tried my best to cretate a multi user system. I have my be on the server, and the fe on the desktops of users. My ID number is =Nz(Dmax...) But ever so often (if it can it will go wrong) i get...
  15. nadir66

    Update/rreplace value of field from Form

    thx tom i will give ot a try. nadir
  16. nadir66

    Update/rreplace value of field from Form

    Hi Tom Yes, 2 textboxes. One is bound to the existing value the 2nd is empty.
  17. nadir66

    Update/rreplace value of field from Form

    Hi For the last few hours i am trying to figure this out... i have a form and on the form a field quantity, the same in the table inv_process. i need to have the users update this value, click or whatever. i mean, they will see two textboxes, one shows the current value, the second is for the...
  18. nadir66

    Subform Update - calculate on save

    Hi I ghave a form (tbl_inv) that has a subform (tbl_code_querry) that are joined through a field called code. The subform is a continuos form because there can be many items under same code but different manufacturer. My problem is how to update the subform using the order items. (ACC97, OS XP)...
  19. nadir66

    Table-query-form-autonumber question

    hi i am sorry, but it is a bit too advanced for my knowledge to just like tahat write code. i could use some more help. Very thankfull to all help.
  20. nadir66

    lock field or other options?

    thank you it works.

Part and Inventory Search

Back
Top