Recent content by cmw

I want form textbox values assigned into a table from save button click event, and I fetch table value into textbox from form_load event. I am using unbound form. How will do it?

I want export all table in my currentdatabase to a folder and its automatically create input year name. How will do it?

If I split my database financial year(01/04/06 to 31/03/07) wise , Transaction table contain empty record and master table contains all record till 31/03/07 and closing balance update into new master table opening balance . Pls anybody help me.

I declare a variable has Where Condition in main form command button and I want if codition is true then subform recordsource wherecondition is added into recordsource.How will it do?

I have a table Purchase, i want a report it creteria is category=me.category and company=me.company and suppler=me.supplier and itemname=me.itemname . But all creteria is not must , so i want notnull textbox wise report. Pls anybody help me. Pls send any sample form report.

If i close my database,"Table TempMSysAccessObjects already exists" warning display. Why this warning display? Pls anybody help me.

Thank u. works well

If MsgBox("Do you want to save this record", vbQuestion + vbYesNo + vbDefaultButton2, "Save Record") = vbYes Then Else DoCmd.CancelEvent End If Above coding, i want change it Else condition ,i.e I click No button current record clear it . New record open it. If you dont mine...

You are great! It works well but I dont want save it, form clear then new record open it.

Thank you very much khawar. Work well.Please another one i.e Form data is stored automatically. But I dont want this. Because I click save button Check Required field value it's ok then save form otherwise Message display.I Don't click save button but i close that form or take front record ...

Please anybody help me. Is it possible Event action perform using one Function key? Eg I press F8, Ledger Form open it. Any sample please post it.

Thanks Big Pat, It works well.

I am using Access 2000. Yes Absolutely correct.If Window is Fullsize, bracket display. How can detect bracket , I want form Maxmize.

title bar display Application title and form name with bracket. i.e Access[Ledger]. I want remove bracket. How do it? Title bar color change only working database, how do it?

Thank you very much namliam. Its work well.I write Date field properties defaultvalue =FetchDefaultDate() ,Its dont display date. So i write Event code, Date display.