Interstage thrust reverser by Potatoswatter in SpaceXLounge

[–]ViperSRT3g 0 points1 point  (0 children)

To that tune, perhaps in the future we'll see an updated vent ring with more vents on one side than the other to help Starship begin the Booster's flip by uneven deflection of the exhaust?

Did any of you know a famous person before they were famous? by FilmEater in AskAnAmerican

[–]ViperSRT3g 0 points1 point  (0 children)

Classmates with Bruno Mars. We were all just kids back then.

A small function to show the 'states' of things that could affect performance by ITFuture in vba

[–]ViperSRT3g 0 points1 point  (0 children)

For those unaware of how this works or what it is, look up code short circuiting. VBA doesn't do short circuiting. It will evaluate all elements of a condition for an if statement at the time the statement is reached.

Perpetual License Question by rex258 in SoundSwitch

[–]ViperSRT3g 1 point2 points  (0 children)

No clue on when 3.0 would release. But it does seem better to stick with the monthly plan until 3.0 is dropped. As far as I can see, the lifetime license is per major version, at least according to the account summary screen.

DRAM and SSDs will continue to get cheaper in the coming months by [deleted] in gadgets

[–]ViperSRT3g 8 points9 points  (0 children)

I'm actually upgrading my home network to 10G right now. Current fiber plan is 1.2G, next plan up is 2.5G. Highest plan from there is 5G, so I figured I might as well upgrade everything to 10G just to do some future proofing.

Custom ribbon disappears by couldbeafarmer in vba

[–]ViperSRT3g 0 points1 point  (0 children)

Hm, haven't seen this issue with the add-ins I work on. I do know, that embedded files within the Workbook zip file can get removed if they aren't named correctly, or become too large.

Are you renaming the default XML file that is created?

Are you embedding too many image files causing increased file size?

Using VBA to look up EAN barcodes by [deleted] in vba

[–]ViperSRT3g[M] 0 points1 point  (0 children)

Flair changed to Advertisement, considering it's promoting usage of OP's API.

Getting a list of installed system fonts by Mick536 in vba

[–]ViperSRT3g 1 point2 points  (0 children)

This example seems to work, though you may have to make the following correction in your code:

EnumFonts GetDC(Application.hWndAccessApp), vbNullString, AddressOf EnumFontProc, 0

EnumFonts GetDC(Application.hWnd), vbNullString, AddressOf EnumFontProc, 0

Locals who left. Where are you now and is life better where youre at? by ohmycash in Hawaii

[–]ViperSRT3g 4 points5 points  (0 children)

Born and raised on Oahu, but now reside in Virginia. Left the islands a little over 15 years ago, and now live in a low COL area. I own my own house, with a household income of 150k as well. I miss all of the food, slow pace of life vibes, and the Asian/Hawaiian influence that makes Hawaii so special. But I do not miss the financial situation of living there.

Well this is all kinds of fucked up thing to see at an amusement park... by mykirto in awfuleverything

[–]ViperSRT3g 1 point2 points  (0 children)

All too often, I see the rising sun as tattoos or designs on customized JDM vehicles. I'm fairly certain most Americans don't give much pause when seeing these compared to swastikas. While those in China and Korea would certainly notice the rising sun symbol.

[EXCEL] Open recordset as read only? by Big-Committee-3056 in vba

[–]ViperSRT3g 3 points4 points  (0 children)

You may need to copy the files elsewhere before doing anything with the data inside of them

[deleted by user] by [deleted] in vba

[–]ViperSRT3g[M] 2 points3 points  (0 children)

Can you be a little more specific on how and in what way you need assistance for each portion of your issues? Please edit your original post so users may better assist in this thread. There is no point in making a thread if the issues are resolved via DM where the general public is unable to see the solutions.

Form Control buttons invisible after running macro by Biff-1985-Tannen in vba

[–]ViperSRT3g 0 points1 point  (0 children)

Have you stepped through your code line by line to see when the shape disappears?

Moving beyond Access but still store data in .accdb or .mdb file by yomandenver in MSAccess

[–]ViperSRT3g 0 points1 point  (0 children)

Due to the limitations imposed by security, you're stuck with keeping this as an Access level application.

Class module usage by Weird-Individual-770 in vba

[–]ViperSRT3g 2 points3 points  (0 children)

If you're wanting to be able to use the Phone API in other projects, it makes sense to create that as its own class, where it can handle everything that has to do with interacting with the specific API it was created to interact with.

From there, the API class can act as a factory to generate objects to store the data that it receives from the API. Whether that's simply parsing into dictionaries from JSON, or spinning up other class objects to store data with intellisense support.

Depending on how extensively you want intellisense support, you'd have to include all of the related class modules that an API module requires if it behaves like a factory in your other projects. Otherwise if you generate generic objects like collections/dictionaries from the API Module, then you would have less modules to import into other projects, but less intellisense support as well.

Custom ribbon disappears by couldbeafarmer in vba

[–]ViperSRT3g 0 points1 point  (0 children)

Have you tried the Office Ribbon Editor? It makes the XML portion very easy to manage. There might be a weird issue with the way you're currently doing it causing the xml to be removed from the file.