User Profile

Collapse

Profile Sidebar

Collapse
iheartvba
iheartvba
Last Activity: May 31 '11, 01:35 AM
Joined: Apr 8 '07
Location: Sydney, Australia
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • iheartvba
    started a topic Outer Right Join on SubQuery
    in SQL Server

    Outer Right Join on SubQuery

    Hi Everyone,

    I am new to SQL Server, but have played around with MS Access a fair bit.

    I am currently trying to create an Outer Right Join on a Table and Query in SQL Server. Heres query from Access Query builder below:

    Code:
    SELECT tblPhone.custID, NotMobile.CustMoreThanMob
FROM NotMobile RIGHT JOIN tblPhone ON NotMobile.CustMoreThanMob = tblPhone.c_uid
WHERE (((NotMobile.CustMoreThanMob) Is Null))
    ...
    See more | Go to post
    Last edited by NeoPa; May 31 '11, 10:56 PM. Reason: Fixed CODE tags problems
    • iheartvba
      replied to Allow users to change Back Ground Color in Access
      in Access
      I understand what you are saying, the only reason I want to do this is so each user has a different color associated with their forms. This will ensure that when they log on to the database they haven't accidently logged on with the wrong username, as they will see a different color if they log in with another user name (I don't like to use passwords because people forget the password). Probably simpler for me to choose schemes for each user.
      See more | Go to post

        Leave a comment:

      • iheartvba
        started a topic Allow users to change Back Ground Color in Access
        in Access

        Allow users to change Back Ground Color in Access

        Hi How can I make a user panel where they can choose a color for all the forms in an Access database.

        I have made a table with all the user names and it has a field for color which can store their desired color.

        I don't however know how to allow them to choose a color themselves.

        Thanks
        See more | Go to post
        • iheartvba
          replied to Issue with connecting to SQL Server
          in Access
          Well actually, I don't mind using windows authentication, I am only using SQL Authention because otherwise the client app (also on the lan) isn't able to connect to the SQL server.

          Another thing which may clarify a few things is that the access front end which is on the local machine hosting the SQL Server doesn't give any issues, but I don't really know what to make of that...

          My mind is just boggled, and I need to...
          See more | Go to post

            Leave a comment:

          • iheartvba
            replied to Delete Query Not Working after Upgrading To SQL Server
            in Access
            its working

            1. I have changed [Delete] to [Del]
            2. I have changed the first line to
            Code:
            DELETE tblCollections.*
            3. but the thing that actually made it work was changing the last line to
            Code:
            WHERE (((tblCollections.Del)<>0));
            strange :S

            Thanks Guys
            See more | Go to post

              Leave a comment:

            • iheartvba
              started a topic Issue with connecting to SQL Server
              in Access

              Issue with connecting to SQL Server

              Hi,

              I am trying to connect to an SQL Server Express 2005 Back End with an Access mdb front end. I realise mdb's are not the best to link to a SQL Server.

              Reasons for not using an adp file: not able to transfer my queries from the mdb to the adp file.

              Attempt to use accdb file: I tried to convert the mdb to an accdb file but the same error (listed below) also occured with the accdb file, so I suspect...
              See more | Go to post
              • iheartvba
                replied to Delete Query Not Working after Upgrading To SQL Server
                in Access
                Well, This had been created from Access Query builder, and you're right, I thought the same thing, but suprisingly it did work. I will try your other suggetions, hopefully they might work.

                Thx
                See more | Go to post

                  Leave a comment:

                • iheartvba
                  started a topic Delete Query Not Working after Upgrading To SQL Server
                  in Access

                  Delete Query Not Working after Upgrading To SQL Server

                  Hi,
                  I have upgraded to SQL Server Express 2005 and now my Delete Querey which was made in MS Access Query Builder is not working. It doesn't give any error it just doesn't work:

                  If its of any use the SQL in the query is :
                  Code:
                  DELETE tblCollections.MDCollectionID, tblCollections.Delete
