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!

Register Log in
  • Congratulations dencom 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: *

  • Users: jwrocko
  • Content: Threads
  • Order by date
  1. jwrocko

    setting form field to the results of a vba query

    I want to be able to populate a form field using a query. The fields on the form are: Part Number, Quantity, and Vendor ID. My form, on click, will check to see if I have multiple vendors available for the specified part number. If there is only one, I want the field to be populated with the...
  2. jwrocko

    query join help

    I have a query that produces the desired results, but I need to be able to edit the results. So, the query is form resource. SELECT Parts.Part_Number, Parts.Component, Part_Detail.Manufacture_From, Part_Detail.Manufacturer, Part_Detail.Vendor_Part_Number, Parts.[Tracked?], Part_Detail.Vendor...
  3. jwrocko

    using table field to populate report box

    I have a report with two subforms that have distinct ID numbers. I want to seperate the ID numbers from the subform and place them in the main form. The ID numbers exist in seperate tables. Is there a way to either do this, or use a query to populate the text box/label?
  4. jwrocko

    I need to eliminate duplicates in a query

    I need to be able to compare two bills of material against each other and only view the differences between the two. I'd like to have a report setup with drawing_info_a on the left and drawing_info_b on the right. pertinent applicable information: Tables: BOM Query - this holds Part_Number and...
  5. jwrocko

    programmatically disable F11

    Is there a quick way to disable F11 in a report (or any keystroke)? I don't want a user to be able to hit F11 and then do whatever they want.
  6. jwrocko

    Using a listbox to pinpoint "wildcard" search.

    Ok, here goes. I am creating a form to edit user information. I need to be able to type in all or part of a username. Part of this is completed already - if I type in a full username, I can go from there. On a partial name, however, I want a listbox containing all the usernames to pop up...
  7. jwrocko

    Resetting or stopping code processing

    I am running an algorithm to create a pdf file and then save it to a specified file. This works just fine. The issue is that, whenever I need to edit code (soon after this process has been run), I always need to hit the little stop button to reset the code. Is there a way to do this so that the...
  8. jwrocko

    External pdf creation...help with output file

    I am using this code: '=========================================================== ' Code begins here ' ' The function to call is RunReportAsPDF ' ' It requires 2 parameters: the Access Report to run ' the PDF file name ' ' Enjoy! ' ' Eric Provencher...

Part and Inventory Search

Back
Top