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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by loonytick11

  1. loonytick11

    Refer to single instance of active control in continuous form

    Sorry, I meant right-click the control and select Conditional Formatting. Then select Got Focus.
  2. loonytick11

    Refer to single instance of active control in continuous form

    You can use conditional formatting. Right click on your control in design view, and select Got Focus (I'm not exactly sure of the wording) from the drop down menu.
  3. loonytick11

    Cannot add record when textboxes are bound to a JOIN statement

    Thank you for your help, Tom. In an Access control's RecordSource there can only be one line, so there is no need for a semicolon. However, in most SQL programming the semicolon is necessary and in general that's a good rule to live by, so I'll try it tomorrow when I get to work.
  4. loonytick11

    Cannot add record when textboxes are bound to a JOIN statement

    Access 2000 front end, MS SQL backend ------------ Two tables (tblA and tblB) have a one-to-one relationship. tblB's primary key is an autonumber. Nulls are allowed on all fields of both tables except the primary keys. I made a form whose recordsource is the following SQL statement: SELECT...
  5. loonytick11

    "Invalid input parameter values. Check the status values for detail."

    I'm not using an INSERT statement. I'm using MS Access textbox controls bound to fields in a query. P.S. If this post does not belong here, please direct me to the correct forum. Thank you.
  6. loonytick11

    "Invalid input parameter values. Check the status values for detail."

    Access 2000 front end, MS SQL backend ------------ Two tables (tblA and tblB) have a one-to-one relationship. tblB's primary key is an autonumber. Nulls are allowed on all fields of both tables except the primary keys. I made a form whose recordsource is the following SQL statement...
See more

Part and Inventory Search

Back
Top