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 Mike Lewis 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: *

  • Users: Nkuha
  • Order by date
  1. Nkuha

    turning a combo box into a search field

    I tried doing this, and it works when I search for a primary key value, but it doesn't work when searching for a match in the "lastname" field. This first sub below works (the primary key one), but the second one doesn't. Below is the search function that performs the actual search...
  2. Nkuha

    Using rst.Find with non-PK fields

    I'm not sure why it's doing this, but I think it's because you can only search this way by primary key.
  3. Nkuha

    Updating records where a DATE field has gotten too old.

    we must be very close now. It does accept the connection string.
  4. Nkuha

    Marking a record based on data in it's "Many" relationships.

    Thank you. This code looks logical, but I'm having trouble getting it to work. I get the error: "syntax error converting the varchar value 'true' to a column of data type bit." I tried replacing "true" with -1 and "false" with 0 in my code to no avail. Here is...
  5. Nkuha

    Marking a record based on data in it's "Many" relationships.

    I have a one to many relationship. I want to count all instances of "true" in a field in the "Many" table, and if any are found I want to mark another binary field "true" in the "One" table. If none are found, I want to mark the field in the...
  6. Nkuha

    Adding a variable in the middle of a Query

    Anyone know how to correct this code? rst.Open "update cases SET cases.flag = 0 WHERE" & DateDiff("h", rst!datein, Now) > threshold, CurrentProject.Connection, adOpenKeyset, adLockOptimistic
  7. Nkuha

    Updating records where a DATE field has gotten too old.

    Are you using microsoft access as a front end to the database?

Part and Inventory Search

Back
Top