Search results for query: *

I'm a little confused where I need to enter the table numbers etc. My tables are called ILCommentx (where x=1 to 6000+)

I need to delete close to 6000 tables from an access database and obviously don't want to do it manually. Can anyone suggest any macro code for doing this?

Thanks, it does the first table,just gotta get it to do the rest now

This gonna sound really thick but how do I do this in Access? I've created a module called test with the above code in it, then how do I run it? thanks

Can anyone help: I have over 1000 tables called ILCommentx (where x=1 to 1000+). I want to copy the entire contents of each table into one table called ILComments. I could do this manually but as I'm sure you'll appreciate this would take a considerable amount of time, has anyone any idea how I...

I have a couple of web applications, back ended by access databases, which have been having problems of late. On a few occasions now the application has 'broken' reporting Microsoft OLE DB Provider for ODBC Drivers error '8007000e' [Microsoft][ODBC Microsoft Access Driver] Not enough space on...

With Access is there: i) A limit to the number of database connections you can have at one time ii) How can you kill off these connections?

Thanks that works a treat.

rather than using vbscript can i do it just using javascript then? What i want to is have a drop down box containing 4 entries. If they select the 'onhold' option then I want a text box to appear below it for them to enter a date, if they select any other option they don't get the text box and...

I have an asp page which has a dropdown box in it. Using the onchange event I want to decide whether to do something or not. The event calls this javascript <SCRIPT ID=clientEventHandlersJS LANGUAGE=javascript> <!-- function HandleChange() { var list = document.form1.seltest; var listValue=...

I have an asp page which has a dropdown box in it. Using the onchange event I want to decide whether to do something or not. The event calls this javascript <SCRIPT ID=clientEventHandlersJS LANGUAGE=javascript> <!-- function HandleChange() { var list = document.form1.seltest; var listValue=...

I tried it on the read one and it works. Thanks

Thanks for this, one question though. Do you I put this on the page which writes the information to the database or the one that reads the data from the database?

I have an asp page with a form in it. There are several large textboxes on the form, similar to this one. When users enter the text they can space everything out nicely with paragraphs etc, but then when the data is extracted from the database to view it comes in one long text line with...

I have an Access database and a script which when run manually pulls information into the database from another source. I'd like to automate this process so that when the user access an 'index page' the code within the page kicks off the script, any ideas if this is possible and if so how I do...

Part of an application I've written involves adding names into a database to assign responsibility on a particular day. People then have to put the information into their outlook calendar themselves. Is it possible that when the request is added to the database I can automatically generate a...

Thanks that worked a treat

Litlle confused there: I currently have strSQL=&quot;SELECT * FROM ILDatabase&quot; Dim objRs Set ObjRs=ObjConn.Execute(strSQL) %> <TABLE border=1 cellPadding=1 cellSpacing=1 width=&quot;75%&quot;> <TR><TD> <Select name=&quot;ReportItem&quot;> <option selected> <%While NOT ObjRS.EOF%>...

I have an access database and I'd like to create an Asp page to allow the user to build their own reports. In order to do this I initially want to populate a dropdown box with the field name so they can select which one they want to report. I know how to create one when I want the contents of...

I have a table on an asp page, when you select the amend link it takes the variables from that line and passes them across to another page. On this page I use Request.Querystring and get the variable but then I want to put it into a text box to enable the user to amend, however it would seem...