Search:

Type: Posts; User: wai1985

Page 1 of 5 1 2 3 4

Search: Search took 0.06 seconds.

  1. [RESOLVED] INNER joins problem - please help

    Anyone tell me what is wrong with this SQL? I have lined VB6 to Access database. Keep getting error with FROM clause


    Dim sql1 As String

    sql1 = "Select NameOfTheRisk From tbl_risk...
  2. Replies
    1
    Views
    373

    Display two arrays of data

    What is the code to display two arrays of data? Is it possible?

    I have MSChart.chartdata = arrData & values

    that didnt work

    ANy ideas?

    THanks
  3. Thread: Line - MSChart

    by wai1985
    Replies
    1
    Views
    577

    Line - MSChart

    I want to plot a second series of points on the graph in a different colour, with a single value of y for all date periods x. Value of Y = 80%

    I tried this:

    Dim y As Long
    y = 80

    ...
  4. Thread: RAdio button

    by wai1985
    Replies
    12
    Views
    878

    Re: RAdio button

    Soz, forget last post. Something stupid I did! Think its working all good now. Will fully test it first and mark thread resolved.

    One more thing; can u explain to me what this code actually means:...
  5. Thread: RAdio button

    by wai1985
    Replies
    12
    Views
    878

    Re: RAdio button

    I have changed it, but now all i get in the message box is "1" all time. No matter how many no's or yes's have been selected.

    I also tried changing the 'No' radio button caption to "No" as well...
  6. Thread: RAdio button

    by wai1985
    Replies
    12
    Views
    878

    Re: RAdio button

    Just refreshed my page and realised MarkT has replied. I tried your code and it works, but I have four frames, and each frame has two radio buttons (one has label 'yes' and the other 'no'). I only...
  7. Thread: RAdio button

    by wai1985
    Replies
    12
    Views
    878

    Re: RAdio button

    Thanks for the reply. Not working right still. I have put all 8 radio buttons to an array, so its called option1

    It doesnt like 'output counter', so I used a msgbox instead "Msgbox = counter"
    ...
  8. Thread: RAdio button

    by wai1985
    Replies
    12
    Views
    878

    Re: RAdio button

    No they are not in an array. I take it I need it in an array. What do I do after once its in an array?
  9. Thread: RAdio button

    by wai1985
    Replies
    12
    Views
    878

    Re: RAdio button

    Thanks for the code but am a little confused, this is what the code looks like now:

    Dim counter As Integer
    counter = 0
    Dim x As Integer

    For x = 0 To 7 Step 2 '(assume 'yes' is 1st one)
    If...
  10. Thread: RAdio button

    by wai1985
    Replies
    12
    Views
    878

    RAdio button

    Is there any easier way of doing this. It is taking me ages to think of ALL the possibilities.
    I have 4 sets of radio buttons with labels 'yes' and 'no'.

    If any of ONE of the radio buttons = no...
  11. Replies
    8
    Views
    509

    Re: Adding data in columns together

    static cursor meaning: rs.Open sql1, cn, adOpenStatic, adLockOptimistic ?

    what do i do with the recordcount property? How do i use it?
  12. Replies
    8
    Views
    509

    Re: Adding data in columns together

    with the 2nd option, if it is empty meaning it dont exist, can i do some sort of if statement? for example:
    if riskname.value = 0 then
    msgbox "error"
    end if
    ?
  13. Replies
    8
    Views
    509

    Re: Adding data in columns together

    Hi, Im using your sql query from post #2. I put a column called RiskName in tbl_risk update. It works!

    However, is it possible to do something like from the query selecting the risk name from...
  14. Replies
    8
    Views
    509

    Re: Adding data in columns together

    Thanks for the reply.

    I have a bit of a problem hoping u can help. tbl_riskupdate has field names of RiskID(foreign key), Probability.
    tbl_risk has fields: RiskID(Primary Key), RiskName

    At the...
  15. Replies
    8
    Views
    509

    Adding data in columns together

    VB6 is connected to Access using ADO.

    I have written a query in VB6:

    Select Probability from tbl_riskupdate where RiskName = & (cborisk.text)

    I should now have a long list of all the risks...
  16. Thread: Tables

    by wai1985
    Replies
    15
    Views
    799

    Re: Tables

    I think i may know where the problem is but dont know how to fix it. It still displays the same error but when I debug highlights this bit of the code in cmdAdd: (.Fields("RiskID") = Text1.Text)
    ...
  17. Thread: Tables

    by wai1985
    Replies
    15
    Views
    799

    Re: Tables

    I tried your code and this time i have a different error. May be a little better? The error is: Item cannot be found in the collection corresponding to the requested name or ordinal. I had to change...
  18. Replies
    2
    Views
    385

    Re: recordset issues

    had a feeling that was the problem. Im missing a SQL query. Thanks
  19. Replies
    2
    Views
    385

    [RESOLVED]recordset issues

    Can anyone tell me what is wrong with this code. I keep getting error: item cannot be found in the collection corresponding to the requested name or ordinal. Then highlights this code: ...
  20. Replies
    1
    Views
    354

    Working out average

    VB6 is connected to Access using ADO control. I have main tables called:
    tbl_category: RiskID(foreign key), CategoryName(primary key),
    tbl_updaterisk: RiskID(foreignkey), date and Probability....
  21. Replies
    71
    Views
    94,677

    Re: Resizing form and textboxes ...

    Dont know if anybody still replies to this post. First of all, I want the form to expand maximum when the form first loads. That possible? How?

    Second, are there any explanation to what the code...
  22. Thread: Tables

    by wai1985
    Replies
    15
    Views
    799

    Re: Tables

    It worked. But now I have another problem. When I now add a record. it comes up with this error: current recordset does not support updating. This may be a limitation of the provider or of the...
  23. Thread: Tables

    by wai1985
    Replies
    15
    Views
    799

    Re: Tables

    Yes there is RiskID in tbl_riskcategory. Im just wondering if the sql 'rs.fields' is wrong?
  24. Thread: Resize form

    by wai1985
    Replies
    7
    Views
    694

    Re: Resize form

    hi, i dont understand something. On form load i wrote this code:

    Call resizecontrols

    error: expected variable or procedure, not module
  25. Thread: Resize form

    by wai1985
    Replies
    7
    Views
    694

    Re: Resize form

    Thanks for that. I like Martin's code. I have many forms and all these forms have to do this. I am thinking of creating a module then grab all this code in the form. Is it a call function?

    Call...
  26. Thread: Tables

    by wai1985
    Replies
    15
    Views
    799

    Re: Tables

    Hi Amrita,

    I just tried your code. I have changed rsnew to rs3 because i already have risk_category table opened as rs3.


    Set rs3 = New ADODB.Recordset

    rs3.Open "Select...
  27. Thread: Resize form

    by wai1985
    Replies
    7
    Views
    694

    Resize form

    When the form is executed, if i try to expand the form or by clicking the rectangle icon on the top right corner of the form, the form expands but all my command buttons, text etc. are still situated...
  28. Thread: Lines

    by wai1985
    Replies
    13
    Views
    1,055

    Re: Lines

    I see what u mean. Is it possible to make that line only to a different colour or something? Its just that I need that line to show the threshold (critical level). So it needs to stand out.

    Thanks
  29. Thread: Combo boxes

    by wai1985
    Replies
    8
    Views
    600

    Re: Combo boxes

    Thanks for the reply. Something strange is happening. When combo1 is selected John, and combo2 is selected John, it displays "Not allowed" which is fine. I then select a different name in combo2 and...
  30. Thread: Tables

    by wai1985
    Replies
    15
    Views
    799

    Re: Tables

    The code for previous and next is basically the same:


    Private Sub cmdnext_Click()
    If Not (rs.EOF = True) Then
    rs.MoveNext 'move to next record

    fillfields 'fill the...
  31. Thread: Tables

    by wai1985
    Replies
    15
    Views
    799

    Tables

    VB6 is linked with Access using ADO control.

    On a form I have many tables linked; tbl_risk and tbl_riskcategory. tbl_risk has RiskID, RiskName. tbl_riskcategory has CategoryName, RiskID(foreign...
  32. Thread: Combo boxes

    by wai1985
    Replies
    8
    Views
    600

    Re: Combo boxes

    I have a long list though. Plus, the data in the combo box comes from the database in Access. So I cant go through every data in the combo box and write if statements. Unless u can write something...
  33. Thread: Combo boxes

    by wai1985
    Replies
    8
    Views
    600

    Combo boxes

    I have 4 combo boxes that list the same things. Lets say if combo1 is selected to be John, and then combo2 is selected John, how do I code it so that a message box pop up to say this is not allowed...
  34. Replies
    1
    Views
    442

    [RESOLVED]'If' help

    I want to say if all the fields of the text boxes are filled in then open a new form, But If ALL the fields are not filled in, msg box displays. I got this syntax error by putting the 'And' in:

    ...
  35. Thread: Lines

    by wai1985
    Replies
    13
    Views
    1,055

    Re: Lines

    Thanks for the reply. On the picture of your graph from your last post, how can I get a horizontal line going across sitting on 80%?
  36. Thread: Lines

    by wai1985
    Replies
    13
    Views
    1,055

    Re: Lines

    Hi, yes I want to draw a line graph. U are right. I do have a line graph drawn on MSChart. The line graph plots by using data that is stored in the database. VB6 is connected to MS Access using ADO...
  37. Thread: Lines

    by wai1985
    Replies
    13
    Views
    1,055

    Re: Lines

    Thanks for both replies. I want to ask Code Doc - can u teach me or tell me how to draw your own charts using lines?

    Thanks
  38. Replies
    2
    Views
    493

    Command btn pictures

    Is it possible to get command button where it displays a picture? For example, i need a button to save some records. Can I get an image of a button that has a disk displayed?
  39. Replies
    2
    Views
    435

    [RESOLVED]Dates

    What is the code to display the current date in a text box? I rmb something like date.now().

    Thanks
  40. Replies
    0
    Views
    461

    Urgent help drag and drop

    Anybody know how to drag a point on MSChart line graph and move it to another point using mouse?

    I really need this. Is it even possible? Please someone reply. Thanks
Results 1 to 40 of 178
Page 1 of 5 1 2 3 4



Click Here to Expand Forum to Full Width