Search results

Dear Ziggy1 Thanks for your reply. What I actually want is, I want to select from a form. The form will have 3 button (may be option button or check box). These option button will be Monthly report, Quarterly Report, Annual report. If I check one of these bottun, the query will format the date...

Dear Friends I want to build a query with a date field. That particular date field should be formatted and grouped into "Month" or "Quarter" or "Year" depending on an input box from a different form. Thanks in advance.

Dear Mailman Thanks. It works fabulously. Wishing you happy new year.

Dear Friends I have a table with varibles like GDate, Code and Grade. "Code" is code number of person. "Grade" is grading of that particular for the "GDate" which is a date value. I want to evaluate each person in grading for a peirod of within 6 month. But for the grading, I don't want to...

I have a table with an OLE field. In this OLE Object field, I used to attached a Microsoft Word file. Then when I create the report, I want to display or Print this attached Word File. Is it possible? HELP!:D I am using Microsoft office 2003.

Dear Friends I have a script attached to a control in form. In the "Code" control, if it is not in list, I want to close current "Service" form, then open the "ClientIntake" form. In the "ClientIntake" form, I will enter the value in "Code" field. These two forms, "Service" and "ClientIntake"...

Dear friends Can I protect my table with a password? Best:D

Dear Friends If it is not in list in a "Customer" combo field, I would like to add details of that particular customer in a different form. I found many Not in List examples. But I did not find to do so. Thanks in advance:)

Thanks for quick reply. I have try it with Append query. It works. Best

I mean merge the similar tables of 2 files.

Date, Person and Catgory are the field name of my table. Date Person Catagory 1/20/2008 0001 A 1/25/2008 0002 A 1/30/2008 0003 B 1/30/2008 0001 B 2/10/2008 0002 B 2/15/2008 0002 B ---- ---- 7/10/2008 0001...

Dear Bob I actually do not notice the InStrRev works in reverse text direction. Thank you for your clarification. I have replaced the InStrRev wtih InStr. thank you.

Dear pbaldy I think I've got one expression. Column2: IIf((InStrRev(nz([Column1]),"1") Or InStrRev(nz([Column1]),"2"))=0,"Yes","No") But if you have more decent one, I still one to learn. Best:)

I have a column containing Text strings. (Column1 is text field) Column1 123 145 235 369 456 In this Column1, I want to know if the record contained "1" OR "2", the Column2 will give the result "Yes". If not, "No". Column1 Column2 123 Yes 145 Yes 235 Yes 369...

Is it possible to to syncronize table from 2 files?

My mail is naungsai@gmail.com. Thanks in advance.

I found out that you did not link your form with the table. I have done one in my attached. In doing so you just use the form wizard. I have not add buttons in the attached.

I have reattahced your file. I have change the data type in the table.

Can you review my file and fix it?

In the table design, you should choose "Date/time" in data type.