Search results

Hi boblarson, I reviewed the code begind Function Fusion and it's great. I figured that I can incorporate the entire code from frm merge 3x. I noticed that you used only one option group instead of 2 options group as it's on frmCriteria. In this case if I take the code from frmCriteria2...

ALL 3, you mean the renewals ? No, not running 3 at the same time, not even selecting another and running it. Here's the logic: - user selects renewal 1 and the language of its choice -data is moved to table Tb_1stRenewalTMP -at the same time, another query moves data to Tb_data which is...

Here's what I did (correct me if I'm wrong) -opened the form frmCriteria -added a sub form - the subform wizard asked me what sub form I wanted to add, I selected the merge 3x form - in the OnClick properties of the merge button I changed it for ''Public Sub Fusion(strTableName As String)''...

boblarson, I'm a little confused here. What you suggest is move the code from form merge 3x into a sub, but hidden, on form frmCriteria ? If it's like that, ok, but next this line where strTableName needs to be replaced by the three tables? Exemple: Sql = "SELECT * FROM " &...

BobLarson, I posted the db at the same time you posted your instructions. That's why. I looked if I could post the db on the post I was currently on, but I did not see the ''GoAdvanced'' button. That's why I went up and posted it there. Now that I see the ''GoAdvanced'' button, I'll remember...

It's already up at the top of the post as explained in post #11

I added finallya sample db so you can see how it works. It also contains a sample word template. For this you need to create 2 folders on your computer in the same directory as the db, folders named IN and OUT. Place the sample word doc in the IN folder. Then open database and click on form...

Better is to add a sample db so all of you understand better the logic. But where in the post I can add the db ?

Rx, You mentioned the "Forms Datasource" ( Me.RecordSource). Just wondering if you might execute the business logic to determine what the RecordSource might be (in terms of SQL string) and then assign it to the form's Recordsource property as it loads? > Yes that's correct.

BobLarson, To use multiple tables on a form, the NORMAL way is to use SUBFORMS on a main form > if you say the normal way is to use SUBFORMS, I agree with you, but the subform does not need to be visible on the main form. Just remain hidden. But will that solve the problem ? I mean make this...

The_Doc_Man, This smells suspiciously unnormalized. If you have different tables for different renewals, why would you NOT prefer to just have a code in a single table that TELLS you which renewal is in progress? > I do have a single code in a single form for the three renewals. But I cannot...

Hi Rx, The user has no idea which table to select, an hence that's why I'm trying to pass it only through VBA. In fact, my first form, which is the main form, contains 2 group options with a command button. The user click select which renewal he wants, in this case, let's say he selects...

Hi all, I was wondering how to make my form look for other tables as well. Actually the form uses one table, but I want it to use 2 other tables, making it 3 tables in total. Here's my code: Public Sub Fusion_Click() Dim Sql As String Dim pathFichierWord As String Dim rs As...

DCrake, I added a revamped version of the database and added the missing fields. For the merge, you need to create 2 folders, In and Out. Put the word template in the In folder. Now you can run the code without any other compile error (I hope so).

DCrake, I'm trying to add the code from merge3x form into frmCriteria2. As it was not working, I thought it was better to call this code from a module (mdTransfer) If you run frmCriteria2, it will work, except when we come to the module function. There is no compile error that happens, but...

True, I had to suppress sensitive information, that's why. You can add something else and it will work.

Trevor, The query you quoted, normally it loops through records from the Assurvar1 table and select those with the date criteria, which is records in the past 30 days. What it does next is putting these records in a temp table (Tb_1stRenewalTMP). From there, the code that is in the second form...

Trevor G / DCrake, I added a sample Word template at the top of the post. It can help with the merge.

Hi Trevor, Adding the Fields to the rs or not, they work because they refer to bookmarks fields in Word. But the main problem is how to run the code from the module. You may look in the mdTransfer and notice that I took most of the code from merge 3x and put it there, then placed a Call...

The db is attached. Look at the top of the post.