Search results

Hi Trevor, Regarding paragraph 1, you're correct, that's what I'm trying to do. Is it easy to do? That's what I'm stuck on to be honest. I'm aware of the need to error trap, that's fine. Thanks for the heads up on the naming errors, I'll get those fixed.

Thanks Trevor, There's no sensitive info in there at the moment anyway so that's fine. See attached. Based on my previous explanations I'm sure you'll see what I'm trying to achieve. I'm happy to do a total re-design if need be, I understand how I've done it may not be the best way...

Sorry to bump again so soon, can anyone help?

I may well have design issues - I'm very new to this. Basically, at my company we do "CPS" (Customer Perception Survey". So, on the database there is 4 tables - one contains customer data (Name and account number). The other three are as follows: "expected", "bestother" and "competitor"...

Good afternoon all, I typed a long message earlier and got a database error, so excuse me if this is a little short. I'm looking for a solution to the following issue: I have three tables. Each heading is a criteria. Each row is a customer account number. On each row I can assign one...

Bingo! Works perfectly - thanks for your help Trevor, very much appreciated and will stop me from tearing the rest of my hair out!! Mike.

Hi Trevor, I did read the page you linked me to initially and I just re-read it, unfortunately I'm not experienced enough to fully understand it. Thanks for bearing with me as I'm learning still... Am I right in saying that the "Function" you posted is instead of a Sub? If so, how exactly...

Thanks Trevor, I followed your instructions and it worked on my version. Unfortunately testing it on a PC with an older version of Excel, I opened the Access database and it said it "Contains a broken reference to the file EXCEL.exe version1.6", it lets me enter the database after clicking OK...

Thanks for your response Trevor, I'm still stuck though (Please excuse me if I ask silly questions, I'm very new to Access!) I now have: Private Sub checkingtoolbtn_Click() Dim xlApp As Excel.Application Set xlApp = CreateObject("Excel.Application") With xlApp .Workbooks.Open...

Hello all, I'm new to the forum and would like some assistance if you wouldn't mind? I'm currently building a "Main Menu" tool for the team I work with, which has buttons and combo boxes that allow a user to choose a tool to use and then launch it. When I use "Shell" to open an Excel sheet...