Search results

Use the Combo box wizard and select "Find a record on my form...."

I agree with coach (And now Bob) . Create one contact table then a contact type table that has businessman freelancer employee frontdesk etc.. in it. That would be a more "Normalized" approach

if cbsupplier is a combo box with a bound column, you will only need to do the one supplier code. It is not necessary to do both code and name since they are tied to each other in the table, presumably of course.

You will want something like Like "*" & [Enter keyword] & "*" Of course this assumes that you type the keyword in correctly....

Are you using tabbed forms or overlapping windows?

so this would be RowSource = SELECT studentID, LastName + ", " + FirstName + " - " UniversityID FROM Students ORDER BY LastName; You dont see column count and column width under the format property of the combobox?

Yes it is, put the ID in the row sources, set it to be the bound column, increase your column count and set the width of the first column to be 0"

I was able to do this using a few queries. First query I got the courses required with the staffID, TitleID, and CourseIDs SELECT tblStaff.StaffNumber, tblStaff.StaffName, tblTitles.titleName, tblTitleCourses.tblCourse, tblCourse.CourseName FROM tblCourse INNER JOIN ((tblTitles INNER JOIN...

Thanks Linq. I was close! And wow!! Long time ago! My gf's family is all sox fans so we have a good rivalry going there.. Bought a red sox shirt just so I could spray paint sucks on it!

Yeah sorry i dont know why I thought thta would work at all Here is what ive come up with using this http://www.access-programmers.co.uk/forums/showthread.php?t=142257 Convert your time to minutes =CLng(24*60*CDate([time])) Then using this...

cant you use sum?

This thread made me look back at my first posts... so funny.. I bit off way more than I could chew back then, and it shows in my posts... haha EDIT: I in no way, think that I am a gargantuan mind!! Just wanted to take a look back!

Its ok. I understand. Probably because you are a Sox fan!! :p<----Yanks here!

Are you trying to insert something larger than 256 chars? Which is the Max size for a text field?

look up the dateadd or datediff functions. they should give you some idea of how to do it

Base your "Tools Description and info" form off of your "Tools Description and info query" instead of the actual table and then put forms!search.text0 in the query criteria for the ID Create a button to open the "Tools Description and info" form and you are done

That really is the worst joke ever... I'm not even sure whats going on..

I take no credit for it. All i did was search until I found the correct answer!

see above!

A Green Day album called Dookie when I was 11. Always wanted to name my dog that... But enough about that. Don't wanna re-hijack Brian's good news!