FROM tblCollections
WHERE (((tblCollections.Delete)=-1));
                  Any Help Would be Greatly Appreciated, I...
                  See more | Go to post
                  • iheartvba
                    started a topic Line Graph comparing years Collections
                    in Access

                    Line Graph comparing years Collections

                    Hi,
                    I have a line graph which shows monthly sales, on the vertical axis it has the amount markers and on the horizontal axis it has month markers formatted in "yy/mm" format. The line shows the actual amount of sales for that "yy/mm" period. What I would like to do, is only have months on the horizontal axis, and have a different line for each year.

                    The underlying query is as follows:
                    Code:
                    SELECT Sum(tblCollections.CollectionAmt)
                    ...
                    See more | Go to post
                    • iheartvba
                      replied to Linking a Picture to an Access Report
                      in Access
                      Thanks Adezzi,
                      as always an easy to understand procedure that did exactly what I wanted.

                      Your help is much appreciated.
                      See more | Go to post

                        Leave a comment:

                      • iheartvba
                        replied to Linking a Picture to an Access Report
                        in Access
                        Hi ADezii,
                        From absolute path I assume you mean a text string. My code also works with an absolute path, the reason I had used a hyperlink was because it allowed the user to change the path by browsing windows explorer rather than copying and pasting the path into the table. Is there a way I can still allow the user to specificy the path to the picture by browsing windows explore using the method you have given.

                        Thanks
                        See more | Go to post

                          Leave a comment:

                        • iheartvba
                          started a topic Linking a Picture to an Access Report
                          in Access

                          Linking a Picture to an Access Report

                          Hi,
                          I am trying to link a picture to an access report as follows:
                          1. The location of the Picure is stored as a hyperlink field in a table
                          2. The On Load Event of the report triggers the following code"

                          Code:
                          Private Sub Report_Load()
Set cnn = CurrentProject.Connection
'Table containing Logo Path
rst.Open "tblClientDetails", cnn, adOpenDynamic, adLockBatchOptimistic
    With
                          ...
                          See more | Go to post
                          • iheartvba
                            replied to Calling Windows Application and Executing tasks within Application
                            in Windows
                            Hi Studlyami,
                            thanks for the response,
                            1. I would like the program to open via a proceedure in MS Access i.e. so practically I would have a button on a form, which causes the program to open
                            2.I would like to have the key strokes simulated in the program itself, without me having to run a macro etc in the program. So after clicking 1 button the program should open and the key stokes should be simulated.

                            Thanks
                            See more | Go to post

                              Leave a comment:

                            • iheartvba
                              started a topic Calling Windows Application and Executing tasks within Application
                              in Windows

                              Calling Windows Application and Executing tasks within Application

                              Hi,
                              I have an application which I would like to firstly open Automatically, and secondly after the application has opened it should execute certain commands within the opened application automatically.

                              I would like to give the command explained in the above paragraph through MS Access and from experience MS Access VBA talks to Windows quite well. If there is a way to do this without VBA that's fine as well

                              So...
                              See more | Go to post
                              • iheartvba
                                replied to Running VBA code at a certain Time
                                in Access
                                Hi MaGo,
                                There are probably many ways to do it. But I just drag and drop the Icon for the Relevant Macro to the desired location.

                                All the best
                                See more | Go to post

                                  Leave a comment:

                                • iheartvba
                                  replied to Forms Slow to Save and go into Design View
                                  in Access
                                  I Found the reason my DB was slow to go into design view. It was because I had a network printer set as my default printer!
                                  See more | Go to post

                                    Leave a comment:

                                  • iheartvba
                                    replied to Forms Slow to Save and go into Design View
                                    in Access
                                    Thanks,

                                    P.S. You guys are doing a great job here, no other forum even comes near bytes.
                                    See more | Go to post

                                      Leave a comment:

                                    • iheartvba
                                      replied to Forms Slow to Save and go into Design View
                                      in Access
                                      Hi Guys,
                                      First to MegaLog's Post # 35. Thanks MegaLog, now I know how to check if the Back End is corrupt fortunatley I have never encountered a corrupt back end (knock on wood)
                                      Now to ChipR & NeoPa. Thanks Guys that's brilliant, that will keep me out of mischief for a while. I will have a look at the code and try it out a bit later stage as something urgent has popped up.


                                      Your help is very much appreciated...
                                      See more | Go to post

                                        Leave a comment:

                                      • iheartvba
                                        replied to Forms Slow to Save and go into Design View
                                        in Access
                                        Control (FE) get's the corruption, but I'm not sure whether that's during use or during designing (probably designing in my opinion)

                                        I do however want to Compact and Repair the BE on a regular basis as well.

                                        I'm not very good at knowing when a database is corrupt

                                        Sorry, I couldn't identify a corrupt database if it offered me a bribe!
                                        See more | Go to post
                                        Last edited by iheartvba; Sep 2 '09, 01:36 PM. Reason: more info

                                          Leave a comment:

                                        • iheartvba
                                          replied to Forms Slow to Save and go into Design View
                                          in Access
                                          Hi NeoPa,
                                          I see where you're coming from until getting scheduler to rum the CMD file which open access, and the Access checks it's parameter when it opens, but I don't know how then the Compact and repair would be initiated programatically .

                                          Thanks
                                          See more | Go to post

                                            Leave a comment:

                                          No activity results to display
                                          Show More
                                          Working...