Search results

re: Why can't you go to tools--startup...and change the settings there? Start your application holding down the shift key...all should be back to normal...then you can modify your settings if you want. HTH Good luck

re: Hi, create a query which filters out the correct records based on the boolean yes/no field value. Then open a recordset based on this query and loop through the records to construct a long concatenated string full of email address values. You use that in the 'To' argument of the...

re: Hi, What startup dialog do you mean? Do you mean the one under tools--startup...? Why would you want to open this via VBA. If necessary you can set all options behind that dialog at runtime through VBA. A good sample of this can be found here. If this is not what you are trying to achieve...

re: Hi, this is part of a security update which is supposed to prevent the automation of random emails. There are currently only two ways around this if you want to stick with outlook. Either install this add-in or use Outlook Redemption with automation code. You can read more about redemption...

re: You have been given suggestions here.

re: Hi, Check my reply here. HTH Good luck

re: Hi, the on enter event of a control has NOTHING to do with the keyboard's enter key. This event should be used when you want to execute an action when the user 'enters' the control. It is similar to the on got focus event. I would suggest you use the control's after update event to execute...

re: You're welcome. Glad you got it sorted out. Good luck on future projects!

re: Sure... You're welcome. Good luck on future projects!

re: Hi, Foms have a dirty property which can be set to false if it is true to force a record save to the underlying data source. HTH Good luck

re: I think Outlook 2007 needs to be present for this to function. HTH Good luck

re: Hi, I'm not understanding your request. All versions up to Access 2003 use seperate dialog windows to display database objects. You can use DoCmd.Maximize on the on load event of your first form (switchboard) and make sure you never use DoCmd.Restore anywhere or have any form's modal or...

re: Hi, I assume you are using the shell() method with this. If your code works so far with a hardcoded ID number then all you need to do is dynamically referencing the control which holds the ID number at the time of execution e.g.: "D:\invoices\url2bmp.exe -url...

re: Hi, you could try: If Me.Dirty = True Then Me.Dirty = False HTH Good luck

re: Hi, yes...you will be much more flexabile using unbound controls on your form and refering to them in the query criteria e.g.: [Forms]![YourForm]![YourControl] Now you can reference these controls anywhere else to display their value and as many times as you want. A good setup could be...

re: Hi, Access 2007 has a great new feature which allows you to easily do this. A wizard included in Access 2007 lets you either create HTML or InfoPath forms which you can send to your users. When they reply the data will be automatically synced with the database if specified. You can read...

re: It is really not that bad...just follow the instructions step by step. If you get stuck anywhere let us know and we can try to help you further. HTH Good luck

re: Hi, If you use Acc2000 or higher you do NOT need to define a UDF anymore. All that is required would be: If CurrentProject.AllForms("YourFormName").IsLoaded Then ... HTH Good luck

re: Hi, this is one of many limitations Sendobject() has. It can only send internal db objects as attachments and only one at a time. If you want to send external files then you need to use automation code to automate Outlook (if that is your email client). A good sample can be found here. As...

re: Hi, Just repeat your code to add as many as you want e.g.: ... .Attachments.Add strAttached .Attachments.Add strAttached01 .Attachments.Add strAttached02 ... HTH Good luck