Recent content by stocktondesigns

Works great! thank you!

fredericofonseca, your suggestion makes sense, however, when I try to run it, I get an error telling me 'invalid legth parameter passed to the substring function'

Cheryl, I find myself in the same predicament, were you able to find an easy way to cleanup sql injection damage in your database?

I have a table in our SQL database that has a bunch of hacker URL's appended to about 80,000 rows. I would like to go into each row and erase the offending characters, maintaining my originally entered data. My current approach is to do a search/replace with the table open, however, this is...

I have a 20,000 + record table, I am viewing the table in Access with has a 20,000 row limit on what I can see. The table contains activation codes, some of the codes have an incorrect character at the beginning, an H should be a B, is there a way that I can run an update that will go through...

Thanks Duane, yes, I'm basically trying to update all records in this table to be opted out of our mailing list so I can send a re-invitation whereby they would then decide to opt-in if they want. I'm using MS Access to open the database (SQL). Not sure what I'm doing to be honest. Can't send...

I tried doing your recommendation PVH, but get the same error. It wouldn't take True/False values, these are checkbox fields that have 1 or 0. I'm trying to do this through MS Access since I do not have SQL. I can only display first 10,000 records. It looks like it does uncheck the opt-in value...

I'm having a problem getting an Update Query to work. I would like to change the checkbox value of field called EmailOptin to 0 from 1, however, when I execute this I get the following message: Query executed, however no records were found This error doesn't make sense to me because I...

I am trying to create a query that keeps a running sum of each month, restarting at 0 at the beginning of each month. I've looked all over this web and found a number of cumulative query tips, but it always seems to maintain a running total from the very beginning of the data. Is there a way to...

I am doing a query in Excel, the OrderDate is stored in SQL as a varchar field. When imported to Excel, it is seen only as Text, not a Date, and requires conversion in Excel. Surely there is a way to format my view/query so that this field's date comes into Excel as a Date format and not text...

I currently have Area Code as a seperate field, seperate from the rest of the Phone Number. Since most places where I want to use the data (exporting to our CRM application etc) I'd like to abandon the seperate area code field go with a plain old Phone number field which includes the area...

I have a press release section on our web site, I show current press as the current year. I would like to have a query that returns press releases older than 1 year, but am having difficulty creating the view in SQL. I have created a similar query for the current year: SELECT TOP 100...

I've got a couple of tables, tblCustomers and tblProducts. tblCustomers has a unique UserID and the tblProducts includes a unique ProductID - the tblProducts includes a UserID field so the tables maintain a relationship. If a customer registers, but does not select any products, there is no...

I have two tables, MasterList and RelatedList. Both have a Email address field that I have joined on. There are 7500 records in the RelatedList that I want to purge from the MasterList which contains around 16000 records. When I try to create a delete query in Access it will not permit me to...

I have a View query for the number of product registrations in my table. I have got my View query to SUM and give me a grand total, but I would like the view to show total for each month: Date Total Jan 20 Feb 30 Mar 22 In Access, I can use the 'Month...