Recent content by cyberbob999

Rolliee: I'm not sure you understand my problem (or I don't understand your solution, perhaps). I'm not trying to add a new record... I only open the recordsets to display data from the underlying table--I don't even wish to edit the data in the recordsets. The data I'm editing is not in a...

I *think* I understand the nature of this error--if I'm using a dao/ado recordset and I try to update it without using the addnew or edit method beforehand... Well, I do use two different dao recordsets in my project; however, both are read only (for data display only--neither is ever updated...

Very helpful Rolliee--thank you VERY much!

Rollie: I don't really follow--could you elaborate please? Thanks!

hmmm...either I don't understand or it doesn't work. I tried yy\/mm\/dd in in the table properties format for the field in question and I still got the invalid data type message. I haven't had a chance to do any research yet, but what is the backslash-forward slash combination do?

Unfortunately, most of the dates are manually transcribed from paperwork (written in the yymmdd format) so I think it would be cumbersome for the person entering the data to have to mentally convert each date to a conventional format, then enter it vice just being able to mindlessly type the...

Actually, there are no separtors of any sort. And, unfortunately, the format that I put the dates in is not flexible--more specificially, the format that I DISPLAY the dates in is not flexible. The underlying tables all store the dates in a conventional manner (i.e. mm/dd/yyyy).

Let me tell you exactly what I'm trying to do... I have a date field that I am formatting as yymmdd. However, even though it is displayed in this format, the user cannot enter the date in that format because Access doesn't accept it as a valid date. So, what I want to be able to do is to test...

You're right, that does sound like what I want to do. Unfortunately, I tried it and I still get the "warning" even with: docmd setwarnings false My uneducated guess is that this message ("The value you entered isn't valid for this field.") isn't actually a warning, but of...

I have a date field on my form. I would like to keep all of the functionality associated with the field being a date; however, I have one problem. If I enter a non-date string in to the field, I would like to be able to deal with the error handling before Access pops up saying "The value...

Yeah, I know that the cangrow property exists for a text box, but isn't that ONLY for printing? I know that when I set it to yes it makes no difference (on the screen) and the desciption specifically says "Control or section expands vertically when printed to fit text"

I have a form that is viewed in continuous forms. One value (txtComment) varies in length from only a few words to 3 or 4 sentences. Ideally what I'd like to do is vary the size of the text box on the form such to fit the amount of text. Something like the cangrow property would be nice...

Very useful guys, thanks! That is exactly what I was looking for!

Let's say that the directory where my db is located is c:\a\b\c\d\. Is there any way to use objword.documents.open() such that I can just put the include the filename as the argument vice the entire path? (i.e. objword.documents.open(filename) vice objword.documents.open(c:\a\b\c\d\filename))...

I hate to be greedy, but I have one more question: How do I pass the same variable over to a query? For example if my record source was a query and I wanted the filter criteria to be "[performer] like filPerformer"... thanks