Search results

I went through and updated the code with the FileDialog Object and updated the library to include the missing pieces and it works great!

I didnt write any of the code, I just inherited it. Most of it is an older terminology than I have seen previously. I was trying to figure out how he linked the various parts. It does not look like it is linking to anything to open a box to search for a file at all but I am told it did. I...

This may be very helpful. I will take a look at re-writing the code and see if that works. Someone way before me wrote it and had notes from windows 95.

It doesnt throw an error so this part doesnt help too much. It just doesnt do anything.

Thanks, that did work for all but Command 53. So the other 3 buttons that were not working, now work. Not sure whats going on with that button though. I tried deleting the code completely, saving, and going back to readd the event and code but still does nothing. Should I just get ride of it and...

I think the way it operates is what confuses me. I am used to just building a program from scratch. The interaction of other programs with the coding and terminology is taking some getting used to.

Yes, it does not say test when I click on it

The conversion was done before I started here. I ended up just needing to add PtrSafe to a few lines of code so that it would run. When I look at references it is only showing four as selected. VB for Apps, Microsoft Access 15.0 Object Library, OLE Automation, and MO 15.0 Access Database...

Thanks! Thinking about taking a Udemy course on some VBA to get a better understanding of some of this code. Just havent had time with all the items that need to be updated or fixed

I could post the code for the functions if that would help

No nothing, the button just doesnt do anything. Before the database was throwing an error because the code was so old and I needed to update it to run with 64 bit to open. Fixed that, but now some parts just dont do anything, and do not throw errors so not sure how to fix it.

Hi, I am fairly new to VBA and working with older code created by someone that no longer works with my company. The command click no longer does anything and I am not sure why. I did enable variable declaration, but not sure it helps if its existing code. Added the code below, please help...

I find myself using them interchangeably

I am newish to VBA and Access. I went to school for software engineer but ended up with more of a scripting job, working with Access and SQL. I am finding that I am more fixing old VBA code than creating anything new as the code has broken or been out dated. Never really used modules and VBA is...