Recent content by CoolFactor

I have the following query: ID Competency StartDate EndDate FTE 1 PM 10/1/2009 9/30/2010 1 2 PM 10/1/2009 9/30/2010 1 3 PM 10/1/2009 9/30/2010 1 1 PM 10/1/2010 9/30/2011 1 2 PM 10/1/2010 9/30/2011 1 3 PM 10/1/2010 9/30/2011 1 1 PM 10/1/2011 9/30/2012 1 2 PM 10/1/2011 9/30/2012 1 3 PM...

Can you give me an example?

Hello, In my form I created a label that just says "Report." I want to tie this label when I click on it to open a Crystal Report. Of course the Crystal Report would be opened in the Crystal Report Application itself. It almost like tying it to a file path somehow. Any info. would be much...

PHV, How can I get the work days out here?

What Reference do you think it is?

Hello, I have 2 fields one by the name of FirstDay and the other by the name of LastDay and I want to calculate the number of days between the 2 fields using the following expression: NumberOfDays: DateDiff("d",[FirstDay],[LastDay]) I get the Undefined function "DateDiff" in expression error...

Thank you it worked!

It's still not working. I appreciate the help.

I put this piece of code in the command button on click but nothing happens.

Hello, I have couple list boxes on a form that depend on each other . In list box 1 I have the following VBA code in the Before Update Event: Private Sub ListBox1_BeforeUpdate(Cancel As Integer) Me!ListBox2.Requery End Sub When I select an item in list box 1 then list box 2 shows the relevant...

Thanks Guys all your suggestions worked out!

This maybe very simple but how can I add a message box to the following command button on the click event in which if the answer to the question is Yes then open the Report and if the answer to the question is No then do not open the Report. I guess it's more like a statement followed by a...

All I want to do is to exclude [S8] AS SFTE and [S9] AS SFTE from the Union query SELECT qry_Smoother2.Location, 'Y0' AS YEAR, [Y0] AS FTE, 'S0' AS S, [S0] AS SFTE FROM qry_Smoother2; UNION ALL SELECT qry_Smoother2.Location, 'Y1' AS YEAR, [Y1] AS FTE, 'S1' AS S, [S1] AS SFTE FROM...

PHV, I've tried this but it's not working properly. How can I incorporate this Docmd transfer method into the code that I already built. I really like the first part of my code because it allows the user to select whatever excel file they want. Can you show me how to incorporate this...

When I try to execute this it kicks up the error with the sFileName that it requires a file argrument Also I want it to create new table in access, I really don't want to define the table Thank you