Search results

If the error is 3464, mis match then the error is in the rs find line rs.FindFirst "[fldAuto] = '" & Me![List0] & "'" is searching for a text field. Try rs.FindFirst "[fldAuto] = " & Me![List0] This is for a numeric field. Dave

Simply make the image on the report smaller, delete the txtcover (not sure why thats there anyway), and move the report footer up. No re-coding required.

Mail Merge is something my client seem to ask for, as they know word, but something I have always struggled with. Merging always seemed messy and un co-ordinated. The sample in the link is excellent and I think it will allow me to easily include mail merge from now on. Thanks heaps, Dave

Glad you were able to work it out.

Sure, but we might need a bit more info...

Sorry for the rant in this link, but the guy was sending me PM after PM asking really dumb questions over and over, and not taking any notice of my advice. http://www.access-programmers.co.uk/forums/showthread.php?t=126179 The attachment shows how to store the path and view / print. Dave

Something I will never have to worry about :p

Opps, did I start all this? :eek: Seems we have lost demen_demen. Wonder if we had given the answers if they would have analysed where they went wrong, or just copy them in and submit it? The latter I bet.

Maybe posting a cut down version of the Db will help.

I've checked your answers, when's the test?

How are you gathering the sql In a module... Public strSQL as String Then construct the sql strSQL = "Select Blah Blah Blah" In the On_Open event of the report: Me.RecordSource = strSQL HTH Dave

Why do you need to refresh the data in the combobox so often? If the combobox is driven by a field on your form and used to search, then us the afterupdate event of the field to save and refresh.

2 things.... 1. I had the same sort of issue when I bought my Vista laptop. Came up with an error saying I did not have the necessary permissions and to contact the system administrator. (or something) Wonder if you get the same error. I searched the error and found I had to edit the registry...

You need to check for new record, because if you are scrolling through existing records that are correct, they may update. Making the next field in records default to the last record. Using the UserName field as an example.... In the After Update event of the UserName field put code like...

Just had a play, I think I will be able to get the "Hide Duplicates" property to work. :D :D Thankyou, Thankyou, Thankyou

Have never noticed or used this property. Will give it a go. Thanks

Close, but as mentioned, I dont want to "Group" by the Category field, but add a heading each time category changes - As in the example at the end of my first post. If you look closely, there are 2 "Computer" headings. If I sort as you mentioned it prints as Pic3. Will keep trying.

I have been grappling with this for some time to no avail. I have developed a database to keep track of assets. Each asset has a categoryID, and this controls what labels appear next to the field names (Building category might have Address, Date Constructed, Height etc, Computer category might...

:confused::confused::confused:

C'mon, stop being distracted :rolleyes: