Search results

?? Could it be bound to a report? for instance the report I have, once populated, may have 1000 employees. but, i do not understand about binding to a form. When a person gets a warning notice, I click a yes/no box on a form, the query looks for "yes" results and then list the names. i guess I...

I have a query that pulls up information on employees when they receive warning notices. I would like the query to give me some type of warning (report, email, etc.) when an employee has three or more notices. Can someone help me with this? - Thanks in advance!

I have a macro that opens a form. On this form I use an unbound menu to select a persons name that populates a report with data concerning this person. the report opens in print preview. All of that works fine. I would like to send the report that is on the screen via an email as an...

I have a query that runs info selected from safety visits. I have made a form with an unbound combobox that selects the supervisors name and after the name is selected, I have a button to run the query. When a name is selected, the query comes up blank. When I do not select the name, the query...

I have a report that has numerous records in it. Some of the records are split (starting on one page finishing on the next). How can I stop this? I would like the report to throw the record onto a new page if it would not fit on the page area that is left on the previous page.

Here is my SQL SELECT main_input_table.ID, main_input_table.Date, main_input_table.Vessel, concerns_sub.concerns, concerns_sub.comments, main_input_table.Location FROM main_input_table INNER JOIN concerns_sub ON main_input_table.ID = concerns_sub.Number ORDER BY concerns_sub.positives DESC ...

yup That's what I need!

nope not working??

I need help again! I have a query that I am making a report off of. The querie has infor for a vessel, good findings, bad findings and comments. I want the report to see bad findings per vessel. I added a criteria space under the vessel section and when you type the boat name in, the report...

I have updated some tables and stuff with new fields. I have updated the queries to have the new fields in them. Where I am building the report, the field list drop down menu does not show the new fields in the querie. How can I get this info to show so I can use it in m report? The help files...

My report for my project is pulling info from a query that queries three tables. For simplicitys sake, there is a main table a good table and a bad table. I want my report to reflect the info from the main table as the header and the info from the good and bad tables in the detail section. Is...

I posted a "issue" I was having with a query a few days back. To all who helped me, thank you - but, nothing worked. This is what I have. I have three tables that I need to pull info from. These tables get thier respective information from a main form and 2 subforms. I have relationships built...

I am trying to build a report that will use multiple subforms. The report will be made from a querie and the tables are already linked in the relationship area. How would I format the report?

What would be the best way to print a report from a form that has 2 subforms in it? I created a query and would like to choose from one of the catagories on the main form. What is happening is that I come up with a report with multiple entries of the same item (87 to be exact). I have only 1...

ok Here is the way I have it in the event procedure block Private Sub Form_Current() Me.Text60 = IIf(DateAdd("d", 31, "[Last Fire Drill]") < [Inspection Date], "Drill Past", "") End Sub It is giving me a run time error!?!?!?!?!?! - I think I will skip this and get a cup of coffee!

Duh ! I tried your example and I have not had any success. Just to get it right, You want me to click on the properties of the form and not the control box.....correct?

Meaning??? I did not know that date is a reserved word. Also, what are you talking of when you mention oncurrent event? If I change the Date range to inspection date, how would I syntax the formula? Just checking on this. I would make a unbound box, click and stick the formula directly in...

here you go! If you look at your example, thats what I would like. The database stripped is to large to send even stripped down. The date it compares to is not always going to be the current date. It would be another field named date. I did not mention that before. So in a nutshell, I am...

I am not having any luck. It just will not work on my end. I would really like to have this work as a reminder to my guys when the fire drills are over due. I looked at your example and it seems to work, I do not know what the issue is. Thanks anyway!

Hmmmmm Ok, well I tried that and changed the name to my field and I get a #error sign.:rolleyes: