Search results

  1. W

    Solved Open Report with where condition

    Thank you, works beautifully. I think I need to learn exactly where to put this apostrophes and quotes.
  2. W

    Solved Open Report with where condition

    I am using Access 2016, I am trying to open a report with a where condition, on a form I have a unbound combo box listing names (Cbo_Fltr_AADCtrCd) (saved as text) and on the report the field to be filtered is (AADInstalledBy) (saved as text) the report will open without the were clause, but...
  3. W

    Update Statement with a listbox Filtering & Combobaox

    Basically the listbox shows what equipment is available to be transferred, the db does not know what equipment is being transferred there is not a way to filter it out because a person decides what equipment is being transferred. lets say there is 300 parachutes in the db 50 of them may...
  4. W

    Update Statement with a listbox Filtering & Combobaox

    Thank you for your assistance/work, creating the message box and it works great. I will now continue creating the rest of the db. I will have to learn how to work with strings they allow for more flexibility.
  5. W

    Update Statement with a listbox Filtering & Combobaox

    Attached is as requested, and thank you for all the help.
  6. W

    Update Statement with a listbox Filtering & Combobaox

    I appreciate the help, and any thing that helps to get this working the way I am things would be great. I received another runtime error 3144 Syntax error in UPDATE Statement FYI, if I select a different location I receive a different error code of runtime error 3075 Syntax error (missing...
  7. W

    Update Statement with a listbox Filtering & Combobaox

    Sorry to say that did not work, received another run-time error '3075' Syntax error (messing operator) in query expression '[LSN] in (1A1256B)' 1a is a SN
  8. W

    Update Statement with a listbox Filtering & Combobaox

    Thank you, I received an run-time error '3075': Syntax error (missing operator) in query expression 'Raeford, NC' It shows the error on the CurrentDb.Execute line I do not understand string programming that well, I usually stay away from them for that reason, I am a self taught VBA and...
  9. W

    Update Statement with a listbox Filtering & Combobaox

    I did think about the update query, but I could not think of how to filter down to only show the records that need to be updated or am I thinking how a update query works that it updates all records that show in a update query. this will happen on a month by month bases that a end user that...
  10. W

    Update Statement with a listbox Filtering & Combobaox

    Thank you for your help, I am trying to update records in a table with the update statement, By using a unbound Listbox [SN] that shows serial#(s) (stored as text) (able to select Multi) primary key is hiding, there is a third column that shows item discerption (text), then there is a unbound...
Top Bottom