Search results for query: *

Im sorry to be a pain but have you got an example of a coding. As i usually understand beta by looking at a given code and adapt it to my example. Manny

Forri So sorry to go out of subject but would you be able to look at another query for me. its under "Using Data Environment and Data Report" Im stuck on this Manny

It seems clear enough. Thanks for that. I will look into it. Manny

Hi Guys, I am trying to print the customer records on for one of my tables. Rather than printing all the records, how can i implemented a set of codes to print the selected records identified by a primary key. The selection is done using a DataCombo control. Manny

Forri, What is your solution so as i can have a look at it and possibly implement it as a precaution. Manny

ArtieChoke, I have found a solution to my problem. Thanks alot for your help Manny

I took your advice and implemented the following code: Dim strSQL As String strSQL = "select max(customerid) from customer2" adoCustomer.RecordSource = strSQL adoCustomer.Refresh incCustomerID = adoCustomer.Recordset.Fields("CUSTOMERID")...

I have a table with customerID which starts from 100000, each number is unique since it identifies a customer. All i want is when i click on the add button i want the system to give me the next number in the series and by displaying it in the text box. But if i can then then i want the system...

Hi maryrp2 Sorry for being a pain but how exactly did u get the autonumber working??? Im finding it difficult. I am using oracle for backend. Would be a great help Thank you in advance

Hi guys, I have developed a system using oracle 9i and visual basic 6. Im not quite sure how to generate an autonumber for the next row. All i need is when i click on add button on my form, i want the next number in the series to be generated and displayed on the assigned text box. It would be...

Hi guys, I am trying to update my database using the code below unfortunately it seems to be doing nothing at all. Any suggestions? Dim strSQL4 As String strSQL4 = "UPDATE VEHICLE SET VEHICLESTATUS = 'Booked' WHERE VEHICLEID = '" & dbcVehicleID.Text & "'" adoVehicleUpdate.RecordSource =...

Hi Guys, Im finding difficulty implementing this code using ADODC control component. Any suggestions Private Sub dbcClassType_Change() Dim sql As String sql = "SELECT * FROM RATE WHERE CLASSTYPE = '" & dbcClassType.Text & "'" Set RS = New ADODB.Recordset RS.Open sql, CON...

I cannot use the data component instead im using adodc component. I tried adapting the code above but doesnt seem to do the magic?

Hi guys i have this code: Private Sub DataCombo2_Change() Dim sql As String sql = "select * from creditcard where CUSTOMERID = '" & DataCombo2.Text & "'" Set RS = New ADODB.Recordset RS.Open sql, CON DataCombo3.ListField = RS2!creditcardnum When the customerID is...