Search results

All, Thank you for your responses. I'm about to carefully consider each one in the meantime, to ensure we're all on the same page, here is a visual representation attached. I admit, I'm starting to think it's not a great idea, but I'm having trouble coming up with a solution.

Doc Man, I'm not sure what you're asking. Please ask me a question if needed to clarify. The path I'm suggesting would be to have a column for each foreign key to link each table. So, tblA, tblB, tblC, etc. would each have their own foreign key column. As already pointed out, this would...

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

Doc Man, Thank you for your reply. It's time to fill in the rest of this story. I was hired to take a few small access apps and split them. They were created by a superuser, who is a database enthusiast. They did an OK job (it is working, for now), but after seeing them in use today, I...

There isn't many records at all (<1,000). So, I'm not sure what they could have been doing. They have these apps on 4 computers. So, in theory I guess all of them could have been typing in new records? Still doesn't seem like a huge load. I also just checked the trust settings and added...

Doc man, The Back End resides on an in house server. close to the client computers.

DB Guy, That isn't my post, but I'm about to look at it. Thanks for bringing it up.

Hi CJ, Thank you for the quick response. Clients have full version of Access 2016 (I believe, will confirm). I'm running Access 2013. I was able to get it to open fine on their machine last night. The only thing I didn't try was to have more than one FE looking into the BE at the same time.

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

isladogs, Thank you for the quick reply. I'm pursuing option #1 right now, as that would be very simple! I appreciate it!

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?

OK, turns out I do not need a new version. Found this gem after an intensive search this morning: https://social.msdn.microsoft.com/Forums/office/en-US/669a9865-e3dd-47a4-a7c6-0a402f82baf3/error-2046-when-exporting-a-report-from-2010-runtime?forum=accessdev Long story short...

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.

Thanks everyone. MickJav, I'm going to peruse your example and get back with any questions. Jdraw, Will do. So, this application is stand-alone, running without any interaction, on our server every few minutes. It compares a "shadow table" to the "live table" and searches for any...

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

ah, ok thanks!

I read it, but I don't understand how to call it, without the keyword me. what is ObjAppSettings?

I think I found a work around. basically, I'll loose the Let properties, and just keep the module level variable. Then I'll just populate that. Arnelgp, because in VBA, we cannot instantiate a class and pass arguments, I make a method I call "init", where I pass over anything necessary...

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