User Profile

Collapse

Profile Sidebar

Collapse
Jinzuku
Jinzuku
Last Activity: Jun 14 '12, 02:47 PM
Joined: Feb 17 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Jinzuku
    started a topic Conditional Where clause using SQL in Access
    in MySQL

    Conditional Where clause using SQL in Access

    Hi all,

    Here is my situation. I've got 3 combo boxes that are used to filter data from my main database. These are Organisation Name, Contract Type and Branch Name.

    Under normal circumstances that's easy to do, however there is another constraint. There are 3 contract types, 1 of them (Type A) requires all 3 fields to be populated and searched upon. However if it's any of the other 2 (Type B and C) then it must search...
    See more | Go to post
    • Jinzuku
      replied to Converting number to text for concatenation
      in SQL Server
      Thanks all for your help but I've managed to figure it out. The reason I was having issues was because I was trying to convert them to char or varchar, but what I really needed to convert them to was nvarchar and then concatenate them.

      Still not overly sure what the difference between varchar and nvarchar is but at least it works :D
      See more | Go to post

        Leave a comment:

      • Jinzuku
        started a topic Converting number to text for concatenation
        in SQL Server

        Converting number to text for concatenation

        Hi all,

        I'm trying to create a unique identifier field in my table but the two fields I'm trying to concatenate are numbers.

        When I write "nhsnumber + diffdate as a_sid" it tries to add the fields together rather than concatenating them.

        I've tried converting them into varchars and chars and it's still doing the same thing.

        How can I convert these to text so that they can concatenated?...
        See more | Go to post
        • Jinzuku
          replied to Running total in a form using a SQL Statement and tables
          in Access
          Excellent, that worked like a charm.

          Thanks TheSmileyCoder, you've now made me smile too :D

          Sunny
          See more | Go to post

            Leave a comment:

          • Jinzuku
            replied to Running total in a form using a SQL Statement and tables
            in Access
            I think maybe the term "Running Total" was the wrong word to use, since that tends to refer to a cumulative total.

            What I'm hoping to have is more an auto-refresh on the totals, so when more data is imported into the database the totals for each organisation will go up if they have been sent a new invoice.
            See more | Go to post

              Leave a comment:

            • Jinzuku
              started a topic Running total in a form using a SQL Statement and tables
              in Access

              Running total in a form using a SQL Statement and tables

              Hi,

              I'm trying to create a form that has a running total of the amount an organisation has been invoiced. 1 table (Database) consists of everything I've invoice out. The fields this table has is the Organisation code, name and amounts among many others.

              I also have another table (Orgs) that is a comprehensive list of organisation codes, name and a blank field (Organisation_T otal).

              I've created a form whose...
              See more | Go to post
              • Jinzuku
                started a topic Selecting a printer when printing a report using a command button
                in Access

                Selecting a printer when printing a report using a command button

                I’m trying to set up the printer button on my form, I want it to allow the user to select a printer when you try to print the report. I know that the code for this is
                Code:
                “DoCmd.RunCommand acCmdPrint”
                However, I don’t know where to fit it into the current code that automatically prints out that report:

                Code:
                Private Sub Print_Click()
On Error GoTo Err_Print_Click

    Dim stDocName As String
                ...
                See more | Go to post
                • Jinzuku
                  replied to How do I open the "Save As" window when I export my data from Access to Excel?
                  in Access
                  Excellent, thanks for that ADezii.

                  I did have to think twice about which button i wanted to press :)
                  See more | Go to post

                    Leave a comment:

                  • Jinzuku
                    started a topic How do I open the "Save As" window when I export my data from Access to Excel?
                    in Access

                    How do I open the "Save As" window when I export my data from Access to Excel?

                    Hi,

                    I'm trying to map an export function to a command button to my Access form (called Results). However, I would like it so that the "Save As" window appears when I try to export the table so that the user can select where they want to save the spreadsheet.

                    The VBA code forces you to extract to a certain place, which isn't practical for my data's intended use. I've tried using a macro but that automatically...
                    See more | Go to post
                    • Jinzuku
                      replied to How do I get a total to refresh in my Form from a Subform
                      in Access
                      Sorry again but I think I've sorted it out based on what I could understand from your suggestion. I replaced the coding in my text box to "=Forms![Main Form]![Subform]![Grand_Total]" and that has seemed to work.

                      Thanks for your help
                      See more | Go to post

                        Leave a comment:

                      • Jinzuku
                        replied to How do I get a total to refresh in my Form from a Subform
                        in Access
                        Sorry for being dumb but I don't really understand how it gets my to display the total of the data in the subform. Would any other information be useful? I'm reletively new to Access and have vitrually no knowledge of VBA.

                        I tried looking that your other article but it just went over my head.
                        See more | Go to post

                          Leave a comment:

                        • Jinzuku
                          started a topic How do I get a total to refresh in my Form from a Subform
                          in Access

                          How do I get a total to refresh in my Form from a Subform

                          Hi,

                          I've created a main form that populates a subform using 2 combo boxes, however I'm having difficulty trying to create a sum of the total amounts of the results of the population.

                          I have a Grand_Total field in my form that the subform is based on.

                          In my main form if I try to reference to the Grand_Total in the form my subform is based on then I get a #Name? error (=forms![form]![Grand_Total) and if...
                          See more | Go to post
                          No activity results to display
                          Show More
                          Working...