Search results for query: *

I put the debugger before: strYear3 = CDbl(Mid(PULL_record, 229, 4)) It now fails on that line of code. The immediate window shows * * Curiously, when I hover the mouse over strYear3 anywhere, it has the correct year. It is failing on that line of code but has the correct data in it.

At the risk of being a complete noobie, when I put the debugger in as you suggest, the only thing that happens is that it fails on: strYear3 = Cint(Mid(PULL_record, 229, 4)) The error message I get is "Run-time error '13', type mismatch" Is there a way to post screen shots or...

Thanks for the advice. I did try CInt as you suggested but now I get an error on that very line of code. I've tried other data types of numbers and still no luck.

Can someone please tell me what is wrong with my code below. I am attempting to extract a date of birth from a text file. I am able to convert the day and month portion of the date as seen at strDate3 but when I try to get the year, I get a "Run-Time Error 13, Type Mismatch" In the...

It is my understanding that the SQL program is not a full version. Would the Upsize wizard still work with a limited version of SQL? I do not know what version of Access the customer has. My boss just came back from them and told me of this problem and that I needed to write a short, simple...

I am rather new to VB and SQL. I've searched this forum for solutions to my problem. While I have found others trying to convert, the answer is not available to me because of software/computer limitations. I need to be able to convert an Acess database to SQL server thru code. I can't use...

CCLINT, Thanks for the reply. It solved the problem. This forum and the folks in it are the greatest!

How does one prevent the user from re-sizing the rows in a datagrid? I have made the columns by the following: .Columns(0).Allowsizing = False I have search this forum and looked at the help files and tried many things but the user can still change the size of the rows. Other than disabling...

How can I search a database for records which have a date field that is blank. I thought this would be simple but have yet to find the correct syntax. Any help is appreciated.