Search results

Hello, I have a 32bit access application that ties to an external db on our server. Been using this for years on several computers. We just got a new computer, and it has 64bit office. I run it as a .accde, with access 2013 runtime. I'm still getting an ODBC call fail error. Which...

Trying to find and download Bob Larsons Access Front-end Auto-Updating Utility. I can't seem to find the actual link anywhere. Including BTAB's website. Is it still available? Thanks.

I'm creating a new database. To be honest, I've never worked through the best approach to create a great user interface before. I'm looking for ideas on how to best approach it. What you've come to value for end-users when they first open the app, etc. For sake of brevity, let's say I will...

I have two unbound list boxes. The first one is populated with File names from a given folder. I want to be able to push them to the other list box, using the multi-select, selected property. Then, remove the selected items from the first listbox. The .selected only seems to work on the last...

What is your preferred method of storing application settings for access? Things like Back end location (so an updated FE knows where to look), User Preferences, and other "global" settings. I'd prefer not to hard code them in VBA, because they may need to change at some point. But that is...

Ok, at the early stages of designing a new database for a client. The application will have a few areas (let's say 5 as an example) that will have note fields. There may be notes for a Company, for a Contact, for a project, for an Invoice, for a Purchase Order, etc. I've been taught that...

Just wrapped up a db for a client. Put the backend on their network (.accdb). Had the front ends put on the client work stations. (.accde). Deployed last night. Tested and worked fine. Today we're getting errors Saying the wait period for an event has timed out. Any ideas?

I have an accde file that I've compiled in 2013. It's been running fine for years ( and still does on other computers that I've setup with 2013 runtime). We have a new computer in the office that has MS office 2019 on it. It doesn't like my file. I can't remember the exact error, but it I...

I have an app that is opened automatically. Noticing that through some glitch in my process, it has been possible for it to open more than once. I'd like to add some code on startup to prevent this. Seems like application.quit will work, but how to test for the existing instance?

Long story short, I think I'll need 1 new license of Access 2013 Docmd.OutputTo does not work in access Runtime, and I need VBA code to be able to output a report and email it. :banghead: What is the best way to purchase old licenses? I develop in 2013, and don't want to go higher at the moment.

This is going to be difficult to explain, so please ask questions as needed to clarify. I have a program that does somethings with new records. I want this program to be able to send emails if certain conditions are met. This conditions will be user-defined at runtime (and saved as...

Hello, Having a hard time within a new class module I created. It has a property called "CompanyName". I've set the Get property to public (to expose it outside the class), and the Let property to private (I want to populate this value within the class with another method). Here's the...

Had a nice working database. Changed some code, and added one field to a table in the back end. Refreshed the table links. Now when my code tries to edit a recordset based on a query I have not touched, which was always updateable, it shouts the following error: Cannot update Database or...

Hello, Having trouble in Access 2013, deploying an application that references a .tlb file. I've successfully registered the .dll file on the deployment computer, and made sure it was the same file path as my dev computer. Both the .dll and the .tlb are there. This was necessary to access...

Hello, Made a quick app this morning which uses a macro to email a report. Runs fine on my computer (Win10/access 2013). When I deploy to Station A or B (Win7/Access 2013 runtime) it gives me the following error. The command or action 'OutputTo' isn't available now -You may be in a...

I have a report that is based on a query. query shows all records for the field first name. I used the wizard to create the report, and not it is not showing the field value for every record. It appears to only show a value for the record if the value isn't the same as the previous record...

"Professional" Developers always seem to throw dirt on VBA and say it's not going to be around, etc. After learning what its capable of, I simply don't see the need to move elsewhere. It's too easy to accomplish most things in MS Access. There are great add in tools help the VBE become a...

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...

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...

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...