Search results for query: *

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...

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...

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...

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'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...

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...

I'm new to Access, and even newer to VB...so hopefully this will be an easy question to answer. I would like to be able to display/edit [comments] in a text box that is controlled by an option group (or toggle buttons? ...or whatever is easiest!) Each record has a variable number of comments...