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: *

  1. JJOHNS

    Primary Key Workaround

    I'd like to thank all of you for your assistance. If anyone is interested, here is how I resolved my problem: I used a KEY-CREREC trigger to present an error message if the user clicks the Insert Record icon and the student already has at least one record. I used a KEY-NXTREC to keep the user...
  2. JJOHNS

    Primary Key Workaround

    With your trigger you will not solve the issue, perhaps only prevent new dups to be added." That is all I have been tasked to do.
  3. JJOHNS

    Primary Key Workaround

    Thank you both for replying. Here is my problem: This application has been in production for several years (since 2007) and has been applied to 36 separate databases. I know that there are a lot of records already in databases that should not have been created. These databases belong to...
  4. JJOHNS

    Primary Key Workaround

    I have an Oracle Form which allows users to add more than one record into a table for a given person. Each person in the database is supposed to be allowed one and only one record. The simple solution was to use the person's ID as a primary key when the table was created. Unfortunately, the...
  5. JJOHNS

    Forcing User to Use LOV

    I have a form with a field that has a list of values associated with it. It's not actually set up as an LOV. Rather the original developer created a List Canvas that works like an LOV. Right now the user can key in the data in that field and get the rest of the record, but I want to force the...
  6. JJOHNS

    One Line in Excel to Another Line in Another Worksheet

    I think the pivot table idea is going to give my friend exactly what he wants. Thank you to all who contributed.
  7. JJOHNS

    One Line in Excel to Another Line in Another Worksheet

    I'm asking for this to help a friend. He is trying to use Excel as a content management system for dispatching jobs to locksmiths. So, the dispatcher takes the initial call and enters the data onto the main page, and assigns the job to a locksmith. Then she copies and pastes the data into...
  8. JJOHNS

    One Line in Excel to Another Line in Another Worksheet

    I need to have a line in one Excel Worksheet go into the next available line in another worksheet, so that if I enter column A = Roy Column B = $1.00 Column C = 4 Hours On any line of my main worksheet, it will automatically go to the next available line in my worksheet named Roy. I have a...
  9. JJOHNS

    Reset All Values to Default

    Can someone refresh my memory. I want one command that will reset all of the values on a form back to blank or default value. Thanks,
  10. JJOHNS

    Subtracting Dates

    Worked great! Thanks
  11. JJOHNS

    Subtracting Dates

    I'm creating a little calculator in VB.NET. The formula I'm calculating is different when the startdate entered by the user is over 90 days ago, than when it is less than 90 days ago. So, I need a way to determine if the date they entered is more than 90 days ago. user enters: StartDate. If...
  12. JJOHNS

    One terminal will not find all the Access records....

    I had a similar problem once. It turned out that a user had made a copy of my database and put it on their desktop, thinking they were creating a shortcut. To check, right click on the icon and make sure it is a shortcut and not a database.
  13. JJOHNS

    Excel Formula Problem

    That was it. Thanks Ken!
  14. JJOHNS

    Excel Formula Problem

    I have a spreadsheet with a lot of formulas in it. When I open the file on my hard drive, the formulas don't always work. If I save it to a disk and open it from there, the formulas work fine. If I save it back to my hard drive from the disk, the formulas will work fine until I close the file...
  15. JJOHNS

    Excel Time Conversion

    Thanks dhulbert. Worked great. SkipVoight, umm, huh?
  16. JJOHNS

    Excel Time Conversion

    I have times in decimals. I want Excel to return it in hh:mm:ss format. So, if I put 7.50 in cell A1, then B1 should show 7:30:00 Does anyone know how to do this?
  17. JJOHNS

    Cumulative Numbers

    I have a database that I want to calculate Year-to-Date numbers. For now, if there is no record for a certain person, then the Year-to-Date number becomes equal to the daily number. That works. When there is already data in the database, so the program should go and add yesterday's number to...
  18. JJOHNS

    Most Recent Record of Several Individuals

    The problem with that is that because the name field is in the query, I get this error: "You tried to execute a query that does not include the specified expression '[Name]' as part of an aggregate function." I'm starting to think the best answer would be to create a second table. I could...
  19. JJOHNS

    Most Recent Record of Several Individuals

    Here is what my assessment table is set up like: PKey - Name PKey - AssessmentDate Result1 Result2 The people in this program are assessed based on certain results. It's a health-monitoring program, so they're assessed based on weight change, heart rate, BP, etc. Each month's assessments are...
  20. JJOHNS

    Most Recent Record of Several Individuals

    I have a program in which members are assessed monthly. The problem is not all members are assessed on the same day, and some less active members occasionally skip a month. My database tracks the assessments. I need a report that list all the members and their most recent assessment. Can...

Part and Inventory Search

Back
Top