Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 25 of 40
Search took 0.01 seconds.
Search: Posts Made By: Astro
Forum: VB How-To August 26th, 2005, 02:31 AM
Replies: 2
Views: 1,241
Posted By Astro
select statement with listbox item(where qnsID ="

I was advised on this.

select * from ans_table, ss_table where ss_table.qnsID = " & List1.ItemData(List1.ListIndex)

i'm a bit skeptical on how SQL joins with VBA using =" & (is it really meant...
Forum: VB How-To August 22nd, 2005, 01:00 AM
Replies: 2
Views: 1,831
Posted By Astro
list10.column(0).additem? hah!

Private Sub Command2_Click()
Rem fetch
Me.List10.RowSource = ""
rst.Open "select * from Qns_Table", cn
rst.MoveFirst
Do While Not rst.EOF
Me.List10.AddItem rst!QnsID
'Me.List10.AddItem...
Forum: VB How-To August 14th, 2005, 06:42 AM
Replies: 1
Views: 1,448
Posted By Astro
dblclick event with listbox

hello there,

i have been trying to make use of the dblclick event in a listbox to additem into another listbox.

do i make use of itemsselected property?

thank you

Astro
Forum: VB How-To August 9th, 2005, 08:02 PM
Replies: 64
Views: 5,498
Posted By Astro
Hello Raghavendra Mudugal i have been...

Hello Raghavendra Mudugal

i have been looking around the internet for samples of creating a questionnaire form by pulling out data from the table as i have shown you in the screen capture....
Forum: VB How-To August 6th, 2005, 11:24 PM
Replies: 64
Views: 5,498
Posted By Astro
Hey Raghavendra Mudugal Sorry for the late...

Hey Raghavendra Mudugal

Sorry for the late reply, i haven't been able to find a host to upload images.
These are the images upload with reference to the previous post.

If you look at the word...
Forum: VB How-To August 4th, 2005, 02:20 AM
Replies: 64
Views: 5,498
Posted By Astro
Hello Raghavendra Mudugal, Here is a screen...

Hello Raghavendra Mudugal,

Here is a screen capture of a word document and it's contents.

I am sorry for the vague explanation on the previous post.

If you look at the word doc. (screen...
Forum: VB How-To August 3rd, 2005, 02:26 AM
Replies: 64
Views: 5,498
Posted By Astro
Hey Raghavendra Mudugal, Here is the url...

Hey Raghavendra Mudugal,

Here is the url where i uploaded my project file. You gotta copy and paste the url into your web browser in order to be able to download it.
Sorry for the trouble. =)
...
Forum: VB How-To August 2nd, 2005, 09:39 PM
Replies: 64
Views: 5,498
Posted By Astro
Hey Raghavendra_Mudugal! Finally, it's up!...

Hey Raghavendra_Mudugal!

Finally, it's up! well, not entirely but the inital part i worked on has completed! I'll try to upload it for you to see! Haha erm now i am completely clueless on how to...
Forum: VB How-To August 1st, 2005, 09:31 PM
Replies: 64
Views: 5,498
Posted By Astro
Hey Raghavendra Mudugal, I am still having...

Hey Raghavendra Mudugal,

I am still having some trouble with handling 2 seperate 'inserting into table' with one click event.
I have tried duplicating the codes (line 3 to 12) with another If...
Forum: VB How-To August 1st, 2005, 03:34 AM
Replies: 64
Views: 5,498
Posted By Astro
Hey Raghavendra Mudugal, Ah sorry, it was...

Hey Raghavendra Mudugal,

Ah sorry, it was qnsID & ansID... i'll run through again and let you know the error.
Thanks!

Astro
Forum: VB How-To August 1st, 2005, 02:12 AM
Replies: 64
Views: 5,498
Posted By Astro
Hey Raghavendra Mudugal, Oh yea i remember...

Hey Raghavendra Mudugal,

Oh yea i remember coming across ADO Command Objects... currently i am struggling with handling two seperate tables.



Private Sub Command21_Click()
Rem insert...
Forum: VB How-To July 31st, 2005, 10:30 PM
Replies: 64
Views: 5,498
Posted By Astro
Hey Raghavendra Mudugal Haha yea it looks...

Hey Raghavendra Mudugal

Haha yea it looks much simpler after you explained!
Is it right to say that handling more than one table requires a seperate recordset each?

Thank You!

Astro
Forum: VB How-To July 29th, 2005, 03:05 AM
Replies: 64
Views: 5,498
Posted By Astro
Hey Raghavendra Mudugal, Managed to spot the...

Hey Raghavendra Mudugal,

Managed to spot the difference (rst!cid = "qns" & Right("0000" & CStr(CInt(rst1!cid) + 1), 4))
this one looks eally high level! haha.

Thanks man, will keep you...
Forum: VB How-To July 29th, 2005, 02:24 AM
Replies: 64
Views: 5,498
Posted By Astro
Hey Raghavendra Mudugal I am progressing...

Hey Raghavendra Mudugal

I am progressing pretty much with your example!

There is a question on Access table's autonumber format, because the example you have uploaded handles cid (from table:...
Forum: VB How-To July 28th, 2005, 08:14 PM
Replies: 64
Views: 5,498
Posted By Astro
Hello Raghavendra Mudugal, I've seen the...

Hello Raghavendra Mudugal,

I've seen the example and shall take some time to learn it well.
Thank You so much =)

