Recent content by dragnor

Hi Experts, I'm have run into a wall :banghead: I have been given a task on extracting all appointment from a certain number of Shared Calendars in Outlook 2013. I'm able to read the calendar entries but have two major issues. First issue is that I can't get "Restrict" to work, so every...

I'm still working on this and finally i got the correct solution :-) I will now explain the process: First i make a lot of reports. Then i merge them into one PDF file. Some clients are to have more than one copy so i create x number of the same PDF file and merge that into one file. So now i...

Finally I fund the solution but ran into a new problem :-( First I have to make sure that Acrobat Pro and Acrobat Reader are completely shut down. If you make PDFs with Adobe in VBA, you can open and close the program with the following code: Dim AcroExchApp As Acrobat.CAcroApp a lot of...

Hi Nidge The pause proposal works if the network can keep up (i use a network printer). Sometimes it's small PDF files other times they can be very big, and if I pause too long the idea of my solution is ruined. So i need another way to handle this. Sorry!

Hi Experts I have this code that is printing a report a number of times(1-10 times). I use the code below to print the PDF file. But sometimes when i'm printing the same PDF file 6 times, only 1 or 2 of them is printed. It seems that the system does not wait for the printer to receive the...

Thanx! That worked!

Hi experts At work we have to cange from access 2003 to 2007 and the following code used to work in 2003: Dim ws As Workspace Dim DB As Connection Dim rst As Recordset, rst2 As Recordset, rst3 As Recordset, rst4 As Recordset Set ws = CreateWorkspace("FK", "", "", dbUseODBC) Workspaces.Append...

Hello Experts I'm working with a database, which take up about. 100 mb of space, after some additions of code I compiled the database and ran the compact and repair function, and then it got down to 22 mb. I do the compile and compact and repair every day and normally it would grow in size...

Thank you, this is nice of you. Have a great weekend!

How du you loop through the controls and test for a subreport og subform?

you are able to add/include a subform or subreport into a report, and i need to know how many there are in a report, there names, if there are any. But thanx for your response!

Hi, I need some help if posible. If you know the name og one report, and then want to get the information about all recordsources used in that report, also if the recordsources are used in subreports or subforms? Please don't ask my why I need this, it's a company that need a function to do it...