Recent content by sluggercoach

Hi. I have a database set up that is supposed to automatically send emails out when a form is filled out. The cose works fine but when this happens Outlook generates each email one at a time and then waits the user to click the send button. This defeats part of the purpose of the email...

Hi. I have a form that has a sub-form on it. I am trying to refer to a field on the subform from within a query. Basically when you click on a check box on the sub-form I am trying to then open another form asking for a password. So the query has to know which record you are on, on the...

Excellent. That will work. Thanks so much!

I am not sure what you mean. The problem is that the values are stored in separate rows in the table. So it just lists them on the report one at a time. I need all of the values in the table related to one change to be displayed in a text box separated by commas or some character. Can you...

I have 2 tables that are linked with a one to many relationship. The main table has a list of changes that are going to take place. The 2nd table has the many different stations that the change could affect. People need the ability to view a report showing each change and what it affects...

Hi. I need a way to determine if a number in a query is even. Anyone know how?

haha. Do I sense a little sarcasm there?? I have the database and everything set up, I just need to know the best way to create the query to select the top -- however many -- based on the value from another query. I am sure I can figure out but just wondering if anyone had any thought.s

I have a challenging issue... I have 2 tables. One contains engines that are available to build by a specific part number. The other contains a schedule of which part numbers need to be built. I have been asked to take the schedule table, count the number of engines by part number (for...

Not sure my title is very good but... here is what I need to do... I have a database with a form where a user will chose a specific zone (Zone 1, Zone 2, etc.). They can choose multiple zones. I want to be able to display all of the zones that they can choose from on the screen and give them...

HEre is what it is. I took the code from your sample database and modified it to try and get what I need. Right now I am getting the End Date from Row 2 minus End Date from Row 1. What I need is Start Date from Row 2 minus End Date from Row 1. I don't know what the code tags are. Sorry and...

OK. I have the code working except for one thing. I am trying to take a time from Field1 in row 2 and from a different field in row 1. I have a table that has a start time and a finish time in. To calculate travel time I have to take the start time from record 2 minus the finish time from...

I think I understand. I just need to change a few things to match my tables and I should be good. Thank you so much! I have been struggling with this a while now. I was doing about 5 make table queries (which always somehow fail when you give them to the end user) to try to do the same thing!

Thanks alot. I see the database but I am having a hard time understanding what you are calculating in the sample. It seems that you are just taking data from one table and putting it in another. Maybe I am not following. What I am trying to do is calculate the difference in time between 2...

Hi. I am attempting to do some calculations with time that requires me to pull data from 2 different records. Below is an example. Record # Start Time Finish Time 1 9/3/2009 8:55:09 9/3/2009 9:01:09 2 9/3/2009 9:04:10 9/3/2009...

I am about to go crazy! I have something that I know should be easy that I cannot get to work. I have an application that has a form with several subforms on it. The user opens the forms and I need to be able to allow them to view a report to show more details about what they selected in the...