Recent content by ClaraBarton

  1. C

    Solved Alter a table by adding a column

    No, the ID is not the autonumber field used for relationships. The ID is a SECOND field used for other filing, but still required. I figured out a work around. I check for missing field and then throw up a message telling them to pull it into Excel and add an empty column named ID. Works good...
  2. C

    Solved Alter a table by adding a column

    Records have an autonumber that's used for relationships. This is just a file number they use. It's there so I have to deal with it.
  3. C

    Solved Alter a table by adding a column

    No no. The import is contact data that is new people that are added to the main table of customers. They're collected by a third party. No relationships until there are sales and reps. I know the field needed. It's ID but not used until the records are added to the main table.
  4. C

    Solved Alter a table by adding a column

    After checking an imported table, if a column is missing, I need to add it to the temporary table before it can be imported to the main table. The ID (not the autonumber main ID but a second one) is built using a recordset but if the column is missing it breaks. Occasionally a user will omit it...
  5. C

    Selected fields from a table/query to generate Report and export to Excel & PDF in MS Access

    I think that Public Function fnUpdateZZTable(ByVal tName As String) needs to clear the zztable before appending records.
  6. C

    Selected fields from a table/query to generate Report and export to Excel & PDF in MS Access

    I have been working long on an export/import form that actually works. I took yours, arnelgp, and ran. I added import capability, file pickers, and prettied it up to match the rest of my forms. The import function is rather specific to my needs but could be easily modified by anyone else. I...
  7. C

    Selected fields from a table/query to generate Report and export to Excel & PDF in MS Access

    Believe me, arnelgp, I'm indulging. Although yours is a lot prettier, I got hold of Majp's form and started reworking it. I had been working on my own mess for HOURS and DAYS and now am starting over with his. Thank you so much.
  8. C

    Selected fields from a table/query to generate Report and export to Excel & PDF in MS Access

    OK, guessing that's a personal message. How do I do that? I don't see his address.
  9. C

    Combo information

    For what it's worth... I went a different route. I created a 2nd continuous subform with a combo that is not connected to the main form. Works great. Thank you all for the ideas.
  10. C

    Combo information

    You hit it. That's exactly what's happening. Thank you for your time.
  11. C

    Combo information

    last record selected. Each combo is a different row (record) but all the little info boxes return the same values as one of the records. Whichever one was just updated.
  12. C

    Combo information

    This is a continuous form. The combo returns a customer id to to tie it to the main form and an item ID for the item. I have different items in each row but all the above information is for the most recently selected (last item) field. why doesn't it stay the same as the record selected?
Top Bottom