Recent content by helen269

Of course! So when I deleted the original month label and control boxes - after making a copy of the control box - I didn't eliminate the problem as the copy of the control box that I modified the contents of still had the original conflicting name. Damn! Anyway, thank you very much indeed...

Wow, that's amazing, thank you! But I put in exactly the same as this. You've even left in the text label box. I want to understand this, what did you do to make it work?

Ok, I deleted the existing Month boxes in the report, both the text and control box, and put in a control box your =MonthName([Month]) and it's giving a #error.

Really? That's very good of you, thanks! :-) When it opens you'll need the second from last item on the switchboard. There's not much data in it but enter 2011 for the year and either 6, 7 or 8 for the month. Thanks again! :-)

Nope. It still comes up with "January". I think I'll leave it as it is, it's only for an Access class assignment. The database works and the tutor can take the month as a number and it'll still pass.

It just comes up asking for a third input: Enter Parameter Value tbl_2_CustomerOrder.OrderDate I already have a control box with the Month value in it which displays as a number so I get "Month: 6" for example instead of "Month: June". I'm going to try making a copy of that box and put the...

In the table and the form it's OrderDate. In the query it's Month: Month([tbl_2_CustomerOrder.OrderDate])

Oops, mistake! What I actually get is "Input Year" followed by "Input Month" followed by "OrderDate" - because of the square brackets it wants me to input the order date.

Thanks Paul. I've just tried =Format$([OrderDate],"mmmm") but now I don't get anything, not even a #error. And don't worry about the year, I have an input for the year as my first field in the query, the month is the second.

I have a report based on a query where in the query the user inputs a month from 1 - 12. How do I make the report say the name of the month instead of the inputted number? The field in the query is constructed like this: Field Month: Month([tbl_2_CustomerOrder.OrderDate]) Criteria...

Mixing the Autonumber and the Number types worked! So much for "you can't mix the data types". As you say, they are the same even if they look different. Many thanks! :-)

Thanks, I'll try both methods. :-). What a learning curve! Phew!

Thanks, it's good to be here! :-) Thank you for your reply. So you're saying that Autonumber and number can be linked on the relationship table? Can I enforced Referential Integrity? I thought two fields in a primary/foreign key pair had to be of exactly the same type. I'm still building the...

I have a form and subform as shown below. The order number in the main form and in the subform is entered manually but of course ideally the Order Number should be an autonumber. I've tried to change it by going through the steps to change the number field to an auto number (delete the...