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

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?

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

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

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

Hi. I am using the following script to alter a new field to a table in my database based on the entry on a form. I won't explain why but it is working. However, I really need to make the new field that I have a set as a number, a Yes/No field. I cannot figure out the format to set it to...