Search results for query: *

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?

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?

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 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...

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...

I have an application running on a Lan, is it possible to identify the user from their network login as you can within word or excel?

I have a web site, predominately asp, which could do with a spell check facility. Rather than writing one is there anywhere on the web i can download one for free?

I am having problems with an SQL query from an .asp page to an access database, can someone please help!!!. I have the following SQL which works out which records were raised between the user specified start and end dates strSQL=&quot;Select ProblemDate, StartTime, Service, Descrip, BusText...

Various toolsets I have used in the past have provided the functionality to enable you to download a report into another product such as Excel. Is this easily achieveable to set up?

I am running Outlook 2000, so not sure if this falls into the scope of this forum. Basically I have a standard email I want to send out on 5th of every month. At present I have to remember to do this each month. Is it possible to set up a rule which will do this automatically instead?

I am having problems with an SQL query from an .asp page to an access database, can someone please help!!!. The fields in the database are as follows: ID SupportTeamName StartDate EndDate FirstPersonInitials Basically I want to select the row where the Date falls between StartDate and EndDate...

I have an application (connected to an access d/b) where users log a record. What I would like is to be able to generate an email if after 20 minutes the record is still open. I know how to generate the email but is it possible to have such a timer?

I am using a textbox to show data extracted from the database, the code takes the format of: <Input name=&quot;IncResolution&quot; value=&quot;<%=objRS.Fields(&quot;IncResolution&quot;).value%>&quot;<%=UpdateMode%> style=&quot;HEIGHT: 68px; WIDTH: 496px&quot;></td> However the text does not...

How do I send an email to more than one recipient using CDO. I currently have this: objCDOMail.AddRecipient &quot;Pete Jones&quot; ,&quot;Pete.Jones@yahoo.co.uk&quot; Which works fine, but I've tried several different options to add others and it won't work Thanks