Search results for query: *

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...

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.

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...

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...

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...

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

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...

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...

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,

Worked great! Thanks

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...

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.

That was it. Thanks Ken!

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...

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

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?

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...

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...

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...

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...