Search results for query: *

Thanks! Just what I need!

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!

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...

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...

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?

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?

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?

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...

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...

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...

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...

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

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.

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...

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

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...

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...