Need Experts Advice

gaurav.inani

New Member
Joined
Jul 17, 2010
Messages
8
Hi,

I have a stiuation, I wanted to know that whether it can be solved by Excel 07 or not?

Q: There is a library, which is not following a coding system for books. Currently the library is having 100 books and 100 are coming on the way. It is having 4 Shelves each is again divided into rows of 10 and one row can carry as much as 10 books.

There are four types of books currently available at library.
1. Physics
2. Mathematics
3. Literature
4. Fiction

Library incharge made an Access table with the following fields:
BookName Type Rows Position Shelve

And also an Excel file named as Librarybooks.xlsx having two columns
BookName Type
Because management wants to know only the books available and type they have.

For data entry purpose in excel he made a data validation rule for column B i.e. Type
having options :
Physics
Mathematics
Literature
Fiction
New Entry

If a user selects on New Entry he will get a input box asking Type,Rows,Position and Shelve and after entering the data the same needs to be updated in Access Sheet.

Or if user selects any of the pre defined types the input box asking Rows,Position and Shelve.

Else it is better to have the same table in excel and hide it using hide property. And then writing code will be easier for the same.

What do you suggest?

And if the answer is the first one please mention how to relate the access table to excel....and what will happen if the same code is copied to another machine i.e. whether Access works as a back end database with the sheet, wherever it is been copied.:confused::confused::confused:

Thanks.
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Forum statistics

Threads
1,213,565
Messages
6,114,338
Members
448,569
Latest member
Honeymonster123

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top