Search results for query: *

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.

dhookhom, The header information comes from a query of which vary on a day to day basis. It is imposible to use the crosstable if you don't modify else from the query itself. Since the program was created for a dummy user no access is given this way. Only forms are used! thanks Kenneth

Hi all, Is it possible to create a crosstab query were colomn headings vary, ie fields are picked up from a form.(since headings change from day to day). I also, would like to be able to use it in a report. Thanks Kenneth

Thanks for the advise. It worked with a slight code variation and is below: If IsNull(Len(Trim(Me.a1) & Trim(Me.a2) & Trim(Me.a3) & Trim(Me.a4) & Trim(Me.a5))) Then MsgBox "Nothing to Print. " & Chr(10) & Chr(13) & "Please post Picking Numbers in 1,2... ", , pro call...

Hi all, I have five edit boxes in a form which ex a code. I want to stop code if all edit boxes are Null but not if one or more is filled with data. I tried the code below but with no success for obvious reasons- still not know how to proceed. If IsNull(Me.a1) Or IsNull(Me.a2) Or...

Thanks a lot.