Search results
-
S
TransferText changes pound sign into accented character
I exported an Excel 2003 spreadsheet to a tab-separated text file, and then wrote some code to import the text file into an Access table. All goes fine except the fact that any pound (£) signs in the text are translated into the accented u symbol " ú " I realise it may be a charset...- ScottT
- Thread
- Replies: 2
- Forum: Modules & VBA
-
S
Can't update data returned by SELECT query
I have the following query: SELECT fl.File_Name, sm.Who, v.Long_Vin, v.Short_Vin, v.Reg_Date, sm.Finance_Comment, sm.Fleet_Admin_Error_ID, sm.Allocated_to_ID, sm.Resolution_Status_ID, sm.Fleet_Admin_Note, sm.Resolution_Status_Note, prk.current_assigned_to AS parked_note... -
S
TransferSpreadsheet gives me "Error; could not create" for ImportErrors temp table
TransferSpreadsheet gives me "Error; could not create" for ImportErrors temp table I am using the following code to import an Excel 2003 spreadsheet with a single worksheet (ie: one tab only) into a security-enabled Access 2003 database. DoCmd.TransferSpreadsheet acImport, ...- ScottT
- Thread
- Replies: 9
- Forum: Modules & VBA
-
S
Question Securing database for Access noobs (Access 2003)
Hi, I've used Access for a while but database security is causing me some trouble. Basically I've used the user-level security wizard to lock down objects in my database. I then added new groups, the names of which aren't important but I will refer to as group A, B, C and D. I then added...