Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by CoolFactor

  1. CoolFactor

    How to change query format

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

    How to link an object to a "Label," in a form

    Can you give me an example?
  3. CoolFactor

    How to link an object to a "Label," in a form

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

    Problem with DateDiff Between Two Fields

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

    Problem with DateDiff Between Two Fields

    What Reference do you think it is?
  6. CoolFactor

    Problem with DateDiff Between Two Fields

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

    Restore selection on listbox dependant on another listbox.

    Thank you it worked!
  8. CoolFactor

    Restore selection on listbox dependant on another listbox.

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

    Restore selection on listbox dependant on another listbox.

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

    Restore selection on listbox dependant on another listbox.

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

    Excluding specifc values of a Union Query.

    Thanks Guys all your suggestions worked out!
  12. CoolFactor

    How to add a message box to my command button

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

    Excluding specifc values of a Union Query.

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

    VBA code not importing excel data as intended to

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

    VBA code not importing excel data as intended to

    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
See more

Part and Inventory Search

Back
Top