Search:
Type: Posts; User: wai1985
Search:
Search took 0.06 seconds.
-
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...
-
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
-
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
...
-
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:...
-
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...
-
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...
-
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"
...
-
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?
-
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...
-
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...
-
static cursor meaning: rs.Open sql1, cn, adOpenStatic, adLockOptimistic ?
what do i do with the recordcount property? How do i use it?
-
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
?
-
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...
-
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...
-
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...
-
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)
...
-
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...
-
had a feeling that was the problem. Im missing a SQL query. Thanks
-
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: ...
-
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....
-
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...
-
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...
-
Yes there is RiskID in tbl_riskcategory. Im just wondering if the sql 'rs.fields' is wrong?
-
hi, i dont understand something. On form load i wrote this code:
Call resizecontrols
error: expected variable or procedure, not module
-
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...
-
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...
-
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...
-
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
-
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...
-
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...
-
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...
-
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...
-
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...
-
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:
...
-
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%?
-
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...
-
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
-
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?
-
What is the code to display the current date in a text box? I rmb something like date.now().
Thanks
-
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
|
Click Here to Expand Forum to Full Width
|