User Profile

Collapse

Profile Sidebar

Collapse
jadeverell
jadeverell
Last Activity: Feb 12 '08, 11:46 AM
Joined: Jan 2 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • jadeverell
    replied to Query Problem - Help!
    in Access
    Hi again,

    Thank you all for your help on this.
    I have decided to take the UNION approach but have been having some problems over the weekend trying to create this as there are so many calculations involved.

    I have been using the following code, but the results are not displaying as i would expected....
    Code:
    SELECT  Tbl_Supplier.[Supplier Name], Sum(Nz(Tbl_Contract_Maintenance.[Value of Contract],0)) AS [Value
    ...
    See more | Go to post

      Leave a comment:

    • jadeverell
      replied to Query Problem - Help!
      in Access
      Hi rabbit, This is actaully the case, even though the two types of contracts have similar fields, the majority of them are unique to the type of contract.

      Therefore is it best to join a few quieries using UNION statements?

      What would be the most logical way to do this? hummmm

      Thanks all for your help.

      JD...
      See more | Go to post

        Leave a comment:

      • jadeverell
        replied to Query Problem - Help!
        in Access
        Hi fish,

        I think you are right, i have noticed that a few of the other calculations are wrong. Do you know what the correct join should be?

        Thanks...
        See more | Go to post

          Leave a comment:

        • jadeverell
          replied to Query Problem - Help!
          in Access
          Can anyone else shed any light on this problem?

          Thanks

          JD
          See more | Go to post

            Leave a comment:

          • jadeverell
            replied to Query Problem - Help!
            in Access
            Yep.

            Thanks
            JD....
            See more | Go to post

              Leave a comment:

            • jadeverell
              started a topic Query Problem - Help!
              in Access

              Query Problem - Help!

              Hi,

              I am having a slight (but very annoying) problem with a query I am trying to create. I will try to explain what I am doing as best I can……

              I have 3 tables, one is Maintenance contracts, one is for General Contracts and the other is a suppliers table.
              The two contracts table link to supplier by Supplier ID. A supplier can supply both a general contract and a maintenance contract.

              I am trying...
              See more | Go to post
              • jadeverell
                replied to Prompt to Save?
                in Access
                Hi Jim,

                I am using version 2003.

                The problem is, when i amend data in a table (maybe for test reasons) or edit the SQL within a query and go to close it it saves my changes automatically, even though i didn't want to save......very annoying also! :O)

                Thanks
                See more | Go to post

                  Leave a comment:

                • jadeverell
                  started a topic Prompt to Save?
                  in Access

                  Prompt to Save?

                  Hi,

                  I have noticed that when i am editing an object within my database, specifically a query and click to close it, it doesn't prompt me to save the changes and does it automatically. There have been cases where i do not want to save the changes and just wanted to know if there was a simple setting to turn off automatic saves??

                  Thanks

                  James
                  See more | Go to post
                  • jadeverell
                    replied to Requery Question
                    in Access
                    Jim,

                    You are a gentleman! Thank you ever so much for your help.

                    I have finally got it to work, and have managed to simplify it slightly.

                    Cheers.

                    James
                    See more | Go to post

                      Leave a comment:

                    • jadeverell
                      replied to Requery Question
                      in Access
                      Thanks for all your efforts Jim.

                      I look forward to hearing from you.

                      Cheers

                      James
                      See more | Go to post

                        Leave a comment:

                      • jadeverell
                        replied to Requery Question
                        in Access
                        Hi Jim,

                        Thanks for your quick response. The logic seems to make sense by using a pointer, but i cant understand the difference between setvalue / Gotocontrol & FindRecord options.
                        I have aprrox 200 records, but the primary key isn't simply 1-200, one record might have a primary key of 34A-7, so when i tell the macro to either go to or find =[Primary Key] its says that no record exists?

                        Is there any chance...
                        See more | Go to post

                          Leave a comment:

                        • jadeverell
                          replied to Requery Question
                          in Access
                          Can anyone help with this? If they need me to explain to problem clearer please let me know.

                          thanks
                          See more | Go to post

                            Leave a comment:

                          • jadeverell
                            started a topic Requery Question
                            in Access

                            Requery Question

                            Hi,

                            I have a form which contains some dates and some calculated fields based on these dates e.g. Days until contract expires (difference between today and contract end date) etc....I also have an update button that re-calculates the derived fields if the dates are manually changed.

                            The update button has the following macro behind it:

                            SetWarnings
                            Requery
                            OpenQuery
                            OpenQuery (update...
                            See more | Go to post
                            • jadeverell
                              started a topic Automated Emails
                              in Access

                              Automated Emails

                              Hi,

                              I have a database that contains a list of contracts including the dates they are due to expire and i was wondering if Access can be set up to send an automated email to an email address that contains a report of Contracts that are due to expire.

                              I know how to set up the email function and do it manually, but is there a way for access to send the email automatically, even if a user is not logged into the database....
                              See more | Go to post
                              • jadeverell
                                started a topic SUM & Count
                                in Access

                                SUM & Count

                                Hi,

                                I am trying to perform a calculation that adds together two 'Counts' (on seperate tables) to give a total value.

                                The code for the two counts is:

                                Count(Tbl_Contr act_Maintenance .[Supplier ID]) AS [No of General Contracts], Count(Tbl_Contr act_General_Hea d.[Supplier ID]) AS [No of Maintenance Contracts]

                                I thought that i might have been able to use the 'Sum' Function in an expression like...
                                See more | Go to post
                                • jadeverell
                                  replied to Query Calculation
                                  in Access
                                  I have tried that, but it keeps reporting a syntax error (missing operator) in query expression.

                                  at the moment my code looks like:

                                  SELECT Tbl_Supplier.[Supplier Name], Sum(Nz(Tbl_Cont ract_Maintenanc e.[Value of Contract],0)) AS [Value of Maintenance Contracts], Sum(Nz(Tbl_Cont ract_General_He ad.[Value of Contract],0)) AS [Value of General Contracts], Sum((Iif(isnull ([Tbl_Contract_Ma intenance].[Value of Contract],0,[Tbl_Contract_Ma intenance].[Value...
                                  See more | Go to post

                                    Leave a comment:

                                  • jadeverell
                                    replied to Query Calculation
                                    in Access
                                    Hi,

                                    Thanks for your reply, it makes sense, but a little unsure which part of the code i should be replacing.

                                    Thanks...
                                    See more | Go to post

                                      Leave a comment:

                                    • jadeverell
                                      started a topic Query Calculation
                                      in Access

                                      Query Calculation

                                      Hi,

                                      I am trying to create an expression within a MS Access Query, but am having some issues.

                                      I am using the following code to add together two values from 2 tables. But the problem is that if a value is not available from one table it is not included in the calculation and there for being displayed as a null.

                                      SELECT Tbl_Supplier.[Supplier Name], Sum(Nz(Tbl_Cont ract_Maintenanc e.[Value of Contract],0)) AS...
                                      See more | Go to post
                                      • jadeverell
                                        started a topic Send an Automated Email
                                        in Access

                                        Send an Automated Email

                                        Hi,

                                        I have a database that contains information of contracts / tenders and need to do the following task:

                                        * when a contract reaches its expiry date, i want to send an automated email to notify the Account manager.

                                        I have a query/form that displays all the expired contracts but wanted to add some 'automation' into it.

                                        Any advice would be much appreciated.

                                        Also, if the Access...
                                        See more | Go to post
                                        No activity results to display
                                        Show More
                                        Working...