Search results for query: *

Not sure if anyone can help with the following I have created a send object action in my database that After update sends an email to a predefined email address. When the action occurs outlook opens, sets up the email and waits for the user to click the email send button Is there any way the...

Thanks works a treat

Many thanks Have checked and the picture property is embedded so I assume I cannot change?

Can anyone help I'm sure there is an easy answer but cannot seem to resolve the fact that even though I change the back colour of my form in design view, when I change to form view the colour stays the same as the original desing. Not sure if this helps but I created my original form using the...

Many thanks

Can anyone help I am trying to run an append query using insert into in visual basic and thought I could simply copy from the SQL into the code window for my form I have pasted the following but no matter what I try to change in terms on syntax I cannot seem to get it right Docmd.Run SQL...

This works really well.... Many thanks for your help

Okay I have a data link from my excell spreadsheet which links into my access table and is set to refersh on open via Data Properties I was originally opening the excel doc from a command button with a fixed hyperlink and can now open different version of the same excel doc that are linked to...

This is great!!!!!! Only problem now is when I open the excel file it doesn't refresh the data from my access database as it seems to be overuled. Do you have any ideas

Thanks, I'll give it a try

Can anyone help Is it possible to create a command button that opens an excel file but with the hyperlink changing and being dependent on values of other control box values I know how to set up the other control box values but not sure how to change the hyperlink, otherwise I hve to create a...

Can anyone help I would like to open a specific excel file after click on a command button from a form Is ther any code / macro that can do this thanks

Can anyone help I have an excel worksheet that links to an external datasource and is set to refresh on open. When I open the excel workbook I get the message asking for automatic or manual refresh. Does anyone know how to turn this off Thanks

Hello Wonder if someone can help with the following I have the results of 4 querys that I would like to export to an excell template that is already created and formatted but with blank fields where the data from each of the query results should go in the excell template. In addition the...

Just managed to make it work - many thanks

Apologies but I am having a very long period of stupidity - can you tell me where to place the goto instruction as I can't seem to make it work

Can anyone help I have a command button that carries out a send object (Email with attachement when clicked. However if the user cancels the email I get a debug error. On other buttons in my databse I get the accepted send action cancelled Can you advise what I need to correct so I get the...

Thanks for the quick response

Can Anyone help Akin to the excel transform action when pasting special in excel, is there such an option to do this in Access. I have heard that there is a Transform Query that can do this As an example I have 10 entries in a table with a column called building. the entries are London A...

Can anyone out there help I have a query which is based on a preceeding query which is producing a very strange result. The first query "Spend so Far Query 1A" produces a result of "1/12 Maintenance Sum" in a field called description. The second query "Spend so Far Query 1AA" which also has a...