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 Chriss Miller 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: cdawley4
  • Order by date
  1. cdawley4

    Removing unwanted text

    Hi, I have this spreadsheet with a lot of text in a column. The column is set up as follows. Text 08:43:00 I want to be able to get rid of the time. I could do this with text to columns, but some rows within the same column have 3 or 4 items. Ex: Text 08:43:00 Text 08:43:00...
  2. cdawley4

    Unrecognized database format

    Hi, I was moving files from my floppy disk to my pen drive and accidentally deleted a file that wasn't on the drive. I thought I moved it over but must have skipped it. Anyways, to make a long story short, I deleted it. I tried to recover it last night and was successful, except when I go...
  3. cdawley4

    Augat DSX3 Panel

    I don't know how deep y'all get in this forum, but I have an Augat DSX3 Panel that I won off of Ebay. It has 22 cards in it but I am not sure it works. I didn't get any documentation of how to wire it up. The only connections I see on the back of the dsx as far as power is +48V and -48V...
  4. cdawley4

    Name & Number lookup

    PHV, Thanks for your help. I figured out what was happening. I had the datebase pulling information from a different query and trying to get the VB Script to work as well. I created a test database to see if it would really work and it did. That is how I found out it was a query/VB Script...
  5. cdawley4

    Name & Number lookup

    That doesn't work with the Column(1). Any more suggestions?
  6. cdawley4

    Name & Number lookup

    That almost works. If I leave off the .Column(1), I get the info in the Combo Name box. If I add the .Column(1), I get nothing. I tried .Column(2) since the phone number is in Column 2. That doesn't work. Am I missing something? Thanks, Chris
  7. cdawley4

    Name & Number lookup

    I tried the combo box and it didn't accomplish what I was doing. The names are in a combo box and the phone number field is set up as a text box. I want to be able to pick a name from the combo box and have it fill in my text box with the phone number that matches the name on my combo box. I...
  8. cdawley4

    Name & Number lookup

    Hi, I have a database that contains a main table and several lookup wizard tables linked to the main table. Within the database, I have some Names and Phone numbers. I also have a form that I can fill out. On the form, I have the names and phone numbers as well, with a row source pointing...
  9. cdawley4

    Names & numbers

    The table is set up like: tblPeople PersonName PersonTelNo The main table includes the fields and I used a lookup wizard for it to look back at the tblPeople for the names. PersonName PersonTelNo Thanks, Chris
  10. cdawley4

    Names & numbers

    I am modifying an existing database that contain names and phone numbers. I want to be able to select the persons name and let the database automatically select the phone number that matches that person. I am thinking that is going to be a relationship thing. Would there have to be any code...
  11. cdawley4

    Insert row

    jb, Thanks for the reply. When I ran it the first time, it came back with an error in the debug process, however, I was able to fix it by removing Set XL = CreateObject("Excel.Application") XL.Application.Visible = True and changing While XL.ActiveSheet.Cells(lin, 1) <> "" to While...
  12. cdawley4

    Insert row

    I have a spreadsheet with about 200 rows and I want to write a script to insert 2 rows after the row containing the text. Ex: This is what I have in excel. abcd abcd abcd abcd This is what I want it to look like. abcd (skip 1 row) (skip 1 row) abcd (skip 1 row) (skip 1 row) abcd (skip 1...
  13. cdawley4

    Password Generator

    I have created a database with my personal and work related passwords on them. My work related passwords expire every 60 days. The password limitations are: a. Password must be at least 8 characters b. Password must contain at least 1 number and 1 special character. c. Password can be a...
  14. cdawley4

    Adding records to Oracle

    Question 1 - Is learning Oracle part of your current job description? A. It is not a part of my current job description. Question 2 - What is your job title? A. I am a technician in the telecommunications industry. Question 3 - Are you wanting to learn Oracle as a side activity to improve...
  15. cdawley4

    Adding records to Oracle

    I was talking to a co-worker that knows oracle and explained that I wanted to be able to create tables, queries, forms, reports, etc from scratch. They said that was more along the lines of Oracle Developer, and that Oracle DB was for maintenance, size, cleaning, & security. Is that true or...
  16. cdawley4

    Adding records to Oracle

    As you all can tell, I am very new to oracle. I just downloaded and installed the 10g db on my home computer and was able to get logged in after altering the password for the SYS user. I am in the learning stage and want to know how to add data to the database. Is this a sql command line...
  17. cdawley4

    Oracle question

    I got in an created a user account for myself. How do I create a database with this program and learn how it works?
  18. cdawley4

    Oracle question

    Does it make a difference which oracle demo I download? I downloaded the 10g_win32_db at work and I am now downloading both the 10g_win32_db and 10g_win32_client for my home use. Is the client necessary or does the 10g_win32_db have client built in?
  19. cdawley4

    Oracle question

    Here is the readback from the SQL prompt. USERNAME ------------------------------ SYS SYSTEM DBSNMP SYSMAN MGMT_VIEW OUTLN WK_TEST MDSYS ORDSYS CTXSYS ANONYMOUS USERNAME ------------------------------ EXFSYS DMSYS WMSYS XDB WKPROXY ORDPLUGINS SI_INFORMTN_SCHEMA OLAPSYS WKSYS MDDATA DIP...
  20. cdawley4

    Oracle question

    I am trying to learn more about different databases and how they work. I downloaded Oracle 10g and installed it onto my computer, so I can experiment with Oracle and learn how to use it, to enhance my DB skills. I created a test database but when I try to log into the database, it denies me...

Part and Inventory Search

Back
Top