Search results

Thanks guys, Marks comment got me thinking. It was procedural, but I was missing an important step. This is a snippet of my previous code: Public Function RunProgram() As Boolean ' Status: In Devlopment ' Comments: ' Params : ' Returns : Boolean ' Created ...

Thank you Jdraw! I wasn't aware of the issue with unhandled exceptions and global variables. One question -- what exactly is an unhandled exception? Every single function or sub in my application has the "On Error GoTo Proc_Err" with a this setup at the end: PROC_EXIT: Set Options =...

For the sake of brevity, I'll be as abstract as I can. If you need more details, I'll be happy to go deeper. I have developed a medium sized application where I have a flow of 3 main events. 4,300 lines of code and 15 modules (6 are classes) so far. I've tried to make the code modular and...

Thanks for the quick responses guys. As far as the transaction. I was trying to use it because I don't want the records created by this test to persist in the database. So, It doesn't look like it will work then, because once I commit a transaction (so I can see the record in the db), I...

Long story short, I'm using a DAO Transaction during my unit testing. Apparently, Dcount doesn't pickup the newly inserted records in the middle of a transaction. If I comment out the transaction code, it works fine. Ideas? :banghead: Private Sub AddEventRecordTestMethod() On Error...

Jdraw, All product docs are directed towards the user interface. No user group, small niche product. I know the developer, but, I don't think he'll oblige. I don't want to give him any bad publicity by listing it here. Doc_Man, I'm strongly considering a "shadow" db, or at least a...

Hi Mark, It does have a sequential key. There is no last updated field. It is a 3rd party out of the box application, so we only have Read access to the DB via ODBC. No way to add it, unfortunately. I wish it was in MS SQL, then I could get into it a bit more. I have admin rights to it...

Thanks Pat, Believe it or not, this is an off the shelf ERP, so we don't really have any control over the underlying db. It's a shame, as it makes it harder. Somedays I think it'd be easier to re-write the whole thing myself.... Given above, do you think the route of copying the last...

I'm creating an application that will look into our ERP back end (Borland, through read-only ODBC), and find new or changed records in a specific table, then take actions, such as adding them to our google calendars, or pushing that information to a webhook for Zapier to do something with...

For years now I've avoided using the native Dcount function like the plague because I've been told it has terrible performance. Today, I'm starting to plan a new application (rewrite of an existing one), so I've been looking into performance. I have a table that I need to regularly query the...

I have a form with a subform (qry) on it. I want the form to load, then the user fills out some cbo boxes in the header, which then pass that information to the subform (fills out the parameters of the query). I want the subform to be invisible or blank until this happens, and the query not...

Does anyone do unit testing on their VBA projects within Access? I use RubberDuck, which has a framework for it, but I'm having a hard time understanding what and how I would actually test, and perhaps more important, if it's truly worth it.

I'll try to make this short. We have a CNC Machine (Windows-based) on our shop floor that we send files to from the office. These files are used once, to run the program, then we need to delete them periodically, as searching for the right file takes too long otherwise. I want to create a...

Excellent, that's what I was hoping to hear. Thank you, Gentlemen!

I need to create an application that will reside on our server. It will be started with a scheduled task early on a workday, then through a form timer, every 5 minutes, it will poll for new information, then send emails, notify people, maybe post to a webhook etc. I would have it shut down at...

Just wanted to give an update. I think I found a simpler way to handle this. Apparently, with Zapier, you can set it up to parse emails (you tell it the structure of your email template, then it can extract the data). I'm going to try this route, as I already know how to send an email with...

Hello all! Hope everyone is having a great Friday!! I've used access a bunch in the past to automate tasks within our office and create data bridges between our ERP and engineering software. Now our software stack will soon includes an online store, and online accounting (QB Online)...

Somewhere in the dowloads on this site, there was a nifty code repository db that someone had created. I used it before I got the FMS Sourcebook. It worked fine. But, the sourcebook is worth it if you can swing it. I like that it's right there in access as I'm working, and the source code...

The first versions of Rubberduck did crash a few times on me. I haven't had that problem in a long time, so I think it's stable now. Snaggit certainly does help. I have that as well. Also, I forgot Notepad++ (Also free). You can set the language up to VB, and it reads pretty well. I...

This is just a quick post to show the tools that have helped me in my quest to improve my Access skills. I have nothing to gain by any of you following this advice, as I'm not affiliated with any of the companies, just a happy user, looking to give back to the forum that's helped me along the...