Recent content by DanSc0tt

Hi, Have a string similar to below 15000;898983;363849;2738389 which I place into a listbox via additem. i want to place comma's in the string so that the numbers are easier to read in the lisbox i.e. 15,000;898,983;363,849;2,738,389 But when i do this it creates new lines after the comma...

ugh still giving me a syntax error. I have this as a part of a loop and so each time it loops I want it to paste in the individual value in the array hence DoCmd.RunSQL "Insert into tbltest.Test values {" & strArray2(z) & "}" any more ideas? Thanks!

Hi, Trying to find a way of creating a table and then filling it with values from an array. Have tried Docmd.runsql "select into tblName values " & ArrayName but this doesn't work Any ideas of 1/ How to fix it? 2/ To do it a simpler way? Thanks

Hi, Have the following code to open excel Dim objXLApp As Object Dim objXLBook As Object Set objXLApp = CreateObject("Excel.Application") objXLApp.Workbooks.Add Set objXLBook = objXLApp.ActiveWorkbook The code does not appear to work. However when I go and open Excel manually it opens to...

OK this is probably very simple, but I have just got a new PC and this code JUST TO OPEN EXCEL e.g. Dim objXLApp As Object Dim objXLBook As Object Set objXLApp = CreateObject("Excel.Application") objXLApp.Workbooks.Add Set objXLBook = objXLApp.ActiveWorkbook used to work on my old PC...

ah fixed it myself - autonumber was enabled! hence giving me a null entry in the final row of the recordset!!!

Would be of help - but this solution is in DAO and not ADO!

Hi am trying to populate a list box based on a criteria set by another 'multi'-select list box. This is the first time i have tried to do this and put together the following code, but it is telling me that i have an 'invalid use of null' (where i try to bing back ProdURC from rs) Can anybody...

Thanks guys - both worked as needed and my brain has grown a little largr to!

Thanks guys - where would I put the redim? (sorry my array knowledge is vvv minimal!!) Thanks Dan

Dim varItm As Variant Hi, Not had much experience of arrays, but am trying to capture the data selected in a multi-select list in a number of array variables. However the following piece of code is giving me a 'subscript out of range' error Any help much appreciated - Dan --CODE-- Dim i As...

Genius - told you it would be simple ;) Thanks very much!

Code below......help appreciated!! Thanks Dan <% sql = "SELECT mtgLine FROM tblmeetings WHERE mtgDate=#" & vAGD & "#" Set rs = Server.CreateObject("ADODB.Recordset") rs.Open sql, conn, 3, 3 %> <form method=post action="agenda2.asp?AGD=<%response.write vAGD%>"> <table>...

Hi, Apologies if this is a simple one! I am using VB in asp to pull records from an Access database. Opening a recordset and then pulling them into an ASP. My problem is that the page is only showing the record up to where the first space is and then truncating it. I think it might be...

One idea is (have used this myself) Code up the sending of an email to a pregenerated address - automate the download of the info you need into a csv file, attach to the email with code and send to wherever. The code you need is not too difficult if you use outlook - check out some of the...