Search results for query: *

Thanks guys but I used - it is a bit longer and required three queries because of the length - hey thanks again but can anyone answer my question about using a statement as the return value for an iif statement when it is true ? SELECT Table1.date1, Table1.value, Table1.value2 FROM Table1 WHERE...

The iif will check to see if the current date falls between a date range and if it does it will then return the records with a date between a date range - this is going to find out which quarter is the current quarter and return last quarters data. Ps - I know that the current code doesn't...

Hi - I am having some difficulty using a between statement in iif statements My separate iif statement and between statements work but when I join them they don't SELECT Table1.date1, Table1.value, Table1.value2 FROM Table1 WHERE (((Table1.date1)=IIf(Date()=#5/9/2003#,(Table1.date1) Between...

Does anyone know what compression utility makes *.dl_ files that are decompressed by decomp.exe - if it is compress.exe then which version ?

ActiveDocument.PrintOut as far as I am aware it just prints the file to the default printer.

I have added code to a button in a template but when I open the template as new the code does not follow the the button over to the new document ? Can anyone help ?

Thanks - I now have that code and it works fine except that the code is attached to a button and that button is in a template - when you open the template ie new by double clicking it the button's code does not exist in the word document : ( Any ideas on persistence of code from tempates to...

Thanks - I was going to use mapi but I saw the sendmail command and thought it would work - nice of Microsofts development teams to talk to each other - the excel team must get paid more ?

Does the sendmail command in word's vba have a recipient option ? or does it just open up a new email with the document as either the body text or as an attachment ? works in excel : |

Hey thanks Ken but I think that I found the answer on the MS web site - but your solution is now the only way to go : ) ACC2000: Access 2000 Does Not Support the UserForm Object The information in this article applies to: Microsoft Access 2000 Microsoft Visual Basic for Applications...

Hello - whats with the load statement in Access ? This is the help code Private Sub UserForm_Initialize() Load UserForm2 UserForm2.Show End Sub But what is a Userform ? The help says UserForm is an Object data type. You can declare variables as type UserForm before setting them to...