Search results

  1. A

    Rename Tables Programmatically in MsAccess 2003

    Thank you for your suggestion, but the Excel Spreadsheet we receive each month has about 60 different fields and we would like to keep the data for a few months for comparison. What do you suggest? Thank you.
  2. A

    Rename Tables Programmatically in MsAccess 2003

    Every month we receive an Excel Spreadsheet that we import into our MsAccess Database table “ RBC “ Can I please get a suggestion on how to; Rename Table RBC_D to RBC_To-Day’s date Rename Table RBC_C to RBC_D Rename Table RBC_B to RBC_C Rename Table RBC_A to RBC_B Rename Table RBC to RBC_A...
  3. A

    Print a list of table Field names

    Thanks Doc Man for your suggestion, but all we want to see are two fields.
  4. A

    Print a list of table Field names

    Thank you Jun7, I will give your suggestion a try
  5. A

    Print a list of table Field names

    Yes, TheDBguy. We did try your suggestion, but we received more information than we wanted.
  6. A

    How many similar fields should be in each table?

    I appreciate your suggestion Mark. We have followed your advice and we have the results that we were looking for. Thank You
  7. A

    How many similar fields should be in each table?

  8. A

    How many similar fields should be in each table?

    I appreciate your suggestion. We have followed Mark’s advice and we have the results that we were looking for.
  9. A

    How many similar fields should be in each table?

    I appreciate your suggestion. We have followed Mark’s advice and we have the results that we were looking for.
  10. A

    Print a list of table Field names

    We are preparing to upgrade some of our MsAccess 2003 Databases and would like to review the field information being used in 2 fields. Could I please receive a suggestion on how to print two objects within the table Field Names Data Types Thank you. Crystal
  11. A

    72 Fields on a MsAccess 2007 form

    Thank you, we have had success with your suggestion.
  12. A

    How many similar fields should be in each table?

    We are developing a database that will perform four comparisons each day. My idea was that each table would contain about 36 different fields except for one common field, the part number (identifier / common Key). Table A would contain the part number and other product information. Table B...
  13. A

    Trying to change Export Grouping

    Yes, June7 suggestion works and thank you for your question
  14. A

    Trying to change Export Grouping

    Yes, June7 suggestion works and thank you for your question
  15. A

    Trying to change Export Grouping

    Yes, June7 suggestion works and thank you for your question
  16. A

    Trying to change Export Grouping

    June7 Thank You / T.h.a.n.k. U. Your suggestion works
  17. A

    Trying to change Export Grouping

    I / we have been trying to add a new grouping “Watch” for some time without success. The export group “Holdings”, works, but we cannot get the group “Watch” to work. Your suggestion will be appreciated. Crystal
  18. A

    Percentage Calculation Problem

    Thank you CheekyBuddha for your suggestion. I am sorry that I did not explain our problem properly. When the value in “Net_Share_Cost” is $0.00. Meaning that this stock was not purchased. Then an error occurs in the field “Percentage_PC”. If the “Net_Share_Cost” field is empty or contains a...
  19. A

    Percentage Calculation Problem

    I have not been able to solve our calculation problem “IF” the Net Share Cost has a value of $0.00. (If the Net Share Cost is BLANK or $0.00, it means that this stock has / was not purchased. Your suggestion will be appreciated. Problem – Field = Percentage_PC...
  20. A

    CSV or Excel daily data

    As of January we will be receiving daily data on about 100 items, which can be in a in a CSV or Excel format. Our intention is to store this information for comparison purposes and historical comparison in a MsAccess database. Should we receive the data in a CSV or Excel format? If the data is...
Back
Top Bottom