Recent content by Cris VS

  1. C

    Is it possible to create a Find unmatched-append query?

    Hello, I have a table (OwnershipT) that has a list of ProductID and OwnerID among other fields. Both ProductID and OwnerID are foreign keys to the tables with their details. A product can be owned by different Owners and vice versa, but each pair OwnerID-ProductID is unique - no duplicates...
  2. C

    Divide code to avoid "Procedure too large error"

    Because my code consists in 4 blocks that are very similar and that use two or three loops that repeat exactly and that are quite large... so I was thinking that instead of having 4 blocks x 3 loops per block x 20 lines per loop I could call them, but I don't know how to do this call. I looked...
  3. C

    Divide code to avoid "Procedure too large error"

    It is more related to rows but I guess it's the same procedure, but could someone specify a bit more how to do it please? Thanks :)
  4. C

    Divide code to avoid "Procedure too large error"

    Hello, this sounds just like what I am looking to do but I am not sure how to as I am relatively new to VBA, could you explain how to do this or provide some kind of bibliography where I can find the details of this? Thank you
  5. C

    Solved Duplicate records changing a field with VBA

    Solved, thanks!
  6. C

    Divide code to avoid "Procedure too large error"

    I posted the code to try to show the loops that I want to separate correctly but I didn't copy all the dimming parts - in fact I wrote notes on those lines to remark that some dimensionings are missing Dim xlApp As Excel.Application Dim xlWorkbook As Excel.Workbook Dim xlSheet As Excel.Worksheet...
  7. C

    Divide code to avoid "Procedure too large error"

    Hello all, I have a giant procedure that exports a set of queries from access to excel and formats the excel sheet. A lot of code parts are repeated several times throughout the code and I would like to know if someone could explain how to take these bits out and call them somehow like if they...
  8. C

    Solved Duplicate records changing a field with VBA

    Hi, I must have done something wrong previously because now it works :) The only problem is that it takes the configurations from the event with the oldest date, not the immediate previous. How could I fix it? I have seen that in the code you added you don't use the query I used to select the...
  9. C

    Solved Duplicate records changing a field with VBA

    Yes, I created a new event by going to a blank record, made sure it was saved correctly in the table and then clicked the button, but nothing happened
  10. C

    Solved Duplicate records changing a field with VBA

    I clicked in the button but nothing happened - it just went to the first record...
  11. C

    Solved Duplicate records changing a field with VBA

    I want the user to click the button in the form to run a program that copies the previous event's configurations and pastes them with the current event's name in the same table. This way, in the current event would appear the list of configurations and the user can modify them as needed instead...
  12. C

    Solved Duplicate records changing a field with VBA

    Thanks!
  13. C

    Solved Duplicate records changing a field with VBA

    Hello all, I have a table where I register the configuration of different elements for various events. The fields of this table are: "ElementName", "Configuration" and "Event". Field "Event" is a lookup to a table where I also have a date field. I have a form where I show the user the Event and...
  14. C

    Solved Export several queries with CopyFromRecordset to Excel

    Thank you all for the help, it was just what I needed to solve my problem
  15. C

    Solved Export several queries with CopyFromRecordset to Excel

    I will try this also, thank you!
See more
Top Bottom