Search results

WEll I guess Half-way is better than the wrong way... :o ...at least I THINK we're saying the same thing.

Probably due to the date being stored as both date and time (which Access does) when the field uses the Now() function. If you change it to Date() it should clear up. If that's not an option, then try using the Format() funtion in your query to reformat the output to return just what you want...

Glad to hear you got what you needed.

Sounds like your report is based on a query (or should be) with a criteria something like this: [Enter Customer Name] which should popup a prompt whenever the report is opened

You are correct, it is your criteria you need to set. Try using the expression builder to set your criteria.

DON'T store calculated data in your table. To display it in your form, you can base the form on your query, or use an unbound textbox with the same expression as it's control source.

Mile AND mission2java, I'd love to see your final results, as I've put a similar task on the back burner for quite awhile now. Any chance of posting what you've got that works? Thanks

LOL, Mile... :D As I approach 45, I really needed that! :p And just when I was starting to reminisce of My youth. :rolleyes: BTW... I really find your new avatar appealing. Are you free for dinner tonite?

Speaking for the simple minds... Could you not simply choose to have the input mask save the data WITH the formatting? I believe it is an option in the wizard. (although I realize there's probably a good reason not to, which I hope I'll soon learn)

Have a look at this

Mile, They were '70's, I met him on his solo tour in the '80's. This link to Ian Hunter should give you a quick history of both Ian and MTH.

Ian, I didn't really expect you were.:D But I've had many similar experiences over my 23 years as a stagehand. I did meet him once when he played a club I teched for in the early 1980's.

Maybe you could explain in more detail, or attach a sample

Sounds like a Continuous form based on the linked table. If you've already got that link established, use the form wizard and then adjust the design to suit your taste.

Forgive the sidebar question, but... are you THE Ian Hunter of Mott The Hoople fame?

Courtesy of a friend John had a terrible accident which mangled his private parts, requiring they be removed. His spirit was broken. His doctor told him: "John, all is not lost. I can make you better than before. It is possible for us to replace your lost member with a prostetic. However, the...

No problem. Glad to hear you got it going, and in just a few minutes at that.

Here ya go... Oops! the file is too big to attach. Sorry, but I was willing. :eek:

I've never done it, but Access 2002 does have an encryption feature built-in. Search the help file for details.

Two blondes walked into a bar. You'd think the second would've seen it. ===== 2am. The phone rings and Marie answers and listens a moment. She then replies: "How should I know? That's 200 miles away from here! Try the weather service." Then she hangs up. Her husband asks: "Who was that?"...