Astro
Forum: VB How-To July 28th, 2005, 04:39 AM
Replies: 64
Views: 5,498
Posted By Astro
Hey Raghavendra Mudugal I've seen the...

Hey Raghavendra Mudugal

I've seen the example that you have uploaded, played around with it for practice and that helped me to pick up some new stuff.
In this case, i assume that Recordset is...
Forum: VB How-To July 28th, 2005, 01:40 AM
Replies: 64
Views: 5,498
Posted By Astro
Hello Raghavendra Mudugal I have been trying...

Hello Raghavendra Mudugal

I have been trying to connect up my database named 'db2' but unsuccessfully.

Dim cnn As ADODB.Connection
Set cnn = CurrentProject.Connetion
cnn.Open.

Do i replace...
Forum: VB How-To July 28th, 2005, 12:36 AM
Replies: 64
Views: 5,498
Posted By Astro
Hey Raghavendra Mudugal I got it! Thanks,...

Hey Raghavendra Mudugal

I got it! Thanks, i'll explore with ADO now and update if there are any doubts! Thanks!!!

Astro
Forum: VB How-To July 27th, 2005, 10:28 PM
Replies: 64
Views: 5,498
Posted By Astro
Hello Raghavendra Mudugal, In order to pull...

Hello Raghavendra Mudugal,

In order to pull data (questions) out of the table and display them on the form, do i work on VBA codes or there are wizards in MS access to perform such operations?
...
Forum: VB How-To July 27th, 2005, 09:45 PM
Replies: 64
Views: 5,498
Posted By Astro
Hey Raghavendra Mudugal, Yea i got it,...

Hey Raghavendra Mudugal,

Yea i got it, access has this memo datatype which handles up to 65k+ characters. that'll work for the question database. I'll start working on it today. Thank you so much...
Forum: VB How-To July 27th, 2005, 02:58 AM
Replies: 64
Views: 5,498
Posted By Astro
Hey there Raghavendra Mudugal, so the form i...

Hey there Raghavendra Mudugal,

so the form i have created with text-fields will have to work with sql statements e.g, INSERT into table... and so on?

Thank You

Astro
Forum: VB How-To July 27th, 2005, 02:55 AM
Replies: 64
Views: 5,498
Posted By Astro
Hey there Raghavendra Mudugal. In this case,...

Hey there Raghavendra Mudugal.

In this case, the text-fields i have created will work with sql statements?
e.g. INSERT into table.... and so on?

The form is intended to be sent to individual...
Forum: VB How-To July 26th, 2005, 09:44 PM
Replies: 64
Views: 5,498
Posted By Astro
Hello Raghavendra Mudugal, From what i have...

Hello Raghavendra Mudugal,

From what i have as of now, after successfully creating the textfields. do you think it is possible that when i fill in the text-fields, the strings can be stored and...
Forum: VB How-To July 26th, 2005, 08:11 PM
Replies: 64
Views: 5,498
Posted By Astro
thanks! =) there could be some deviation on where...

thanks! =) there could be some deviation on where i am to continue on this project. waiting for more information.
Forum: VB How-To July 26th, 2005, 03:45 AM
Replies: 64
Views: 5,498
Posted By Astro
Hey Raghavendra Mudugal, i have managed to...

Hey Raghavendra Mudugal,

i have managed to allow the label display String captured from previous textbox!
thanks! =)
Showing results 1 to 25 of 40

 


All times are GMT -4. The time now is 12:25 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.