Search results for query: *

Thank you BlackKnight and FancyPrairie

I saved my db on a cd-rom, and I copied it to another computer, but now it says it is read-only. I tried even making a copy of it, but it still says read-only. Is there a way to make it not be read-only? Need help. Thanks Ray

What is the best way to link an access db to a dreamweaver driven web site, so my online forms results are written to the access db? Can some one give me the steps in completing this task? Thanks Ray

I want mutiple poeple to be able to use the same database, but how can two poeple make chnges to content within the same table. We have a database that stores all of our contacts. I have two columns one that says bad mail and do not email. I need to go in and check off those records that...

Does anybody know the best way to link an access db to a form within FrontPage?

I have a list of accounts that I would like to mark HTML_Unable. I have a field called Html_Unable that uses a yes/no data type. How would I create an UPDATE SQL statement that would allow me to find all contacts within a specific account and set their Html_Unble value to yes? Any direction in...

Hi JHall, Thanks for the response. Is there a way that I could have it say yes and no instead of 0 and -1 for within my output? Ray

Below is the code that I'm using: SELECT First_Name, Last_Name, City, Postal, First(Do_Not_Solicit), First(Account), First(State), First(Country), First(Email), First(Bad_Email), First(Bad_Email_Host), First(Do_Not_Email) FROM [marketing lists] WHERE (((Do_Not_Solicit = no)...

I would like to take a form that people fill out online, and all the results go into an access table. Within this table will be people that we have sent an email too, so I would like when a person enters their name within the form that if they already existed in the database all the fields that...

Thanks for the solutions. I've noticed that sometimes when I do my dedupes like the way I mentioned above, Access will remove one of the records, but somethimes it doesn't. Do you know why this may happen?

I have records within a table that I know have duplicates. The problem is I may have two records that are identical except one is in upper case and the lower case. I've been just doing is the following: 1. I make a copy of my table (structure only) 2. I set Frist name, Last name, city, and...

I'm trying to create a starter query, so that all other queries that I make in the future would use this query but with some addtional criteriab. Here is what I want to include within my starter gtoup: Following are the columns that I do not want null: First_Name Last_Name Account Address1...

I'm trying to create a starter query, so that all other queries that I make in the future would use this query but with some addtional criteriab. Here is what I want to include within my starter gtoup: Following are the columns that I do not want null: First_Name Last_Name Account Address1...

I would like to identify duplicate recordes and move them to a separate table. I just can't get it to work. I have multiple columns but the four columns that I will be looking at to see if the record has a duplicate is by the First_Name, Last_Name, Account, and City fields. I would like to...

I have columns that use the yes/no datatype, so in the table it puts a check in those that are yes. I would like to create a select statment that can gives me a query results of just those records that have a check within one of these columns. But how?

I tried doing your example that you gave me. Below is what I did: SELECT First_Name, Last_Name, Account, notes, First_Name(notes) FROM [Marketing lists] Order BY Last_Name Access didn't like the First_Name(notes). Need help.

I would like to find all duplicates and move only the first instance of two similar records to a duplicate table. What query or code will I need to do this? Thanks

I would like to only get back distinct rows but one of my select columns will prevent this from happening because one of my columns that I would like to include in the select is notes. Notes represents what list it was imported from. This means I may have two John smiths from the same company...

Hi, I have an excel file that I wish to import into a new table within my MS 2000 db, but I would like to keep the same order of the records from the excel file to Access. Whenever I try importing it, I notive the records are not coming in the same order as they were in the excel file? I...

I have a column which is the first name of contacts, but some of the names include their middle initial. I would like to move the middle initial characters to the middle initial column. There is alway a space between the first name and the middle name. How can I globally do this? Thanks