Search results

  1. Infinite

    Lots of fields, or lots of tables?

    I just add some more fields to the main table, instead of creating a new table, and then having to reference to it. So just 1 giant table is good?
  2. Infinite

    Lots of fields, or lots of tables?

    Hello! I have currently 5 tables, and each one is for sales. They are as follows, tblAmazonOrders tblEcwidOrders tblVendorsMart tblEarthOutdoors tblShowSales Now, all of those are are just tables for sales, what im trying to figure out, is it okay for me to have 5 different tables, all for the...
  3. Infinite

    Quick addition problem

    SELECT tblItems.Model, Sum(tblAmazonOrders.quantity) AS SumOfquantity FROM tblItems LEFT JOIN tblAmazonOrders ON tblItems.Model = tblAmazonOrders.description GROUP BY tblItems.Model; That is the query for all 3 of those. EcwidTotal, AmazonTotal and ShowTotal. I also just checked (changed one)...
  4. Infinite

    Aliases

    OK, guess there is nothing that you can do on your end to help me. No problem, either we will have to change those names, or im on for a lot of replacing :) Either way, thank you for helping me so far! Thanks!
  5. Infinite

    Quick addition problem

    Hello, I have that. Problem I have is in the picture, its kinda weird, never had it before. Any idea what im doing wrong?
  6. Infinite

    Aliases

    Not sure why we do, but when we create a new product, we dont know the name till we think of one, so we just have random product till we name it, but we still sell random product. Because, like I said, I import the product sales, and they only have the product name.
  7. Infinite

    Aliases

    I do have that, in all the tables that I can use a ModelID I have it being used. BUT, in the table that I am referring to, I cant have a ModelID because I have to import data into that table, and what im importing from has just a name of the model, and other date, but none of it useful to what...
  8. Infinite

    Aliases

    Ok, back to square 1. The problem I have now is, I have a 22 cowboy Pistol. And I can see I have sold 200 of them. Now, if I change the 22 Cowboy Pistol to a 22 Pistol, access (and me) have no idea how many 22 Pistols I sold. So I (And I hate this to) for the time being, have to have a drop down...
  9. Infinite

    Auto insert number if year is

    @burrina I tried that, but it was really confusing me, so I just changed the GasID to the date, and I have the user just enter the date of the year if there going to be doing anything with the gas prices. Thanks for you help though!
  10. Infinite

    Auto insert number if year is

    Err....not sure how/were to use it. In a field using the builder? Or a query. Pretty sure it isn't a query. And what do I place in Me.SomeDate, Me.Somevalue and IsDate? Also, my fields for dates are ShowYear and it is a ShowYear: Format([StartDate],"yyyy") That is my field name, and as you...
  11. Infinite

    Auto insert number if year is

    Hello! I have a tblGasCost for the cost of gas, and I also have how many miles they travel, how many vehicles, and the date. I have a ID for the tblGasCost. Example. the Van traveled once, on 2/12/2012 to a show that was 20 miles away. The IRS cost per gallon for that year was $0.555, so in the...
  12. Infinite

    Aliases

    Hey, I got (I think) the aliases working. I just need to know how to tie them all to the item ID. in the Picture 1, you can see what I have for the query, but in picture 2, nothing is working.
  13. Infinite

    Option Buttons

    Question, I am trying to figure out how you did this. I can work with it, but I would like to know how, I saw you had the the Field called [Forms]![frmItems]![Frame16] and its criteria was "Is Null" and you have the other field "StatusID: Status" and its criteria is [Forms]![frmItems]![Frame16]...
  14. Infinite

    Dynamic Multi Search

    The code that opens it is a macro. The macro is in the picture. Just look at the pics, should explain what you want. Not sure what you mean by that, sorry :(
  15. Infinite

    Dynamic Multi Search

    SELECT tblItems.Model, tblItems.Price, tblItems.OnlineShow, tblItems.Category, tblStatus.Status AS StatusID, tblItems.Status, tblItems.FitPerSheet, tblItems.Wholesale, tblItemSizes.ModelWidth, tblItemSizes.ModelHeigth, tblItemSizes.ModelArea, tblItemSizes.ModelPerimiter, tblItems.ModelPicture...
  16. Infinite

    Dynamic Multi Search

    I have a quick question, when using the search code you gave me, something is not working. I have the items in my form, and I have it so when I double click, it opens up another form to edit it. But, if I have John Doe Smith and I search for Doe, and double click John Doe Smith, it opens up a...
  17. Infinite

    Option Buttons

    Thats just what I wanted, thank you very much!
  18. Infinite

    Remove Enter Parameter Value

    I would do that through VBA or Macro? And if VBA (Or macro) what is the code? If its not either of those, then were in the settings? I cant seem to find it.
  19. Infinite

    Remove Enter Parameter Value

    You mean "I'd" not "I've" ? And, how would have you done that?
  20. Infinite

    Search not working

    Just looked at that (really looked at it) and im not sure it is what I want...Would it be possible to have....Maybe another query duplicate? I know that would be a waste and I probably shouldn't do that, cause any changes to the main query I would have to change on the 2nd query also....just...
Back
Top Bottom