Search results

I quite enjoy watching LeMans. NASCAR, not so much. I agree that it is boring to watch. That being said, I think it takes a tremendous amount of skill to control a car at those speeds, and to maintain those speeds around an oval with 50 other cars potentially within inches of the one you are...

Sorry... I meant the info from the web portal. I hereby make the guarantee that no more than one VDS code from a uniqe model name/model year combo will ever be assigned to one SETR. For the most part, the VDSs being used will be the ones with *'s in them. It is a very rare scenario that might...

No skill whatsoever? 200 laps = 800 corners Have you ever made 800 consecutive left turns at 200+ mph?? :p

The parts are not obtained based on trim level. The only reason I incuded VDS is because the warranty system uses it in the recovery of parts. In the text string that is the requirements for a part recovery, there is only a section for VDS, not model name. The warranty system also uses *'s as...

Hey Craig, It's been a while since I have had a chance to work on this, as there has been an awful lot going on. I have made some changes, but seem to be stuck here. In subformSETRModels, embedded in fmSETR, we have decided we want to filter by the VDS (a five-digit code that represents a...

SELECT tblYourTable.* WHERE tblYourTable.Field1 = "Sabbatical" OR tblYourTable.Field2 = "Sabbatical" OR tbleYourTable.Field3 = "Sabbatical" etc. I think this should work...

Played on my buddy's 360... Man, that game is amazing. We ended up beating the game in a solid day of playing, which we've never done. Played some XboxLive too... That game alone makes me want to get a 360.

Can you post a pic of you relationships? I'd like to see where all this information goes...

Hmm... In Access you should not be using the tables themselves for data entry; this creates too many opportunities to mess up the raw data contained therein. Through the use of forms, you have the options to set whether the user has the ability to modify or add data, or only view it. I think...

Have you checked out Access' Help Menu?

Ok, let me see if I get this... When ever any user enters data, they need to create between one and five records. Regardless of how many records they create, there are common elements in that batch. The one unique element that must exist is their Case_ID. A batch of five records might look like...

But if they didnt have to re-select/re-enter any information, would it be that bad? Or would it be any different from what you have now? You could use combo boxes in place of the text boxes... I know there is a way to store the selected values (I was just reading an article on it, but can't...

Instead of using combo boxes, would there be a way to put the info in through text boxes, and use a somewhat modified "save record" cmd button so that on the OnUpdate event or something, the values of the text boxes were stored (maybe as a string?)... Then the user can click the button up to...

Search the forums for threads about Inventory Management, Invoicing, and similar topics. The answers are out there. Also, I took a quick look at your db... You need to setup the proper relationships between the tables before you do anything else. Read about Normalization as well. Once you have...

on the first line of your SQL, try: SELECT DISTINCT professorFirstName, etc.

Whew! I'm just glad I could finally help... :cool:

I was wondering the same thing... I assumed 24 hour clock... so 2:00pm? Maybe try GROUP BY cursusplanning.Cursusdatum ORDER BY cursusplanning.Beginuur; I'm running out of ideas... :confused:

try switching the order the fields appear in the last line... so it would look like: ORDER BY cursusplanning.Beginuur, cursusplanning.Cursusdatum;

Ok, so what is the purpose of the field? Is it showing a time period for each record? I don't understand the 16u - 18u... Will the times put in this field always be whole hours? No minutes recorded?

so it is a text field then? try changing the last part of the line to: cursusplanning.Beginuur DESC;