Recent content by alayash03

Nice job ! its work. I tried many times with DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "QrySalesDailyRecord", "E:\POS\Data File\Excel_File\Sales And Invoice Recovery", , , , True Now it work only replace with acSpreadsheetTypeExcel12Xml Thank you.

I have an Excel file which file have 29 sheets. And all of the data records in a sheet which name is [DataStore]. Others all sheet with linked this workSheet for data collected for analysis sales and others things. I want to import daily records data from ACCESS in query name is...

Thanks for your reply. Now Its works with backup file. But my question was C&R in my main file that name is "Purchase Order- V6_be" and Inside table "tblOrder" & "tblPurchase" than take backup. Can possible to do C&R with main file ? Can possible to take C&R multiple tables ? for multiple...

Sure

theDBguy Error is : 3265 - Item not found in this collection. I just asking you that #Post_20 & #Post_24 are okay. have there any mistakes?

This is the code... Private Sub CmdCompactBE_Click() 'Courtesy of Brent Spaulding (datAdrenaline), MVP 'Modified by theDBguy on 5/27/2019 'Source: http://www.accessmvp.com/thedbguy On Error GoTo errHandler Dim oFSO As Object Dim strDestination As String Dim strSource As String...

Compact is remove Last Auto numbers in the tables before you are not entry/Insert a complete record in the table. Example : Now you are just try to entry a orders and Click New Order that autonumbers is 5001. In such a situation, your electricity is gone. When you will re-open your database...

Okay, Lets say it again. My BE file name is : Purchase Order- V6_be.accdb I need to compact this file into two tables. Table Name is : tblPurchases and tblOrders Destination Path : D:\POS\Purchase Order-125 V6_be.accdb My FE file name is : Purchase Order- V6.accde The code is in this file...

My file name is : tblOrders strTableName = "tblOrders" Error : 52 Bad File name or Number

its tried also strTableName = "D:\POS\Data File\POS_be.accdb" 'name of your linked table Error ; 3265 - Item not found in this collection.

I test it, Private Sub CmdCompactBE_Click() 'Courtesy of Brent Spaulding (datAdrenaline), MVP 'Modified by theDBguy on 5/27/2019 'Source: http://www.accessmvp.com/thedbguy On Error GoTo errHandler Dim oFSO As Object Dim strDestination As String Dim strSource As String Dim...

Thanks. I trying it and give you feed back later.

Its should purchase ?

Yes, for that I afraid to do that, But why I did it, because, black rows is adding into the order table And Purchase table. Why its happen with : There is crisis electricity. And any time electricity gone. We use UPS, only Sales, Admin & Server Computer. We have 5 Users. Now, we see many...

BE file is not using anyone. Yes, here 5 users. Any ways to compact automatically when use FE file any user or ADMIN.