Search results

sorry, i mean thanks gemma

Thank femma, working great! Thanks neileg. mithani

Thanks neileg Please see attached database in 2003 format. mithani

hi neileg, Please help me with my query. Thanks a lot mithani

Hi Neileg, Please see attached four tables : tblInvoiceParent & tblInvoiceChild (Puchase transactions) Project (name of projects) Project_cost (project budget detail) I have made one query "master Query". What I need in my Master Query, All detail from table "Project_cost" All purchase...

Thank Neileg, Lets assume I have table Master Code Cost with Expense code & totalpurchase fields. I am running a query based on master code cost and transaction(for totapurchase) table. Now what I am looking for is, when I run query, should get one line of each code cost. like Code Cost...

Hi neileg, See the attached shot. At the end is a report which I need. thanks for your help. mithani

Dear neileg, You are right, thats what I am looking for. How would I summraize transcations and enter in master quiery. Let's say I made query based on Project Master code and coloum Total purchase need to be calculated from transcation table. Would you please give me a clue how to do it...

Hi all, Is there any way in Access, when I change Paper size of my report from A4 to A3, report fit automatically in A3 page. Any Idea. mithani

Dear all, I have a table "Project Master Code", contains: Project code, Cost Code, Description, Budget Amount, Total Purchase, Left to Complete. For each project, we enter all above field except Total Purchase. Total Purchase to be taken from Transaction table. What I want is that, I want to...

Hi Ajetrumpet, Data in subform is a standard combination of a construction drawing. I want subform data to be copied as well. I think the best way to do this through recordset. What do you say. thanks a lot mithani

Hi ajetrumpet, Only one subform is there. Drawing # is a primary key. Please correct me if I am wronge, you mean instead of working directely with table, should set recordset. So when I make duplicate and change primary key, should press SAVE buttton to save in my table. If this is a case, do...

guys any help

Thank you ajetrumpet mithani

Hi missinglinq, When I press duplicate button, error comes "The changes you requested to the table were not sucessful because they would create duplicate value in the index......." Even if I change primary key first and than press duplicate button, still same error comes. Any idea. Hi...

Hi all, I have made one query based report. In my report I want data should be ordered by Expenses_Code_num. So simply I have mentioned Expenses_code_num in Order coloumn. When I run report, getting error. Please have a look attached jpg error. Please advice me. Mithani

Hi ajetrumpet Thanks for your reply mate. We have several projects and what I am looking for is to save same templates. Whenever I get a new project, I can call my old saved template and change project name, quantity, sizes and save as a new record. I am not very good with access. I would...

thanks ajetrumpet, will this help me with? 1. Call my saved record, 2. accmdcopyrecord, 3. press new record button 4. accmdpaste 5. change project code and save. Any sample form... Thanks a lot. mithani

Hi all, I tried a lot but couldn't figure it out. I have a form with subform. I can saving my record and recall for edit purpose. What I am looking for, when I call any saved record, I want option for SAVE AS. Means I can keep all information same but make some changes and save as a new...

Hi, To make it more clear, I would like to use this code: IIF([calculation]<>0,(totalpurchase: [tblInvoiceChild].[quantity]*[tblInvoiceChild].[unitrate]),0) but not working. Any help mithani