varunvithalani
Registered User.
- Local time
- Today, 09:14
- Joined
- May 11, 2010
- Messages
- 19
Hello,
I have been given a task to develop a booking system with Microsoft Access VBA for my project.
Project Details:
To create a graphical user interface database which would show, add, delete, edit details of the customers, companies, orders, products, staff, departments of an engineering company.
Problems:
I am very familiar with Visual Basic but lack knowledge of Microsoft access. I have a few key tasks which I am listing below with its possible solutions. Kindly correct me or provide an alternative wherever possible.
1) The project requires to use minimal amount of memory and automatically delete old entries from the database after keeping a back up:
In this case, I decided to make use of the Compact and Repair feature of MS Access to reduce memory usage. But I do not understand how I would be able to use VB to delete entries automatically? (say entries older than 6 months) OR do I need to use SQL? (which I have no clue about).
Also, How can I transfer data from MS Access to an excel file to creat backup automatically after a period of time? (through a piece of code and NOT manually)
2) I have a date field in my one of my tables and I want my program to generate the next 4 months date automatically without the user manually typing it in. How can I program that?
3) The project also asks me to create a button which would call a macro or form which would allow me to key in all the public holidays of the year. Upon entering these holidays, my program should automatically be able to set the word HOLIDAY in one of the columns of the row of that particular date in a table.
I am really confused whether VB can do this or SQL must be implemented in VB?
Kindly help me on these issues if you have inputs or sample codes.
I will be really grateful. I am a little new to access, but hopefully with your help , will catch up.
Thanks,
Varun Vithalani
I have been given a task to develop a booking system with Microsoft Access VBA for my project.
Project Details:
To create a graphical user interface database which would show, add, delete, edit details of the customers, companies, orders, products, staff, departments of an engineering company.
Problems:
I am very familiar with Visual Basic but lack knowledge of Microsoft access. I have a few key tasks which I am listing below with its possible solutions. Kindly correct me or provide an alternative wherever possible.
1) The project requires to use minimal amount of memory and automatically delete old entries from the database after keeping a back up:
In this case, I decided to make use of the Compact and Repair feature of MS Access to reduce memory usage. But I do not understand how I would be able to use VB to delete entries automatically? (say entries older than 6 months) OR do I need to use SQL? (which I have no clue about).
Also, How can I transfer data from MS Access to an excel file to creat backup automatically after a period of time? (through a piece of code and NOT manually)
2) I have a date field in my one of my tables and I want my program to generate the next 4 months date automatically without the user manually typing it in. How can I program that?
3) The project also asks me to create a button which would call a macro or form which would allow me to key in all the public holidays of the year. Upon entering these holidays, my program should automatically be able to set the word HOLIDAY in one of the columns of the row of that particular date in a table.
I am really confused whether VB can do this or SQL must be implemented in VB?
Kindly help me on these issues if you have inputs or sample codes.
I will be really grateful. I am a little new to access, but hopefully with your help , will catch up.
Thanks,
Varun Vithalani