Search results

Hi, I am using MS excell 2007. I want to write "Customer & supplier comparison report" in header but showing "Customer supplier comparison report" without sign &. Any clue. Regards Mithani

Hello, Could you please have a look attached my database link in Crystal Report 2008. I am using two databases: MYOB Database Table : Item : List of all items Table : ItemPurchaseLines : all purchase transaction My Access Database Table : Project : List of projects Table ...

Hi everyone, What I am looking for is: Scenario 1 1. Append all records from Table 1 to Table 2. 2. Whenever any record add/edit/delete inTable 1, Table 2 should automatically upate. Scenario 2 1. How would I append all records from Table 1 to Table 2 where both tables structure are...

Hi, I am working on Accounts Statement query. I have compiled my StatementQuery which is based on two queries, purchaseQuery and invoiceQuery. If I have got one purchase order of amount $1,500.00 and we received three invoices $600 + $500 + $400, my query shows as below POno, POamount...

Hello, I am working on statement of accounts. I have a purchasing table (POno, POdate, POdescription, POAmount, .........). What I am looking for is, If I have difference amount against same POno, my query should show only one line with POno, PoDate, POdescription and POAmount(total Amount as...

Hi Everyone, I have one combo box which listing name of different screens. When I click on any item from Comobox, that screen opens. What I want is, how would I make enabled false on any item. Means as per user rights, some of the item(s) would be enabled false. Thanks Mithani

Hello, I have a simple continues form where I have two check boxes. I am trying to click check box but showing RECORDSET NOT UPDATABLE. Any clue. Thanks Mithani

Hello, Can anyone help me please. I have got my own user password screen which protect my software to use unauthorized person. What I am looking for is, I want to display username on everyscreen. How would I save a current user?. Here is a code of user password screen Private Sub...

Hi mates I am moving my head arround but couldn't figure it out. What I am looking for is when I enter user name in my login form, should save in public variable so I can call in any other form or can save in any table. Thanks for your help Mithani

HI mates, Trying to display bmp but can't figure it out. See attached screenshot. Just showing file name and something else. Can anyone please help me? Thanks mithani

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 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 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 Freinds, Can anyone please tell me that how can I use IIF function in my query? Thanks mithani

Hi mates, I want to creat menu. That should be similar to any microsoft product, like File, Edit, View, etc. I would appreciate if anyone got any sample. I tried to design but seems I am very poor with menu designing. Thanks mithani

Hi friends, I have got print button in my form. What I am doing is: DoCmd.OpenForm "remarks", acNormal DoCmd.OpenReport "Ac-report", acViewPreview, When I click my print button, form "Remarks" popups and immediately my report runs. How can I fix that when I close my "Remarks" form...

Dear Friends, I have one query based on code, rate, quantity. I created field for total (rate x quantity). What expression i can write that the query will calculate total only with the first figure as per code and if code repeats again, should not calculation total. Please see the following...

HI All, I have two tables: 1. Project Cost Project 2. Project_cost I want two things: 1. I need all data from Project Cost Project even the field "EXPENSES_CODE" from Project_cost is not availble in Project Cost Project. 2. Only include rows where the joined fields "Project_code" from...

Hi friends, Need you help. Recently I have upgraded my system from access 2003 to 2007. Few of things not really working. I have one form where I drew lines and boxes. Initally lines and boxes are disable but as soon as user enters dimensions for lines and boxes, all get visable and change...