Search results for query: *

This video demonstrates how to use a button to switch between access files using Follow Hyperlink. In the video, he is using a switchboard (3 files rather than 2). Since you want to go directly between the two rather than a switchboard, I tried putting a button "Switch to A" in the Second...

Is the signature an outlook signature or a third party/add-in signature such as templafy? If an add-in sometimes even with html, it gets wiped out. For standard signature can also try this code. Function GetBoiler(ByVal sFile As String) As String 'Dick Kusleika...

What about another approach of having three entry fields and then use vba code or excel concatenate functions to combine and output the data. That way don't have to build a lot of logic to identify whether they used a slash or not.

If you prefer not to set a reference as shown in the screen shot from Andy, the alternative is late binding. Public Sub Rename() Dim fn As String Dim RegExp AS Object Set regExp = CreateObject("vbscript.regexp") 'Does not require a reference to Microsoft vbScript Regular...

I got three similar messages over the weekend and since I have a desktop without a camera and don't go to the kind of sites mentioned, knew it was fake and glad this thread confirms it. Before I switched to a desktop mail client when I used to use the web browser for outlook, there was an...

strongm, sorry for the oversight, you are correct. <smiley>ashamed icon</smiley> I think due to the additional discussions and examples, it didn't register that you provided the original solution. Hopefully it is rectified by the star. If not, please advise.

Contributing a new line of code before the refresh since I figured out how to adjust the range of the pivot table due to the latest refresh having less rows than the template and that caused the chart to display a literal blank. This is a hard coded statement per the comments, so it would need...

Looks like my screen refreshed whilst I was clicking on the post, meant to star Andy's post from 29 Aug 23 14:53 rather than 29 Aug 23 18:18 which must have come in while preparing and reviewing my reply.

Wow, great discussion. Thanks for the input. Andy, looks like your last post sorted it out. After adding objapp. before ActiveWorkbook, I was able to run the code multiple times without the error. I did a search [CTRL+F] for Current Project and that was the only spot where ActivWorkbook...

combo, first time through: Debug.Print ActiveWorkbook.Name displays: SubmittalsOverdueDataLeadChart_Template.xlsx Debug.Print ActiveWorkbook.PivotCaches.Count displays: 1 second time error 91 when it gets to the debug statement Case "Submittal Data" .Cells(2...

Upfront, letting you know I might not have explained well or need to provide more code for context... This question is using MS-Access to run vba to modify an excel sheet. Found this code to refresh data in pivot at https://www.automateexcel.com/vba/refresh-pivot-tables/ It seems to work fine...

Are you able to use CDO to send emails directly from Access without using Outlook? https://isladogs.co.uk/email-tester/index.html

I recall reading something about metadata in another access forum, haven't looked at it in detail or tried it so not sure if adaptable to vb script, maybe could help? Colin's web address changed so included a link to his site. https://www.accessforums.net/showthread.php?t=84076...

Is the file in a trusted location (Trust Center Settings)? Is it only the files that were copied or is there an issue with new files too?

Tried that, no luck. I did see that it changed the title in the values section, but once I hit refresh, then the original title goes away the chart goes blank and then when I click on the field, chart reappears without any data labels.

Thanks for confirmation. One would be nice, but at least two boxes is much better than dealing with 8 individual boxes. Any thoughts on how I can change the header text of the table in cells C2 and D2 without losing the data labels on the pie chart?

Thanks again combo for your formula suggestion with if and "" to avoid conditional formatting and for checking to see if there was a pivot table. I added two formula cells one for the text and the other for the numbers with concatenation and then placed two textboxes within the chart and so far...

To answer your question (yes and no), yes in original file and apparently not in file I modified, see below for discovery. Ok, I copied a previous file and was able to modify with generic data, attached. I had thought the pivot chart is not based on a pivot table for two reasons: 1) I...

The if statement looks like a simple solution... Unfortunately, things have not gone well and I am probably going to give up. I thought I had things under control, but not really. I can't believe how much time and effort I've been putting in and trying to get things right. I am unable to...

Since combo has confirmed that to use conditional formatting, the camera tool is what is called for. My reason for using conditional formatting is due to them wanting to show a midweek update and based on that the logic would be if <quote>today</quote> is between Monday and Wednesday, hide the...