G
Guest
I am working with a database that isn't automated ie no switchboard or
similar device was made. I've pretty much gotten everything added to the
switchboard except for two related key parts.
Right now, what I do is open a table called tbl-Temp, then use the import
feature to point to an Excel spreadsheet. I select the area to be imported
and let it rip. The tbl-Temp was set up to match the Excel spreadsheet so I
don't have to worry about names/headers etc. Once I have the data imported I
run various queries and reports and then delete the data from the table and
repeat as necessary.
So what I did was create a form that can be accessed from the switchboard I
am making and added two command buttons. I would like one to be an On Click
[event procedure] (import data from Excel sheet to tbl-Temp), and the other
to be an On Click [event procedure] (delete data from tbl-Temp).
I import from the same spreadsheet everytime, but if it would allow me to
select one after clicking the command button that would be a better option in
case things change in the future.
So I have said all of that to say I'm having trouble writing the procedure.
So if anyone could tell me what to write for each of them or point me in the
right direction for online resoures/explainations etc I would appreciate it.
Thank you.
similar device was made. I've pretty much gotten everything added to the
switchboard except for two related key parts.
Right now, what I do is open a table called tbl-Temp, then use the import
feature to point to an Excel spreadsheet. I select the area to be imported
and let it rip. The tbl-Temp was set up to match the Excel spreadsheet so I
don't have to worry about names/headers etc. Once I have the data imported I
run various queries and reports and then delete the data from the table and
repeat as necessary.
So what I did was create a form that can be accessed from the switchboard I
am making and added two command buttons. I would like one to be an On Click
[event procedure] (import data from Excel sheet to tbl-Temp), and the other
to be an On Click [event procedure] (delete data from tbl-Temp).
I import from the same spreadsheet everytime, but if it would allow me to
select one after clicking the command button that would be a better option in
case things change in the future.
So I have said all of that to say I'm having trouble writing the procedure.
So if anyone could tell me what to write for each of them or point me in the
right direction for online resoures/explainations etc I would appreciate it.
Thank you.