Search results for query: *

Hi all, I come back to this forum after an absence of ..several years! Ok, let’s go to the point: I have a form called frmCustomers, and it has a subform (sfrmContacts, continuous type) that shows every contacts made with the specific current customer in the main form (in each record of the...

MaxDD thanks. I 'll see and tell.

Thanks GKChesterton. By now, i'll try to implement the function with a text replacing the AcFormat constants, it has given me at the moment some result. Anyway, after i'll see also the references and i'll tell.

With the constant acFormatXLS , it works pefectly. About the text that appears in the textbox of the export window, with DoCmd.OutputTo acOutputReport, "ReportName", acFormatSNP, , True it neither works, and with DoCmd.OutputTo acOutputReport, "ReportName" after choosing the...

Thanks lameid. About AcFormat constants, i meaned the text for replacing these constants if they don't work, but i'll try first with them. I'll try next patching office versions.

GKChesterton, how can i check if it's a references problem? I suppose by unchecking the corresponing checkbox in the references list and viewing then if the problem has been solved? lameid, how can i check what the text says for eported snapshot files? Do you mean manually, and using what...

lameid GKChesterton, I have tried replacing acFormatSNP by "Snapshot Format (*.snp)", replacing CurrentProject.Path & "\temp1.snp" by "C:\temp1.snp", and both things together. It didn't work any of them. I don't know if usign a numeric value corresponding to acFormatSNP could solve the...

Thanks dhookom. I have been useful for me (i have it fully implemented) the code in http://www.mdbmakers.com/forums/showthread.php?t=4544

I have found in http://www.eggheadcafe.com/forumarchives/Access/Jan2006/post25579028.asp a code that works, but only for the Left margin. What changes would have to be made for setting in that code the four page margins? I have added PM.intLeftMargin = 1134 PM.intBotMargin = 706...

dhookom, always i modify the margins to the ones i need i save the report after. I think that is what you refer to. Thanks.

Thanks dhookom. I have all these checkboxes already unchecked.

I see. Thanks John.

Thans for reply jrbarnett. Here are the results of checking in different systems (DoCmd.OutPut Failure Yes or No): Windows XP Home Edition 2002 SP2 – Access 2000 Spanish No Windows XP Home Edition 2002 SP2 – Access 2002 English (Office 2002 Professional)...

Hi, i have an Access application that must work in Access 2000, 2002 (XP), 2003 and 2007 Access versions. The application uses DBPix for the image treatment in the DB. They are 486 records, with an average of 12 images per record of 270 KB each image: 486 · 12 · 270 = 1’574 GB of images space...

Hi, some times, though In File > Page configuration the margins of the report pages are stablished, when the report is again opened in Preview or printed the margins are the default ones: 24,99 mm. ¿How can this anomalous reconfiguration of the page margins be avoided? Thanks for any help given.

Hi, in some pcs in which i have made this comprobation, the command DoCmd.OutputTo doesn't run; when this code line enters the procedure stops running. The code line is: DoCmd.OutputTo acOutputReport, "reportName", acFormatSNP, CurrentProject.Path & "\temp1.snp", False Can it be due to the...

Compacting and reparing the DB has solved the problem.

Hi, since i have added a few lines of code to my database from the VBE, i have the window: "Microsoft Office Access has encountered a problem and needs to close. We are sorry for the inconvenience" when i open the database. The code lines are: Private Sub Form_Open(Cancel As Integer) If...

Thanks TheAceMan1. That has worked.

Hi, i have a DB with two main forms, and a button in each of them for going from one to the other. SOmetimes, when i change from one to the other Access asks me if i want to save the changes in the objects: both forms, and some subforms of the form of origin. Can anybody say if that can be...