Search results for query: *

Hi Derren, I moved the header row to before the loop. I've moved the spacer row to the end of the loop. which makes my table line up properly. but the problem turned out to be a timing issue with other queries that were also running. I have put in a wait sub (just loop through doing nothing a...

Hi Derren the whole page is massive, but the relevant bits are: sub display_the_Goddamn_Table() set rs = server.createobject("ADODB.Recordset") sSQL = "Select * FROM [Client Detail];" rs.open sSQL, "DSN=amssc" count = 0 do while not rs.eof %>...

hi, I'm getting data from an access database. the data is being turned into a table. one table had 44 rows and returned all of them. one had 66 rows and returned only 61 and the final one had 109 rows but only returned 76. Is there a size limit on the amount of rows that can be returned, and...

Hi, I have created a table using vbscript and an ADO connection to an Access Database. some of the tables are large and I would like to give the user the opportunity to download the file to excel. The way I had envisaged of doing this was to fire off an access macro or a VBA function in Access...

Hi, one can use string functions such as RIGHT(), MID(), etc, in SQL Statements, so is it possible to run a function I wrote from an SQL statement? FrankX

Hi, as the title says, is it possible to run a Macro or preferably a Sub or Function from a data access page. I can run an SQL statement using VBScript as follows: sSQL = "SELECT blah.blah FROM blah" MSODSC.connection.Execute(sSQL) maybe it is possible to run a function from an SQL...

Me again. Could it be to do with using MSODSC? I know I can run an SQL statement with the Execute Method, but I cannot see if I can run a procedure.

Hi, I've just started playing with Data Access Pages. They have the option to add buttons and textboxes, much like Forms, but I cannot work out how to fire code off from them. I have a page that displays the details from a table, and I would like to give the user the opportunity to update this...

Hi, Please excuse an oracle virgin coming onto the developers site, but I figured you guys will know. I have a request that has to be kicked off in 20+ databases that produces output files which we use analyse with other tools (as our contract with Oracle does not allow us to develop our own...

Hi, I've been asked to see if I can fire off some oracle reports from within a VBA application. I understand that this will require me to send instructions using ODBC, but I have not got a clue as to how to do this. does anyone know a good site to goto for a tutorial / articles on how to use...

Hi, I'm pretty new to VBA. I have created a form (in Access) called frmMain. on it I have a frame called fraDays. In this frame I have 5 option buttons. I want to find which is selected and select a string based on that. I have declared and set the form: Dim frmMain As Form Set frmMain =...

Hi, I've been banging my head against my desk for a day now. I want to download a .ZIP file from my companies intranet from within Access. I used the InternetOpen, InternetConnect and HttpOpenRequest functions from wininet.dll. I set the HttpOpenRequest AcceptTypes parameter to...

Hi, I want to download files from my company intranet from within Access. I guess that this would have to be done in VBA. The file is normally accessed by clicking a hyperlink. this then asks me where I want to download it to, so I would also like to pass the directory and file name as a...

Hi, I want to download files from my company intranet from within Access. I guess that this would have to be done in VBA. The file is normally accessed by clicking a hyperlink. this then asks me where I want to download it to, so I would also like to pass the directory and file name as a...