Search results for query: *

Hi i have 3 questions on listboxs. if anyone could give me answers with code (As im quite a novice!) i'd be SOOOO thankful. 1. how do i link 4 listboxs together, so when i select one item on one list, the corresponding index numbers on the other lists are also selected? 2. how do i create a...

I am wondering if someone can tell me the code i would need to be able to play 3 random .wav files from a designated folder/directory after pressing a cmd button, without playing the same one more then once each time the cmd button is clicked. thank u

thank u both for you excellent and speedy replys! you guys are LIFESAVERS!!! cheers ~ nick [elephant2]

Hi here's my problem: i need to know how to write some code that will allow me to read/write data from a textbox to a .txt file The hard bit is that the .txt file will need to be read/written to a directory that will be different for each user. Let me explain it in a bit more detail. My program...

i figured it out!!! it had NOTHING to do with my SQL code, my database code or my Access DB, it had something to do with the way i ws loading 2 text files into 2 labels. the code i had that was screwing with my database was: Open StatID for input as #1 lblStatID.Caption = Input(LOF(1), 1)...

i have never used MS Flexgrid, so i was wondering if u could point me in the right direction for some tutorials etc, or even add some sample code for me thank u

i ran this code thru debugging mode, and it seems to skip everything from If Not (rs.EOF And rs.BOF) Then to Else MsgBox "Not a valid StationID", does this mean that my recordset is empty? and if it is, how can i fix this?

Hi another question from my bag-o-problems I am designing a user input playlist. It is going to be made up of the following columns from left to right: Track Number - the track number on the playlist Track Name - pretty self explanatory Length - Length of the track Running Time - Total running...

it think that its not any of my code that's the problem, but instead its my Access Database. Now this i have no idea what could be wrong! I've created new ones, but it did nothing. Is there some References or components that i might be missing? OR is there another way i can approach this...

my recordset is trying to look at ONE user's info. it is checking to see if the yes/no field "STAccess" is ticked or not. If it is ticked: optStat.Visible = True lblNoSTAccess.Visible = False if not: optStat.Visible = False lblNoSTAccess.Visible = True

sanuj: also, after i put that END IF in the proper place, it would just load up lblNoSTAccess for all users, no matter if they had access to STAccess or not

i ran the query and it returned the results i thought it would: users who had access to STAccess had the yes/no "STAccess" field ticked, and those who didnt have access did not have that field ticked what does this mean?

when i debug the code, it runs perfectly up until the if not rs.eof and not rs.bof then line in which it skips all the lines until the end if at the end, hence missing out the bit which tells the program to make optStat and lblNoSTAccess visible/invisible

this code that u, sunaj, wrote does take away the runtime error, but it doesn't seem to be making either optStat or lblNoSTAccess visible what could have happened?!

how do i use a variable for the "STAccess"? it was working perfectly just a little while ago, so i rekon it muct be somethin basic Check the status of the recordset? how is that done? if u mean check if the "STAccess" yes/no field is there and working, then i have. nothing...

...'Prepare the recordset rs.ActiveConnection = dbconnection rs.CursorType = adUseStatic rs.CursorLocation = adUseClient sql = "SELECT * FROM UserAccess WHERE StationID='" & lblStatID.Caption & "'" rs.Open sql If rs("STAccess") Then optStat.Visible = True...

...'Prepare the recordset rs.ActiveConnection = dbconnection rs.CursorType = adUseStatic rs.CursorLocation = adUseClient sql = "SELECT * FROM UserAccess WHERE StationID='" & lblStatID.Caption & "'" rs.Open sql If rs("STAccess") Then optStat.Visible = True...

foada. u wouldnt be able to include some example code for what u suggested in ur message above - im a bit of a beginner so need a helping hand from someone who knows [wink] thank u! [thumbsup2]

there must be away u can add a vscrollbar thou? like it just cant NOT be able to be done or am i way off?

how do i add a verticle scroll bar to a frame? thanks