Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
TransferSpreadsheet and datatypes
I have tried manually. You dont get an advanced option and therefore no specs when importing SPREADSHEETS these are only there for text files.- SMB
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
TransferSpreadsheet and datatypes
When I try and use the following code DoCmd.TransferSpreadsheet acImport,_ acSpreadsheetTypeExcel97, "tbltmpImportFile",_ Me.txtInputFileLocation, True One column in the spreadsheet contains mixed data types (numeric and text) - I have set the data type in the Access table to be...- SMB
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Creating a 'find' screen like Help => Contents and Index => Find
Yes this would work thanks but I was trying to be a bit more flexible. By having one text box and a separator for the different criteria (could be a space or a comma) just like the standard MS help contents find facility. Thanks for you input- SMB
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Creating a 'find' screen like Help => Contents and Index => Find
I have a table with 70000 records. I want to be able to find records which match mutliple criteria ie field called Description I want to list all matching records which contains words in text box ie Line Items, Controlling, Period (The table is linked from another system so is not normalised...- SMB
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
