Search results

re: You need to create a procedure which does the emailing part. As mentioned in the link the simplest method is the SendObject() method. Though it has limitations as pointed out. If you want something more powerful then use automation to create the outlook item. You can then call this...

re: Hi, it is not advised to embed images within an Access application in all versions prior to the new 2007 edition. Access has a known bloating issue that will make you run into problems with the 2GB file size limit. As mentioned before just link to the files with a text datatype table field...

re: Hi, you could also completely hide the Access shell if you want as described here. However, normally this is not advised in a production environment. HTH Good luck

re: Hi, you might find the option 'Use Windows Themed Controls on Forms' under Tools--Options--Forms/Reports tab helpful. HTH Good luck

re: Hi, Access 2003 includes object dependency which works somewhat ok if you have the Name AutoCorrect tracking feature turned on. Otherwise you could use third party tools like SpeedFerret or Rick's find & replace. HTH Good luck

re: Hi, check the machines which do not run reports for default printer drivers. Are any installed...if yes make sure they are not corrupt. Access needs a default printer driver to render/create the reports...if it doesn't exist or is corrupt you might experience this behavior. HTH Good luck

re: No problem...glad you got it sorted out. Good luck on future projects!

re: Hi, check my reply here for a good start. If you have any questions let us know. HTH Good luck

re: Hi, if you are using Acc2000 or higher you don't really need a UDF anymore. All you need is: If CurrentProject.AllForms("YourForm").IsLoaded Then ... HTH Good luck

re: No...it will only make a directory within an existing directory...or the top one if there is no top directory. To check if a directory exists you can use the FileSystem objects FolderExists Method or even easier the Dir() function e.g.: If Len(Dir("c:\YourDirectory", vbDirectory)) = 0...

re: I already gave you two possible ways to create a folder. Check my initial reply again. HTH Good luck

re: Hi, You can use the 'SentOnBehalfOf' property which is described in this article. HTH Good luck

re: Check my reply here.

re: Hi, check this earlier discussion. HTH Good luck

re: Hi, You can find a good sample of this here or here. HTH Good luck

re: Hi, to hide the menu bar you can run: Application.CommandBars("Menu bar").Enabled = False To hide the entire Access shell you can use this API Code. Keep in mind that it is not really advised to be used in a production environment. It has issues with previewing reports and you need...

re: Hi, you can use the FileSystem Object to achieve all the file/directory/folder manipulation. To create a folder you can use its CreateFolder method. Access also has an internal MkDir method which works similarly. For the browsing part check this API Call. HTH Good luck

re: Hi, check the link I provided in my initial reply. HTH Good luck

re: Hi, The command to bring up the startup properties dialog is: DoCmd.RunCommand acCmdStartupProperties But as earlier mentioned you might be better of setting these settings through code rather then exposing dialog. However, I guess that is up to you. HTH Good luck

re: Hi, you should NOT be storing these files within your Access application. You will run into a known bloating problem which will run into issues with the 2GB file size limit. Instead you should store the full string path/name to the external files in a text or hyperlink datatype. In case of...