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 TouchToneTommy 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. m198redleg

    Perplexed, getting access 97 setup on a server for 50 Users

    I apologize for not getting back with you all earlier, but meeting and such. I have implemented your suggestions. Thank you. Quehay and Foolio12. You are true examples of a term my Dad used to say to people. "You are both a cool drink of water on a hot day." Thank you very much...
  2. m198redleg

    Perplexed, getting access 97 setup on a server for 50 Users

    Folks I want to thank you for get back so soon, sorry I didn't. I went for a frost mug watched a movie and got some sleep. I woke up and thought about font end & back end and when you spoke of it and the references "foolio12" you confirmed it and since tried it. works great. ?? Does...
  3. m198redleg

    Perplexed, getting access 97 setup on a server for 50 Users

    The question I have is how to setup Access 97 on a server(a), where the field technicians(50) can access the table for input only, N the District Managers(2) can access the table with read only(b). I have written this Access97 dBase which has worked very well as a stand alone system. The...
  4. m198redleg

    Can't Assign a Value to this Object

    I rather new to this programming thing, but I had this same bug for about a week. What I found out was, my form was in read only mode and by a flike I went and placed it in edit/write and wa la the bug went away and I can not place a designated variable in a text box. In my particular form I...
  5. m198redleg

    Queries, How many filters(?) is to many?

    Thanks vey much Steve. The table idea was what I came up wit, but was hesitant, but tried it. worked great and using the idea of temp tables - well, Steve. Dog gone it. makes sense and I can control the queries just as easily as if I had simple queries again. Take my hat off again to you...
  6. m198redleg

    Queries, How many filters(?) is to many?

    I have written the dBase and with dhookom and others I have been able to iron out a lot of problems. Thanks folks. I have a query with four tables working great. The query has 28 fields, I know I am well below the half way point. The problem is when I place...
  7. m198redleg

    Union Query gets evrything I don't want

    Thank you folks, dhookom and hneal98 This Query works great now. Thanks
  8. m198redleg

    Union Query gets evrything I don't want

    Thanks hneal98. I tried different appraches but came up with the same thing. "An Action Query can not be used as a Row Source." I do not understand how placing the INTO tblJACOBS makes it go into row sourcing, unless it is having to drop row up on row.
  9. m198redleg

    Union Query gets evrything I don't want

    This is First time posting, I have gleaned a lot from listening. This has got me by the hair. Query Code is as follows, I find alot of request for coding; TABLE "01DATA" WEEK, D, A, DTE_ENL, ([LAST_NAME]&" "&[FIRST]&" "&[MI])AS F_NAME, SSN, QT, DEPT, TYPE_ENL...

Part and Inventory Search

Back
Top