Search results for query: *

Thanks Duane. I'll see what I can do with it. Gave me some ideas I had earlier. See Ya . . . Be sure to see FAQ219-2884 Worthy Reading! [thumbsup2] Also FAQ181-2886 Worthy Reading! [thumbsup2]

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

OK strongm ... Looks good. I'll probably tickle minimize/maximize and store the values on open of the workbook. Much appreciated! See Ya . . . Be sure to see FAQ219-2884 Worthy Reading! [thumbsup2] Also FAQ181-2886 Worthy Reading! [thumbsup2]

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

How are ya nikademous, Consider a popup form linked to the table or with a Listbox linked to the table ... Your Thoughts? ... See Ya . . . Be sure to see FAQ219-2884 Worthy Reading! [thumbsup2] Also FAQ181-2886 Worthy Reading! [thumbsup2]

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

strongm ... Thanks for the critique. It was worthwhile and put another method I wasn't aware of at my disposal. All in all and especially for a single value, the registry method fits the problem directly and with minimum code. For a greater number of passed values, I'd probably use the .run...

strongm ... I did say "as far as I know". I would love to see an example. See Ya . . . Be sure to see FAQ219-2884 Worthy Reading! [thumbsup2] Also FAQ181-2886 Worthy Reading! [thumbsup2]

strongm . . . The registry is common between Access and Excel. Their Custom property Stores are not. At least as far as I know. In this case passing the variable thru the registry simply made it all easy ... and done quickly. I have yet to imagine how I would pass a variable using custom...

How are ya strongm, There's no point in custom properties in the execution of passing a value from an external application. However, custom properties have been crucial in many of my designs. Your Thoughts ... See Ya . . . Be sure to see FAQ219-2884 Worthy Reading! [thumbsup2] Also...

OK ... @Skip: I wound up spending a little too much time getting the table to work, so I went with the registry commands suggested by combo. @combo: Your suggestion was spot on. Simplicity in motion. Take care guys ... See Ya . . . Be sure to see FAQ219-2884 Worthy Reading! [thumbsup2] Also...

Howdy Combo ... You hit the nail on the head. Will check it out and ge back to you. Your Thoughts ... See Ya . . . Be sure to see FAQ219-2884 Worthy Reading! [thumbsup2] Also FAQ181-2886 Worthy Reading! [thumbsup2]

To be clear, I'm talking a public variable and function in an Access module and running that function from Excel. Your Thoughts ... See Ya . . . Be sure to see FAQ219-2884 Worthy Reading! [thumbsup2] Also FAQ181-2886 Worthy Reading! [thumbsup2]

Good mourning Skip. I first tried my original idea with environment variables but quickly realized we're talking two separate environments (one for each process ... Access/Excel), so can't connect. The above brought to mind Public Variables, which are set in the declaration section of a...

Hi Skip. Ahhh ... my post finds you well. I retired in 2015 and enjoying it. A table seems to be a good idea however, I'm just passing a single boolean value. I'll give the table a shot tomorrow and let you know the results. Your Thoughts ... and honors to be in the company of old friends...

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

Andrzejek, DrB0b, Thank you for your responses. I was already looking into KVM Extenders. They'll do the job (quite easily), but are on the expensive side. My query was for other means or methods not having a hard impact on the wallet. Control by remote applications like TeamViewer (suggested...

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]

How are ya macropod ... I've been deriving formulas all weekend and got mentally tired out. Don't believe I danced all around it. Yhanks for the post. See Ya . . . Be sure to see FAQ219-2884 Worthy Reading! [thumbsup2] Also FAQ181-2886 Worthy Reading! [thumbsup2]

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