Recent content by branston

Ah good thinking. Thanks!

I have a report with a lot of fields, which is based on a query. The query runs fine but when I try and run the report I get an error: "Data type mismatch in criteria expression" Any idea how I can narrow this down to a certain field? I can't see anything obvious and I have a very similar...

OK, thank you. I'll give it a go but I think it might be a bit beyond me...! Especially as I just thought it would be nice, don't think its a vital function! Thank you anyway!

Sorry, what now?! My head's not managing to get round that!!

by the way - I have had to edit it a bit as the code was on the form prior to this one... does that change things? Also the form has 3 subforms...

OK, thank you. When you say Me.subformconrolname is the subformcontrolname just the name of the form you are using as a subform? Im getting an error there now (method or data member not found)

Oh great! Thank you. Just tried to put it in and with the error bit it said it couldn't find the if relating to the else... but if I remove that I get another error saying: "Compile Error - Invalid of unqualified reference" and it highlights the .MasterLinkFields line.

Hi, I don't know if this is even possible, but I was wondering if you could help? I have a form which contains 3 subforms, all linked to the main form on a 'firstname' field. This works fine, but in the firstname selection page (A form which leads to this one) I have an "All" option. When I...

ahHA!!! Dave, you were spot on... I added a iff statement around my division and it works fine. VbaINet - I think that might have been in the SQL code you gave me, looking at - think I missed that when I was making the changes! Thanks everyone!

Oh, sorry, I didn't realise you had made changes to the SQL... incorporated those now... Still not working though :-( Still falling over on current. Thanks Dave - I'll double check that as I do have some dividing.

Right... the 1st one I come accross that does it is 'Current'. I cast that to Double, and then tried to filter it... it looked like it did the filter, then the error came up.

Good point - Thanks for that, makes the whole thing a lot quicker. Still getting the overflow error though. I changed it to a string because thats what the field is being set as (XXXX) Surely you can't set that as a type of number?

by the way - I tried casting to a string but that didn't change the outcome.

Thanks for the suggestions - I'll crack on with the trail & error I guess! The SQL is: SELECT QryRatesCheck1.Phase, QryRatesCheck1.StaffNumber, QryRatesCheck1.StaffName, QryRatesCheck1.StaffAgency, IIf([StaffAgency]="Staff",([StaffInvoiceRate]),[AgencyInvoiceRate]) AS RateA...

Hum... Surely if it can deal with the whole query, it can deal with a is not null filter?? I wouldn't say it was hugely complex - I have definitley got queries that are more complex that work fine! I have tried adding the filter to other fields, as you suggested, and with some it works, some...