Search results

Greetings, Can someone justify what's wrong with my code below. DoCmd.TransferSpreadsheet acImport, 8, "Info", "C:\Test1.xls", True, "A1:E60" It said Microsoft Access db engine could not find the object "C:\Test1.xls" I already added reference to Microsoft Excel Object Library but still it...

Good Day, I have difficulty in doing my database project. I have an excel workbook where users enter all the data in the cells. Later, from Access I need to import all the data that I have filled earlier in Excel. I know we would need to use Import wizard. It is tedious to do so moreover if...

Hello all, I wanna ask about SQL codes on how to join 2 fields from 2 different tables in Access into 1 new field in new table proposedly. It is not that I want to combine those two fields into 1 new combined field like this. (many turned up giving this solution) First Field (First Name)...

I have created a split form in Access 2007; I have added a number of fields to this form. Is there a way in VBA to hide or show selected fields (columns) in the datasheet? I deperately need help. TIA :)

Hello all, I'm working with filtering data and I had just found this code, very helpful indeed but I just need help to understand it in depth. Dim strSQL As String strSQL = "1 = 1" If Len(Nz(Me.Combo104, "")) > 0 Then strSQL = strSQL & " and [Part Type] = """ & Me.Combo104 & """" End If If...

Hi, I'm working with VBA Access 2007 and currently I have a problem of how to filter certain data from a query. I have a form with combo boxes, radio buttons, check boxes and command buttons. When user select combo box Department = Steel, and click the View button, Query1 will appear. But...

I'm new here and I hope you guys could help me since I have some hurdles while doing my project (VBA Access 2007). Have a nice day all ;)