Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sxschech

    Printer.Print to PDF

    I've done printing to PDF using VBA in MS-Access, if the code is compatible to regular Visual Basic, I can try to locate it when I get back to the office. You will need to pass in the filename and pathlocation where to save it as a variable or hard code.
  2. sxschech

    switch between two open database

    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...
  3. sxschech

    Retain signature in Outlook

    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...
  4. sxschech

    Force Data Entry Format in Excel

    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.
  5. sxschech

    Run PowerShell Commands from Excel VBA

    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...
  6. sxschech

    Spam Messages

    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...
  7. sxschech

    For Each Loop works once then gives error 91

    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.
  8. sxschech

    For Each Loop works once then gives error 91

    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...
  9. sxschech

    For Each Loop works once then gives error 91

    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.
  10. sxschech

    For Each Loop works once then gives error 91

    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...
  11. sxschech

    For Each Loop works once then gives error 91

    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...
  12. sxschech

    For Each Loop works once then gives error 91

    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...
  13. sxschech

    Programmatically send email using only OWA

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

    vbscript to read properties of JPEG file

    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...
  15. sxschech

    error 3027 database or object is read-only

    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?
  16. sxschech

    Pie Chart with linked updatable data table formatting

    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.
  17. sxschech

    Pie Chart with linked updatable data table formatting

    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?
  18. sxschech

    Pie Chart with linked updatable data table formatting

    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...
  19. sxschech

    Pie Chart with linked updatable data table formatting

    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...
  20. sxschech

    Pie Chart with linked updatable data table formatting

    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...

Part and Inventory Search

Back
Top