If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using Excel sheet for an Access form
Hi everyone!
I've made a couple a excel sheet about 3 monh ago, and I decide to use Access to compile the result, I what to use my excel sheet in a form so the user wil enter all the data directly in access, for that I don't what to make a new form but use my excel sheet were I have some formula in it too. I try to insert with insert/object/file but I can't see all my page in the form, or sometimes I can but with I go to the mode to enter data I loose the end of the sheet. Do ou have any idea to solve this problem. Thank you |
#2
|
|||
|
|||
Using Excel sheet for an Access form
I don't think you can do this. If the user made an entry, how would Access
store it? What field would it go to? If you don't care about storing the results, then why are you using Access? Just let them open the spreadsheet. Not sure why you would want a hybrid of Access and Excel. Rick B "Yannick" wrote in message ... Hi everyone! I've made a couple a excel sheet about 3 monh ago, and I decide to use Access to compile the result, I what to use my excel sheet in a form so the user wil enter all the data directly in access, for that I don't what to make a new form but use my excel sheet were I have some formula in it too. I try to insert with insert/object/file but I can't see all my page in the form, or sometimes I can but with I go to the mode to enter data I loose the end of the sheet. Do ou have any idea to solve this problem. Thank you |
Thread Tools | |
Display Modes | |
|
|