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 Chris Miller 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: *

  1. Fitzy1012

    Screen Flicker

    I recently wrote a access application that is used for a IN/OUT BOARD for my office. Because of the nature of the application, the fact that people coming and going, the form is updated every two seconds using the database information. The program works great accept the problem with screen...
  2. Fitzy1012

    Having trouble executing my SQL statement

    thanks guys, including Duane lol!!! You guys are great!!!!
  3. Fitzy1012

    Having trouble executing my SQL statement

    then how would you update a boleen field in a database? I the same database I have a field called Status-IN which is booleen.
  4. Fitzy1012

    Having trouble executing my SQL statement

    Andy, Think you so much for your help. I have not used access for 20 years. But Can you explain why your sql works and mine does not. originally I did not use the .text.; MINE - dbs.Execute "Update Location SET Comment = TxtLocation1 Where ID = 1;" yours - dbs.Execute "Update...
  5. Fitzy1012

    Having trouble executing my SQL statement

    Hello, Hopefully someone can help me. I am trying to execute an SQL statement in a Microsoft Access 2016 application. I'm am trying to update a database using the "Update statement" in my SQL but I get keep getting the same error message "Two few parameters. Expected 1" My SQL Statement is...

Part and Inventory Search

Back
Top