Search results for query: *

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

I understand that portion and I thank you for your time but at the moment this is what I have: Private Sub Command0_Click() DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, TableName, Filename, True End Sub I want it to transfer the data into a new table in Access with an...

I did follow your link and this is what I have so far: I do want this to be a specific workbook at all and I want it to transfer to a temp table that access creates on it's own Private Sub Command0_Click() On Error GoTo Err_Command0_Click DoCmd.TransferSpreadsheet...

how would you put it together as an example? I apologize if this is to much to ask.

Golom Actually, I'm trying to figure out how to capture everything in Column A, Column B, Column C etc... to a temp table in Access in their respective fields. I appreciate your input, I wasn't sure if what I was doing was right or not. I like the first part of my code because I can open an...

I'm getting data conversion Error: I also changed a part of the code presented above: With ExcApp.ActiveSheet 'ActiveSheet' rst("PEODirectorate") = ExcApp.ActiveSheet.Range("A2:A45") rst("Profile") = ExcApp.ActiveSheet.Range("B2:B45") rst("System") =...