Recent content by phil_s

Gary, thanks for the response but this does not really do what I wanted.... what this does is export data to set fields in a word document.... What I am trying to do is to use a word.dot template and then use the mergefield function and to export the record data from access, but driving the...

Hi all, have a query here as being new to Access and VBA it's leaving me dumbfonded. I have (well actually my boss) has the need to export data from Access to a MS Word document in a formatted manner. OK, so I have started to go down the line of a Word template with unique characters inside...

thanks for the response Thanks for the response but I think I have my terminology a bit mixed up. On thr form that defines the list box, the box is UNBOUND, and I then use ADO to read the database that is on a remote drive. I then use the .AddItem function to add the returned data to the list...

Hi all, I have been caught by what I think is a classic compatibility issue. I have created a list screen that uses ADO to access a database located on a remote drive. In Access2003, the following code works fine and my list box gets populated correctly: lessonList.AddItem...

Hi ecawilkinson.. the two parameters txArea and txtRelease are being passed into the function as arguments from another form, so I want to filter on those, but they may or maynot be present, so that is why I went for a Like and the "%" match if the value was passed as a blank. If a value is...

Rabbie, thask for the quick reply.... yeah got me.. the CONTAINS is not valid in ACCESS... cant remember where my adled brain got that one from.... I tried swapping the "%" for "*" in the query but then got a -2147217913 "Data TypeMismatch in Criteria Expression" error... looks like I'm still...

Sorry if this is the wrong forum to place this one under, but it is an SQL query I have coded up in VBA for a search on a Access Database.. so sorry if this is the wrong forum to place this one under...... I have a SQL Query I have coded up in some Access VBA as follows: strSQL = "SELECT *...