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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: colbyhynes
- Order by date
-
Upload Excel Sheet to Access: Date Format Problem
LameID... you have saved me from a severe 'CASE OF THE MONDAYS'! I ran this query: SELECT cdate(Replace([Somedate]," ","-")) FROM TableName; ...and it has worked perfectly! Thanks again!- colbyhynes
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Upload Excel Sheet to Access: Date Format Problem
Hi All, I am trying to upload an excel file that contains dates in text format like this: yyyy mm dd (eg. 2012 03 14) I am getting a 'type conversion error' when I try to specify this data as a date. Does anyone know of a quick macro I can run that will take my text (eg. 2012 03 14) and...- colbyhynes
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
VBA Macro Type Mismatch Error :(
Hi All! I understand the meaning of a type mismatch error ( runtime error 13 ) however I'm not sure what the problem is here... I've got one line of code that runs with no problems: ElseIf (Check = "Com") Or (Check = "COM") Or (Check = "HRP") Or (Check = "HIG") Or (Check = "PWR") Or (Check...- colbyhynes
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
