Search results

My apologies Shuie, it works fine now.

The basic problem is "why does my report contain 7 identical pages?". Until I find the answer to this question and fix it I'm stuck with printing Page 1 To 1. My code for this is:- DoCmd.OpenReport strDocName, acPreview, , strCriteria DoCmd.RunCommand acCmdPrint The Sendkeys command needs to...

Always a good standby, Sendkeys. In this instance it will not work. Thanks

That code is fine if you want to print to a default printer, which I do not. I need the factility for a user to send the report to any one of a number of networked printers that is why I use the code I do. Your code still does not address the problem of printing duplicates. Thanks anyway. Any...

I have created a chart in a report and on printing the default is to print duplicate pages corresponding to the number of data series! How do I get rid of this. I'm using:- DoCmd.OpenReport strDocName, acPreview, , strCriteria DoCmd.RunCommand acCmdPrint to bring up the standard Print...

I've tried the Me.Requery in every possible place I can think of to no avail. Nowt worked!

Boys, oh boys, oh boys. Someone must have an answer or thread I can look at?

I have form containing a pivot chart which I am trying to print. When I alter the selection criteria the form looks OK in the print preview but when printed out, uses the selection criteria when the form was loaded.:mad: Any ideas how to "refresh" the underlying query.

Ctrl & ' will bring down the value of that field from the previous record. Not sure if that helps?

Just ran the utility JetComp.exe in:- http://www.everythingaccess.com/tutorials.asp?ID=Access-Database-Corruption-Repair-Guide#3 It created an new database that I am able to open but the query and the form I was working on when I was last in have disappeared! Still at least I can get in and...

gemma, rebooting not the answer. Your comments re locked tables or startup code may prove to be correct if only I could get into it to find out! It was a new form I was working on the last time it was open. Thanks

Now I know what backups are for!!!! Thanks for trying.

AllowByPassKey is on. Tried the decompile with the following batch file:- "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE""C:\Documents and Settings\SDawson\My Documents\ACCESS\Production\production_new.mdb" /decompile pause Still no joy. Same message. Plan B?

Yep MDB and yep same when holding down shift key.

Got the following message when I opened a database front end I'm working on. There are no other users involved (stand alone PC). "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." :confused: Pointers...

Well I'll bite the biggest dog in Bury! Reseverd words. Doh. Thanks one and all. Now, anyone know how Coolmax or Drifit technical clothing is best washed? ?:)

Lost here now guys. Attached is extract of what I'm trying to do The query byweeknumber does exactly what it says on the tin. The second query calculates some date but not the wc Monday date. Any help would be appreciated.

Is it me? I've put the following expression in expression builder in the Query Expr1: Date1 + (7 + vbMonday - DatePart("w", Date1 )) Mod 7 and it immediately changes to Expr1: Date1 + (7 + [vbMonday] - DatePart("w", Date1 )) Mod 7 When I run the Query it asks for a value for [vbMonday]...

Looks good. Thanx.

I have a query that groups records by date into week numbers using the following expression. WeekNumber: DatePart("ww",[Date],2) I would prefer to display the result as the week commencing Monday date. How?