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 strongm 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: amerifax
  • Content: Threads
  • Order by date
  1. amerifax

    Queryare there with him him in the

    I am trying to create a quarry which is totally new to me. I am including a picture that gives a better idea what I'm trying to do. I'm drawing the value from field "PropertyDescription_1". Note: The image shows lot as a field. That was a mistake "Lot" is a vale within "PropertyDescription_1"...
  2. amerifax

    Transferring a Value that is contained in a field for 250,000 records

    It's hard to describe what I need to do but I put together a text file that I am attaching to try to help explain. But bottom line I have a field called PropertyDescription_1 where there is a high probability of a Subdivision Name contained within if certain conditions are met. I hope I'm not...
  3. amerifax

    Concatenate

    I am not sure if I am posting this in the correct spot...if not I apologize. I am using Access 2007. I have three columns, fst,lst and name. How do I get the column "name" to contain "fst and last"? So basically I have a table with first name and last name in seperate fields. I would like to...
  4. amerifax

    Should I UpDate dBase 5.5

    Sometime ago I had updated to visual 7.5 and had problems so went back to 5.5. I am now in Windows 7 and very happy. I have not migrated my 5.5 away from XP. When DBS was purchased, I believe from Ashton-Tate, the new company had some price schemes that didn't set well with me. 5.5 works well...
  5. amerifax

    Move table from one computer to another

    I have a table that I would like to copy across the network using a PRG. Thanks for the help. Bob
  6. amerifax

    End of file encountered

    End of file encountered I recently saw a message that mentioned encountered. I felt I should respond to this topic since I had a huge battle with dBase (Aston Tate) back around base IV in regards to the error message. It was a bug with dBase. It was a very big fiasco that ended out with a...
  7. amerifax

    Uncertain about relationship

    I have a master database called permit. It has all the builders that built homes in Wisconsin in past years. It only has one number that has builder information “BLD”. That is the reference used in the builder database file. It’s called “Builder”. It has a reference called “BLD”. I want to link...
  8. amerifax

    Use network file

    We are trying to use a field across the network. Rather than using a mapped network drive we would like to use the network path to the file. When we use the following path: use \\heather\c\file\dbv\Per_dil excl We get this error: Invalid file name. Do you see any problems with this? Bob
  9. amerifax

    ALTER TABLE

    We are trying to add a field on the fly. This is the code that is shown in the example: ALTER TABLE CUSTOMER ADD REFER CHAR(20), ADD LASTCALL DATE, DROP FIRST_CONT The code we are using is: alter table Perdil add STEPXX char(3) The error we get is Table does not exist. I tried adding the...
  10. amerifax

    Swith from dBase IV to Access 2007

    I dont have much luck on questions about dBase so I Switched to Access 2007. Can any one show be the code I would need to run the following in Access 2007. It would give me a goos ubderstanding on how we use data. Note: (For the most part) a. lower case = code b. upper case = table for file c...
  11. amerifax

    Average

    Based on the above message on finding the total, we are also trying to come up with an average. How would the average work. One of the fields gives the weight of the car and it runs by the year. Each year we have a different weight over a three year period. We want to come up with the...
  12. amerifax

    Find Total

    We have a database of model cars wil a total field. We want to propagate the total field with how many times that model of car appears. So if a ford is listed in a file of 100 records 5 times the total for that field would be 5 where ford is listed. The rest of the fields depending on the...
  13. amerifax

    CMOS reset to post

    I have no display on my XP Pro x64. I have a Dell 30 inch and a 24 inch set up as a dual monitor. The only way I can see a display is to flash the cmos than go into cmos. Here I see a dispaly. When I exit and try to load windows I have no display. I then flash the cmos and , again, can see the...
  14. amerifax

    Folder Limitations

    Not sure if this is the right place to post this but...As a rule of thumb is there a limitation on the number of files that can be in one folder? What about a size capacity? Just wondering... Thanks, Bob
  15. amerifax

    AddressBar Shortcuts

    I created many shortcuts in my register *\app paths. My address bar opens on the taskbar when I highlight the taskbar (Like a qualifier). Is there a way to execute an address bar command without having to highlight the address bar? In other works just type the shortcut key.

Part and Inventory Search

Back
Top