Search results

Hi All Can anybody help with the following: - I have created a subform from a query. In the subform design view I have created an option group for me to select an option for the form to filter. In my option group properties I have entered the following code in the afterupdate option: -...

Mailman & Mile-O-Phile Thanks v much for your reply. It's driven me nuts! as I knew I had the code etc all correct. I suddenly had a thought :confused: and all it was was that I had my subform set to datasheet. Why I didn't think of that before god knows! Thanks all the same :)

Hello Can anybody help with this - I am still having probs.

Hi All I have a subform which I want to apply a option group to to filter records. My Option Group is called FilterOptions and has at the minute 2 options which are All Dates & 2003. When I click on any of these options I want it to filter all entries on whatever I choose. Therefore I have...

Rich Thank for your reply. Only just recevied it as I have been off for a couple of days. Cheers

Thanks Rich It's now worked. Quick question - With Satuday being "7" is Sunday "1"?

Rich I created my own field called "Week Day" in my query so that it is easy for me to see what day of the week it is against what date I enter in my "MyDate" field. Therefore in my query all I have done is given a column a name - in this case I have called it Week Day so in my field it reads...

Rich Forget my previous note. There was something wrong with the text box. I have created a new text box and my control source is now =Sum(IIf([Week Day]=6,[Overtime],0)) When the report is run all Overtime shows a total as zero even when an entry is in Sat. If I change 6 to "6" it brings...

Hi Rich Thanks for your reply but I can't get it to work when I change "Sat" to 6 by using "6" or [6] etc. It comes up with a message saying that "The expression you entered contains invalid syntax" etc. Any ideas?

Hi All I have a report with reads from a query. In my query I have 4 fields - a date field, week day, salary month and Overtime. I have created my week day field from my date field so that it displays the day of the week. In my report I have created a text box in the footer to be able to sum...

Rich Thanks for your reply. I have entered your code into my forms properties in the "on key down" but it doesn't work. When I view my form and use my down arrow it jumps to the next text box to the right like it did before instead of jumping down. Any ideas?

Hi All I have a subform where the properties are set to Continuous Forms. In the subform part of my formI have a text box called overtime and I want to be able to enter a number into the text box and then on key down it move to the overtime box in the next record underneath as opposed to it...

Thanks Pat It seems quite straight forward I will try to have a look at it today. I will let you know how I get on. Cheers.

I belive you are right. However, I don't like ending up with loads & loads of queries used for one purpose only. My forms are subforms created from tables as I don't need to raise a query for any part of these.

I thought that this would be the only way around it. It seems daft though that you can't do this in forms created from tables without using queries. Thanks all the same.

Rich Sorry - But with Namliam not being able to help I didn't think anybody else was looking into this. Also with the last thread he did solve my first problem. You mentioned form or subform - I have tried both ways and you have the same problem with both. When you view either when you go on...

Hi All Can you not filter by selection on a calculated text box in a form? I have tried it through queries and you can, however I can't seem to get it to work in a form. Is this not possible. Please advise.

Thanks for trying!

Namliam The strange thing is is that I have just created a query to see if it did the same but it doesn't - It lets you filter by selection. I can't understand why it won't do the same through a form. However, I don't want to have to create a query each time I want to use this.

Namliam Tried this still no good! Any other ideas?