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!

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

Search results for query: *

  1. watty215

    Deleting oldest file

    Try this it works for me ! Dim objFSO Dim ofolder Dim objStream Set objFSO = CreateObject("scripting.filesystemobject") CheckFolder (objFSO.getfolder("C:\Your Folder")), objStream Sub CheckFolder(objCurrentFolder, objLogFile) Dim strTemp Dim strSearch Dim strOutput Dim...
  2. watty215

    Passing value from drop-down list in form for validation

    Had a look @ your script try this. <script language=&quot;VBScript&quot;> <!-- Function CreateWR_onSubmit() if Document.CreateWR.FloorSelect.Value = &quot;&quot; then Msgbox &quot;Invalid data&quot; CreateWR_onClick=false else CreateWR_onSubmit =...
  3. watty215

    OWC Chart Help

    This line of code works fine with office xp chart but not OWC Chart
  4. watty215

    OWC Chart Help

    Does anybody know how to put an axes on the right of an OWC Chart.
  5. watty215

    ComboBox Hide

    It's ok i have done it for anybody who would like to see the code here it is. Sub Combo1_onChange() If document.selection.combo1.value = &quot;Hello&quot; Then document.selection.combo2.style.display = &quot;none&quot; Else if document.selection.combo1.value = &quot;Goodbye&quot; Then...
  6. watty215

    ComboBox Hide

    I have two combo's in a form i want to hide the second box when a certain value is selected in the first box and show the combo again when another value is selected.
  7. watty215

    Query to export data to excel

    Try this line of code DoCmd.OutputTo ouputQuery, &quot;Your Query&quot;, &quot;MicrosoftExcel(*.xls)&quot;, &quot;C:\Your File.xls&quot;, True, &quot;&quot; Hope it helps
  8. watty215

    creating time specific reports.

    Create a Form with two text Boxes then point your query at them using builder Put dates in each text box Criteria: Between [Form]![text1] And [Form]![text2] Call the query with a command button on the same form
  9. watty215

    Variable Chart Rowsource Data

    Instead of trying .text try .value this may work

Part and Inventory Search

Back
Top