Search results

I have used the great code from MajP FAYT on a few forms and some work perfectly and a few have an issue. I read the post Populating Combobox with a lot of data and the link in there. The issues I am experiencing are When I refresh the underlying table (I click a button on my form and it...

It is "usually" on the 7th and 8th lines. It is supposed to be on the same row as the date and the one after, but of course, sometimes people manage to mess that up too.

MajP, thanks again. As you surmised, I am using access as a tool to take out some of the drudgery and apply some automation (rather than do it the way my department assumes doing it which is completely manual/hands on) to my work so it is not really being used as a database in the traditional...

Appreciate that comment. I took your suggestion and found this at the Microsoft site. Since all I need is not to display the revisions, I commented out the other statement I had in my code. 'https://docs.microsoft.com/en-us/office/vba/api/word.document.trackrevisions worddoc.ShowRevisions =...

Pat and Doc Man, thanks for replying. Had hoped my brief explanation would have sufficed to avoid the natural suggestions you provided. Our dept gave up trying to get people to comply after all the negativity and push back from many people at a higher level. Initially, our policy was to kick...

Maybe AutoHotkey?

I've seen a few discussions about interacting with Word documents from Access and thought I would post a few questions regarding some items that aren't functioning very well. Background: A set of word documents were developed to be used as templates (starting point as they aren't real...

This won't address the continuous form issue. Here is a method of flashing text without using a timer that I have on one of my forms. It does a quick flash that is noticeable. If InStr(Me.txtExcelName, "V&V") = 0 Then For i = 1 To 10 Me.lblNoteVV.Visible = True...

Could you have two forms one sized only to display the headers and the other form above that and set to not display the headers? Or might have to try a continuous form with text boxes rather than a datasheet and use the footer rather than the header?

Here is some code to unbold text in a cell of a word table. The Sub has the optional paramater BoldCell which will change it to bold rather than unbold by adding TRUE at the end of the parameter list. Since I use it mainly to unbold, you may need to further modify it to do the opposite. I...

Not ideal, however, maybe create a blank query, size it the way you want and save it. Give it a generic name such as qryBlank. Then when you want to create a new query, copy that query and it should open up the way you previously saved it. If you are sure you can remember to do a save as...

Putting this out for our next meeting this coming Friday in a new thread rather than in the original thread. Pre pandemic we had in person meetings at the Microsoft Offices in Mountain View, California. Since then, we have begun using zoom. We would like to invite a few people from this...

morsy_soliman I copied and pasted code to the forum, as an example, so may have left in some bits that aren't relevant. Let's see about more specifics for your situation. 1. Remove MergeRFI = "" as you don't need that. 2a. Dim them all as string Dim stMergeFiles as String Dim PDFName1 as...

Since you mentioned the free toolkit, would like to check whether you installed the PDFtk Free (Graphical tool) or PDFtk Server which is also free. The code works with the PDFtk Server. If you are using the Server version then, did you use the code I provided and where is the error...

If you have spaces in the file name, you may need surround the full path filename and extension with quotes. Also, you should add string to the other variables. Dim strPath as String, strFName as String, strRptName As String

Hi Pat, I would have sent a link to you, but as far as I can tell, I didn't receive a private message request. Hope it will work out for next month. Our meetings are on the 2nd Friday of the month. Now that I know you are interested, I can send you a link near the time of our next meeting.

Pre pandemic we had in person meetings at the Microsoft Offices in Mountain View, California. Since then, we have begun using zoom. We would like to invite a few people from this great/useful forum site to our next monthly Access user group meeting via zoom this coming Friday. For now, we...

I think that is the point, he is only wanting to show the back button when the other form is visible. (covering up form A)

Could you add a debug.print .htmlbody after the last html body statement and view in the debug window. Or alternatively put a breakpoint after the last .htmlbody and do a ? .htmlbody in the immediate window and see what is displayed?

Is this of any use? https://docs.microsoft.com/en-us/office/vba/access/concepts/miscellaneous/detect-user-idle-time-or-inactivity