SPCnut

I have a form that when you push a button "1st Call Placed", the date and time automatically updates in the text box below the button. There are 9 of these buttons on the one form. (1st Call Placed, 2nd Call Placed, & 3rd Call Placed). When a call is placed to the speciality physician, the unit clerk is to push the appropriate button and the date/time is updated. This is to eliminate how much typing needs to be done and reduce input errors.

My problems is this...the first time you push the 1st Call Placed button, the date and time appears immediately. When I push any of the other 8 buttons, the date/time never appears unless I exit the form and reenter it again. They are all running off their own macro. Any idea why this is? Is there an easier way I can do this so the date/time is more real-time? TIA!!!

I am trying to query on my long date field (ex. Monday, April 11, 2011). I want to pull out all of the Mondays. I have tried Like 'Mon%', but cannot get the Mondays to filter. Any suggestions?

If I enter 04/19/2011 in the DateOfCall field on my form, I would like the DayOfWeek field just below it to say "Tuesday". Is that possible?

My husband and I missed our connection with AA in Chicago on Tuesday evening. It was the last flight out that evening so we re-booked for the next morning. We then went to stay at the Hilton there at the airport. Later we find out the airlines offer hotel vouchers for this type of situation. (We were never offered by AA the voucher while re-booking after missing our connecting flight.)

So...do you think it is worth pursuing with AA or a waste of time? BTW, the hotel stay was $269!!

I have created a database the finds the difference between two times:

diff = [time_notified]-[recd_from_lab] ---> this works! it gives me the mm:ss that I need.

Now, I want to take that "diff" and have it tell me if the time is within 60 minutes or not. I have,

=IIf([diff]>"1:00","No","Yes") ----> this is NOT working. How do I tell Access that if the diff time is < 1:00 I want the box to say "Yes" else "No"?

If I want to sum the total of vectors at specific locations, how do I do that?

I tried this and it doesn't like my "+" sign. I want to add the numbers in the 3rd and 10th element of the vector together. How do I do it?

int sum = 0;

sum = [vector.elementAt(3)]+[vector.elementAt(10)];

I am working on a program and trying to get the user to input 5 names and their scores (any int would do). I cannot get it to work so I can enter the 5 names and scores.

import java.util.*;

public class Election

{

static Scanner console = new Scanner(System.in);

public static void main(String[] args)

{

String names[] = new String[5];

int votes[]= new int[5];

//int totalVotes=0;

int index = 0;

int counter = 0;

System.out.println("Enter the canidates name: ");

console.nextLine();

System.out.println("Enter the canidate votes: ");

console.nextInt();

for (counter = 0; counter <= names.length; counter++)

{

names[counter] = console.nextLine();

}

for (counter = 0; counter <= votes.length; counter ++)

{

votes[counter] = console.nextInt();

}

int j = 0;

for (j = 0; j < names.length; j++)

{

System.out.println("The candiates names are: " + names[index]);

}

int i = 0;

for (i = 0; i < votes.length; i++);

{

System.out.println("The canidate votes are: " + votes[index]);

}

}

}

I have my program working for ints, but my inputs need to be doubles as the scores are 9.2, 9.5, 9.6, ... How do I do this?

import java.util.*;

public class Gymnastics

{

static Scanner console = new Scanner(System.in);

public static void main(String[] args)

{

int [] scores = new int [10];

int sum;

int counter;

int newSum;

System.out.println("Enter the 10 gymnast scores: ");

sum = 0;

for (counter = 0; counter < scores.length; counter ++)

{

scores[counter] = console.nextInt();

sum = sum + scores[counter];

}

int highestScore=scores[0];

for (int i = 0; i < scores.length; i++)

{

if (scores[i] > highestScore)

highestScore = scores[i];

}

int lowestScore=scores[0];

for (int j = 1; j < scores.length; j++)

{

if (scores[j] < lowestScore)

lowestScore = scores[j];

}

newSum = 0;

newSum = sum - highestScore - lowestScore;

System.out.println("The sum of the gymnast scores is: " + sum);

System.out.println("The high score is: " + highestScore);

System.out.println("The low score is: " + lowestScore);

System.out.println("The final gymnast score is: " + newSum);

}

}

I have horrible heartburn caused by my gallbladder. I am anxiously awaiting my pending surgery date...in the meantime is there anything stronger than Tums that can help me get through the days? My whole chest hurts and feels like it is on fire.

(I also take a Prilosec every night.)

My dad wants to buy a compound bow for my daughters (ages 7 (left-handed) and 4 (right-handed). How do I determine what eye dominance they are so we know whether to buy a right or left handed bow?

We are getting phone calls from a family member's credit companies because of late or no payments. How can this stop? We do not have contact with these family members.

We are going to check our credit rating to make sure they haven't affected that at all.

I am scheduled for surgery to correct my deviated septum later in June. What do I expect? I have heard from the doctor, but I want it straight from the horse's mouth. What is the surgery like? What is the recovery like? How long before I will be able to care for my 2 girls (ages 6 & 4) again 24/7? Anything else I may want to know?

TIA :)

Is there a way I can separate the tracks so I can put it on more than 1 CD?

The hospital here won't perform the surgery because they don't think he can survive it. He wants to go to Cleveland hospital because he is convinced they will perform the surgery. His heart also has an EF of 20%. What is his life expectance if he doesn't have the surgery? If he does have the surgery what are his chances of survival from the surgery and what would his life expectancy be after the surgery? I am telling him to not have the surgery and just enjoy his life to the fullest.

Here is a link to the video:

http://www.jeanbamin.com/article-5285966.html

On the new Wii play disc, what does it mean when it asks you to find the "three odd mii's out"?

I keep getting the following error in Yahoo Mail while trying to send a message to about 50 addresses:

There was a problem:

Your Bcc field contains too many addressees.

Your message has not been sent.

I have Sunrocket - which phone is the best for VOIP?

The muscles from my knee to my ankle on the sides of both legs burn so bad when I exercise that often my toes go numb and my ankles are so weak they give out on me. What can I do to?

I work out on the treadmill or elliptical.