Hello everyone,
I am in the preliminary stages of putting together a "database" using a spreadsheet to track book orders. In a nutshell, this should be on a per-order basis. I need to track how many of each book was sold, with a running sub-total, how much shipping costs, whether or not PayPal was used to buy them, and all of the customer information. There are many more things, but this is the main idea of what we need to do.
I have been working on a VBA programming course, and I see how VBA could really benefit what I am trying to accomplish. My ultimate goal is to have a large table with all of the information stored inside, with the ability to search and call out specific records (orders), make changes if need be, and then re-save the records.
This brings me to my question - in the experience of everyone in the forum, is it better to use an actual user form or place ActiveX controls on a blank worksheet, while linking to the table on a secondary worksheet?
Do people typically use tables as databases, or should I look into using Access or SQL or something more complicated?
What is the largest database table you have used and still be able to use the program efficiently without errors and other problems? In other words, how large can I grow this before I start running into problems?
Thank you for your time.
I am in the preliminary stages of putting together a "database" using a spreadsheet to track book orders. In a nutshell, this should be on a per-order basis. I need to track how many of each book was sold, with a running sub-total, how much shipping costs, whether or not PayPal was used to buy them, and all of the customer information. There are many more things, but this is the main idea of what we need to do.
I have been working on a VBA programming course, and I see how VBA could really benefit what I am trying to accomplish. My ultimate goal is to have a large table with all of the information stored inside, with the ability to search and call out specific records (orders), make changes if need be, and then re-save the records.
This brings me to my question - in the experience of everyone in the forum, is it better to use an actual user form or place ActiveX controls on a blank worksheet, while linking to the table on a secondary worksheet?
Do people typically use tables as databases, or should I look into using Access or SQL or something more complicated?
What is the largest database table you have used and still be able to use the program efficiently without errors and other problems? In other words, how large can I grow this before I start running into problems?
Thank you for your time.
