Search results

re: Hi, what's the format of the actual HTML file? There might be actually issues with that in the first place. However if it worked under Acc2003 you might want to try to import all db objects into a blank new application and also run a compact and repair on it. HTH Good luck

re: Do you have the developer extension and only need the runtime? If you don't have the ADE then you need to purchase it first. For Acc2003 it is part of VSTO (Visual Studio Tools for Office). However did you hear that the 2007 runtime and ADE will be free? You may want to consider to purchase...

What forum is it? It might actually include such display option as a feature. HTH Good luck

re: Hi, since your users are using groupwise you should implement groupwise specific automation code to create the email. A good start are these: 01 02 HTH Good luck

re: You're question was answered here!

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

re: Hi, I think you misunderstood me. The different sample automation code I gave you links to should be used within Access and not Excel. If you already have excel open then you don't need to create another instance of it. As I understood it you wanted to export a query or table from within...

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

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

re: Hi, I assume you are using an OLE datatype field for this. I would actually recommend scratching that and using a text data type field instead. You should probably have a separate table which only has a PK field and a text data type field which stores the full path and name to the...

re: Hi, I couldn't get to the link you posted so I'm not sure what advise you have received before. Are you saying you want to display text data in a memo field in a formatted manner? What version of Access are you using? Access 2007 implements an internal native rich text control which stores...

re: Hi, I'm not sure if you will be able to do all this within a macro. Try to adapt VBA...you are much more flexible and can use error handling which might be vital in such a heavy automated process. So in a procedure/function you could first run your append query with: CurrentDb.Execute...

re: Hi, how are the values seperated (e.g. by space or comma or...)? You might find this article helpful to get started. HTH Good luck

re: Hi, if it would do that then you wouldn't be able to handle anything else in the application. Access can only execute one thing at a time and not parallel. So you can't really even try to do this with a custom vba approach...but why would you anyway? Maybe you can clarify your goals a...

re: Hi, users should NOT see the query or table level directly anyway. So you would be better of using forms or reports to display that data. Though if you want a more global approach then check the Access help for AutoKeys macro. You can overwrite specific keys and key combination globally...

re: Hi, are you opening the application with the produced shortcut? You might find this step by step process helpful. It should guide you through the whole process and ensure you do not forget one step. ULS can be very intimidating if you are new to it...that's why many do not use it and...

re: Hi, check my reply here. BTW...I would suggest storing the path to the external file in a string datatype table field. Also pay attention to the API code I link to...I prefer using that then being dependent on references...but having a preview of the images rather then just using the...

re: Hi, I would avoid the FileDialog and implement an API solution instead. HTH Good luck

re: ;) HTH Good luck

re: Hi, check the attached. This is one way of dealing with this. Keep in mind that this requires a Microsoft Office Object library reference (VBA Editor--Tools--References...). I normally like to avoid controls like this because of their version and reference dependency but in this...