Search:

Type: Posts; User: jaya-shree

Page 1 of 2 1 2

Search: Search took 0.04 seconds.

  1. Pass a value from a form to a data designer

    Hi!

    I am trying to generate reports using the data designer.

    I have a form with a dropdown combo and a button. I select one value from the dropdown combo. When I click on the button 'Generate...
  2. Replies
    1
    Views
    427

    designing reports using vb designer

    I am designing reports using the microsoft designer in VB. I do nt have crystal reports. I have designed the user interface using the wizard. i want to link it to the database.

    using access...
  3. Replies
    2
    Views
    435

    Design reports using VB designer

    I am designing reports using the microsoft designer in VB. I do nt have crystal reports. I have designed the user interface using the wizard. i want to link it to the database.

    using access...
  4. Replies
    1
    Views
    317

    setting the dates into the db

    rs.Open "select memberId, itemId,dateOfIssue,Dateofreturn,actualReturnDate,fine from transactions where itemid = '" & txtItemId.Text & "'", db, adOpenStatic, adLockOptimistic

    i want to set...
  5. Replies
    3
    Views
    513

    current system date and time

    I have two date fields in my code:

    Dim dateOfIssue As Date
    Dim dateOfReturn As Date

    when i printed the value of date, it gave 12:00:00 AM. I want to get the date in the format MM-DD-yy. Plz...
  6. Replies
    1
    Views
    277

    yes/no column into the db

    i have a column in the database which takes only yes/no in the db. when a query is fired into the db, the value gets retrieved properly.

    If the value is "yes", then i want to display an error...
  7. Replies
    1
    Views
    336

    Logging into a form

    I have a login form. The login name and password tht the user types needs to be compared with the combination in the database.

    plz let me know how do i compare the textbox values with the values...
  8. Thread: login form

    by jaya-shree
    Replies
    3
    Views
    513

    i am using ms access database.

    i am using ms access database.
  9. Thread: login form

    by jaya-shree
    Replies
    3
    Views
    513

    login form

    I have the login id and password coming from the form

    i have a query which gets the login name and password from the table.

    i want to validate the user name and password against the values...
  10. writing an insert query for values coming from recordsets

    How do i write an insert query for the following:

    Transactions table

    transactionId --> autonumber
    memberId --> comes from recordset1
    ItemId --> comes from recordset2

    startDate -->...
  11. I used Instr(ItemId.txt,"b") 0 if i pass...

    I used Instr(ItemId.txt,"b") <> 0

    if i pass "b001", then instr() returns = 0
    if i pass "m001" , even then instr() returns = 0

    if I use Instr(ItemId.txt,"b") = 0 then
    the above condition is...
  12. query tables according to textbox values

    I have a form which has two fields:

    memberId and itemId.

    In the itemId field, I can give values like 'B001','P001','M001' and so on.

    If it is B001,--> it indicates a book and i need to query...
  13. i have a form in which i am displaying the...

    i have a form in which i am displaying the details from two tables:

    in the form load event, i have the following code:

    <vbcode>

    Dim WithEvents adoPrimaryRS As Recordset
    Dim WithEvents...
  14. inserting a record into two tables at the same time

    In the book table, i have the following fields:

    itemid,bookname,author,publisher,isbn,volno,editionno.

    in the items table, we have itemid,isissuable, noofcopies,fine/day,issuabledays.

    the...
  15. Replies
    3
    Views
    510

    hello, is there nobody who can suggest...

    hello,

    is there nobody who can suggest something? i am stuck at one point.
  16. Replies
    3
    Views
    510

    adding records into two tables

    In the book table, i have the following fields:

    itemid,bookname,author,publisher,isbn,volno,editionno.

    in the items table, we have itemid,isissuable, noofcopies,fine/day,issuabledays.

    the...
  17. Replies
    4
    Views
    417

    the above statement gives an error at compile...

    the above statement gives an error at compile time if i dont put a = sign.
  18. Replies
    1
    Views
    500

    compare two date fields

    How do i compare two date fields in VB

    one comes from the table and the other is the system date?
  19. insert data into 2 tables at the same time

    trying to insert data into two tables at the same time

    I have the following code to select data from two tables:

    <vbcode>
    Private Sub Form_Load()

    Dim db As New Connection
    db.CursorLocation...
  20. Replies
    4
    Views
    417

    sql stmt error!

    The following sql stmt gives me an error:

    Dim sql As String
    sql = "Delete from MemberItems where memberId = '" & txtFields(0).Text & "'"

    adors3.Open(sql, db1, adOpenStatic,...
  21. showing a value in the combo box as selected

    The values in my combo box come from a table.

    I want to highlight one of these values after comparing it with the values in the table.

    Eg: if memberId = 2 and schemeName = quarterly for this...
  22. showing a value in the combo box as selected

    The values in my combo box come from a table.

    I want to highlight one of these values after comparing it with the values in the table.

    Eg: if memberId = 2 and schemeName = quarterly for this...
  23. Replies
    3
    Views
    480

    Dim db As Connection Set db = New...

    <vbcode>

    Dim db As Connection
    Set db = New Connection
    db.CursorLocation = adUseClient
    db.Open "Provider=MSDASQL.1;Data Source=library"

    Set adoPrimaryRS = New Recordset
    adoPrimaryRS.Open...
  24. Replies
    6
    Views
    545

    The infinite loop is gone, however, the focus on...

    The infinite loop is gone, however, the focus on the textbox moves off . The focus shifts to the next box.

    i want the control to remain in the same box after the validation msg.
  25. Replies
    3
    Views
    480

    error while adding a record

    when i try to add a record into the db, i get the error:

    multi step operation generated errors!

    i dont know y this error comes and how can i solve it?
  26. Replies
    1
    Views
    343

    unable to delete a record

    i have the following code for the delete function:

    <vbcode>

    Private Sub Form_Load()
    Dim db As Connection
    Set db = New Connection
    db.CursorLocation = adUseClient
    db.Open...
  27. Replies
    6
    Views
    545

    Infinite Loop

    On a form, I have a set of 12 text boxes.

    I have set the following properties for the form:

    Name: txtFields
    Index: 0,1,2 ...


    ie i have made an array of text boxes.
  28. Here is the code: ...

    Here is the code:

    ==============================================

    Dim db As New Connection
    db.CursorLocation = adUseClient
    db.Open "Provider=MSDASQL.1;DSN=library"

    Set adoPrimaryRS = New...
  29. The following is my query: It returns two...

    The following is my query:

    It returns two columns
    ==============================================

    Dim adoprimaryrs1 As Recordset

    Set adoprimaryrs1 = New Recordset

    adoprimaryrs1.Open...
  30. Replies
    0
    Views
    307

    Expected parameters:1

    I have the following code:

    ==============================================


    Dim adors2 As Recordset

    Set adors2 = New Recordset
    MsgBox "txt2" & txtFields(0)
  31. Replies
    3
    Views
    419

    Expected parameters:1

    I have the following code:

    ==============================================


    Dim adors2 As Recordset

    Set adors2 = New Recordset
    MsgBox "txt2" & txtFields(0)
  32. Replies
    2
    Views
    291

    One recordset to another

    I am facing a situation like this:

    I have books and journals table with ItemId as pk.

    I have items table with ItemId as fk.

    Now, depending on the ItemId i need to query the item table and...
  33. Passing a value from a recordset into another query

    I am trying to pass a parameter which is the result of a query into another query as follows:

    ==============================================

    Set adoPrimaryRS = New Recordset
    ...
  34. I followed the steps suggested by u: ...

    I followed the steps suggested by u:

    -------------------------------------------

    Do While Not adoprimaryrs1.EOF
    oCombo.AddItem adoprimaryrs1(1)--> error at this line
    MsgBox "added item"
    ...
  35. passing a value from a form to an sql statement

    i am passing a value of memberId from the form to the sql statement.

    When i tried to print the value of memberId, I get the value properly.

    when i run the sql query and check the record count...
  36. I tried out ur code as follows: ...

    I tried out ur code as follows:

    -----------------------------------------------
    dim index as integer
    index = 1

    Do While Not adoprimaryrs1.EOF
    Ocombo.AddItem adoprimaryrs1(Index)--> at...
  37. Replies
    4
    Views
    549

    I have written the following code to delete a...

    I have written the following code to delete a record from the database.

    ==============================================

    Dim db As Connection
    Set db = New Connection
    db.CursorLocation =...
  38. I have a combo box with say four values, in a...

    I have a combo box with say four values, in a form.

    when i select a value from this combo box, i want the id related to this value to be inserted into the database.

    how do i do this?

    I...
  39. thanks a lot! wht i am asking is when i select...

    thanks a lot!

    wht i am asking is when i select a value from the combo box, there is an id associated with each value in the combo box. i want to pass this id as a hidden parmater.

    i dont know...
  40. Replies
    2
    Views
    379

    extracting a character from a string

    depending upon the item id that is present in the text box, i want to fire queries to different table.s

    eg: if the itemid is B001, then a query to books table,
    if itemid is P001, then a query to...
Results 1 to 40 of 77
Page 1 of 2 1 2



Click Here to Expand Forum to Full Width