Recent content by tenderfoot

Wow, thanks JoeyY, that sorted the format issue and the incorrect results!

Success! The update is the same almost...I chose the parameter query I created as the record source for the update form. Without knowing about recordsource I would not have known how to do this. So, the record is pulled according to the person's surname and the user enters this through a...

I think I now know why the data tab was greyed out. At the top of the properties box the dropdown had not been selected. I clicked this dropdown and selected form and the data tab came alive...I have seen what you mean about the record source and I have now set the data entry to "Yes". I have...

Sorry to be a pain, but the data tab is greyed out with no options available to me. Is something not enabled somewhere?

Thanks for your help Adam! I am alittle unsure about how to set the record source. Is this something I can do in design view? I have tried right clicking on the form in design view and looking in "properties" I cannot see Record source. I created a form using auto form for the "People" table...

Hi guys, I was wondering if someone could help? I am using Access 2002 and I am struggling to find out out how you can insert/update/delete records through a form using the design view. Is this possible or do you need to do this another way? Could some one point me in the direction of a...

Actually, I shot my mouth of too soon - further problem! OK, say I have a record in my database such as 05/12/2007 (this needs to be interpreted as 12/05/2007) My SQL is like this: SELECT Count(*) AS [Any Service Clients] FROM (((Client LEFT JOIN faces ON Client.clientId =...

Dont worry guys, I have played with the sql and realised that the dates have to be entered as a parameter query in a US format! It was the join type that was causing me an issue also! As I was joining the tables on an inner join, no results were displayed, even though I was now entereing dates...

Ah hah! Now I noticed something, when I type the date into the "Criteria" field in design view of the query I type this #04/12/2007#, but after I run the query and vuew the SQL the date is like this #12/04/2007#.... Could this be my issue? How can I make the date stay in a UK format? Cheers...

Hello there, I have been bashing my head off of my laptop trying to get a query to return records where a date field is between two dates. 1. The field has a datatype of date/time 2. There are only two records in the database where the field Client.Refdate of record one is equal to 05/12/2007...