Recent content by MrTK

Thank you very much for your help! TK

Hey Gerry... Hate to trouble you and all, but could you send that helpful VBE study file you mentioned, to sperk20_2000@yahoo.com Thanks again! TK

On a scale of 1-10, maybe a 3. Please send to sperk20_2000@yahoo.com Thanks a million! TK

Cool! Thanks Gerry, I appreciate all your help and steering me in the right direction. I will take your advice and try the VBA thing. If you please share the simple study of a UserForm that you offered, that would be very much appreciated as well. TK

So there's no way get rid of the unwanted data that's coming from Access fields?

I am trying to export a query to Word. It's strange. When I look at the fields in Access the field is empty, but when it pulls the query in, it has the 0's and date in there. I went to the design mode in Access and typed in your (number=0,"",number) and Access said "Data type mismatch to...

Yea, that's really my problem, the underlying table in XP is 0, and the underlying table is "read only", I was hoping for a simple fix to change is back to null. Not sure about the default date thing. All I can tell you is that where there used to be no date and no data in the field in Access...

You mentioned a UserForm, and dumping the data onto the form. Do you mean like a template or do you mean something else? "The way you'd go", sounds like the way to go! Quick, fast and efficient. That's what I'd like to do. What do I need to do? MrTK

Gerry, Thanks for the response. Sorry about the confusion, I'll try to give you a better explaination. I have a couple of Form Word documents, I'm using them essentially as a template saved in .doc format. A couple of years ago I created these doc and I inserted fields under the "Fill-in"...

Just converting a Access 97 to 03, and discovered that I'm not in Kansas anymore! 03 is quite different. But here's my problem (not the only one, but the one I'm working today). I have a "read only" linked tbl, where one tbl is set to "numbers" and the other to "date". The problem is that in 97...

Hello, My work just upgraded from 97 to 2003 (finally!). I'm finding that some of the features don't seem to work in 03, such as: "Fill-in", which I used to enable the dialog boxes to pop-up either when the form loaded or by clicking on the unprotect to protect button, and then I would fill-in...

Hello, My office just upgraded from 97 to 2003. I'm finding that some of the features don't work in 03, such as: "Fill-in" used to enable the dialog box to pop-up, now it doesn't seem work unless you manually click on the field and select "Update". Any suggestions on fixing this? Also in...