Okay so I am in an advance class for Access and I am very lost when it comes to coding...
Okay so I am in an advance class for Access and I am very lost when it comes to coding with VBA! I think I am ruining my database so I am looking for help. How much do you charge to actually do the assignment? ( I know thats terrible!!! But it is due Sunday at midnight) This is the assignment let me know how much you would charge?
Create a simple excel spreadsheet with data to update the database.
1. Create a form (frmUpdateMediaLink) to link the spreadsheet to a table in the database (you can link the spreadsheet manually using the wizard but you will lose 4 points)
2. Create a form (frmUpdateMedia), write a VBA code to extract the data and display it in a listbox, dropdownbox or any from of grid
3. Integrate the spreadsheet data into the application.
HINT: the spreadsheet can contains any special list such new DVDs, or updated notes.
Write a code to update (your inventory table, can be CD list or DVD list) from the list.
HINT: for the update (the easy way)
- delete the current records then insert the records from the spread sheet extra credit (advanced way)
- compare each record if it is new add it to the table, if it exists update the info from the spread sheet. If you are going to do this option please indicate in the student comments so I can look for it, make sure you upload the spread sheet with the database
13 years ago
20
Answer(0)
Bids(0)
other Questions(10)
- for 1accoountsmanagement only
- intro to jazz history paper
- Algebra 2 question
- can someone do this accounting assignment please
- One Quiz and one research paper for Business Ethics
- Qualifications for senator in Ancient Rome
- 10 page power point.
- resume
- What role does the human resource department play in your organization? How does the human resource department affect your company’s organizational structure and function? What is the relationship of nursing leadership to human resources? Does power or
- Writen essay for a news topic about econ.