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 derfloh 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
  • Order by date
  1. kat17

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

    Thanks! Just what I need!
  2. kat17

    How to check for duplicates within one recordset or row

    Thanks all. Unfortunately, I can't normalise because the database not mine! I've just been asked to help make it more user friendly. I'm only a rookie at VBA so I'll ponder on your posts and do some research. Hopefully I'll get it working!
  3. 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...
  4. 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...
  5. 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?
  6. 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?
  7. 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?
  8. 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...
  9. kat17

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

    Thanks for all your posts.. sorry for the delay! Anyway, I went to use "DLookup" but am not sure if this is what I need. Or maybe it's because I am new to the "user-side" of things... (gimme SQL thru a DOS prompt anyday!!) What I THINK I need something that will not lookup values in the table...
  10. 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...
  11. kat17

    Help incrementing a number by 1

    Yes.. thanks for jumping in there PHV! It works like a dream now! VERY USER FRIENDLY ;-) Just one question in regards to the Input Box.... Can I get rid of the CANCEL button? (if you press cancel I get a run-time error '13' "Type Mismatch") It works great when the user types a value and...
  12. kat17

    Help incrementing a number by 1

    Thanks again. You help has exceeded my expectations! I hope I can repay the favour one day!
  13. kat17

    Help incrementing a number by 1

    Yes, I noticed that error.. hence, the error message to ask the user to enter the info manually! (nice try, eh?! LOL) Thank you so much for your time & for giving me this valuable information.
  14. kat17

    Help incrementing a number by 1

    Thanks heaps Zameer. It works beautifully! Just in case anybody is interested what I did, here is the code below: Private Sub Combo10_AfterUpdate() 'after update of CLASS FIELD, a new student roll number is generated Me![rollNo] = newRollNo() End Sub --- Public Function newRollNo() As Long On...
  15. kat17

    Help incrementing a number by 1

    I have looked at the DMax function but did not know it could use criteria. I will research more and let you know... Thanks!
  16. kat17

    Help incrementing a number by 1

    OK... here is a new attempt. I am just a bit stuck with getting the String to become an Integer. I feel like I need to do something like: Me![rollNo] = sql + 1 How and where would this go??? Private Sub Combo10_AfterUpdate() Const cQuote = """" Dim sql As String sql = "SELECT...
  17. 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