Search results

Thanks, I've done that part before but everything was on the same form so I knew a dlookup would work. In this case, 1 value was carried forward as a openarg the other was in a list box thats been selected so I had no way of referencing it. you got me thinking in a different way though which...

Thanks, That got me heading in a different direction. On the form I run the merge from I created 3 text boxes, got the 2 values in a couple of them then used the 3rd to do the dlookup, changed the code to look at the text boxes for the values and it worked. I then referenced that text box with...

The Code is running when I click a button. The code its self is part of a much larger subroutine. The Subroutine purpose is to generate a letter (using words mailmerge function) then saving it. This part of the code comes at the very beginning, to run my 'merge' sqlstatement I need certain...

I'm try to get the result of a Dlookup below so I can use the result later. In debugging the code. I have made sure that the P3rdBUSID and MatterID have both got the correct Values expected. Its just that strContIDLookup does not get the result assigned to it? Am I doing something...

Thanks, I'll give it a try as its something I've never done before.

Learn something each day.... Sorry to be a complete pain, could you give me an example of how I'd do the function with different forms to reference to as the text box would be the same on the different forms. Thanks

I'll use the same text box reference its just the form that would change. Sorry to be a complete pain could you give an example of how I'd do that. Thanks

Sorry, parenthesis? My terminology is not that good. If i need to use the function on different forms for different queries I guess I just make them unique for each time as it references the form.

Yep! I'm running the code from access to produce a mailmerge in word. As part of the code it uses my query to pick up all the fields for the merge and use usings form information (active matter id and client id) to select the correct records to merge. It's just a matter of adding in the...

Thats part of the problem. When i run it the only error I get is when word does the merge. If I run the query from the editor it runs when i give it the data. I don't know how to run the query while the form has live data in it to see if it references correctly or not. I hope I'm making that...

I use the query as part of a mailmerge to word. It ran fine and merged the required letter in word. But as soon as I added the reference to the text field it stopped working.

When i run the query as part of the merge, the form is active and has the relevant data in the fields required.

I've tried to run the query and it prompts me for the field information. When I manually enter the field details (initials in the case) it works. But when i use it in the merge function it does not work and asks to access the database. An error I've had before when the query has an issue.

I have a query I for mailmerging, Its working great but now I need to add the contense of a text box on the form that I'm running to add it in to the merge information. (the information is from a dlookup ran on opening the form and works fine) I've tried adding a reference in to query its...

Thanks for that Alan, That will work great...

I'm setting up a database and have made a rather large mistake! I've completely forgotten about a 'login' feature to pick up user details... Before you all have a go! I know I'm kicking myself enough already. I have a employee table with all various information and can add a login ID and...

Excellent, thanks for that. I thought I would have to be more specific!

In my Main form (frm_Matters) I have a subform (frm_Others) in that form I have a button which opens a new pop up form (frm_Other_Business) but I then need to close the form that it came from (I.e the Parent form 'Matters'). I've used the code I usually use when opening / closing forms but as...

Having looked at your example against mine, I've spotted where I went wrong! I got my bound Column's incorrect! As soon as I sorted that part out it went fine! Thanks for your help

Darn it! It wont allow me to back save to a older verison... I'll try to find what stopping it!