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...
Had a look @ your script try this.
<script language="VBScript">
<!--
Function CreateWR_onSubmit()
if Document.CreateWR.FloorSelect.Value = "" then
Msgbox "Invalid data"
CreateWR_onClick=false
else
CreateWR_onSubmit =...
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 = "Hello" Then
document.selection.combo2.style.display = "none"
Else if document.selection.combo1.value = "Goodbye" Then...
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.
Try this line of code
DoCmd.OutputTo ouputQuery, "Your Query", "MicrosoftExcel(*.xls)", "C:\Your File.xls", True, ""
Hope it helps
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.