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...

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...

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...

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...

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...

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...

A general question really. Can anyone give me some general guidance on speeding up the opening of a form as some take condierably longer to open than others. I assume it's determined by underlying queries and numbers of controls etc. Any advice would be appreciated Thanks

Hi Can anyone help with the following which I am sure is an easy one I have the following control on a form with the record source calculated as below =" " & [Month] & " - " & [Year] & " Application For " & [Vendor Company Name] & " For Buildings " & [Building 1] & [Building 2] & [Building 3]...

Hi Is there any way I can resize a continous form that can sink or grow dependant on the number of records Thanks

Can anyone help I have a continuous form based on a query which shows a list of building names for each record. The last record is shown as a blank as a result of the query. Is the any way I can design the query (or the continuos form) so this blank result is not seen Thanks

Hello Is there any way I can refer to specific reocrds on a continuous form so for example I have a form with a control called "building name" based on a table with ten records. I would like to refer to "building name" on a specific record in the continuous form Thanks

Can anyone help I have a control called Total Cost in the currency format which is set to equal a value based on a mathemeatical formula set by a macro and would like to round the result up to two decimal places as I suspect that the result is longer than 2 decimal places even though they are...

Can you please help - I have created a query which results in a list of munbers and "ALL" which I then use in a combo box on a form. My problem is that I would like "ALL" to be at the top of the list but, depending on the numbers in the query result, the ALL could be anywhere. I have tried...

Can anyone help I have a control called total cost on my form which has a currency format and displays a calculated result based on two other controls on the same form named quantity and unit cost I have a macro which sets the value of total cost through quantity * unit cost The problem is...

Can anyone help I have a subform displayed as a datasheet with a column called "Budgets" (currency format) and would like to display the total in the main form but cannot seem to get it to work My main form control source is written as =[Category_Cost Centre_USD Table subform].[Form]![Budget]...

Can anyone help Is there any way to save the record of a parent from from a subform An example of my problem is as follows; I have two controls on a subform and have set code / Macros against each of them on after update the first subform control changes the value of a control in the mainform...