Search results

no, unfortunatly, we have not found a way to fix that problem. printing is still as slow as ever. as soon as a project gets too big, it tends to slow down.. access limitation unfortunatly

Hi! Thanks for taking your time and writing this example. Well this is exactly what I did. I use a listview with checkboxes to let the user choose which report he wants, plus he can drag the listview items up and down, allowing him to change the print order. Well.. it works.. yes, but it's not...

Hi! I have yet another problem with access. this time with the ListView control. when I try to disable it (listview.enabled = false), all the items disappear, except one... the first, and all my checkboxes disappear as well. when I re-enable it (listview.enabled = true), the listview decides...

yes that I precisely what I want. I use a Queue class to create a list of reports. it works perfectly, however the problem is printing multiple copies. if I use domcd.printout, it will print several copies of each report, but they won't be printed in the correct order. I cant bring this into...

use the PrintOut method first open the report in preview mode call the printout method and then close it DoCmd.OpenReport "My Report", acViewPreview, , , acWindowNormal DoCmd.PrintOut acPrintAll, , , , NumberOfCopies DoCmd.Close acReport, "My Report" replace NumberOfCopies with some variable...

Hi, as I stated in the subject, I would like to combine several reports into 1 report. I did a google groups search, however, but I couldn't find any good solution. The most popular was the subreport, but I can't do this, since the print order is extremely complicated and chaotic. Each page...

Hi again. You won't have to read my previous post... since I have found a "solution" to the problem (after 4 days). It seems that when Access wants to dupe the data, it will call the "Retreat" event before. So, I just declared a string in the report that would save the current group that will...

Hi I'm having troubles with the Format event. More specifically, one of the parameters: FormatCount. In the Access help, it says that FormatCount will supposedly return the number of times the section has been formatted. However, a section can be formatted 2 times, and the value of FormatCount...

1) I would use a recordset to execute a simple query and gather the data.. Something like this: Dim rs as New Adodb.Recordset rs.open "select Sum(Qty) AS SumQty from TblProducts where ProductName = '" & txtProductName & "' GROUP BY ProductName;", CurrentProject.Connection, adOpenForwardOnly...

Create a general procedure that will perform checks on every control, and enable it if they meet your criterias, or disable it if they don't Then call this general procedure at the LostFocus event of every control that need to be checked. Public Sub CheckCriterias() Dim ButtonEnabled as...

I just tried that procedure. It works. You probably forgot to set a reference to MouseWheel.dll. # On the View menu, click Code to display the module of the form in the Visual Basic Editor. # On the Tools menu, click References. # To select the reference, click to select the check box next to...

hmmmm.... so you're saying that in your query you have a "where" condition like this: SomeField = Forms!MyForm!txtSomeTextField ? You could use a global vba function to return a value, but that would imply that you'd have to run some code prior to the query execution. Then you'd have to set...

Thanks.

Okay, You wont have to read my entire post, I seem to have found a workaround... It gives me an error but it modifies the property!! oh well: Public Function nocrash() Dim ReportArray As Variant Dim ReportArrayStr As Variant Dim i As Long Dim orpt as Object ReportArray = Array(Report_Report1)...

well that's not new. Access crashes a lot. But I can't seem to find a workaround this time. First of all, here's my situation. I have a big 11x17" report with 7 subreports that are identical in it. The only difference between the 7 subreports are some of the properties. Now, when I want to...

you can change the colors in vba like this: SomeControle.ForeColor = vbred

I already had that problem. Make sure that "Use access special keys" is checked in the Tools, Startup dialog. For some odd reason, VBA debugging is disabled if this is unchecked.

Salut! You can use docmd.runsql("YOUR SQL QUERY HERE") to run your queries. this will only work with non-SELECT queries (INSERT INTO, UPDATE, DELETE, and so on...) You can run your stored queries with docmd.openquery if you dont feel like pasting all the SQL code in VBA (it might be tedious...

works like a charm!! thanks a lot.

Hi, I'm not sure I understand your second question, but I want every fields to be in thousands of dollars. I've looked around in the table design view. I didnt find anything interesting, except maybe for the Format property. In the help file, it says that the Percent format is "The value is...