Search results

I have certain levels of discretion that need to be maintained, but let's say that I highly doubt this is the case (I'd bet a fair sum on it). As it happens, recently on the other side of the pond a member has come in ranting and raving about all sorts of things that might get a person locked...

Not familiar with bullzip. I've done it with Acrobat before, but that requires an external installation, which is kind of blah. Been a number of years, but I used to "borrow" a DLL from Stephen Lebans for this, which can be plopped into the Access root dir and no need for any other...

I've never used it myself, but FMS has a reputation for having very solid and helpful tools. I would guess it as a reasonable purchase. Even for relatively small databases: it's not just code that it deals with, and - keeping tracking of things starting smaller makes it a much easier job when...

Where do you find a turtle with no legs? Right where you left it. One day an angel came down and stood in front of two bronze statues, male and female, nude and facing each other, and proceeded to explain: "you two have been such exemplary statues, here for so many years, without complaint...

You could use a web browser control and any one of the javascript/jquery libraries as well. Usually with the JS solutions you'd get the signature as an image in Base64 encoding which can either be saved directly to the DB or to disk.

Wayne Phillips can do that for you. I'm not sure he dresses up in a red suit though. http://www.everythingaccess.com/mdeconversion.asp Cheers

It might be part of IE's ridiculous MOTW "feature", which prevents certain actions if the file is served locally (why anyone thought this was a good idea, I'll never know): https://msdn.microsoft.com/en-ca/library/ms537628%28v=vs.85%29.aspx?f=255&MSPPError=-2147217396 After the DOCTYPE line...

Not aware of one offhand, but can you use two stacked images and set their Visible property accordingly? Not sure of any way to handle nice transitions in Access though. If you really wanted to could embed a web browser and use any one of hundreds of HTML/CSS ones, but that's a bit much. Cheers

I don't know for sure, but if someone put a gun to my head and told me to take my best guess, I'd say no, it's not possible to introduce a proprietary data file format for SQL Server. Databases are an extremely fine-tuned engine humming along with all parts in harmonic motion (think about it...

Earlier in the week I was archiving another year's worth of collected crap from my machine and came across this gem: 16 thousand lines of VBA7/64bit compatible API calls and all of their required types. I'm not sure which libraries it covers (skimming through I saw MIDI and menuitem, dde.h...

It's not always that easy. There's lots of ways for them to prevent access to it: SQL Server is pretty robust as far as security goes and if they want to, they can lock if down pretty hard. Besides which, you might find yourself in a fairly nasty legal battle for trying to do so if it's not...

Hi NG - only one that I'm aware of is Web Databases (replaced with now-defunct AWAs in 2013). For the most part, if your apps stick to the "normal stuff" you shouldn't have much issue (as far as core desktop changes from 2010 to 2016, there really isn't much: ADPs were deprecated at some point...

Personally, I wouldn't worry much about renaming. It's very risky and with legacy/crap projects, there's usually much bigger fish to fry (such as decoupling the code and refactoring things to make it more maintainable).

Use it alongside, no problem. They're just addins, there's no particular restriction on "can't have X and Y addin at the same time."

Joel's got a good article on this as well: https://www.joelonsoftware.com/2002/01/23/rub-a-dub-dub/ Not Access specific, but good general concepts all around. Probably worth a read prior to starting to change anything if you're not familiar with it. Another thing I've found to be helpful is...

I like this tool quite a bit as well. Slightly easier to use for the task than V-Tools, IME http://www.accessdependencychecker.com/

Not sure if he has anything for this specific scenario, but Chip Pearson has an amazing set of Array tools: http://www.cpearson.com/excel/vbaarrays.htm (epic - must have) http://www.cpearson.com/excel/SortingArrays.aspx http://www.cpearson.com/excel/SortingArraysOfObjects.htm hth

That's completely untrue. Please read my prior reply. Just because he has an ODBC driver does NOT mean he can connect. He needs to have appropriate permissions set up in the server, which is not always doable.

Are those other two computers using a wireless connection by chance, or accessing the backend over a WAN as opposed to a LAN? Is this an Access backend or are you connecting to SQL Server or some other database? Long running queries can throw Access into a non-responsive state, and - depending...

It's entirely up to the vendor and/or IT department that's hosting the server. Pretty much any database (SQL Server, PostgreSQL, MySQL/MariaDB, etc) can be configured to allow external connections. So, if you can talk whoever's in charge of the thing to allow you to connect to it, then yes...