Search results

  1. 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...
  2. Y

    Multi select records in a shared back end database

    Hello, I plan to split and share my database with multiple users, however after I finished building the project I noticed that my checkbox are bound to a table so If one user checks the box the other user hits the print button some undesirable results will occur :banghead:. Is there a better...
  3. Y

    Speed Print Key

    Hello, I have a form I designed to be able to input data & print shelf tags quickly. An idea I had was add a quick-print toggle switch when switch on any barcode that's keyed in or scanned using a wedge scanner will change the [select] for that item from false to true. I tried the following...
  4. Y

    Passing date ranges from combo box to txt

    Hello, I'm trying to pass a VBA snippet that stored in a table into two text box from a single combo box. The VBA code I'm using is as followed in the after update of the combo box. The problem I'm having is instead of setting the value, it is passing the value as a string. for example "Date()"...
  5. Y

    Filter Query Based on user permissions

    Hello All, I tried using the following in the criteria section of the NO_ACCESSS column which did not yield the desired results. I am not familiar with SQL so I tried to accomplish this using the expression builder, any help would be greatly appreciated! IIF (FORM!MAIN!LEVEL_ID=1, Like ("*")...
  6. Y

    Dlookup query with multiple criterias

    Hello, I need to display closing volume value where the date is one day prior & tanks are equal to the current record tank ID. Help is appreciated. Heres what I have, but I can't seem to get it working. Expr1: DLookUp([CLOSING_VOLUME],[DAILY_TASK_WETSTOCK],("TANK_ID=" & [TANK_ID]) AND ([DATES]...
  7. Y

    Listbox to assign transactions to billing statement

    I Have a table that stores transactions details that occur during a normal business period. *The Columns on that table are as followed* ID (PK) Date Client_ID (CK) Volume Amount Statement_ID (default is blank) at the end of the cycle, I would like to select which transactions get assigned to...
  8. Y

    Display "Multiple" if parent contains more then 1 subrecords

    Hello Community, I have two tables (let's call Parrent & Child ) The parent contains information such as date and status of alarms, the child contains information that relates to that record via a relationship such as alarms that occurred that date. What I am trying to accomplish is a form...
  9. Y

    Calculate Opening Balance

    Hello, I'm working on ms access database to track fuel tank inventories for a multi-store operation. Typically on a pen & paper, you would have the following column headings. Which is what I replicated on access. I can't seem to figure out how to code the opening balance to give me the desired...
Top Bottom