Recent content by GrandMasterTuck

For anybody that cares, I figured out a solution, based upon some of the helpful suggestions herein. What I did was to create a small Access app that uses a wait script to run a function every 60 minutes which makes a copy of the data from tableset 1 (the restricted one) and pastes the data...

Amazon allows for client whitelisting, just as Azure does, which was good for me because I could limit the direct access to the DB using a range of IP Addresses for each of the computers at the shop. Amazon's server management tools are nicely robust, and in fact are far more comprehensive than...

That's the cornerstone of the issue. There won't be anyone onsite that handles that. The app is specifically for low-level employees, and there won't be a server admin on site unless there's a specific server problem, or server maintenance going on (once a month, maybe), and I'm not going to...

One issue with the solutions presented: I will NOT be running this database myself, the USERS will be running it, and the application (fe) they open needs to be able to see the data. I understand that I could write a script that I can execute if I log in, but I won't be logging in or executing...

I have an MS Access 2010 database that is split, with the tables back-end on a network share. In another folder of the network share (a folder that nobody but me has access to) lies a second database for a different set of data unrelated to the first one. Is there a way that I can get a VIEW...

Hey NauticalGent, thanks for checking in with me. It's been running pretty smooth, actually, been using the system for the past several months without major issues. What I ended up doing was getting a SQL server through Amazon Web Services, which had the best pricing structure of all the...

Hi all. I thank you guys so much for always being willing to try and help with my ridiculously convoluted problems, and apologize in advance for the fact that this system is complicated in structure. Can't be helped at this stage. Anyway... I have a form (frmFleet) with a tab control on it...

No, I use TempVars to pass strings along to the INSTERT INTO statement assembler. This part is in the AfterUpdate of the PersonNotes field: SetTempVar "TheAudit" Expression: [IDBox] & " Set/Updated Person Notes: " & [Text45] & " on " & Date() & " at " & Time() RunCode AddAudit() Then the...

I have a field on a form that's hooked to a PersonNotes column in my table, which is set to MEMO instead of TEXT (so there's no character limit). The field has an AFTER UPDATE command that writes the edit to an Audit Trail (records the username, date, time, field name and field contents) so I...

Okay, sorry about that. But the question still stands (even though my other post, the one you classify as a 'double-post' to this one, has been solved): Can you run command line instructions from within Access without doing it by calling a batch file?

The 'convert' command is part of ImageMagick's command-line verbs for performing functions. This particular verb tells the system to allow for resizing, reshaping, that sort of thing, and in my case, I'm invoking the -resize switch and specifying a width and height in pixels. More info on that...

When you refer to the 'command line', are you referring to the line of code that I enter into a command prompt? That's this line here: convert C:\APic\1.jpg -resize 240x300 C:\APic\1.jpg ...and as you can see, it has full paths. Are you referring to the VBA function? Right here: RetVal =...

I have another thread in regards to being unable to get Access to run a batch file. The batch file has exactly one line of code. Is there a way, instead of trying to get Access to run the batch file, to run the line of code that's IN the batch file directly from within Access? Here's the line...

Me too... I can't understand why this one isn't working! Yep, tried it just now. No dice. Nope. Windows 7 Pro Might there be a way to execute the CMD command directly from Access without trying to run it from a BAT and using Access to open the BAT?

Hi folks. I have a vba function that takes a file named 1.jpg that is stored in the C:\APic directory and resizes it to exactly 240x300 pixels. The file name never changes, the batch file simply calls the ImageMagick script to perform the resize. The problem? It runs perfect when I double...