Search results

Thanks a lot for your reply. I tried this before. Also I even tried delete the Date field in the Access Table and Excel. But getting same error message Thanks

These are the Fields in my TestTable: This is the Values in Test.xlsx File: My Test.xlsx file is located in a Network Drive in M: Drive This is my Code: Private Sub Command154_Click() DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "TestTable", "M:\DATBASES ALL...

Many thanks for your reply. I have put the following code in the Click event of a command button DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel3, "TestTable", "\\ABC\MyDocs\S\FirstName.LastName\Test.rawdata", True, "A1:O3" And I am getting an Error "Could not find installable...

Thanks a lot for your suggestion. Let me try Thank You

Thanks a lot for your reply. We are getting data from an External source in an Excel Format. For Data Entry that Excel in to Access it may take 1-2 hours and it will be done in few minutes if they copy and paste data (Manually) from Excel to Access. I am trying to even minimize that copy paste...

Hello Guys, I have an Excel Spreadsheet. By the End of the day, users copy and paste values from the Excel cells in to an Access Table. Is there any method to automate this process? In the Excel spreadsheet when a User select a Range (e.g. A1 to D 14) and click a command button in Excel, I...

Thanks a lot. Let me check this

Many thanks for your reply. Could you kindly let me know how to use a subform instead of using a multi select combo box? Sorry I have no idea how to use this. Currently I am using a very unprofessional method. I have added another field in the main Table next to countries "strCountries For...

When I gave in the Query Criteria as: I am getting the Query Result like: But I just need Thanks

Hello Guys, I have a multiple selection Combo Box in my Table: These are the data in my Table: I have created a query to Display only those Records where Countries are Canada and USA. This is my Query And the Query Returns Nothing. Could you please let me know how to solve this? Thanks

Thanks a lot

Sorry I understand this Incorrectly. So the users will be downloading their copy of the database in their Desktop, for Example, and when they do the Data Entry, these Data will be saved in the BE version of the Access which is located in the Network Folder right? Thanks,

So if there are 20 users, I have to create 20 copies of the Front Ends in the Network Folder? Thanks

Thanks a lot

Hello Guys, I would like to clarify whether my understanding about Split Database is correct or Not. I have a Database in my Network Drive and there are 20 Users are going to Access this Same Database. This may cause Access Database to be slow and chances to get my Database get corrupt. To...

It Works Perfect!!! Thanks a lot For your Help Sir

Many Thanks for your Help. This is my Query SELECT Sum([TotalHours]) AS Total FROM [Copy Of Copy Of Query15] WHERE [LatestDate] Between DMax("[LatestDate]","[Copy Of Copy Of Query15]"-7) And Dmax("[LatestDate"],"[Copy Of Copy Of Query15]"); But I am getting an Error like: Thanks

Thanks a lot. This is my Query This is my Query Result Now I am getting the sum of all 28 Days. To find the Total of Last 7 Days, what change I have to make in my query. Thanks

Thank You for your reply. I guess if I use the Sum() function it will returns me the Total Hours spend on the File. But I want to find the Sum of Records of MaxDate Minus 7 For 30 Days the Total sum let us assume as 120 Hours and for Last 7 Days Before the Max Date (31-Jan-2021 - 7 which is...

Thanks a lot for your reply. This is actually storing the Total Hours spend working on a Particular File. There are Fields Like Start Date 1, Start Time 1, End Date 1 and End Date 1 Up to 30 Days. With a Union Query I found the Latest Date worked on a file. Now I want to calculate Total Hours...