Search results

Hi all, I have 2 listboxes. One is populated when the form loads, then 2nd is popilated by selecting items in the first and clicking an 'ADD' button. When i click the ADD button everything works fine except i want to unselect the items i've added from the first list box after clicking ADD...

Exellent, thanks for your reply its set me off on the right foot. I now have a player thats playing files i select from a url. I'll post the code tomorrow and keep you updated on any problems i come across. Thanks.

Hi, thanks fo the reply. I am creating a DB that i want to have a form with a media player that i can load MP3's into and play. I have no idea what objects to use or how to use them and cant find much on it on the net? VLC is just a media player like Windows Media Player. Thanks.

Hi all, Just a quickie.... is there a way to embed a music player in an access form (VLC for instance) and select songs from it? can someone point me in the direction of references i might need, code etc. Many thanks.

Thanks for your replies. I have another issue though..... I'm using this code to move my selected items to my second list box. Dim ctl As Control Dim varItm As Variant, intI As Integer Dim i1 As String Set ctl = Me.listBox1 For Each varItm In ctl.ItemsSelected For intI = 0 To...

thanks for your help. I managed to crack it with your advise. I just have one more thing (**i hear you sigh**). I now have my items in my second listbox. I want to get those values (serial no's) and update a table with the items in the list. How do i go about getting the number of items...

Hi, thanks for your reply. I have looked at cascading listboxes but dont think its what im after. I dont want the second list box to have values based on what is selected in the first. I want to actually copy the values i have selected in list1 into list2. basically, list1 one shows ,say, 10...

Hi all, I have a listbox on a form which i want to be able to make multiple selections from and pass into another listbox. how do i put the selected items into the other box? is there a way of telling if something is selected in a list box (by the index or something)? If so then i shuld be...

hi all, - I have 2 list boxes. - listbox1 is a query on an table on SQL server. - I want to select a value in listbox1, click and 'ADD' button and the selected value moves into listbox2. - I have managed to get the values moving from one listbox to another but the values don't always appear in...

arhhhgggghghhh, sorry folks. just me being a tit. i had only declared: 'dim rs2 as Recordset' when i needed: 'dim rs2 as DAO.Recordset' if someone wants top tell me WHY i have to do this i would be grateful. Many Thanks, sorry for wasting anyones time.

Morning, I am trying to run an t-sql statement in my vb and put it in a recordset but when i try to put it in rs2 (my recordset object) i get a 'type mismatch' error. The red highlighted text is where the error occurs. Can anyone see why?? sql = "SELECT * FROM [Serial Tracked Stockcodes]...

Hi All, I trying to get a sql query into a recordset but keep getting an error thrown back. The error is : Too few parameters. Expected 1. Can anyone help with this?? Thanks. sql = "SELECT * FROM Failures WHERE rs![user ID] = Failures.[Sales Contact]" Debug.Print sql Set rs2 =...

here is the result of my debug..... the red part is my variable which is now called vl the error is: syntax error in INSERT INTO statement

Hi all, I'm trying to do an insert into query which worked until i added a variable. The red part used to be a direct reference to the form (me.combo.column(0), which worked), but i have since changed it to a variable which im now getting an error : syntax error in insert into statement...

'code' is a field in the table 'charges'. The combo box value (comboCharge.column(0)), i'm using in my sql string has its row source linked to the table 'charges'. The field is a text type 6 long. MultiFlag, which is the result im trying to get into my recordset, is a YES/NO field.

when i remove the single quotes i get a : 'too few paramteters, expected 1', error message?? when i break the code and hover over the 'me.comboCharge.column(0)' value i get the right result which is @DEL01 (@DEL02, 03 etc depending on the selection)??

thanks for the reply... no, my field is a 5 char string so the single quotes should be ok??

Hi all, I'm trying to get a SQL quesry into a recordset but i keep getting an error message saying: type mismatch here's what i've got...... Dim sql As String Dim rs As Recordset sql = "SELECT multiFlag " & _ "FROM Charges " & _ "WHERE code = '" & Me.comboCharge.Column(0) & "'"...

OK...... Im on the right track now. Problem im getting now is that its saying the number of query values and destination fields are not the same. They are the same except for the first column in the table which is and id field which is set to autonumber...... sql = "INSERT INTO TRANSACTIONS...

sorry, maybe i've got it wrong then. im trying to insert new records..????