Search results

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

The code was certainly Bob's from a post on this site. I apologize if I wasn't allowed to use it. I thought if it was posted I was ok. I got it to work now with station but I also need to group by shift. I tried changing the code to have a 2nd group by item (I called it pgroup2) but I...

Sorry. That result should look like this: F0100 3.41666674613953 F0130 3.41666674613953 F0140 3.41666674613953 F0160 3.41666674613953 and so on...

I have read through the forum and found many posts on how to calculate median. However, I am still having trouble. I am attempting to calculate median cycle times per station for an assembly. The result should look like this: F0100 2.56 F0400 5.87 F0425 9.09 etc, etc. Here is the code...

Yes/No Yes. That works to set the data type in the table but the Format is still blank.

Example Sorry for the confusion here. I know how to set the format manually. I need to know how to do it in the code below for the Yes/No format. Dim strNewStation As String Dim strNewStation2 As String strNewStation = "ALTER TABLE tblSchedule ADD COLUMN Printed" & Me.NewStation & " DATE;"...