Recent content by Elpis

I can't see the design view at all. I can only see the Layout view and the Form view, the design view button is greyed out. I have the full version of Access 2010.

Hi I've been looking at the Northwind Database. How have they got the ID number to be a hyperlink so it goes straight to the purchase order? Is the data type set to hyperlink or is it something different? I can't see the design view for it.

Thanks that's worked. It would include May 18th, Monday to Sunday.

The last seven days, so 12/5 to 18/5 and then to update the next week 19/5 to 25/5 and so on.

I want my query to update every week to show how many enquiries we get in one week. Then to show the results on a report so other people can read it.

Hi I have made a query that was supposed to update my reports every week with new enquiries that we get. I thought i had solved this but when i opened the report this morning, it's just showing last week's. I have this as the criteria:Between (Date()-7-Weekday(Date(),2)+1) And...

Tried it this morning. Do i need to make a new form for the "Second Form Name"

I think so. By doing that would it take me to the full entry on my form.

Hi I'm new too the forum. I am trying to set up a very simple database for enquiries we get in the office. So far i have 1 table called Pink Sheets that has Enquiry Number, Date, Details requested, Website/telephone enquiry, Property type, Name, Company Name, Address, Phone Number, etc on it...

Hi I'm from England I have a bit of experince using access but that was years ago for my A-Level! Having a few problems with the database i'm trying to set up so i've decided to ask for help.