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!

  • 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: *

  • Users: TheAceMan1
  • Content: Threads
  • Order by date
  1. TheAceMan1

    Delete from listi n XL open tab with VBA

    Howdy All Win 11, XL 365 When I open XL from the programs menu and click the "Open" tab, I get a list of previously opened XL files. This list needs to be updated if any files have been moved or deleted. The user interface allows removing files from the listing. I want to do the same...
  2. TheAceMan1

    Detect if Ribbon Minimized or Maximized

    Howdy All, I can minimize the ribbon (win11) with the following: CommandBars.ExecuteMso "MinimizeRibbon" The problem is successive executions of the code simply toggle the ribbon. Currently looking for code that reveals wether the ribbon is minimized or not. Any suggestions? See...
  3. TheAceMan1

    WiFi Over Long Distances

    Howdy All, The ministry of my church asked if I could help with a scheme to set up wifi for the church. My first thoughts were of the size of the church, somewhere around 27000 sq/ft (it's an old converted theater and the walls are thick!). Then there's the Sanctuary, 9 Minister Offices, and 4...
  4. TheAceMan1

    Pass a Value from Access to Excel

    Howdy All, Office 2003 Need to pass a value from Access to Excel (VBA preferred). The value tells excel which files in 1 of 2 folders to process. I had the idea of a custom environment variable but would perfer a more up to date method. In this scenario Access opens an Excel file that does...
  5. TheAceMan1

    Long Distance PowerPoint Remote Control

    Howdy All ... Projecting PowerPoint onto the front of a theatre screen from the back of the theatre. Is it possible to remotely control the mouse from the front stage? See Ya . . . Be sure to see FAQ219-2884 Worthy Reading! [thumbsup2] Also FAQ181-2886 Worthy Reading! [thumbsup2]
  6. TheAceMan1

    Howdy All ... Looking for a form

    Howdy All ... Looking for a formula (or VBA routine) to calculate proportional payments of a bill, by two people, according to income. Any help appreciated in advance. Your Thoughts? ... See Ya . . . Be sure to see FAQ219-2884 Worthy Reading! [thumbsup2] Also FAQ181-2886 Worthy Reading...
  7. TheAceMan1

    Appearance of 3rd Program Files Folder

    Howdy all, Win10, MSI Laptop I've noticed a 3rd new Program File folder, only its in Spanish Arquivos de Programas. The folder was not created by me nor would I install any apps in Spanish (I'm English speaking). The folder is owned by the system and can't be changed. I'd like to take...
  8. TheAceMan1

    Change storage locations of windows files.

    Howdy all, Looking to change the storage locations of win10 update and/or restore point files. The machine in question is an MSI gaming computer with near inadequate storage space on the C: drive. I expect another year or two of use will cramp the C: a little too much. There's a huge terabyte...
  9. TheAceMan1

    Wi-Fi 2 Status Dialog in Win 10

    Howdy All ... Would like to set a shortcut to the Wi-Fi 2 status Dialog. Any Ideas? Your Thoughts? . . . See Ya . . . Be sure to see FAQ219-2884 Worthy Reading! [thumbsup2] Also FAQ181-2886 Worthy Reading! [thumbsup2]
  10. TheAceMan1

    Change Default Screen Position for Windows Explorer in Vista

    Howdy All ... Searching for several days (on & off) results in no usable answers. No registry hacks ... nothing that works. So it appears this one can't be done. Can anyone zero in on this? Any help is fully appreciated. Your Thoughts! ... See Ya . . . Be sure to see FAQ219-2884 Worthy...
  11. TheAceMan1

    Setting Interior Color Wipes Out Cell Borders

    Howdy All ... Excel 2010 While troubleshooting a workbook I ran across an instance of a cells backcolor being changed from light red to white. During a break point I couldn't help but notice that the change removed the borders! ... I didn't notice it eariler because I format the borders...
  12. TheAceMan1

    Info On Excel 2010 New "Spark Lines" (In Cell Charts)

    Howdy All! Excel 2010 came with some pretty cool incell graphics called spark lines. Googling 'excel spark lines" I've found out that they are not objects in the cells where they reside. My problem (in my mind), is that I have code that repeatedly constructs the sparks (users change data...
  13. TheAceMan1

    Remove earlier of two versions of Adobe Shockwave Player.

    Howdy All! ... Have two versions (12.0 & 12.1) of Adobe Shockwave Player that show up in control panel. How do I get rid of the former version without harming the latter? ... or is this even necessary? Suggestions fully appreciated ... See Ya . . . Be sure to see FAQ219-2884 Worthy Reading...
  14. TheAceMan1

    Same IP Address ... Different Web Sites ... How?

    Howdy All ... Co-worker came to me with a problem of not getting our companies web page, but the page of another company with the same name! This is not suppose to be possible. That name is Sanrex ... aka sanrex.com. Our company deals in high powered equipment, the other in hand tools. I saw...
  15. TheAceMan1

    Access Posts a Message Before I Do!

    Howdy All ... In 2003, performing some validation on a date textbox control with the following code: Private Sub vacDate_BeforeUpdate(Cancel As Integer) If Not IsDate(Me.vacDate) Then Cancel = True Msg = "An UnRecognized Date has been entered!@" & DL & _...
  16. TheAceMan1

    Icons AutoArrange on Every Boot ...

    Howdy all ... Yes ... AutoArrange is unchecked! It started a few days agoand hasn't stopped since. If I scramble the icons then reboot or logoff then logon ... they autoarrange on the left side. The question I would like to know is where does vista store the desktop icon locations? ... I could...
  17. TheAceMan1

    Running the right If statement in column cell formula.

    Howdy All ... The machine in question has XL 2003 with Vista. What I need to do is execute one of two If statements (which work fine independently), depending on two input columns. Following is sample Data: G H I J K Yen US_Dollar Hrs Days YenTlt ----- --------- ---...
  18. TheAceMan1

    Getting Rid of Hardware Conflicts

    Howdy All . . . I hope I'm in the right forum for this. Statistics for the machine in use are as folows: Manufacturer: Hewlett Packard Compamy Model : m9340f Processor : Intel(R) Core(TM)2 Quad CPU Q6700 @ 2.66GHz 2.67GHz Memory (RAM): 6.00 GB System type : 64-bit...
  19. TheAceMan1

    IRQ Assignments

    Howdy All How can I get a list of IRQ assignments without parsing thru Device Manager? Your Thoughts? . . . See Ya! . . . . . . Be sure to see faq219-2884 Worthy Reading! [thumbsup2] Also faq181-2886 Worthy Reading! [thumbsup2]
  20. TheAceMan1

    RecordsetClone BOF stays True!

    Howdy All . . . The following is a function setup to repeat a problem that shows BOF stays true: Public Function qTest(ID As Long) As Boolean Dim rst As DAO.Recordset Set rst = Me.RecordsetClone Debug.Print ID & " StartBOF = " & rst.BOF; If Not rst.BOF Then...

Part and Inventory Search

Back
Top