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!

  • Congratulations TouchToneTommy 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: *

  • Users: ssampier
  • Content: Threads
  • Order by date
  1. ssampier

    NT 4/Novell netware to AD migration

    I want to migrate both Netware and NT 4 to Active Directory. My biggest reason for the change is my lack of understanding about Novell. I could take classes and read books, but it seems like a lost-cause. I might as well learn Windows and AD which is what most of world uses. My environment...
  2. ssampier

    avg 8.5 serial not working

    Morning all. I have used AVG successfully for many years in an network environment. However an employee received a new pc on Friday. I have a network location for the executable. AVG states this executable is old and no longer support. No problem; I'll get the new one online. I downloaded AVG...
  3. ssampier

    HP 5200 TN NDPS printer problem on Novell 6

    I am the "computer guy" for a small educational center. I have a little problem with an HP printer on Novell Netware 6. I have 3 network printers on a Novell 6 network. Up until this morning, the network and all printers were working without problem. When I arrived this morning I logged into my...
  4. ssampier

    Troubleshooting bad jack

    I am the sys admin of a small educational service center. I am the only computer/phone/anything-that-plugs-in person. I am having a little trouble trying to diagnose and troubleshoot a broken RJ45 network jack. When I plug any patch cable into the jack I do not get any lights on any NIC. The...
  5. ssampier

    Eliminate Duplicate Entries (fairly complex)

    I have a fairly complex problem relating to duplicated customer data. Here is a brief overview of the type of information and how that relates to the problem at hand. I work at a small Internet service provider. We have several disparate systems that are not integrated or combined. When our...
  6. ssampier

    Problem with compound expressions

    I have a phone number containing the area code, a dash after the area code, and a dash after the prefix. I would like to remove both dashes and remove the area code. Both would be replaced with a null character so a phone number 999-123-4567 would be 1234567 instead. To this, I have two...
  7. ssampier

    SQL in boundless form

    I have a boundless form that I want to be able to perform basic search queries. I defined an click event in Visual Basic. I defined variables for each search box. What I'd like to do to perform a SQL query on each text box that is Not Null. I'm having difficulty writing sql statements in either...
  8. ssampier

    Trouble with DELETE subquery

    I have a query that pulls data from a duplicate query. I need to make this query a subquery of a delete query--delete entries that are duplicate in a table--deleting data from the table tblEmail. I tried writing the SQL myself, but it gives an error. This is the original query code: SELECT...
  9. ssampier

    Duplicate Query, automatically remove duplicate entries

    I have an existing duplicate query that compares two columns that are identical, PhoneNumber and EmailAddress. The query also displays the Primary Key, an autonumber field called AutoNum. I have 10,316 results so I'd like to use an SQL statement to automatically remove these entries. Of course...
  10. ssampier

    trouble with Unmatched queries (Access 2000)

    I am comparing one table, tblUsernames, to a query, All Customers. The query combines information from two tables, our main customer table and the table storing their email address (tblCustomer and tblEmail, respectively). When I use the unmatched query comparing the query All Customers to...
  11. ssampier

    Form based on three tables won't update (Access 2000)

    I created a form using the Form Wizard. I selected our main table as the source table. I added the fields I need from the main table, then I added two different fields from two separate tables. The form moves from record to record just fine. I cannot, however, modify, any data in any record...
  12. ssampier

    Break tables without Table Analyzer (Access 2000)

    I have inherited the maintenance of a small database containing several tables and queries. None of our tables are related. Our main table contains over 8000 records. It has several repeating fields, such as email 1, 2… 31. I’d like to move these fields into their own related table, called...
  13. ssampier

    Help Using Unmatched Queries

    I have a Excel spreadsheet of email usernames. This file is emailed to me automatically by the system. I imported the usernames into a separate table, tblUsernames. I have another table that contains all customer records and their email addresses,tblCustomers. I created a query from all active...

Part and Inventory Search

Back
Top