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...
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...
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...
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...
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
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...
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...
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
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...
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...
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...
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...
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...
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...
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...
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?
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.