Search results

Ah, great. Thanks for clearing that up. No, its the ToDate_ field... wanted to only show a date if the Staff field was empty.

Why will it still be cast as string? I changed the "" to Null as you said... And it seems to be being recognised as a date now... Just trying to understand.

Ah, yep, Null error was just be being daft. All seems to be working now I've got rid of the "" and put CDate in a few more places! Thank you!

Oooh, ooh, I got it to work a bit more! If I use the CDate([DateField]) every time I call it it seems to work... now its saying invalid use of Null but I think thats an unrelated thing. Thank you for all your help!

Thanks for the suggestion, but it doesn't help.

Thanks for your suggestions! Its sort of worked... The Query I mentioned calls on other queries where the date is formatted etc. I have managed to get it in date format in the 1st query, but it doesn't keep it in the 2nd query... I am using it in a iif statement: ToDate_a...

Hi, Is there a way to change text to date format? I have text which I have formatted to be in the dd/mm/yyyy format, but it doesn't recognise it as a date so I can't ask it to (for example) show the ones where the date is after another field which is a date (I get an error saying the I have a...

That's brilliant - Thank you for your help!

Hi, I have a form with a combo box on. I have set this combo box to look up its records from a query. In the query there are 2 columns. I was wondering if there was a way to filter the combo box to only show records where the 2nd column equals another field on the form. For example, The...

brilliant - Thank you!

ah, that's nearly got it working - it doesn't seem to update if I change the controlname field though... Will carry on having a play, definitley closer than I was - thank you!

I had a go at that, and I got it to work with a specific number, but I couldn't seem to get it to reference a field on the form... e.g: SELECT [TblA].[ColumnB] FROM TblA WHERE "[TblA].[ColumnA] = '" & me.FieldA & "'"; Hopefully I am going wrong somewhere really obvious!!

Hi, Is there a way to add a Where condition to a combo box? For example, I want my combo box to show column B from a table, but only where column A is the same as a field on the table. Thanks

Do you have a table with all the names from all the events? If so couldn't you just put that table in a query and use the 'group by' function to give you a unique list of names? Then use another query to count how many records there are? (There are probably nicer ways of doing it but thats how I...

OK, thanks - I shall have a check through those points and see if there is anything I should change.

So, how come I can add links to another table and it works fine, but as soon as I try and link MppNumber the whole thing grinds to a halt?!

Thanks DCrake - That is a much neater way of doing it!

See screen shots attached. The code for "Cost01" in the query is repeated up tp "Cost24" each calling the corresponding hours. If you need anything else let me know

ah, don't worry - found it!

Sure... how do I add attachments in here?!