Search results

I use Inno myself, but it's a bit of a learning curve. It's very capable but tricky to get nailed down exactly as you want. For one of the applications we use it on we support Access 2010-2019 on Win7-10, 32 and 64bit and have the installer handling everything except the bitness (we have to...

Feel free to reach out. Even with the best intentions/skills/personalities, it's still hard to find a good all around fit, so ideally a few candidates... Thanks

Mostly because I'm not sure who is interested and not, so this way it's not a bother to them if I ask: they can reach out if they are. And, there's likely twice as many that could do it than those members I'm aware of. (hopefully this isn't frowned upon - I didn't see a board or thread...

Table would work also. I'm used to text files working with other systems and storing things in git, so that's what came to mind first, but either or. A local table is self-contained so probably better here. Regarding the index, IIRC the Properties are just a collection, and items in the...

I'm not sure of any easy way offhand (easy as in clicking a checkbox during the import process like you would for Import/Export specs, I mean). What I'd probably do in this situation is keep a text file in the development folder that contains a list of properties and their default values (just...

Hi all - I'm looking to hire an Access/VBA developer on a contract basis to help out with some projects. Anyone around here particularly good at this stuff and looking for some paid work? Should know classes, custom events, Win API work, web services, recursion, how to use a scalpel to cleanly...

Sure, it's very common.

I wasn't involved in the initial thread here, but use SQL Database (aka, Azure SQL Server hosting) with Access FEs often. Have done it with AWS as well, and some other lesser-known hosts. No major issues, just be careful of performance when you're writing the FE. I personally prefer Azure for...

That was a good one.

I'm not sure of how to display Excel graphs "live" in Access. Access charting is sub-par, although recent version(s?) do have some improvements. I think the generally accepted technique is to grab the instance of Excel via automation, get the excel chart object programmatically, snapshot it as...

I suspect jdraw's link will cover it, but as an FYI, there is a Google API that takes a street address and turns it into lat/lng coords (and vice-versa). Geocoding/reverse-geocoding is the term, I think.

Hi - can you show us the query/expressions you were trying to use? Can't quite figure out with the info you gave. Cheers,

No prob. Now that you're fixed, a few additional thoughts. I usually prefer to use parentheses to make it a bit more readable, and line breaks perhaps. Not strictly required, but reading it later makes it more clear what's going on: If (UnitType = "ASDF") _ OR (UnitType = "CVBN") _...

I've generally found Conditional Formatting to be slow, especially based on heavily calculated fields (usually some flicker/delay in rendering the format, especially noticeable when scrolling). That said, I've not noticed it to be any worse when applying them via VBA instead of through the UI...

Break out each OR into a full expression: If Unit_Type = "ASDF" OR Unit_Type = "QWERT" OR Unit_Type = "ZXCV" Then Tedious, but required. hth

I took a look for VB6 SDK support/examples for Intuit and was not able to find anything helpful (or even confirmation that it's supported). Regarding walking through the .NET COM approach, it's a bit involved to walk through via forum. All of my references on the subject are currently not...

For me, ADO is preferred for things like this (checking if the server is reachable, initially validating users), typically on startup because once you make a DAO connection, a lot of those DAO connection parameters are cached by Access and not able to be cleared without resetting the Access app...

It should not present any specific problems. There's no reason macros and code can't intermix within an Access project.

>> 32bit << That was going to be my guess. Usually a broken Active X would mean that either a) the library was removed from the system (not likely in the case of the MSXML parser), or when you migrated you went to 64bit, which needs different libraries.

Hi Jon - if possible via settings somewhere, would you consider making it so users need not be signed in to view attachments? For example, I'm looking at this thread: http://themindtavern.com/community/index.php?threads/share-your-knowledge-tree.14/ and wanted to open the image to see what...