Recent content by DebbieCoates

Thank you for your reply I've managed to achieve what I wanted by useing Private Sub txtURN_KeyPress(KeyAscii As Integer) If (KeyAscii = 13) Then Call cmdURNSearch_Click End If End Sub I

I have a form with a text box in and a command button. At the moment a user types something in the text box and then clicks the button. is there a way that rather than having to click the button I can automatically detect if the enter key has been pressed, and then do the command button ?

Can anyone help me I have seriously messed up my SQL Security on my local SQL server. i am trying to set it back but I cant. i tried Deleting my sql Server registration, then adding it again, but that didn't work. what I did was change it to SQL and windows authentication, however, when I try...

Can anyone help me I have seriously messed up my SQL Security on my local SQL server. i am trying to set it back but I cant. i tried Deleting my sql Server registration, then adding it again, but that didn't work. what I did was change it to SQL and windows authentication, however, when I try...

i have a SQL statement that i am passing via VB, but for some reason I am getting an error saying that there is a missing operator in string, and yet when i run the statement I am trying to pass in the sql query analyser, it works perfect, has anyone any idea's why? Dim sSQL As String sSQL =...

OK, cheers

if i have already set a connection up to my server can i then use this in vb to execute a stored proceedure dim str as string str = cnn.Execute sp_GetPCON 'input parameter' so that str will now contain the output parameter of my stored proceedure, or do i have to set up a command object?

brilliant, after hours of messing about, i swopped the * for % and it works great, many thanks

I am in vb, but connecting upto sql

can anyone spot what I am doing wrong here, i think it is becasue of the quotes I am using, but cant work out how to put them I am using this sSQL = "Select * from V_SOAPostCodeSearch where PCID Like '" & sPostcode & "*'" which gives me this Select * from V_SOAPostCodeSearch where PCID Like...

can anyone point me in the right direction, having spent the past 3 hours looking at this, I am going up the wall. I am working on a database that someone else has set up. the vb front end is connection to SQL 2000, using a DSB. its been set up so that the database connection is created once...

i am using the following proceedure to fill a combo box on my form. Public Sub FillCombo(objComboBox As ComboBox, strSQL As String, strFieldToShow As String, Optional strFieldForItemData As String) Dim rs As New ADODB.Recordset 'Load the data Set rs = GetRecordset(strSQL) With objComboBox...

I've had a look on the net, and found a sub that someone had written that does what I want Shuld anyone else want it, it is Public Sub MyResetControls(frmMyForm As Form) On Error GoTo Err Dim Control As Object For Each Control In frmMyForm.Controls Control.Text = ""...

i have various forms in my database that as I select a project, will fill all the field on the form. Rather than writing FieldA= "" FieldB= "" FieldC= "" FieldD= "" etc etc everytime I have to clear the form, I thought I would write a function, where I passed in the form name, and then clear...

spot on, Thank You