Search results for query: *

The problem here is that the convert function below gives me an error in the ODBC data string. The SQL string works fine!!! Here is the error message I get at execution on console: error: ERROR [42000] [Microsoft][ODBC Text Driver] Undefined function 'convert' in expression...

Still stuck here .... the code runs till the last line then hang for about 10-15 seconds then returns the error shown below the code sample. This is basically straight out of and example.... Dim oSQLConn As SqlConnection = New SqlConnection oSQLConn.ConnectionString = "Initial...

Just trying to get data into a datagrid but it doesn't like my second to last line Dim oSQLConn As SqlConnection = New SqlConnection oSQLConn.ConnectionString = "Initial Catalog=rathmisc;User Id=sysadm;Password=sysadm;" Dim MyDataAdaptor As...

I need a good book on vb.net as it relates to windows applications and sql database. I dont need any web stuff. Any suggestions. Oh lest I forget .... I dont know squat about vb.net. I get along fine in VBA. But this .net stuff is way different Thanks Jeff

need to get time as time not date... Dim MyConnection As System.Data.Odbc.OdbcConnection Dim MyDataTable As New DataTable Dim MyDataAdaptor As System.Data.Odbc.OdbcDataAdapter Dim strMyConnection, strSavedFolder, strFilename As String strSavedFolder =...

I have been to www.connectionstrings.com and the code doesn't work!!! The Imports line give me an error.... And I am assuming that this is my connectionstring: "Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;" if so why is the 3rd line below spelled: "my...

This code was posted as a solution to a prior question. But the last line is incorrect .... any help? Dim MyConnection As System.Data.Odbc.OdbcConnection Dim MyDataTable As New DataTable Dim MyDataAdaptor As System.Data.Odbc.OdbcDataAdapter Dim strMyConnection...

I have added the "MS Offices lib 11" reference to my project. As a test I did the following: Access.DoCmd.Beep() Which shows up undelined in blue, with the following message: reference to a non-shared member requires an object reference Q: do I need to somehow declare the access reference...

I'm converting a VBA program to VB.net. The program needs to import a csv file to my sql database. In access I was using the following command: DoCmd.TransferText acImportDelim, "My_import_spec", _ "tbl_scan_data", "C:\MyDataFile.csv" Q: How do I acomplish this in VB.net. Is there a way to...

I'm new to vb. I'm trying to get my program to exit by using a button. The on_click calls the code below. This code generates the error message show below at the line 'application.exit()': If (MessageBox.Show("Exiting this application will stop data collection." & vbCrLf & "Are you sure...

I'm importing data from a csv file in to a table. I've purposfully include an error so that one record will fail to import. I'm tring to trap the error or some who see the error. Before the import I clear the errors and then look at the error.count when I'm done importing the data. the error...

Hi, I need to determine if a file (log file) is open. If I open the log file in excel (while it is in use), excel lets me know that it is read only. Is there some way to use the FileSystemObject to determine this. I have look at the attributes prop but it doesnt appear to have that...

I am trying to up size a test databes in access 2000. The only table in the db has 2 fields; an autonumber and a text field. default properties on both with no data in either. When I get the report back, the wizard tells me that it can not convert the table. HELP

this code works great if I set a breakpoint at the while stmt and step thru it.... It puts a value in my txtbox "txt_trainingtype and then moves to the next record and does the same. BUT when I let the code run without steping thru it, it won't move to the next record AND the only values that...

How do i do a .movenext function on form A from form B??

Hi I have a continuous sub form with a text box. I need to put a value into this text box. once the value is inthe txt box the form adds that record and displays a new txtbox below the original for new data. How do I move focus or address this new txtbox???? I have no problems getting to the...

Hi I have an array that is filled by code in the on open event. I need to display the values from the array on my rpt. VBA won't let me create a public array... :( Q: how can I get my array's data to the report's txtboxs? TIA jeff

This is the desired qry: SELECT qry_distinct_data_3days.*, Results.StartDate FROM Results INNER JOIN qry_distinct_data_3days ON (qry_distinct_data_3days.wall_min = Results.Material) AND (qry_distinct_data_3days.mill_num = Results.Line) AND (Results.[Heat Number] =...

Hi I have to run some sort of qry or code to do the following: I have a record set that has records considered similar basied on four fields. there is also a date stamp field attached to each record. I need to be able to view in a form records that are "new" within the last 10 days. Of these...

Why is this not working???? When I trace thru this code all 4 line are executed but the open event is not canceled.... Private Sub Form_Open(Cancel As Integer) If Me.Recordset.RecordCount = 0 Then Cancel = True DoCmd.CancelEvent End If : other code : end sub TIA Jeff