Search results

Yup, they're a lot of help there!! I like the way they tell you how to see the error! As if someone would actually be browsing their pages and think, ooh that sounds fun, let's try it!!!!!!!! OK, back to the beginning then.....

Wow! THANKS!!! I was thinking about a calender thingy, but thought that might be a bit advanced for me at the moment. I'll certainly give that a look :) I have a weird problem. I could view the code of the event procedures in the Hartman db, but when i go back to mine and try to build event...

Thanks for the replies, guys. The functions worked great, but unfortunately are only of limited use in the project I want them for. I need to be able to select ANY week, either this week or a previous week. Doing this by entering a date would be easiest. So yes, I think the event procedure...

Thanks very much for your quick response :)

I have a form that is used to specify criteria in a query, namely the date range for a report (much like the Sales By Year Dialog form in NorthWind). There are two text boxes: StartDate and EndDate. Currently, I have to enter both details manually. I want the report to always list one week...

I want to create a label report based on a query. The database has two tables: Categories and Labels. Categories is used to list (surprise surprise) categories, and is used as a lookup in Labels. I accidentally created a normal report, and everything came out fine! The categories came out...

ahh yes, so it does! sorry, bit of an access n00b :o many thanks :D

I want to use a report to make an alphabetical two-column list of items in a table that do not have a Yes/No box ticked. I used a query, which sorts these items alphabetically. The report also works well. However, it will list like this: Apples Biscuits Cheese Doughnuts...

I am having a problem with my label report for my database. I have a table called Labels. This contains the following fields: LabelID (primary key) CategoryID (lookup from table: Categories) Length (text) Price (currency) The lookup is for the field: Category in the Categories table. I have...