Search:

Hello funky dexter, can you tell which tutorial is that?

Hmmm did i make it complicated? ..

I don't know what is Immediate Window. what is it for. It seem empty only.

ok, here's the story...

I choose section

21.3 x 3.2 I choose this size...
26.9 x 3.2
33.7 x 2.6
33.7 x 4.0

this is it...


StrSQL = "Select TOP " & X & " * From [" & lblST.Caption & "] WHERE ID NOT IN (Select TOP " & PsID - 1 & " [ID] From [" & lblST.Caption & "] Order By ID) Order By ID"

...

thanks Funky dexter, Yes i had tried the "subract by 1". it workvery well but problem occured when i choose item ID 1. [ID = 1], when the program runs it will get ID = 0 which does not exist at all...

thanks U-dee..but with of without the order by ID, it seem both cannot start with the first size i had choose. it will straightaway go to the 2nd size and so on.

so this is my code:


Set...

I got error when i put on this code as you suggested FunkyDexter.


StrSQL = "Select TOP " & X + 1 & " * From [" & lblST.Caption & "] Order By ID WHERE ID NOT IN (Select TOP " & PsID & " [ID] From...

thanks I got it already after 1000 times of trial and errors and at last success.


StrSQL = "Select TOP " & X + 1 & " * From [" & lblST.Caption & "] WHERE ID NOT IN (Select TOP " & PsID & " [ID]...

this is my attempt:
first on the command button for "Circular Hollow Sections". When it is clicked then it will gather all the sizes of "Circular Hollow Sections" and list them down into "ListSS". ...

I don't understand method 1. but when you said

"I want x number of records starting at position Y"

then i know what you mean.


so i put this to a SectionType button_click

I don't understand method 1. but when you said

"I want x number of records starting at position Y"

then i know what you mean.


so i put this to a SectionType button_click

i See...
but I am going to use the data from the table as well for the calculation..

for instance, after selecting the sizes...I am going to use the data such as height, thickness and so on for...

this is my program interface
http://photos-615.friendster.com/e1/photos/51/64/31134615/1_139362546l.jpg

I am creating array.


ok let me make it short...I choose second alternative

let say...

this the screenshot that i print screen of my project.


http://photos-615.friendster.com/e1/photos/51/64/31134615/1_725092856l.jpg

the first picture is the database. using access. With the...

hi...:wave:
I want to the programe to get the data from access and then use it for calculation and dispaly result.

this is my coding for accessing the database..


Private Sub OpenDB()

Set...

thanks a lot...

Hello...:wave:


How do I pass value of a variables between Forms.

Let say form1
Varibles name : Force
Value: 100

Now I want this same value of variable to be transfer to another form,...

thanks anyway when I tried this


Result.CalcResult1.Image = Main.PicDetail.Image

and also


Set Result.CalcResult1.Image = Main.PicDetail.Image

Firstly I store or draw text in the picture box using 'print'

Now I want to copy the text into another picturebox in another form.

anyway koolsid...how to upload a snapshot of the picture box?

text data--- few lines of plain text or captions.

text data not a picture.

I can't use picdetail.caption or picdetail.result

any ways of doing it?

Hi:wave:

How to copy the text data from a picturebox of a from into another picturebox which is also differenct form.

This is my attempt



Set FormMain.PicDetail.Caption =...

Opsss I think I got it already...
Thanks for showing me the method of debug by using toggel breakpoint.

Solution..actually it's the value of LPRUneq
The set Value is "short"
but in the if...

Opus...I had tried that...
Yup when I Mouseover the LPRUneq. I still got value such as "Short" or "Long".

why do you think is this occurence?

Nope,
When I Mouseover the LPRUneq, it shows values of wether "Short" or "Long" I dont think it's the LPRUneq causes problem.

I define my variables this way


Public Cw as single, Cf as single

The my Formula is like this


ElseIf ST = "Unequal Angles" Then

Opss I think I got it...


ElseIf OptTension.Value = True And onebolt.Value = False And TwoBolts.Value = False And ThreeBolts.Value = False And Welded.Value = False Then
Call MsgBox("Please...

anyway isnoend07....

How bout this?


ElseIf OptTension.Value = True Then
If onebolt.Value = False And TwoBolts.Value = False And ThreeBolts.Value = False And Welded.Value = False Then
...

?
oh no
...Can I validate using the conventional way?

oh ya I am putting this code,


ElseIf OptTension.Value = True Then
If onebolt.Value = False And TwoBolts.Value = False And ThreeBolts.Value = False And Welded.Value = False Then
Call...

Here is the screenshot
http://photos-615.friendster.com/e1/photos/51/64/31134615/1_855564334l.jpg

Ok I had change it.

ElseIf OptTension.Value = True Then
If Optonebolt.Value = True Or optTwoBolts.Value = True Or OptThreeBolts.Value = True And OptWelded.Value = False And ListDiaBolt.Text =...

Not Working...Still nothing happened.

another ocation is that I am using conventional validation method that is



ElseIf OptTension.Value = True Then
If onebolt.Value = True Or...

:wave: hi

this is the continuation from the thread

http://www.vbforums.com/showthread.php?t=556477

This is my code


Private Sub ListDiaBolt_Validate(Cancel As Boolean)

hehe...
actually i have lot of data input place...some of it i use textbox, some radio button, even command button and some combobox which will allow user to select their input.

wow, another good...

O i see that's really help. thanks a lot si the Geek. God bless u.

hi :wave:
I am doing validation check on my program to check on wether the user had input some data or not.

if the user forget to input any value, a msgbox will appear as reminder to user to...

hi:wave:

I am wondering how to set my program window so that it contain a minimize, maximize and close buttons?

http://photos-615.friendster.com/e1/photos/51/64/31134615/1_961178865l.jpg

I...

Yep I am using print method.
ya autodrew work like magic.
I got Thanks A lot....

Hi:wave:

this is the situation.
I press a button that will insert some data into a picturebox (PicDetail)
THen When I scroll it, I lost some of the data- it seem like it was being rubbed off.
...

ok...thanks
I got it