Search:

I use vba to create monthly accounts files and save these to dirctory on the PC or server. I have now been asked to save the files to sharepoint instead. I have accessed the document properties...

No yellow warning bar is shown on opening the DB. However I think that, following a bit fo ferkling in the options area, I may have fixed the problem.

However, I am still a bit confused about why...

I have copied all the tables and queries into a new data base instance on the server and the same fault has appeared in the new instance (still 2003 version) of the database. I have tried executing...

All the relevant records that I would like to delete appear to be displayed if I open the query and then choose data sheet view.

Thank you for all your suggestions.

The delete query is just "Delete * from Accts2012 where period = 9" As stated previously this has worked quite happily for the last 4 years
I will try...

Nothing happens when I run the delete query. If I change delete to select then the correct data is selected. When I change the query back to delete the DB once again just does nothing.

I have been using the same .mdb accounts database for the last 4 years, adding data to it on a monthly basis. Each month I need to add data in respect of an interim set of monthly draft accounts,...

This problem is now solved. It helps if you do not send the email before you add the attachment...

I have now found that I should use the code .attachments.add (filepath of item to be added) Instead of Attachments = .... However I have now encountered a further problem. I keep on getting...

I have written code that successfully sends text emails by going down each line in a worksheet and sending reports to the addresses listed on each row. I now need to extend this code to attach...

Zeddy,The problem persists on both my local and the network drives, however it is more pronounced on the network drive. Therefore I tend to copy the files to my local drive, run the macro and then...

I have a master standard monthly accounts workbook that holds project details and summaries for 100 projects. Each month I run a macro that: 1 Extracts detailed project data from Access for a...

I have written a mocro that clears all the exces formatting from rows at the bottom of a worksheet.

Now I would like to extend the macro to also clear the excess formatting that appears on any...

We have just upgraded to 2007.

I use macros to create project files. I have a master projects file in which I hold standard project reporting worksheets. By selecting a project from the...

As an example, when saving a .xlsm file in excel, the save as box restricts your view of other excel files whith the target directory to only those that end in .xlsm

Is there a way of setting...

Thanks - formatting before inserting the formula worked

@ Rory - the formula you provided was useful but has $ signs in front of the column references. Is there a variant that inserts formulas...

I import data from SAP into excel 2007. I then use a macro to insert 2 columns and in the second column the macro enters a formula as follows:

ws.Cells(k, 4).Value = "=if(" & ws.Cells(k,...

Thanks for the replies - I will try out the suggestions so far made

I am just looking to change the font size in SQL

Alex

I have just upgraded to Access 2007 and have 2 quick questions:
How can I reformat the text on the SQL query page?
Once a few tables and queries are open, they tend to get hidden behind each other....

Thanks for the information Rory - My initial impression is that everything takes more effort in 2007:
1. This action now takes potentially 3 clicks rather than one!
2. This option is nicely hidden...

I have just been 'upgraded' to excel 2007 and have 2 quick questions:

Is there a replacement for the paste special values button, which appears to have disappeared?
Given that the tools menu...

I use pivot tables to summarise staff time data by staff number and then by activity as rows and then by month in columns. Currently the pivot table only inserts the staff number in the first row...

Even if it works, note that the code will only ever add validation to columns M and AG (if there's a 1 in column A) but never remove it (even if the 1 in row A is deleted).

Thanks for the advise. ...

The following macro is held within a worksheet. The macro worked quite happily for some days. But now whenever I select a relevant cell it fails at the .ignoreblank or the .incelldropdown = true...

I found that when I copied worksheets that were created in the German template into a new workbook, they tried to revert to my UK template, with some very interesting formatting consequences
...