Search results

It's weird, JS, you'd have thought someone like BrianWarnock would have thought of that? Apparently not. :D

First snow for this Winter, in the area I live fell last night. Nothing heavy (yet) just enough to look pretty. Temperature is exactly 0 degrees.

I do remember hearing it in that 'shave and haircut, two bits' thing they used to do in the old American music hall days. The tune is till used a lot for knocking on doors. Impossible for me to type here (as I have no idea how to go about writing it), but it involves one knock, brief pause...

You would store the name of each state and the number of days pertaining to each in a table. Now, say you have Texas = 40 days, California = 45, etc., when you enter a date value into a field on the form and a state value into another field, you could use the DLookup() function to find the...

The DateAdd function should be what you need.

After his first reading of it, someone gave him a different version, containing passages about Jesus, etc. as opposed to the yellow one listing pizza delivery, carpenters, etc. that he had just finished?

There's a comma after VehNo.

Why did these comments warrant smileys?

I was unable to type into the box, as you mentioned. However, when I deleted it and recreated an identical textbox (same data source, same settings, etc.), by copying pasting one of the other fields, it worked fine. Perhaps this is an option for you?

Jilly, the zip file contains a shortcut, rather than the mdb file.

Apparently, 'effective against bunions[sic]'.

Received, thanks. Either I got the day wrong, or it's being repeated here on the Saturday.

Okay, it’s back to this problem - until the powers that be decide otherwise, that is. Hopefully, the posted ‘cut down and doctored’ version of the db will give you the gist of the problem(s). In summary, when everything works: 1) Select a record from the topmost, left list. 2) The rest of...

*phew* Glad that one finally got sorted for you. :D If you get the time to do so, Gemma was definitely right about creating a function. I didn't mention it before, as the initial problem only involved a few letters, so it didn't seem worthwhile. Now that - theoretically, at least - you could...