Search results

  1. Y

    Speed Print Key

    toggle method scan, scan, scan to add three items to print list then print Manual Tick Option scan to search tick checkbox scan to seatch tick checkbox :)
  2. Y

    Speed Print Key

    That didn't seem to work i recieved a run time error 3464.Good point on the reserved word, ill have to go back and change that to selected instead. Any other thoughts?
  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

    Sorry jumped the gun on that one it doesn't seem to work for codes such as the one below. Last Month(start): DateSerial(Year(Date), Month(Date) - 1, 1) Last Month (end): DateSerial(Year(Date), Month(Date), 1) - 1
  5. Y

    Passing date ranges from combo box to txt

    Thank You! That did the trick
  6. 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()"...
  7. Y

    Filter Query Based on user permissions

    You're Awesome! Thank you this helps me tremendously.
  8. 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 ("*")...
  9. Y

    Dlookup query with multiple criterias

    This is useful information, I will defiantly read the article.
  10. Y

    Dlookup query with multiple criterias

    You're Awesome, that worked!
  11. Y

    Dlookup query with multiple criterias

    Thanks. Now it doesn't show a record at all. Any other ideas?
  12. Y

    Dlookup query with multiple criterias

    Querry is named "INV_DELIV_QRY" for reference.
  13. Y

    Dlookup query with multiple criterias

    Here you go thanks for the Help!
  14. Y

    Dlookup query with multiple criterias

    here's what I get when I click on Error
  15. Y

    Dlookup query with multiple criterias

    That did somthing but, im getting an "ERROR" in every record where the value should be.
  16. Y

    Dlookup query with multiple criterias

    Here you go Expr1: DLookUp("[CLOSING_VOLUME]","[DAILY_TASK_WETSTOCK]","TANK_ID=" & [TANK_ID] & " AND ([DATES] = "# & [DATES]-1 & "#")
  17. Y

    Dlookup query with multiple criterias

    It show invalid syntax with highlighted.
  18. 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]...
  19. Y

    Listbox to assign transactions to billing statement

    I think you got it wrong?? I need to pass the value to the list box Statement_id field.
  20. Y

    Listbox to assign transactions to billing statement

    The two forms are clients billing & clients billing popup.
Back
Top Bottom