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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Import
Unfortunately in Access97 the TransferSpreadsheet method doesn't work with named ranges- mienz
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Import
I've got the following problem: I want to import a named Excel range which contains several Areas into an Access table. I tried the following code but it didn't work. I'm using Access97 Public Function ImportXLSNamedRange(strFile As String, strTable As String, strRange As String) On Error...- mienz
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Access modify default settings in find menu
Hi When I open a form in Access and want to search a field with edit->find, the default settings are 'Match: Whole Field' and the Option 'Search Only Current Field' is set to true. I would like to change the default settings to 'Match: Any Part of Field' and 'Search Only Current Field 0 false...- mienz
- Thread
- Replies: 1
- Forum: Microsoft: Office
