Search results for query: *

Creating a query with a calculated field and then basing the form on the query worked great. Leaving the answer here in case someone else needs it in the future.

I think I got it!!! The control source for the form was a table. I created a query, added the table and made a calculate field (GROUP BY "Title", Count of "Multivalue LookupField". I'm testing now and will let you know if it works. I hate multivalue fields...

I have a form containing a combo box. The control source is a SELECT statement, grabbing values from a table field called Users. The combo box works well. The combo box is a multivalue lookup field. It has check boxes next to each value. Checking the boxes for different user names, puts...

Can't do that. Is there no way to have macros in a file other than PERSONAL.XLSB? What about as an add-in (.XLAM)?

I I have created other macros for personal use and saves them there so they are available in all my workbooks.

We currently have a .DOTM file in %programfiles(x86)%\Microsoft Office\Office14\STARTUP. When users open Word, the .DOTM file opens in the background and the macros are available when user hits Alt+F8. The .DOTM opens "protected" in a way users cannot edit any of the macros in it. I want to...

I searched the forum, but didn't find information related to my question... :( Is there a way to configure the room finder so that it will enforce a 30 minute buffer between meetings? For example, let's say Room A has a meeting from 9:00 am to 10:00 am. If I want to reserve Room A from 10:00...

Hello. I apologize in advance for the question if it's a stupid one. We have an add-in called Mimecast. This add-in has a "Report Spam" button. It reports spam to the Mimecast people and moves the email to the Outlook Junk Email folder. All emails are archived in Mimecast permanently. We...

In thread707-1691129, you guys helped me find a portion of the footer (document number containing version number) and replace just the version number to the next number (increment), which worked fine until recently when we got the ability to delete versions. So now, a document can have multiple...

How to monitor system resources and prevent a crash? Let's say I want to monitor Winword.exe and if it consumes too much memory (random number of RAM, chosen by me), I want to save the document and alert the user Word will be closing in 30 seconds, then actually force Word to close. Is this...

We have upgraded up to 5.3.1 Patch 4 RU1. Question remains. If you are experiencing issues, I would like to exchange ideas.

Anyone using OpenText eDOCS 5.3.1 Patches 1 - 4? We are using 5.3.1 Patch 1 and are experiencing weird issues. I would like to pow wow with other OpenText users.

How to determine the last time a mailbox sent/received email. I have a list of mailboxes. I need to determine if they are still in use. No one seems to know the answer. I'm thinking that the modified date tells me the last time that mailbox has sent or received email. Correct? If I"m...

I have very little kowledge of Sharepoint and for what I've read, documents can be tagged, then found when creating a view that pulls the documents by their metadata. That, to me, is the easiest way to later on, find a document. I have also been reading about workflows and how to automate the...

Hello. I've read may of the threads about finding/replacing text in footers and have found bits and pieces of what I want to do, but can't ut it all together. Would you please help? I want to find a word in all fotoers of the document (first page footer, Footer, Even Footer, Odd Footer...

Thank you! After a few edits, I was able to do what I need to do.

Hello. I have a question and not much time to come up with an answer. we have a login script which extracts the name of the default printer for the logged on user. It comes out as \\computer name\printer name. Every time user logs on, a .txt file is created with that user's default printer...

My batch file: set file=C:\Publication1.png start %SystemRoot%\System32\rundll32.exe "%ProgramFiles%\Windows Photo Viewer\PhotoViewer.dll", ImageView_Fullscreen %file% timeout 25 taskkill /F /im Rundll32.exe timeout 30 %SystemRoot%\explorer.exe "C:\Boo" exit whic I have saved to the guest...

Yay Andrzejek! Thank you so much for the filtering syntax! I put your code in the Generate button and was able to filter the listbox and find the record. With a little digging here and there, I figured out how to insert the value of fields (LastName) in the document. Public Sub...

...Source=C:\Users\Me\My Documents\Users\TemplateFiller.accdb;Persist Security Info=False" strSQL = "SELECT * FROM tblUsers" rs.Open strSQL, cn, adOpenForwardOnly, adLockReadOnly ' populate the list box Do While Not rs.EOF lstUsers.AddItem rs!FullName...