Thanks Tony
Thats all I needed - a little bit of lateral thinking :)
The using DeleteLines I can remove the Option Explicit between creatingthe module and inserting the temporary function.
Thanks again.
Zathras
The module should only exist for the time the code takes to run, once the function has been written out, it is called, the result written back to the form and the module is then deleted. I want to avoid having to edit it manually if at all possible.
Having "Require Variable...
If these are legacy databases that you just need to get working, adding a reference to the 'Microsoft DAO 3.6 Object Library' and removing the ADO reference will resolve most of the problems. If you want to use both ADO and DAO functionality side by side you can preface objects common to the...
Can anyone point me in the right direction to setting the 'Require Variable Declaration' in code so it can be temporarily set to false?
I have a form which breaks down an SQL string to a string which can be pasted into VBA module to a assign it to a variable. The Form also allows a block of...
Once I have a objMailItem set up, how do I get to the actual email address of the recipient if the recipient is recognised by outlook and therefore the '.To' returns the 'Display Name' rather than the email address.
I'm sure this should be blindingly simple - I'm just going round in circles...
Once I have a objMailItem set up, how do I get to the actual email address of the recipient if the recipient is recognised by outlook and therefore the '.To' returns the 'Display Name' rather than the email address.
I'm sure this should be blindingly simple - I'm just going round in circles...
Alternatively, is there a way for me to check for e-mails and create responses in Outlook without the security stopping the process.
I sort of hope there isn't, but if I can't digitally sign the code to let Outlook know the manipulation is from a certified program, I'm going to have to put...
Hi Ben
I started thinking I could do it as you suggest - but the rowheight is only valid if its been set to something other than the default row height (it returns -1 then, the actual row height is then dependant on the datasheet font).
The reason I wanted this was so I could workout where...
Can anyone suggest a way to workout how many rows are displayed in a datasheet.
I thought this would be straigth forward. The reason this isn't so straight forward seems to be as follows:-
1. The datasheet may have been resized
2. RowHeight may have been changed (including set to default...
Hi Hennie
Thanks for the reply.
You have encouraged me to have a look at this again.
I tried playing with the HasTitle property but it was still giving me the error.
However, I have just patched office to SP3 and as a result the context help pages seem to be more complete. In there I found...
Hi xinyin
I don't think there is anyway to stop access sorting records to the order of a key, short of explicity specifying the order of the form's datasource or the 'Order By' both of which require a field that holds data that will produce the required order.
As you do not wish to maintain a...
I am trying to change the display of a chart on a form in Access 2000.
I have some code that changes the charttype between xlAreaStacked and xl3DBarStacked which works fine.
However, to try and tied up the display I would also like to change the text alignment. If the form starts with...
Hi Zyrag
There are lots of ways to crack this nut. The quickest may be the following
In the field definition within the table design set the default value to =Now()
As new records are added to the table the date stamp will be automatically set.
Hope this helps
I am trying to change the display of a chart on a form in Access 2000.
I have some code that changes the charttype between xlAreaStacked and xl3DBarStacked which works fine.
However, to try and tied up the display I would also like to change the text alignment. If the form starts with...
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.