User Profile

Collapse

Profile Sidebar

Collapse
BarbQb
BarbQb
Last Activity: Aug 28 '14, 11:36 PM
Joined: Oct 3 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • BarbQb
    started a topic How Do I Make a Rank Query wih Multiple Criteria?
    in Access

    How Do I Make a Rank Query wih Multiple Criteria?

    Hi All,


    I am working on a ranking Items in a query and I am stuck when I need to take more fields into account for the rank.


    Currently I have a query that ranks [Location] by the [Date] they were entered for each [Item]. We have multiple locations for each item so the earliest date gets ranked 1 for each [Item]


    The SQL below works pretty well so far:

    Code:
    SELECT a.Company, a.Item,
    ...
    See more | Go to post
    • BarbQb
      started a topic Having trouble with filter on multi-select listbox
      in Access

      Having trouble with filter on multi-select listbox

      Hi All,

      I am having trouble filtering a report with a multiselect list box. The report is generated, but it is not filtered based on the selections of the list box:

      lstVehID
      Multi Select Simple
      Row Source Type Table/Query
      Row Source SELECT qryVehicle.Vehi cle, qryVehicle.[RBL Status] FROM qryVehicle ORDER BY qryVehicle.Vehi cle;


      Users enter their information into form: ...
      See more | Go to post
      • BarbQb
        replied to How can I find the week ending date?
        in Access
        Thank you very much, NeoPa. I will let you know how it works.
        See more | Go to post

          Leave a comment:

        • BarbQb
          replied to How can I find the week ending date?
          in Access
          Thanks NeoPa. I think I jumped ahead of myself when I said I wanted to change the column titles in the Query. I definitely had an idea in my head that will not be plausible.

          But, I do understand and agree that it will be beneficial to figure out the Week Ending Dates within the report.
          See more | Go to post

            Leave a comment:

          • BarbQb
            replied to How can I find the week ending date?
            in Access
            Sorry about that.

            I would like for the column titles to be the W/E date and not Sched01, 02,... I am just working with a query right now. Eventually I will put it into a report.
            See more | Go to post

              Leave a comment:

            • BarbQb
              replied to How can I find the week ending date?
              in Access
              NeoPa-

              The table contains product production by week.

              One record is product X and the Production Amount in the following 42 weeks (columns Sched01-Sched42), but I am only interested in the first 15 weeks (columns Sched01-Sched15).

              There is no history in the table. Sched01 is always the current Week Ending Date.

              I would like to show everything that is being produced in each of the 15 weeks,...
              See more | Go to post

                Leave a comment:

              • BarbQb
                started a topic How can I find the week ending date?
                in Access

                How can I find the week ending date?

                Hi All,

                Edit:

                I currently have table where I need to find the Week Ending date for a rolling 15 weeks, where each week is a separate column. It goes from Sched01 - Sched15.

                The Sched01 column is always the current Week Ending Date (Saturday). However, if a month ends on any other day but Saturday then I need the month end date to be the Week Ending Date.

                For example as of 7/22/2011:
                ...
                See more | Go to post
                • BarbQb
                  replied to Select blank line in multiselect list box and retrieve related data
                  in Access
                  Thanks ADezii. You are a lifesaver. I just tested it out and it works perfectly.
                  See more | Go to post

                    Leave a comment:

                  • BarbQb
                    started a topic Select blank line in multiselect list box and retrieve related data
                    in Access

                    Select blank line in multiselect list box and retrieve related data

                    Hi All,

                    I currently have a form with a multiselect list box that shows Vehicle IDs (Column 0) and Vehicle Statuses (Column 1) by customer. The VehicleID column is the bound column. Occasionally the VehicleID is blank for the customer, but there is associated data with it that can be retrieved (the Vehicle Status is not blank). However, when I select the blank line in the list box I can not populate the query/report related to that...
                    See more | Go to post
                    • BarbQb
                      replied to How to set Primary Key with VBA?
                      in Access
                      Thank you very much for the code. Will this work for a Composite Primary Key? I forgot to mention that the PK consists of 3 fields.
                      See more | Go to post

                        Leave a comment:

                      • BarbQb
                        started a topic How to set Primary Key with VBA?
                        in Access

                        How to set Primary Key with VBA?

                        Hi All.

                        I was wondering if there was a way to set the primary key of a table with VBA? I have a make table query that runs, however when it creates the table it does not set a primary key. I would like to do this with VBA instead of manually.

                        Any help would be great. Thanks.
                        See more | Go to post
                        • BarbQb
                          replied to Find a record with more than 1 primary key
                          in Access
                          NeoPa - I will post the different variations of the code that I actually used.

                          The 3 fields of the Primary Key are CorpID, ProductID and ShipToID

                          I have attached the DB. Any comments and advice are appreciated....
                          See more | Go to post

                            Leave a comment:

                          • BarbQb
                            replied to Find a record with more than 1 primary key
                            in Access
                            dsatino - Thank you for still having an interest in this. I haven't had a chance to work on the DB today, but I will post it as soon as I can.

                            NeoPa - Thanks for all of your help so far. I did try the code that you suggested, but it did not seem to make a difference.
                            See more | Go to post

                              Leave a comment:

                            • BarbQb
                              replied to Find a record with more than 1 primary key
                              in Access
                              NeoPa - Thanks for letting me know. I will be more clear next time.

                              dsatino - Thanks for responding. I definitely used the wrong terms when I asked my question. My primary key is 3 fields, and my form has the correct parent/child but it still is not giving me the correct record.
                              When I choose a Customer from ComboBox1, it filters the ProductID's in ComboBox2, which filters the subform. The problem is when there are two of...
                              See more | Go to post

                                Leave a comment:

                              • BarbQb
                                replied to Find a record with more than 1 primary key
                                in Access
                                Is the problem really obvious and I'm just not getting it? Or does no one know how to do this?
                                See more | Go to post

                                  Leave a comment:

                                • BarbQb
                                  started a topic Find a record with more than 1 primary key
                                  in Access

                                  Find a record with more than 1 primary key

                                  Hi All.

                                  I am working with a form to lookup records in one of my tables. The table has 3 primary keys and is not pulling up the records correctly.

                                  Form1 is bound to Table1 (a list of Customers and CustomerID's) ComboBox1 looks up the Customer.
                                  Code:
                                  SELECT tblCustomers.CorpID, tblCustomers.Customer 
FROM tblCustomers 
ORDER BY tblCustomers.Customer;
                                  SubForm2 is bound to Table2 (list of Products by...
                                  See more | Go to post
                                  Last edited by NeoPa; Oct 28 '10, 05:38 PM. Reason: Adding extra CODE tags.
                                  • BarbQb
                                    replied to How to use Mod 11
                                    in Access
                                    ADezii - Sorry if I'm being obtuse, but how does the query reference the function ISBN_10()? Where should I have the function? Right now I have it in the VBA module for FormISBN, but the code works just for that form.
                                    See more | Go to post

                                      Leave a comment:

                                    • BarbQb
                                      replied to How to use Mod 11
                                      in Access
                                      ADezii - Thank you again. This is really above and beyond :) I do have one question: I have this fucntion as a check for new records, but I would like to run a query that would calculate the checkdigit in my existing tables. How would I incorporate this Function in query?
                                      See more | Go to post

                                        Leave a comment:

                                      • BarbQb
                                        replied to How to use Mod 11
                                        in Access
                                        Thank you both so much. I really appreciate your help with this problem. I realize now I was missing a key step. 11 - CDSubtotal Mod 11

                                        OldBirdman - sorry I wasn't specific before about the problem I was encountering.

                                        ADezii - thank you for the code. I will try it out as soon as I can.
                                        See more | Go to post

                                          Leave a comment:

                                        • BarbQb
                                          replied to How to use Mod 11
                                          in Access
                                          OldBirdMan - I tried that and it still isn't working properly.
                                          See more | Go to post

                                            Leave a comment:

                                          No activity results to display
                                          Show More
                                          Working...