Search results

I live very close to a High School. I am surrounded on three sides by roads that have school zones that post a 40kmh speed limit for a period of two hours morning and night at start and finish times for school. If you observe these zones, which I have done frequently, you'll notice that it is...

Forgive me for being stupid, but that's why I'm seeking help. I've downloaded the revision that you've done and it doesn't work. The picture you posted shows that you have the field "MySort: VAL([SGCatNo]) but the actual query just has it as "VAL([SGCatNo]) and the report won't run because it...

Good, true and valid points John. No denying females do have some better qualities than men but I do not believe that driving is one of them, as I have observed outcome 'B' trying to kill me, haha! :D

Everytime I've faced a near death experience on the road it's been due to a female driver. So, even though I'm biased, and at the risk of starting World War 3, I thought I'd pose the question. Which sex are better drivers? No sitting on the fence with this one! :eek:

Okay, i've uploaded a cut down version of the database in both '07 & '03 Access versions for you to look at if you get the time. You'll notice that the report is generated from QRY_CWUsedQtyTotXVal. As previously mentioned, with your help i've managed to get the report to sort the "SGCatNo"...

Going along the lines of what you just suggested, perhaps I should let you know that when I added the MySort field to the query, I inserted it's column just before the original field, would this have made a difference?

Okay, we're getting closer, but still not quite right. The test I've just tried will indeed sort the numbers correctly but not the letter component. My trial resulted in :- 12e 12b 1123c Any other ideas? :confused:

Hi Bob, I've just tried what you suggested. It works.......BUT....... it doesn't display the letter on the end if there is one. I've noticed however, when I add the MySort field, it automatically defines it as a number field, could this be the issue? How do I fix it? Thanks

Thanks Bob, Should there be a box close after Yourfieldnamehere? I'm guessing so. I'll give this a try and let you know the outcome.

Thanks, I'm sorry but you are talking way above my skill set. Whilst I really do appreciate your help, it's something I find hard to comprehend. But thank you.

The order should the read:- 112 117C4 126 1156 Your example of 117C4 in my situation would basically state that the catalogue number was 117 - variety C, so therefore it should rightly appear between 112 & 126. Having said that, the catalogue numbers I have to use never have another digit...

Thank you, That's a load off my mind. It's only since I added code to my forms and I was worried I might have done something wrong! Cheers.

I'm designing a report so I've put the thread here, but it could almost be a Table question also. Okay, within one of my tables, I record a catalogue number. The column though is set to Text because the catalogue number could be "878b" for example. I've built my queries for that table and...

So I set DBpath & DBdrive to what I need and delete the other DBfile lines, is that correct? Please give me more information as I'm not sure about this.

An Asian man walks into an Australian Post Office and asks for a postage stamp. The clerk hands him a stamp and says "That'll be 60 cents thank you", the Asian looks at the stamp and says "I was here yesterday and it was only 55 cents, why is it more now?" The clerk replies "Fluctuation". The...

Hi mdlueck, I have downloaded the script and unzipped to the same folder as the DB. I just need clarification on which parts of the script I need to edit before running. Obviously, I need to edit SET DBPATH. I'm also guessing that I need to edit SET DBFILE but I've noticed that in your example...

Sorry, Access 2007 Thanks, will check out the link.

Hi all, Every time I open my database if the first thing I do is run Performance Analyzer for VBA Project I get the following suggestion :- "Application: The application is not saved in a fully compiled state" Where I'm confused is that I can go into Visual Basic, select Debug, and select...

Cheers for the link. Gave me exactly what I was after and resolved the Performance Analyzer problems with my forms. Thanks.:D

Thanks mate, I'll have a look.