Search results

By the way, I changed the DBPath to the location and name of my database, but didn't change anything else. Should I have done?

Yes, I'm using MADO 6.1 library now. It's Run-time error '-2147467259 (800004005)':

I opened up a new spreadsheet before, not realizing that it didn't contain all the references from before! So I entered the code to my present spreadsheet, and I got as far as conn.Open connString. I get a run-time error. It seems the same problem as I had originally.

I entered the code in the link you sent me. It got stuck on the line Dim conn as New Connection. It brought up an error Compile Error: User-defined type not defined.

I have all your references, plus the following four. Microsoft Forms 2.0 Object Library Microsoft Outlook 12.0 Object Library Microsoft Access 12.0 Object Library Microsoft Office 12.0 Access database engine Object Library I guess I need to keep the Outlook reference. But could the other three...

Thanks Gasman, I'll have a read of that.

Thanks Gasman. I'm struggling to find OLE Automation. Do you have a full reference name for that? Edit. I found it now. It was already ticked Is it possible that I ticked too many references, and selecting the wrong one could cause it to fail? I could play around with it maybe.

I'm not sure if I've defined ConnectionString or not! I'm not 100% sure what this code does to be honest. How do I define it? Do I need to go to references again? Otherwise, seeing as it worked for you, did you define it? I'm a little confused!

Hi Gasman. Thanks for the suggestion. I just tried that now, but I get the same error.

Hi, My aim is to reference an Access table from Excel. I found a Youtube clip that has code to achieve this, however, I get an error when I execute a line. I've posted what I have so far (see below). It's the very last line (Connection.Open ConnectionString = Connect) that causes the error...

By the way, if it's relevant, I can see reason why I am getting more rows with the IIF statement. It is because it is separating the VAT players into their separate payment types (fee, travel etc). Obviously I don't want this to happen, but I'm not able to get it to work if I enter the IIF...

Many thanks arnelgp. I tried what you suggested just now, but when I try to run it I get a message pop up saying "You tried to execute a query that does not include the specified expression 'IIF(Not [T_MusiciansDetails]![VAT_Number] ="",[T_Payments]![Amount]*0.2 ,"")' as part of an aggregate...

I'm making progress, your suggestion did solve the "Enter Parameter Value" issue. The next thing that is confusing me, is that when I run the query, I have almost three times as many rows as before. I'll just explain again what I'm try to achieve, because I deleted my post before. So, I have...

Thanks arnelgp. I'm sorry, I just deleted my question, because I think I just realized why it wasn't working. I haven't perfectly solved it yet, but I'll try what you suggested. Many thanks.

Thanks very much Gasman, that worked like a dream! You wouldn't have guessed how long I've spent trying to solve this, and I would never have worked this out by myself.

Thanks Gasman. That sounds really straightforward. I'm not entirely sure what grouping means in this context though. Do I simply create PID and EngagementsID columns in a query? Or is there more to it than that?

T_Payments ID PID PaymentTypeID EngagementsID DtPayment Amount 94 629 Fee 0004 03/10/2019 £626.40 95 629 Porterage 0004 03/10/2019 £40.30 96 629 Overtime 0004 03/10/2019 £380.25 97 629 Travel 0004 03/10/2019 £80.50 98 629 Costume Fitting 0004 03/10/2019...

Many thanks Crystal.

I'm in the process of creating the extra summary table, but I'm a little stuck. I want to be able to have information for each player for each job and for each category. For instance, for job 2, I'd like to select a player, and see what fee and other payments if any they received for that...

Great, thanks!