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 strongm 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. mdavis1

    MULTIPLE SUBFORMS FROM MULTIPLE TABLES

    OK. I JUST THOUGHT I HAD IT. HELP. I CAN'T GET IT TO PULL UP THE RIGHT CATEGORY FORM IN THE REPORT. HELP HELP HELP. MANY MANY THANKS IN ADVANCE
  2. mdavis1

    MULTIPLE SUBFORMS FROM MULTIPLE TABLES

    I figured it out. Just takes a little patience. Thanks everyone for contributing to this site. It has helped me tremendously . THanks again and ya'll have a great day :P
  3. mdavis1

    MULTIPLE SUBFORMS FROM MULTIPLE TABLES

    ok...one more question :) After i get that info, i want to print it in a report. so how do i make the report pick that form also? i made a query and combined the two tables, but i can't seem to get it to bring the category form? Thanks in advance :)
  4. mdavis1

    MULTIPLE SUBFORMS FROM MULTIPLE TABLES

    Geeez..and you made it so easy [thumbsup] Thanks a million [thumbsup2]
  5. mdavis1

    MULTIPLE SUBFORMS FROM MULTIPLE TABLES

    I have a main database that contains a main product. In this database, the product has 12 categories. I want to be able to pull the # up in the main database, and have a button that will pull up the category form. I can do that for 1 category, but i'm having trouble telling the button which...
  6. mdavis1

    ok..i have a data entry form with a

    Yes. It works great.
  7. mdavis1

    ok..i have a data entry form with a

    ok..i have a data entry form with a subform. when i use the tab from the very top of the main form, it automatically moves to the bottom of the form without using the scroll bar. But if i start in the subform, i can tab to the bottom, but the form view does not move. HELP. This is aggrivating...
  8. mdavis1

    Hi everybody, I have been programming in access + VBA for some time

    """"with a mechanisim to assure that any changes to the "Front End" were copied to the user's system each time they started the program, as this would relieve a part of the network traffic."""" ok..how might one achieve this?I have the FE on...
  9. mdavis1

    OPEN .PDF FILE FROM ACCESS

    I WANT TO BE ABLE TO SEARCH AND FIND A CUSTOMER/LOCATION/#, THEN WHEN THAT FILTERS, I WANT TO BE ABLE TO OPEN THE SCANNED PIC OF THE # FILE FROM A COMMAND BUTTON.THANKS IN ADVANCE. YA'LL ARE GREATTTTTTTTTTTTTTTTTTT.
  10. mdavis1

    LINK COMBO BOX PICK TO A FORM

    I HAVE A FORM THAT HAS 3 SYNCHRONIZED COMBO BOXES, YOU CAN SELECT 1) CUSTOMER 2) LOCATION 3) CATEGORY. AFTER YOU PICK THE CUSTOMER, IT FILTERS ONLY LOCATIONS FOR THAT CUSTOMER, AND AFTER U PICK LOCATION, IT ONLY SHOWS CATEGORIES FOR THE CUSTOMER AT THAT LOCATION. AFTER U SELECT THE CATEGORY...
  11. mdavis1

    network performance

    hey sherman..can u help me with the "upsize all data table to SQL". thanx mdavis1
  12. mdavis1

    MultiUser Lockup

    ok..here's the deal. i have a database (compcomp) that contains all my forms, queries, macros,reports for 4 databases<.<.<these database tables are linked to this database (compcomp). Every thing works fine. (thanx to a little help from friends:-X) UNTIL you access a certain database...<xref>...
  13. mdavis1

    Trouble Accessing Database via mapped drives..server..

    worked great guys. thankx a bunch.... check my other post...ya'll were wonderful :)
  14. mdavis1

    Multiple User Lockup

    i've tried, looked, checked and rechecked..i am completey bumfuggled...for lack of a better word. any POI would be greatful..thanks
  15. mdavis1

    Trouble Accessing Database via mapped drives..server..

    i have a database on a citrix server. I have the forms,queries, etc in one databate (compcomp) and the tables are linked to the prospective databases. (xref, csur, dlog, vlog). all of this is contained in the same folder on the server. J:\databases i have the individual computers J drives...
  16. mdavis1

    Multiple User Lockup

    1. yes 2. yes..done the faq 3. well...trying to access the same table...not same record. 4. i have it set to no locks 5. i've tried combining everything into one database, splitting into two databases....forms/queries in one and tables in another. 6. just made a blank database, imported the...
  17. mdavis1

    Multiple User Lockup

    every time more than one person is in the database to add files, it locks up.. i need for more than one person to enter at a time. this happens if one person is searching and one is adding,.....help...quickly...thank you. monica
  18. mdavis1

    Sync form and subform for filters

    i can filter records on my main form, but when i search from my subform, it doesn't bring back results. I want to be able to filter from any field on this form. The main form contains customer information, the subform contains cylinder information for that customer.. sometimes i might want...
  19. mdavis1

    Filter /Open Report Command Button

    **Private Sub cmdOpenReport_Click() If Me.Filter = &quot;&quot; Then MsgBox &quot;Apply A Filter to the Form First!!&quot; Else DoCmd.OpenReport &quot;Report1&quot;, acViewPreview, , Me.Filter End If End Sub** i have a form &quot;frmCustomerSurveySheet&quot; that has a...
  20. mdavis1

    Show results in a form-- from multiple combo boxes

    <jumping up and down> I GOT IT ...I GOT IT.... ***& Me.[Customer Name] &...i was not putting the name of the combo box here...(like i was told to do) :-P so many thanks to you [COLOR=red]MR.LUNDE[/COLOR RED] YOU RULE DUDE.

Part and Inventory Search

Back
Top