Search results

  1. M

    Calculation Problem (Opening Balance)

    Opening Balance on Report There is no Function to bring up opening balance on Report. i think my problem can be solved by some advance users
  2. M

    Calculation Problem (Opening Balance)

    No Can Give me a Example File No Can Give Me a example File About this Thread. i will greatly thankful
  3. M

    Calculation Problem (Opening Balance)

    Please Give Me Example File if i only want to show the opening balance in report how can i done that. i am using overall sum in Calculated Field. how can i bring up opening balance in Report. i don't need it in a Query.
  4. M

    Calculation Problem (Opening Balance)

    How Can i use the Union Query Can you give me a example file rich how can i use the union query and how can my problem can solved
  5. M

    Calculation Problem (Opening Balance)

    Please Help Me dear Aleb I am very Furstrated .i will be greatly thank full if you solve my problem please check the attach file. there is a query overallsum and a table ledger. when you open the query overallsum it ask you the date please enter 02-04-04 and 05-04-04 then a customer id.it...
  6. M

    Calculation Problem (Opening Balance)

    Thanks More Question thanks very much for your kind reply. ok . i will create the opening balance by query.i have another query which calculate the all result of ledger for customer. how can i attach the first query result.and then the second query result together. i mean in one query i am...
  7. M

    Calculation Problem (Opening Balance)

    Please Give me a Example File Dear Sir i am very furstarted .please if you can give a example file. i will be greatly thankfull to you.i think your help will solve my problem and remove my headache. i am not a advance users .please give me a attach file.
  8. M

    Calculation Problem (Opening Balance)

    Hello Dear i have a ledger report.i am using overall sum in calculated field. i want to take balance in Opening Balance Field Before The dates i have given. Example. i give two date "5-09-04"" and "8-09-04" it gives me result and it's fine. the problem is that in" Opening Balance Field" i want...
  9. M

    Stock Updation

    I want to know what is the profesional approach to update stock.i am using the learning database northwind. in orders detail i create a field which dlookup the stock. i want to know how i update my stock. update query.or any other way. please any body can refer me a sample file in which the...
  10. M

    Give me a message for duplicate record

    Just Paste This Code on Error Event If DataErr = 3022 Then MsgBox "Check this is the Duplicate Product", vbInformation, "Duplicate Value" SendKeys "{ESC}" SendKeys "{ESC}" Else Response = acDataErrDisplay End if
  11. M

    Give me a message for duplicate record

    Just Paste This Code on Error Event Just Paste this code on error event If DataErr > 0 Then If IsNull(Me.Parent!CustomerID) Then MsgBox "Select a Customer to bill to before entering order details info." RunCommand acCmdUndo Me.Parent!CustomerID.SetFocus Response = acDataErrContinue ElseIf...
  12. M

    Is this possible dynamic Changing

    i am using a button to show the product by LinkCriteria method by a subform when i select product id ""1""" it brings up it's price """"12""". and if i want the detail info i click on the product detail button.and it's give us information form.where all products detail about that productid...
  13. M

    Can Someone Correct my Error

    i have a combobox cbo which i use for search items in subform from main form invoice. where i am wrong. MY Question is i am trying this but it gives us a message that the property is not for this object. where i am wrong. i give you some detail.i have main form invoice. main form name is...
  14. M

    Where i am Wrong in Code

    No one have a solution of my problem Hello i am waiting some one help.
  15. M

    Where i am Wrong in Code

    What is The Exact Error Searh in Sub Form Version: 2002 (10.0) XP Posted on 09/28/04 10:26 AM Posted by mkkashif - Utter Access Addict Posts: 52 - Forum: Access Forms • Edit • Reply • Quote • Quick Reply • Print this post • Bookmark Post • Notify Moderator • Top of page i have a...
  16. M

    Search in SubForm

    No can Answer my Question is the my question is to much difficult no body reply me
  17. M

    Search in SubForm

    i have orders form in that i have subform ordersdetail Like """Northwind""". My Question is that i want to Search in OrdersDetail. i have a combobox SearchOrderDetail.i have my codes in that combo Box.My Sub Form ordersdetail has a Field Code. i want when i click on the SearchOrderDetail Combo...
  18. M

    Give Me Example Code For Shortcut

    Dear ,if you can give me code i will be very thankful . i have orders form in that form i have a orders detail form. in order detail form to select a single record i use the """Shift+SpaceBar""" . My Question is what code i have to put on Key Press Event.When i click ""End"" Button.it...
  19. M

    How Can I delete a Single Record in DataSheet View

    i have got the Problem i want to select a single record in the datasheet view . the way is to shift+spacebar. to select a single record. is there any way to do that by custom key. i mean to do that by my own code and by single key.is this posible. to assign the Shift+SpaceBar key with custom...
  20. M

    How Can I delete a Single Record in DataSheet View

    No Can Guide Me i think it is not answer of my question
Back
Top Bottom