Recent content by yeasir01

  1. Y

    Certain VBA will Not run when file is converted from ACCDB to ACCDE

    :eek: Thank you guys for all the input, but arnelgp was absolutely correct, the issue was that I didn't set the focus to the main form. Thank you very much! Forms("MainSearchForm").SetFocus DoCmd.BrowseTo acBrowseToForm, "PrintSearchQuerySubForm", "MainSearchForm.Main_Subform"
  2. Y

    Certain VBA will Not run when file is converted from ACCDB to ACCDE

    The code posted does not open another form. it switches the navigation from products to print list.
  3. Y

    Certain VBA will Not run when file is converted from ACCDB to ACCDE

    I recently converted my completed project from ACCDB to ACCDE, since then I noticed the following code will not run. DoCmd.BrowseTo acBrowseToForm, "PrintSearchQuerySubForm", "MainSearchForm.Main_Subform" The code is suppose to switch the navigation form from products tab to print list tab...
  4. Y

    Speed Print Key

    For anyone doing the a similar project here's the syntax that worked for me. The one posted before this one did not work. if Me.SpeedScan = True And DCount("UPC", "merchandisetable", "UPC=" & "Forms!MainSearchForm!searchtext") = 1 Then Me.SelectedData = Me.SelectedData & DLookup("ID"...
  5. Y

    Speed Print Key

    Heres what I came up with, Is this the best way to do this? Forms("MainSearchForm").SelectedData = dlookup("id","merchandisetable", searchtext) & "|"
  6. Y

    Speed Print Key

    I attached a picture to hopfully convey the message a little better.
  7. Y

    Speed Print Key

    I actually added the speed key so I can scan a barcode and have that item put in a que for printing or displaying the report. Hope that makes sense. It speeds up the process of select only the items you would like to print.
  8. Y

    Speed Print Key

    I had to redesign the database to work for multi user. The flaw in my first design was the check box was bound & stored on table which was used for selecting items to print. I quikly relized that will not work when the tables are being shared. @CJ_london made a great suggestion...
  9. Y

    Multi select records in a shared back end database

    Im sorry I figured out that I wasnt refering to the correct table, it worked Thanks a million!:banghead:
  10. Y

    Multi select records in a shared back end database

    I just tried that one & im getting a This specified field [ID] could refer to more than one table....
  11. Y

    Multi select records in a shared back end database

    I made the changes & uploaded the database. also, updated form location & I keep getting an error the expression is typed incorrectly....
  12. Y

    Multi select records in a shared back end database

    Sorry for the late response, Iv decided to go with the method you mentioned on the sample database. I Just have one question, how do I interpret this into usable data for query search (criteria)? The numbers below represent ID numbers produced by making a selection. 6|5|8|9|7|2|3|4|712| As an...
  13. Y

    Multi select records in a shared back end database

    :) Thank you for bringing my attention to this thread, I just learned a new way to accomplish the desired goal. However is they're a way to make it work with check boxes instead?
  14. Y

    Multi select records in a shared back end database

    What method do I use to select the record to add to the local tbl? I would like to keep the checkbox if possible.
  15. Y

    Multi select records in a shared back end database

    there is no user name it a simple 1 form database where anyone with access can add/edit records and print shelf tag labels.
See more
Top Bottom