Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. badger8

    READ-ONLY DB

    Thank you BlackKnight and FancyPrairie
  2. badger8

    READ-ONLY DB

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

    Dreamweaver and Access DB

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

    Multiple users in same access database

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

    Linking an Access DB to Frontpage

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

    updating a field that uses the Yes/No Data Type

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

    Need just disinct records

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

    Need just disinct records

    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)...
  9. badger8

    Linking Web form pages to an access db

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

    Removing duplicates from a table that contains upper and lower case

    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?
  11. badger8

    Removing duplicates from a table that contains upper and lower case

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

    Starter query help

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

    And and or query

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

    Distinct rows issue

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

    Select Query that includes a column that uses a yes/no datatype

    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?
  16. badger8

    Distinct rows issue

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

    Duplicates moved to seperate table

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

    Distinct rows issue

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

    Importing an excel file into my MS2000 db

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

    Moving some characters within one cell to another cell

    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

Part and Inventory Search

Back
Top