Recent content by striker83716

I am trying to create a crosstab query that will sum hours between dates, based on system failures. In the table below, the first three columns are from the table, the last two columns, is the data as I would like it to appear. I am posting here, because I believe I will need some VBA for this...

Thanks for your help jedraw!, After walking away and thinking about your reply, I realized you were right. I now have a query giving me the results that I need. Thanks again, and have a star!

Thanks for your recommendation, and I agree that doing this is not the normal practice. But because of the complexity of this project, I must do it this way. By the way this is a temp table that will be deleted and replaced every time the code is executed/report is needed.

I have an access table that has two date fields. These fields are titled StartDate and EndDate. They represent a range of time. I am simply wanting to put these ranges into a new single column table using VBA. The range needs to include the StartDate, EndDate and include every date that is in...

I have tried the AfterUpdate of the list box to change the recordsource of the graph as well as the code above, which is also triggered by the afterupdate of the listbox. In both cases If I select a value that has a series collection of 1, then select a value that has a series collection...

I am struggling with a access database I am working on. I have a form with a graph and a list box. After update of the listbox I would like to update the graph's recordsource. The recordsource will not be based off of the same table or query. I have this somewhat working, however when I...

3 text boxes. Name them txt1, txt2, txt3 The control source of txt3 = [txt1] - [txt2] Hope this helps

This is still a great option. Just instruct the managers/leaders that are performing the evaluations, to save the .dot file to their hard drive. Then, when they are ready complete the evaluation they need to open the file by double clicking on the icon in explorer. Or if the file is saved on...

Gerry, Gave you great advise, put a table on you form get it all set up the way you want it then make the color of all of the borders of the table that you do not want to see white.

It is possible to make a template in word. First create the document that you want, but be sure to use the form toolbar, insert controls that the end user will complete, such as a text boxes where the end user will put the fax number, the receipent etc. Name: TextBox Phone: TextBox Fax...

Binder is still available in Office 2003. It, however, is not installed by default. If you insert the setup disc, and selct custom install you can selct and install Binder.

Try this, Open the form in Design mode, change the property "Data Entry" to Yes, save and close. Now when you open the form it will always be a new record.

Woo-Hoo it works. Thank you So much for your help. It does give me more then one record for each employee but I can easily create a "min" on the date column. Thanks again for your help. Rob

2003, happy to convert If i need to. If so tell me which version you have.

here I get "Enter Parameter Value dialog box asking for the "Duration"? sorry to be such a pain but I am really struggling here.