Search results

Printer Dialog box Mike, perhaps as a 80% or temporary solution: try to display the printer dialog box; so the user can select the correct printer. Search for "Printer Dialog Box". As I think the best solution for the Box is (found it while searching, so don't ask why/how it works ;-)...

Hi Alex, these links could help: http://www.access-programmers.co.uk/forums/showthread.php?threadid=57085&highlight=top+per+group http://www.access-programmers.co.uk/forums/showthread.php?threadid=55156&highlight=Top+invoices+for+each+customer Just use the described solution to draw the...

MattS, perhaps this thread could help: http://www.access-programmers.co.uk/forums/showthread.php?threadid=40384&highlight=Saving+Report+Formats (just in case the link doesn't work: search for "Saving Report Formats") HTH, Barbarossa II

hi russiver, try to group on the invoice number field and to sum the cost field in one query (in design view: group & then change setting for cost from group to sum). Then simply copy the consolidated data from the query-results into a new pre-prepared table (containing the right number of...

what about adding an extra field, which is never null & has 20 records per page ? then you can get the lines by the detail section of the displayed 20 records per page, even if there is no 'real' data on the page (except the data in the extra field; in the rpt set the properties to invisible =>...

hmmm, the thread seems to be 'cold' now. What additional info do you need to help ? Thanks in advance, Barbarossa II

I simply took the code from this thread http://www.access-programmers.co.uk/forums/showthread.php?threadid=57085 and adapted it regarding the column-names. What I'd like to do: get the records with the top 3 entries for "anz-schl-" (number) for each dat (date in yyyy-mm formate) and LG...

Hi, got a query which works in a test db, but fails in the real db. The SQL of the query is: SELECT a.LG, a.dat, a.[anz-schl-], a.RMNR, a.[PB-DAT], a.STATUS, a.KST, a.E3, a.E4, a.LIEFERANTENNR_8, a.LIEFERANTENNR_9, a.LIEFENAM, a.ARTID, a.ARTIDX, a.ARTDESC1, a.[tech-entsch], a.merkmal1...

Hi ssh, you can formate the fields of ur report in the design view of the report while u programm the report: click the field, open the context menu, "properties", "fomate". There u can change font, color,.... HTH, Barbarossa II

Thanx ghudson, I will try this. Brabarossa II

ghudson, with the printer dialog box I'd like to - give the user the possibility to change the printer - let the user choose the pages which will be printed - allow the user to print to a printer (existing hardware) or to a pdf-writer (allready installed & working with printer dialog boxes...

Sorry, I didn't get your answer. I changed the code for the button to: Private Sub Befehl4_Click() On Error GoTo Err_Befehl4_Click Dim stDocName As String stDocName = "rpt_MONATSBERICHT" DoCmd.RunCommand acCmdPrint 'rem CHANGED 'rem CHANGED "DoCmd.RunCommand...

Thanx dcx693, do you know if there is a difference between the "Int-method" and the round-function of newer access-versions (run-time, accuracy,...) ? Or is the round-function just more user friendly and using the "Int-method" internally ? TIA, Barbarossa II

Hi, how can I round the result of a calculation in A97 ? There seems to be no round-funktion in my German A97, so ppm: ROUND(1000000*[s_schl]/[s_gel];0) doesn't work in the design view of a query; instead I only get an error message "undefined function 'ROUND' in expression". Thanks in...

Hi, got a form on which I created a print button via the wizard. The button works, but it prints the report without the printer dialog box appearing. What must be changed in the code created by the wizard to make the printer dialog box appear ? I've searched this site already but found no...

plucnik, as each date can be converted to a integer no and vice versa, I suppose u won't need to work around the "leap-february", if u create one table containing just integer numbers as a "calendar": 37001 37002 37003 37004 37005 ...... and convert each number in a query into a date via a...

hi plucnik, don't know another way.....But: Try creating the "calender" once for - say - the next 15 yrs. Use the now() function in a criteria of a query to filter only the dates in the past from ur calendar. (this would make sure that ur query wont return 'driver x hasn't returned his papers...

Hi plucnik, you could create another table w/ all (needed / possible) dates in it ("calendar"). Create a query and link the "calendar"-table and ur data table with a join (in querry design: Arrow from the date field in the calendar pointing to ur date field). Then set the criteria in the query...

Hi Massoud, Regarding the 2nd part of your question: try to calculate the wanted sum twice - before and after a page break... HTH, Barbarossa II

Hi kentwood, could try to sum & divide by the number of counted entries (to circumvent the avg function). If it doesn't work in the report, try it in a query and show the result via a subreport. Just in case the special formate creates problems: convert ur time in partial seconds add them...