Updating ms access table vba Vidoesex chat
I'm getting errors regarding Excel trying to read from the Access database because of Access being locked due to it being used by another user (me). I should point out that I have a FE and BE to my Access DB. I have a Parent Form Name "Rec Tab2" and subform "Rec Tab2B" After the product is received, I enter all the received product in the subform and to complete my inventory stock I am using the below on click event of a label from the Parent Form , so that my stock will be updated.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.What I'd like the script to do is on_Click(), open the specified file in excel, Excel should then read from Access and refresh its query (I may be wrong if it really does this), then save and close. The following is my code: Private Sub Insert_Click() Dim obj Excel As Object Dim obj Workbook As Object I'm having a an issue with this approach. Once a new record is updated, that record and its other related records get updated into an excel file - which can be displayed as read only in a One Drive weblink. I am looking for a alternate solution to update the stock from table to table, so that it can be faster.
As it has 450 records in the subform to be updated at one time click.If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.