Search results

You may be running into comparability issues. Access 2003 is most compatible with SQL Server 2000 and older. When you create the SQL database on Azure you will need to be sure that you only use the data types that were support in SQL Server 2000. For example, the datatype Big Int is not...

I do that all the time.

I agree with CJ the you probably can use a sub report control. A sub report control is a container that will display another report on the main/parent report. The don't have to be linked. It is common that they are linked (master/child properties set) so the sub report is filtered to the data...

II think yu got what I was suggestion. Looking at eh VBA code for recordsets is what I would do if it were my project. I would suggest making a new blank front end and linking to a test copy of the back end. I would import a single object at a time that has VBA code hat deals with a recordset...

I doubt it is the OS. If you are truly using Office Access 2002 then that is part of the issue. Does the front end have any VBA code that opens a recordset? If yes, then the issue you are having is normally cause by a bug in your code hat is causing the JET database engine to open a second...

James, Each print job start on the front side of the page. Since are sending two print jobs, they each start on the front side. You need some way to combine the two report into a single multiple page print job. That way the printer can print it full duplex (front end back). The simplest...

IMHO, The general information is: The issue is specific to the design of your database and your unique code.

Thanks. You ROCK.:cool:

I would like to see the original is you still have it. Thanks.

TIP: When searching for examples, you can normally use anything for Access 2000 and later up to the versions of Access you have. FWIW: I post all my example in the oldest version possible (usually 2000) to allow the most people to use them. I do have this example on my web site that might be...

The timecard examples can give you some ideas on how to create the scheduler. I agree with CJ_London to look online, not just within Access, to see if there is anything that you can purchase to use as "building blocks" to speed up the development. Have you looked in the Code Repository or...

I Agree that a database is a better solution that spreadsheets. Not sure what you me by hoping for. If by "tell me there is a solution" you are asking if this is possible to program this within Access then I would say yes is possible to create a solution with Access.

This is not what I was referring too, but still a good thing to check.

FYI: There was a relase of Ofcice 2002 for Windows. It has an update for Windows XP compatibility. It was replaced with Office 2003. FuzMic, Verified with Access 2.0/95/72/2000/2002/2003 What you are describing happens when a recordset is opened in VBA code and not properly closed. This is...

You're welcome. Glad we could assist.

Verify that you have a control named: Prog_2ndline_12

Make sure you have the Office 2007 SP2 update or later installed. There is a 2007 Microsoft Office Add-in: Microsoft Save as PDF or XPS that is required to be installed manually is you have the original release or Service Pack 1 installed. Starting with Service Pack 2 by default it adds the...

I was able to test the SendOjbject with acForamtPDF and it works just fine with Access 2007 SP3.

sdawson, To answer the subject line about acFormatPDF, it was introduces with Office 2007. My customers have been saving reports to a PDF for many years now using DoCmd.OutputTo with acFormatPDF. I just noticed that you were also asking about DoCmd.SendObject using the acForamtPDF. Since I...

I use the latest version daily. I don't use all the features yet. What I do use has been invaluable. Spell checker is for the Caption property of controls and for the text of MsgBox statements. Not the VBA code.