Search results

I think I need to replace ("SALES SYSTEM MENU") with my own file. Can you please share your file.

Do you have an example file? I am a newbie. I do want to secure my Access File with user level. Thanks in advance.:)

Can you please send me one. My mail is naungsai@gmail.com . what do you mean by "pm"?:)

You can also do it with a single column, Wks: format([BehaviourDate],"YYYY WW")

Dear nIGHTmAYOR:D Thank you for your reply. Through your expression, I have learnt alot. I have written an expression as followed. Interval: Format([my_date],"yyyy") & IIf(Month([my_date])>6,2,1) Thanks again for putting some concept of writing expression in yours. Best:D

Dear nIGHTmAYOR:D Thank you for your reply. Through your expression, I have learnt alot. I have written an expression as followed. [code]Interval: Format([my_date],"yyyy") & IIf(Month([my_date])>6,2,1)/code] Thanks again for putting some concept of writing expression in yours. Best:D

Thanks. It works.:)

I have a date field named "ModifiedDate". After I edit or change the value in the record, I want to change the last modified date in "ModifiedDate". How should I do it?:D

OK I did it. Going well.

Dear Night Mayor Thank you. It works. In my table, I do use another name for the "date". As you say it should be put in Query. But I hope that only VB will solve my question, so I have put it in this catagory. Sorry for mis-place.;)

Dear Friends I have a table with a "Date" field. In the queiry, I have grouped it into 6 monthly. Although it is easy to group the date in Quarterly, I do not find ready made expression for 6 monthly. So I have used the following expression: 6Monthly...

Month: format([ActionDate],"mmm yyyy")

Thanks for the concept behind it and the code. It works!

Thank you for the reply. One more question! When I navigate the old records, I want to lock the "txt.IorO" field. What code should I put?

Dear MStef and Aqif Thank you. Both work well. :) Best

Fabulous It works beautifully. Thank you.:)

Dear Friends :p I have created a form with subform. I want to put (let's say) 3 default records into the subform whenever I start a new record in main form. For Example; when I enter a new record in main form, the following records will wainting me to modify in the subform. Description...

Thanks for reply. :D In the form I do have numeric fields. I also don't want to save these default value as sometimes I may leave it blank.

Dear friends In stead of putting the label aside the text box, I want to make the label appear in the text box before I enter the data into it. :p

Dear friends In stead of putting the label aside the text box, I want to make the label appear in the text box before I enter the data into it. :p Moreover, I like the appearance of the label in dim contrast. Thanks in advance.