Recent content by danboi10

Thanks pbaldy. That did the trick. Dan

Hi All, Hoping somebody maybe able to help with a little query regarding access vba. I have used VBA to develop an automated letter that is run from access. It works....which is a miracle! However one field is driving me insane:banghead: and it revolves around the combo box. In the Access form...

Thanks for the reply Trevor. Unfort i do need it to open from the pivot table. However, you did give me the idea to go right back to basics!!!! Dan

That's brilliant. Done the trick nicely. Thanks very much

What Im trying to do is say If the field "first Name" is only 1 letter then type "dear sirs". Else if the field "first name" is greater than 1 then enter the data from the "first name" field. eg somebody puts R in the "first name" field and the letter would be "dear sir" but if somebody wrote...

Hi, I have created a macro which takes the data in an access data base and produces a letter based on the information. I am almost at the end but have found a variable that I don't seem to be able to find an answer for. The issue in questions relates to a field called first name. It's not...

Hi, Have used the access forum but this is my first foray into excel! I am hoping that someone maybe able to assist with the following query: I have a pivot table that has two columns and 29 rows. The essential function that i'd like the VBA code to perform is to open each row to a new...

Thanks Pat. Will chase up after me return from leave. Dan.

I probably should have mentioned that the automated letter is being generated using access 07 vba. Sorry.

Hi, I am currently working on an automated letter and have in the most completed the automation. I have only two more issues to resolve and it can go live - I've searched the web and got no joy. :banghead: It's a two parter! The first query relates to inserting a table and fields. I'd like my...

Just back from leave. Thanks.Dan.

Hello, I'm currently working on automated letter and as a general rule it is going well, to the point where with a click of a button all fields and text are sent to the word document. The problem that is causing me the biggest headache is when i try to reformat the caps entry into proper text...

That's got it. Many thanks for your help. For ref it works much better without the .execute!

Hi Bob, I think we almost posted at the same time so whilst I was asking for a bit more info you were sending me the link! Thanks will take a look into it.

I know this is the most basic of questions but what would the 'add period' be? I am very new to access....this week! It was given to me as a project and through a hatchet job of recording macro's and searching the web I've been able to produce a search, find and email function...that doesn't...