Search results

That is a good idea, but I don't think it is practical. This is a small part of a procedure with over 1000 lines. The procedure uses DAO to pull data from multiple tables on a SQL Server and creates a 5 sheet Excel workbook to provide a number of tables and charts summarising the data. I would...

I have an access database which produces a multisheet excel workbook with many tables and charts ( > 20). I need to copy each of these into a powerpoint presentation. I have created a code for one of the tables (see foot of post). But if I have to repeat this for each of the 20, that is a lot...

I take your point, however: The presentation has multiple slides, the quantity varies and the title position may need to change for each. I need to be able to add text boxes because each slide will need them, there will be different quantities on each and they will be in different locations I...

Now sorted, I needed to add references to the MS Office object library as well as ms powerpoint object library.

I am trying to add a textbox to a powerpoint slide using access. I am following the syntax from microsoft website. But I keep getting a compile error variable not defined with msoTextOrientationHorizontal highlighted. I am confused. Set mySlide = myPresentation.Slides.Add((intSlideCount + 1)...

Thanks that works better. How can I determine the size of the pasted image and resize it?

I do this sort of thing quite a lot. I created a function to do this. Public Function GetNextIndex(strPrefix As String, strTargetTable As String, strFieldName As String) As String Dim db As Database Dim rs As Recordset Dim strSQL As String Dim strNumber As String Dim...

[SOLVED] Access into Excel into Powerpoint chart size issues. I have an access database which produces as reports a series of financial reports comprising multi sheet excel workbooks with many tables and charts. These are created in VBA. Management have decided they want the information as a...

After a lot of experimenting (thanks to everyone who contributed with ideas) The problem in the end was down to the IIF, which with 12,000 records was taking an age. Thanks to CJ_London for pointing me in this direction. I ended up solving it by changing the rationale and data structure of the...

Nice one, I hadn't realised that, all the field names hail from an Excel file which is imported into a SQL table. I replicated the field names from this (hence all the spaces which I personally never use). I will need to think of a work around I googled "Transact SQL Equivalent to IIF" and got...

We may be talking at cross purposes because that is exactly what I am already doing. The mainform is filtered to a single record and the recordsource is a pass through query from the SQL Server which pulls a single record. The mainform itself shows the budget line detail it can only be accessed...

I will give this a try, but I think I tried it a while ago without success (this has been a long standing problem that has got worse recently as the number of POs and Invoices on the server has doubled).

OK for what I am trying to do: I have a table for budgets, each budget has many lines each with a code, purpose and amount (tblBudgetLines). Related many to many to budgets are purchase orders (tblPOs) and related many to one to POs are Invoices (tblInvoices). For the user, the budgets are...

All my forms that don't need to be edited use pass through queries for their recordsource to speed up performance. But when I set a passthrough query as the recordsource for a subform I get an error "You can't use a pass-through query as a recordsource for a subform". According to google I am...

I have a SQL BE/Access FE database for relating POs and Invoices to Budget Lines. A master form for the budget lines uses a pass through SQL query. It has two view only subforms (each in a tab) that filter to show related POs and Invoices. The PO table has approx 7000 records, the invoices...

Huge thank you, that has solved it. Thanks for everyone else who contributed too, it helps the learning process.

Answers: 5. the only two apps that run are EXCEL.EXE *32 and MSACCESS.EXE *32 6. after the code runs the CPU goes to zero for both 7. the same two apps run again 8. no duplication Same error occurs

OK I have double checked all my code, prefixed all declarations for excel objects with "excel." and double checked that the workbook is closed and all object variables are set to = nothing. But still get error.

Now I am confused, which have I declared as variants unintentionally? How did I do it?

Object Variables are: Dim db As Database Dim xl As Excel.Application Dim wbk As Excel.Workbook Dim wsht As Worksheet Dim cht As Chart Dim rng As Range Dim qdf, qdf2, qdf3 As QueryDef Dim rst, rst2, rst3 As Recordset Dim xComment As Comment It...