Search results

Hi, I assume it would be an IIf statement, but i am not sure how to write it. i need it to look at previous entries in a Subform and to only count the ones that were made within the last six months from todays date. Then to return the counted value to a Textbox on the form on which the Subform...

GolferGuy, Thanks for help, I dont think i explained my problem well so i am sorry. What i am looking for is a way of to check previous entries in a Subform and if they fall in a 6 Month period from new entry made today. Then they would be counted and the figure to be displayed in a Textbox. So...

Hello all, I need your help please, i have a Form that also has a Subform in it. I need to create a Text box on the form that will display a number which will reflect the total enties made against a particular ID within a rolling six month period using the system date as a perameter. The number...

I told you i has new to Code (ha ha). Thanks alot mate, it works ok now

Access 2000

As requested, Thanks

No other code running, i created a new Database and created a box called "Week Number" then entered the text in the default value box. as soon as i moved the curser away from the field the error message came up. I also put the message in the "Open Form" VBA but nohing happened.

The reason i ask is that no matter where i put it the code an error box pop's up stating "The expression you entered has an invalid . (dot) or ! operator".

Thanks for reply, Where would i place this code? Assign to function on week number teaxtbox or on funtion for form? etc

Week Numbers that start at 1st April (HELP!!!!!) Hello all, Very new to Code so your help is much needed. I need a code to show the Week number in a TextBox called 'Week No' when the form is opened/loaded to make an entry. However i know this can normally be done using =Format(Date(),"ww")...

It Works!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Paul, I changed the time to " instead of # because that is what user Slade Justin suggested above. Anyway i have changed the time default value as stated in your email and it works fine, i have checked all time frames by altering my system clock...

Thanks for reply, Your suggestion i have already tried. I have created 1 box for date using a default value of Date() and a seperate box for time with the default value of Time(). I have also tried it with no date box and only a box for time. Plus also using 12hr format and 24hr format with and...

Slade Justin, All i can say is that i must be stupid. Now it does not even work when i manualy input the time. Thanks anyway, i have attached the db incase you can spot something i have done

Paul, Still no joy, Firstly i noticed you have used "And" instead of "Or" which you told me i was not to use. I tried it with both and the method of using "And" only works when you input the time manualy and where if you use the system time it returns the wrong result. The same is said for when...

Paul, Thankyou for your help, the reason i deleted the thread is because i titled it incorrectly and i was not able to edit the title. I have used what you suggested but it does not fully work, it does return a value but where it should show "Nights" it states "Lates". I have set up the format...

Hello, I am still wet behind the ears in regard to Access so your help and support is much needed. I have created a form in Access where i am having trouble with a textbox. In short this box is called [Shift] i want it to be populated by the result the system returns in another Textbox which is...