Search results

Ranman Thank you - thinking way to much into it. I was all over the place.

Hello, I have this wonderful service oriented database and I want to include some statistical reporting. I have created a parameter qry that the user inserts the filter data on my form and the report generates. All of that is well and good. I attached a partial image where I have the report...

Brilliant Isaac! Thank you so much!

Hello, I am thumping my head looking at different methods of transferring data into my template file. This used to work perfectly prior to I believe it was moving from Access 2013 to 2016- so its been going on for sometime. I now have a subscription to 365 and am on semi-annual updates...

I could never get the northwind template to work either. Here is the code I use, good luck. I prefix the fax number with the word fax so it doesn't pop up in the address book as an available option. Private Sub cmdSaveToOutlook_Click() On Error GoTo Error_Handler Const olContactItem...

Hi, I am wondering if anyone knows if this is possible. A co-worker wants to be able to set a specific email address that will automatically insert attachments into the file folder on the server. We have a server onsite running windows active directory and use windows exchange for email...

I have a form called frmProposalDetails in which I can click a button and another form opens allowing me to pass the JobNumber on that form to another table called tblWOH. This allows us to add an approved job to be scheduled and so on. This has grown over time most recently adding send email...

Your right! thanks so much :banghead: Wrd.Selection.HomeKey wdStory sFindText = "TM" Wrd.Selection.Find.Execute sFindText Do Until Wrd.Selection.Find.Found = False Wrd.Selection.Range.HighlightColorIndex = wdYellow Wrd.Selection.MoveRight Wrd.Selection.Find.Execute Loop

Hello! I have the following code that sends info to a word document to create a label I would like the code to find and highlight text on the label. The first time I run the code it works fine. Any additional occurrences produces runtime error 462 breaking at Selection.HomeKey wdStory. I have...

This is how it is now really - USA so a little different. So, this is used in a commercial construction company and we would look at the entire building so I don't have to be concerned about apartment numbers. tblServiceAddresses is the table that my addresses are stored in with ServiceAddress...

Thank you all for your valuable input. After serious consideration I realize as my DB grows in functionality I will be hit with this limitation of the multi-value field. For now I will mark this as solved. Maybe this winter I will have more time to detangle this web and redo the address field...

CJ, for some reason the first time I ran it without the "" as suggested it worked. After that it went back to the same behavior. Static, your suggestion worked perfectly. I suppose its similar to order of operations? My dear aunt sally... Thank you both for your guidance!

This should be very simple and was working up until about a week ago. I have been searching all day for a resolution. I have unbound modal form that acts as my menu. It contains several buttons in which the user selects and another form opens. Simple right? For some reason all of the forms work...

Hi there, I was having some issues with modal forms in my DB. Certain users would go to open these forms and they would load then freeze and the whole program became unresponsive. For me I changed the form's properties Moveable: yes & Auto Center: yes. It cleared up my issues. I can't explain...

Yes, that is why I addressed it first "using a multi value field - I know, I know". It would be a mess to go back now. :banghead:

Hi CJ, thank you for your response. ServiceAddress is a multi select field and it combines the addresses with comma separators by itself. Is there any other way to manipulate it without split? I am not so concerned with typos causing an issue sometimes it does happen and I have to go back and...

Hi there, I am not sure if what I am attempting to do is even possible. Let me also preface this with: using a multi value field - I know, I know. When I started this DB it was a fabulous idea, now that the functionality has grown so much it makes it difficult. My field...

After researching the error message in further detail I was able to locate another thread to solve my problem. I really don't understand why it works however surrounding the link in # fixes the problem...

Happy Friday! I have been making minor improvements to my database and most recently I have added some code to make a file folder on the network with the click of a button. In order to take this procedure one step further I would like the code to then insert the hyperlink into the hyperlink...

Thank you Punice! "\" - this is what I was missing from the line. Here is the code I used in case it helps any one else. Private Sub cmdMakeFolder_Click() Dim strFolderPath As String, strNewFolder As String, CoName As String If IsNull([tblLookupCompany.Nickname]) Then CoName = [Company]...