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!

  • Congratulations Wanet Telecoms Ltd 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: kat17
  • Content: Threads
  • Order by date
  1. kat17

    How to check for duplicates within one recordset or row

    I would like to check for duplicate entries within one record (one row). Here is a scaled down example of my table: NAME GuessA GuessB GuessC ======================================= Jill 1 2 3 Jack 2 8 6 Basically, each person...
  2. kat17

    is it possible to find duplicates WITHIN one record or query?

    I would like to check for duplicate entries within one record (one row). Here is a scaled down example of my table: NAME GuessA GuessB GuessC ======================================= Jill 1 2 3 Jack 2 8 6 Basically, each person...
  3. kat17

    List Box for selecting a report font size

    I would like to allow the user to choose the font size (and possibly alignment & font type) before print-previewing the report. Can I add a listbox to a form so the user can select the font size for a report?
  4. kat17

    Printing reports are slow

    Where should I start troubleshooting this problem? I have some reports that print out class & student details. The printer is stopping between each page, the pause time greatly extending for each class that is printed. Any tips?
  5. kat17

    Display results as comma separated values

    I'd like to display a list of names using commas in my report. Is this possible? At the moment, my report looks like this: FNAME LNAME ---------------- Rowan Atkins Jon Bell Matt Bowen I would like it to look like this: Rowan Atkins, Jon Bell, Matt Bowen Can anybody help?
  6. kat17

    how to execute an SQL SELECT statement in VBA?

    I want to execute an SQL SELECT statement in the "after update" event of a field on my form. If the query returns NULL, I want nothing to happen. If the query returns a result, I need to display a MsgBox. I am also hoping that I can insert the query result into the MsgBox. Can anyone give a...
  7. kat17

    How to alert the user of duplicate entries within a form?

    I have a sub-form that represents a matrix. I would like to alert the user if a value has been already entered. (These values are not primary keys) I gather some type of code would need to be used in the AFTER UPDATE event but am not sure what to use. I only want to search the current form for...
  8. kat17

    Help incrementing a number by 1

    I have a table called tblStudent & a matching form with the following fields: idClass(Long), idSchool(String), rollNo(Long), barcode(String), fName(String), lName(String) I would like to increment the field "rollNo" by 1 depending on a WHERE clause. My problem is getting my form to work...

Part and Inventory Search

Back
Top