Recent content by jedel

Hi, My work PC use Office 2003. I'm looking for a feature where I can use MS Office to search for text in multiple files and produce a result for people to go to the file and read. I'm sure, as always, that this forum would have the expertise to point me in the right direction or assist me in...

Good Site link!!! Been looking for something like that for a while. Going give that one a star. Thanks for that. ------------------------------------------------------------- "The most overlooked advantage of owning a computer is that if they foul up there's no law against whacking them around...

Possibly, is "general" a saved word? ------------------------------------------------------------- "The most overlooked advantage of owning a computer is that if they foul up there's no law against whacking them around a bit."

AS it turns out, I discover that I did not need to enter the password. Seems that it saved into the connections in the linking process. I am having another problem with this database now and that is trying to get it to run as an MDE file. Keep getting run time errors. Basically, I have a...

Hi all, I know this can be done, but I'm struggling with the whole relinking of database tables, connections etc etc. Here is the situation. I have a database FE / BE setup where the data (BE) database needs to be secured using a password. Easy enough Now the front end needs to connect to the...

Hi all, I'm not sure if I can explain my issue clearly, but I'll give it a go. I have an ASP page with a list of events running horisontally across the page. These events consist of a date in text format, the title of the event and an image. The events are listed inside DIV tags, and, as I...

gmmastros, take a star. That was the problem. Stinkin' reserved words!!! ------------------------------------------------------------- "The most overlooked advantage of owning a computer is that if they foul up there's no law against whacking them around a bit."

Hey all, I'm stuffed if I can find this error. Here is the UDPATE code. It comes from Dr Devs pages <% If Request("UDBtn") <> "" Then intRecIDs = Replace(Request("hidRecID"), "*", "") arrRecIDs = Split(intRecIDs, ", ") For i = 0 to Ubound(arrRecIDs) DESC=...

It's OK, I found it. Stupid mistake really. I did place a condition around it so it ran when the page loaded. The code above worked nicely. Thanks for your thoughts ------------------------------------------------------------- "The most overlooked advantage of owning a computer is that if...

Hi All I'm trying to set up a SQL that will delete multiple records but keep getting an error. Its the same code as the thread here thread181-27567. But my problem is that I am not getting any values in the SQL at all, i get the error Microsoft OLE DB Provider for ODBC Drivers error...

Drex!!!!!!!! If I could give 10 stars I would! What a mongrel little letter. Don't you just love code!!!!!!! That was the issue. All is working well now. Cheers Dean ------------------------------------------------------------- "The most overlooked advantage of owning a computer is that if...

Drex, Tried all of your suggestions with the space in the SQL. Tried my code and your code all to no avail. I know the connection is working because I had an error through the redirect code so it had to be passing through. I rem'd the redirect line un unrem'd the response write line and it just...

Good Pickup. Unfortunately, it did not resolve the problem. Here is the latest code. Its straight out of Dr Dev tutorial on multiple updating of records. <% If Request("Submit") <> "" Then intRecIDs = Replace(Request("hidRecIDs"), "*", "") arrRecIDs = Split(intRecIDs, ", ") For i =...

Hi all Can anybody tell me why this code is not updating the records? Got it from Dr Devs site and I even used my own FAQ, but I still can't get it to work. The code processes all the way through to the redirect page, but when I go back to the records, they have not been updated. <% If...

Hi All, I'm running a database (Access 2003) at work. I have run this database for many years over different locations in Access 97 and 2003 quite successfully. Over the years, I have found that the people that take over the database are not real competent PC users (I know its hard to...