Recent content by vassa

  1. V

    select query based on 2 tables

    Thank you very much, vbaInet! I actually messed with Join Properties prior to posting here, it didn't work for me in the first plce because my actual query contains a lot of tables with one-many relationship and access was giving me an error "SQL statement can not be executed because it contains...
  2. V

    select query based on 2 tables

    SELECT tblProposalNew.* FROM tblProposalNew INNER JOIN tblOffsetWell ON tblProposalNew.ProposalID = tblOffsetWell.ProposalID; tblProposalNew is the "One" table and tblOffsetWell is the "Many" table. Thank you!
  3. V

    select query based on 2 tables

    Hello! I have a Select Query based on 2 tables with one-many relationship, let's call one table "One" and the other one "Many" based on the sides of the relationship. How to make this query to return all records from the "One" table even if the "Many" table doesn't have related records? Right...
  4. V

    Selecting and inserting records into the same table

    Yes, it looks a lot better. Far more concise. I'll be using a continuation character more now. Reassigning to a string I learnt from the book' VBA for dummies'. Thanks once again for the help, vbaInet.
  5. V

    Selecting and inserting records into the same table

    I figured it out! Thank you for pointing me in the right direction. InsertSQL = "INSERT INTO tblRA ( [ProposalID], [ProductID], [ProductConc], [Stage], [Description], [Volume])" InsertSQL = InsertSQL + " SELECT tblRA.[ProposalID], tblRA.[ProductID], tblRA.[ProductConc], " & NewValue & ""...
  6. V

    Selecting and inserting records into the same table

    Here is what I have so far. I can't figure out how to pass the variable (& NewValue &)to be placed by Append Query into the stage number. PLus I need to pass another variable for tblRA.[ProposalID]), right now for simplicity it is set to 1. I am getting error: "Number of query values and...
  7. V

    Selecting and inserting records into the same table

    vbaInet, thank you for the fast reply, I will give it a try and report back.:)
  8. V

    Selecting and inserting records into the same table

    Hi! I have a table with a few columns. I am trying to write a code which would select certain records from the table an then append all these same records into the same table with only one column values changed (column: StageNumber). The reason for this: I have a form with several subforms...
  9. V

    Code strategy

    Decided to redo the db structure Thanks a lot for the compliment. I built everything myself from my idea. To be honest I knew nothing about Access and VBA until about 2 months ago. But I wanted to learn a new skill and read 2 books: one on Access 2003 and another one "Access VBA Programming...
  10. V

    Code strategy

    For some equipment categories with just one Calibration Type (or ID) I have forms with continuous view like this. My idea was to create a nice switchboard which user would use to navigate to all these different Equipment category forms
  11. V

    Code strategy

    Scrolldown view
  12. V

    Code strategy

    Here is how I wanted it. User can toggle on/off different Cal_IDs. With one table I will need to set some type of filters on these forms so when the user flips thru records he could see just units from this particular equipment category (in this case consistometer). I am not very concerned with...
  13. V

    Code strategy

    c_smithwick, thank you for the code, it's great for the second part of my task! But is there any way to automate "collecting data into tblData"? I'd like the code to collect that data by itself. Thanks again for your time.
  14. V

    Code strategy

    Not sure what you mean since rows constitute different records, please elaborate a bit more.
  15. V

    Code strategy

    I just counted the number of columns for my biggect Category calibration table - 126 columns! Most of those columns are irrelevant to other categories. I don't know what Access limit for the max number of columns per table, but I am sure I will be pushing it if I try to drop all 12 tables into...
See more
Top Bottom