User Profile

Collapse

Profile Sidebar

Collapse
drago
drago
Last Activity: Aug 6 '07, 11:28 AM
Joined: Jul 12 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • drago
    replied to Storing Values in database using Forms
    in Access
    great...so now for example if iam calculating values on the form taking some values from database like

    attribute A= 90 - want to save in the database
    attribute B=30 - want to save in the database
    attribute Total= A-B = 60 - this calculated value i want to save in the table

    please dont be mad at me as iam trying my best... iam new to this......
    See more | Go to post

      Leave a comment:

    • drago
      replied to Storing Values in database using Forms
      in Access
      Thanks for your reply. Amm... so form are used just to view records. Thats fine. Suppose if I want to store values (not edit) in database using an interface. What should i do then. For example what i mean is if u enter name, dob, address in 3 different text fields it goes in to the database and create a new record.
      I hope this will help u....
      See more | Go to post

        Leave a comment:

      • drago
        replied to Storing Values in database using Forms
        in Access
        Hi again, thanks for moving this question to forum section :). Sorry about that as iam still learning the forum life style which is very helpful.

        I have created an invoice table with attributes invoiceID(invoi ce number), item_price (price), no_of_units(Num ber of units), Weekly_Total, start_date, end_date, Days, Monthly_Total(t otal amount)


        I have to input data in the database table manually, except the fields...
        See more | Go to post

          Leave a comment:

        • drago
          started a topic Storing Values in database using Forms
          in Access

          Storing Values in database using Forms

          Hello guys again! Back with invoice problems. Just want to know how to store data in the main database in different tables and fields using a form. I have a datasheet view of a form where i have to show ;

          Code:
          invoice number                      (INPUT) 
price                                     (INPUT)
No. of units                            (INPUT),
Weekly Total          (calculated by =[no_of_units]*[price])
          ...
          See more | Go to post
          • drago
            replied to Query-Automatization Problem
            in Access
            Hi :)... the error #Name? means that Access is not getting the field name in your exprssion. Check for any spelling mistakes,name of the field and control name (should be different) if you using any expression check the brackets done properly or check if you have an equal "=" sign at the start of theexpression.

            Best of luck...

            Majid Awan...
            See more | Go to post

              Leave a comment:

            • drago
              replied to To find total from generic column values in subform and displaying it in main form
              in Access
              :) ok this time its not complex like me. If I have to add all values in the same column of a subform what do I have to do?
              See more | Go to post

                Leave a comment:

              • drago
                replied to To find total from generic column values in subform and displaying it in main form
                in Access
                Is it possible in Access?
                See more | Go to post

                  Leave a comment:

                • drago
                  started a topic To find total from generic column values in subform and displaying it in main form
                  in Access

                  To find total from generic column values in subform and displaying it in main form

                  Hi guys, I will be quick this time... Just want to know how we can calculate generic values in the same column. I am using invoice form with a services subform . I have a column of 'total' in subform and I want to add all values of that column to get the total cost on main invoice form. The 'total' column contains service cost of different clients. Some clients have 1 service i.e 1 total which is the total cost but most clients have more then 1 services...
                  See more | Go to post
                  • drago
                    replied to Calculating days!
                    in Access
                    Hi ADezii, sorry about that... its just iam new to access and trying to work out what i can... Sorry about that :)...
                    See more | Go to post

                      Leave a comment:

                    • drago
                      replied to Calculating days!
                      in Access
                      (whispering)..H ello?
                      See more | Go to post

                        Leave a comment:

                      • drago
                        replied to Calculating days!
                        in Access
                        Hi fellows! Me back. I tried the later code, when i run it, it says "Data type mismatch in criteria expression". Iam sorry, I should have told you guys earlier about my Access , so it Ms Access 07 using vista 07.

                        I have few queries which run fine. They are:

                        1. The result of this query will allow invoice system to use invoice start date and end date.

                        SQL code:
                        SELECT Invoice.invoice _from_date,...
                        See more | Go to post

                          Leave a comment:

                        • drago
                          replied to Calculating days!
                          in Access
                          Hi Adezii thank you very much for your help. I have created queries now i will try to create the logic which you have written... I will send you the feedback once its working or working...
                          Thanks again :)
                          See more | Go to post

                            Leave a comment:

                          • drago
                            replied to Calculating days!
                            in Access
                            Guys thank your for your prompt replies...u ppl are amazing...let me try what MTB and Kepston have suggested...I will get back to you soon. If you ask me I can see the hurdle here... Now each client have 1 or more than one contracts and for that I am using a subform in invoice form... so at the moment it is bringing all the contract records related to the selected client by using the invoice ID...the calculation is done on the sub forms.... Anyway...
                            See more | Go to post

                              Leave a comment:

                            • drago
                              started a topic Calculating days!
                              in Access

                              Calculating days!

                              Hi guys, good to be here... I am struggling to calculated days in invoice system...Ok...T he dates fields are of two kinds...One is the invoice start date and end date... The other one is the contract start date and end date...I have to calculate days of charging according to the dates involved...
                              Suppose INVOICE start date: 01-01-07; INVOICE end date: 31-01-07

                              Conditions are:

                              1. IF the contract start date...
                              See more | Go to post
                              No activity results to display
                              Show More
                              Working...