Search results

Thanks ST4RCUTTER, I want only week number in given month. eg if month="March" then result is week1=01/03/2008 to 07/03/2008, week2= 08/03/2008 to 14/03/2008 ,week3=15/03/2008 to 21/03/2008,week4=22/03/2008 to 31/03/2008

Sorry for late reply Its not work, the below error display " The value you entered doesn't meet the validation rule defined for the field or control " How it solve?

I give wordart texteffects from format->font->Text Effects. But text effects not work.

Thank u very much DCrake, I insert wordart text but text effects not work. Can i use text effects or random color display timer event ?

Wordart text is kept in word document.I want a label caption is the wordart text in my form. Is it possible?

Thanks CyberLynx, I want enter billno in a textbox, if billno is available,that billno record fetch in form,otherwise nothing. Its billno is primarykey. i.e Billno is available form refresh update mode,else addnew mode.

How will do weekly report per month? eg if month="March" then result is week1=01/03/2008 to 07/03/2008, week2= 08/03/2008 to 14/03/2008 ,week3=15/03/2008 to 21/03/2008,week4=22/03/2008 to 31/03/2008

I enter Primarykey value in textbox , Find record textboxvalue wise and work form requery display it. How will do? I try below this. Dim db As DAO.Database Dim strSQL As String Set db = CurrentDb Dim rs As Object strSQL = "SELECT * " & _...

How do solve this pbm

Sorry, I am using IIF Statement. But not work well.

Thanks Guus, No way for grouping in a form, is it? How to do work Decimal place round into 2. I try many ways round function but doesnot work. Then value=0 then Display blank , I try follow method iff(debit=0,"",debit) but not work. Please help me.

Specified field name grouping in form is possible or not? It is work done in report.I want Accounts type wise grouping in form. eg Purchase A/c Purchase 1% Purchase 2% Sales A/c Sales 1% Also I want If reportdetail double click,another report open. Is it possible.

I am really sorry. Textbox value is January-2008, I want Result is 31/01/2008. Also February-2008->29/02/2008 unless 28/02/2008. if me.combo.text="CASH", Display Error:"You can't reference a property or method for a control unless the control have the focus". me.combo.defaultvalue="CASH" or...

If I select month&year,I want month enddate. eg. Jaunuary-2008, Result is 31/12/2008. How will do it? Combobox value how do assign in form_load? me.combo="CASH" or me.combo.text="CASH" or me.combo.value="CASH" Error display for above three method assign.

thanks cooh23. I really want your link method. I try it.Work well. But i try double click on anyfiled in datasheet currentrecord it will open up a new form that pertains to that particular record. Any idea? Thank you,

Double click on subform current record, Open another form through if criteria field is equal.

How will do join two queries such as query1,query2. Query1,Query2 fields all are available where join any no common fields.

I have two subform in main form. Main form is unbound form. I have 2 queries such as detail query,summary query. summary query is summary of detail query by sum(amount) groupby code. subform1 recordsource is detail query.subform2 recordsource is summary query. My problem is I select a combobox...

I have written insert command in mainform After_insert() or After_Update() Event for a Form field value insert or update into another table field value except mainform and subform table. Mainform insertion work before entering data in subform. So Subform value can't insert table filed value ...

Please help me. How will write for mainform and subform save when mainform save button click(). Mainform Form_BeforeInsert() or Form_BeforeUpdate() event work before subform enter. But I dont want this. I want only form save main form and subform through save button.