Search results

Yes. I was saying is it better that I set my subform parent/child link to show the data after a combobox is chose. Or using vba, to just filter the data in the subform base on the combobkx. I know the difference is when you add data to the subform. Using parent/child link, when you add new...

Hi, I have a subform on my main form, and I am wondering which one will be better to work in multi user way. By using a parent/child link to load the subform data from a combobox, or by filtering the data base on the combobox? Which one is faster? Thanks

Thanks for your help! I get more where I should go with this. That really gives me a clear way of dealing with the structure of it. Very appreciated! I just started the project, so there is no data to move. I will work base on your sample and modified it to adapt to my requirement. Thanks...

The product type, recipient, etc are prefilled by me. There is no addition to the data by the user. Yes, they choose the recipient, language, and the beneficiary then generate a letter. The option are the "autotext" that is already built in the Word building blocks. So by selecting the autotext...

Thanks for your taking your time to help me out with this issue. What I am trying to accomplish is to cascade the [Options] depending on the Product that the beneficiary has. It's kinda a go by elimination of choices for the user to choose before they can generate a letter. Because there are...

Hi, I have cleanup all the useless data, and here is the database with the issue. Steps: If you select recipient, Spouse Then you select English It will populate 2 rows of data in the "Option" listbox. If you select the first rows of Beneficiary, which is "RRSP", the Option listbox...

I was able to add the autotext, but how can I add multiple autotext 1 after the other? Dim objWord As Word.Application Dim docWord As Word.Document Dim WordHeaderFooter As HeaderFooter Set objWord = CreateObject("Word.Application") objWord.Visible = True Set docWord =...

Here is what I come so far, but it doesnt work: Dim objWord As Word.Application Dim doc As Word.Document Set objWord = CreateObject("Word.Application") objWord.Visible = True Set doc = objWord.Documents.Open("C:\Users\yygh98\Desktop\TEMPLATE.dot") With objWord.selection...

Thanks for the link, but I want the WORD document to open up itself base on my template, and add the autotext without the user having to go in WORD and starts adding themself. Thanks for the link anyways. ;)

Hi, I just wonder if anyone can provided any information on creating a new word and insert autotext from a template (usually: Normal.dot) I have looked many sites online, and it mainly explain the code to use within the word document macro, but not from Access VBA. A help will be...

Because it's possible for not choose anything in the listbox, so I still want to load the data after choosing the combobox. I added this code: If strProdCSV = "" Then lngLen = Len(strRS) - 4 strRS = Left$(strRS, lngLen) Debug.Print "strRS = " & strRS Else 'remove trailing comma...

I tried but it doesnt work. How is the final query should look like by using the IN? Thanks

Not quite sure how they going to repeat the strRS if i remove it from the loop?

Hi, Can anyone take a look and guide me where is my mistake? Dim strRS As String Dim lngLen As Long Dim varItem As Variant Dim strProd As String strRS = "SELECT text_en, text_desc FROM qLetter WHERE" If Not IsNull(Me.cboRecipient) Then strRS = strRS & " recipient_id...

To replace all those textbox, I would need 3 differents query, so 3 new subform on that main form. I can make looks like it embed inside the main form, that's not an issue. I care more about the performance. I was able to also make 1 query to have all the data, but that will be a query that...

Right now, I have about 16 textbox witha Dlookup in it. The issue with creating the query is that I can never come to 1 query that can query all the information as they come from multiple table. Is it fine if I use multiple query, then multiple subform in the main form? Will that be any faster...

Hi, On the main form, I add a bunch of Dlookup textbox to query all the amount, quantity of product of a client. Somtimes, it takes time to load all the information, I was wondering if by creating a query and insert that query straight on the form will be any faster? Thanks

Oh aha, text. I think I got why its not working. The user does not have writing access to the backend where the tblConnect is stored. Thats why it cannot write to the table.

The path is linked to the LAN server starting \\... So not personal drive. However you made a super good point for the writing access to that LAN. I will double check that and confirm back. That employee is on vacation until nx week. Thanks

The NetworkUsername is a string.