Search results

None of this is very helpful. I still don't know how to modify my code to make it create 3 documents with different countries.

this is the query I'm using ID COUNTRY ECPNumber CRTitle 1 Colombia CR-033349,- INITIAL RELEASE 2 Japan CR-033349,- INITIAL RELEASE 3 Korea CR-033349,- INITIAL RELEASE The results I want is: 3 Word documents, one for each of the...

In case you don't have it, here is a link to an overview for Word and its object structure. You don't actually care about the article directly referenced in the link. You care about the tree-like index list to the left of that article, which lets you browse the various objects exposed by Word...

Hello, I need some help with this code. I am trying to export several word documents from a query. I can get the 3 documents out but the information keeps adding to the previous doc. The letters in orange are commented out because if I use them the code doesn't work at all, but I believe is...

Still need help on this. Anyone?

that is correct!

Hello everyone, The company decided to "upgrade" to windows 10/64 bit and now the below code gets stuck at the :confused: line. Can you help me? thank you! Option Compare Database Option Explicit Private Type WKSTA_USER_INFO_1 wkui1_username As LongPtr 'name of the user currently...

well, if I close the error message the form opens just fine and access is happy, is there a vba code I can add to tell it to just ignore the error and continue???

yes, the form I'm trying to open has this code, but I also have the same code for a different form and have no problems with it. Private Sub Form_Current() If Me.[CR Change Class] = "Major A Change" Then Me.[Major_A_CRs_Microplan_subform].Visible = True Else...

Please help! I need to release a new copy of my database and I'm getting this error: The expression On Current you entered as the event property setting produced the following error: cPIC can't find the field '|1' referred to your expression' referred to your expression. cPIC is the name of...

it doesn't hide the subform. that's what I'm trying to accomplish

Hello, I have a form with two subforms. I would like to hide one of the subforms when the field "CR Change Class" is Major A or B Change. This is what I got but it doesn't work Private Sub Form_AfterUpdate() If [CR Change Class] = "Major A Change" Then Me.[Major A CRs Microplan...

Hello I have a table with some old records that are not updated any longer but need to be included in a final report. Is it possible to add that table to my query of new records?? Thanks!

Thank you so much for your reply! I watched your videos and I'm doing something very similar to what you have. I have 3 option groups, one subform and a "clear filter" button with this code: Private Sub Clear_Click() Me.cboCIname = Null Me.grpChoice = Null Me.grpPsdDue = Null Me.grpWeeklyNotes...

Hello, I need help with a subform. I have filters and I can clear the filters but the subform stays on the last records that were filtered. How can I get the full list of records back? Thanks in advance!

Hello, I'm a little new to access, I've build a database with the help of a friend, but I'm sure he's tired of me asking questions and taking his time, so I thought this forum would be a good choice for me. Looking forward to sharing with everyone!