Search results for query: *

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

Hasu you're a genius! You have NO IDEA the amount of time I spent trying to get that right! I thought I had tried every combination of brackets, single quotes and double quotes possible! To be honest, right now I don't really care why it works, just that it works ...but, I know I will run...

I'm trying to filter my recordset using a combobox. This seems like it should be an easy task to me, but I can't make it work. I've followed various examples in this forum, but I can't get any of them to work. Can someone please point out what I'm doing wrong? This is what I've tried...

I think I figured out what I was doing wrong...but now I have another fundamentals question... I have comboBox (cboName) which looks up values in a table. Let's say I select "Smith" from the list (cboName) and then MsgBox cboName, I get a number returned (the primary key assoicated...

For the life of me I cannot figure out how to filter a recordset dynamically based on a combobox value... I have a form that uses a table (surveillances) as a source. My combobox is cboFilName. The field that I want to filter by is [performer]. If someone could please explain to me how to do...

I am trying to fill in a table in MS Word using a recordset from a query (SurvQuery). SurvQuery has the following fields: [comment], [cause], [action] and [date]. The table has only the 4 columns: one for each of the above fields. There is a variable number of rows depending on how many...