Recent content by kennetha

Thank you.

Hi all, I would like to transfer an Access query to a workbook template in Excel. Some VBA code appriciated. Thanks in advance Kenneth

Thanks

Have no idea how to INSERT query with DAO

Hi All, Is it possible to transfer all table data from a table to another by using DAO? All fields are the same for the two tables. Some Vba code appriciated. Thanks Kenneth

Thanks you saved my day

Thanks PHV, It worked fine and defitely better than opening and closing forms. How can i change "idcode='101z'..." if it is to come from an edit box (txtidcode) in Forms!vv!? If IsNull(DLookUp("idcode", "t", "idcode='" & Forms!vv!txtidcode AND Forms!vv!txty Between dfrom And dto")) then ...

Hi all, I have created the below on a form basically to open it hidden, check if there is any data (like if dcount()>0 and then continue or stop the code when necessary. My question. Is there any other way to accoplish the task with a simple Dlookup or an Sql code? Here's the sql; SELECT...

Thank you ..been of great help

Straybullet, Cannot do a combo since tool is selected first. ie before posting date periods. Some Vba suggestions appriciated Thanks

Hi, I'm building a database for a friend of mine who owns a tool hiring shop. I've create tables and forms (all unbounded objects) which update by DAO.I've stuck with a problem and cannot figure it out. Table fields are as follows: clientid; tooolId; datePeriodFrom; PeriodTo How can I allert...

ok thank you

Not really but unique numbers such as invoice no. thanks anyway

Can you tell me how? plz

Is it possible to make a query criteria from a table.