Search results for query: *

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

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

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

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

I have daily numbers stored in a table. I can use a stored procedure to pull the data. My supervisor has asked me to add a button to my system that will display a line chart reflecting trends in those numbers. I'm not sure where to start. Can anyone help with this?

I have a web page that is basically a list of states, with information about each state. It's a very long page, so I put links to each state title at the top of the page, using anchors. Now, to take up less space at the top of the page, I want to put the anchor references in drop-down lists...

I have a report for a list of employees. In each record, there are four checkboxes that tell me something about the employee. On the report, I'd like the record to be highlighted a particular color if one of the four checkboxes is checked. I've managed to get the form to highlight in color as...

I need to add a time stamp to an Excel spreadsheet. If someone changes one cell, I want another cell to change to today's date. Something like this: A3 changes, causing A11 to =Now() It should only change the value in that row. Is there an easy way to do this?

I have a graph in a report. The X Axis is a date range. No problem there. The Y Axis is a weight range. If I way myself every day, you can see any fluctuations in my weight over time. If, on the other hand, my girlfriend weighs herself every day, the increments on the Y Axis will be...

In my job, we are required to take a certain number of classes each year to keep our license. I have a report that shows how many classes each employee has taken so far. Works great. The problem is those who have taken no classes yet are not showing up on the report at all. I need to either...

I have a database I work on quite a bit. Something has happened to it that I can't figure out. When I try to open it, the password box pops up. I enter the password, and then I get a gray screen. The database doesn't open. I've tried to open the database several different ways, including...

I was asked to add a report to a database that counts records by type. Simple, right? Here's the problem (I think): There are about 20 users who add about 10 records each per day to this database. When I was asked to create my report, it had over 28,000 records in it. When I tried to count...

Here's the problem: I have a start time and an end time, something like this: Start: 3:32:16 End: 6:02:22 I need to be able to represent the total time as a decimal, 2.5. Does anyone know how to do this?

Here's my problem. I have a couple of Access 2000 books and have tried to use some code at work, but it doesn't work. I use the same code at home (also on Access 2000) and it works fine. Does anyone have any idea what the difference is between my program at home and the one at work...

I've been given a new project that should be pretty interesting, but I'm not completely sure how to start. Right now, data from a proprietory database is provided to my user in a Word document. My user then keys it all in to an Excel spreadsheet every day. This file is about 300 records long...