Recent content by davemarco

Hi Ranman, thanks for the reply. The issue isn't so much that the spreadsheet is popping to the front. The major problem is that occasionally when one of my users open the database, one of the linked spreadsheets will pop open with it in full WRITE mode. As a result, whenever any of my other...

Hi all, Seeing some strange behavior here. I have a database front end with an Excel spreadsheet as a linked table. On occasion, when one of my users either starts up the database, or attempts to run a query that pulls from that linked table, it will automatically open up the linked...

Ok, small issue. I have an Access database that pulls data from another department's Excel spreadsheet. My database seemed to be locking their spreadsheet any time someone ran a query that drew data from the link, so I created an intermediatary spreadsheet that basically links to all of the...

Simple and elegant. This works perfectly, thanks!

Ok, I've been studying this, and I think that I'm starting to get some of it. I was hoping that you might be able to fill in some of the blanks for me. sub YourEvent //Defining the event. I'm think that I might want AfterInsert() for this? dim db as dao.database //declaring database object...

Thankfully no, "Lot #" is manually entered. :)

I am definitely following your train of thought. Unfortunately, I have several reports that our end users can generate that are based on queries. These queries use the "Lot #" field for their INNER JOIN's, which requires the lot numbers to exist in all tables at the time that the queries are...

Thanks for the reply. I can certainly understand how it might seem elementary to someone who understands it. Unfortunately, as I stated, I am not VBA proficient. I found pages explaining what several of the key words do, but I'm not understanding how they fit together. It looks like you're...

Thanks CJ. I had considered consolidating all of the tables, and may have to do that if it comes to it. Unfortunately, I've written a bunch of rather extensive SQL queries that reference the current table format, and it would be a major headache to change them all. I'll keep that possibility...

Hi llkhoutx, Thanks for the reply. I took a brief course on VBA, but I am not currently very skilled in that arena. Is this a problem that can only be solved using VBA? Could you provide a small explanation of what your code does, or maybe some developer's comments for the various sections...

Hi all. I currently have a pharmaceutical lot database set up in the following format: MFGData (table w/Manufacturing Info) QAData (table w/ Quality Assurance Info) QCData (table w/ Quality Control Info) PASData (table w/ Process & Analytical Science Info) SCData (table w/ Supply Chain Info)...