Search results

Actually, I believe you could just add a new text box to your Report Footer, and in the Control Source of the text box, type: =count([Monthly Population]) ... or any other field for that matter. Is this where you were looking to put a total records value, at the end of the report? QT

Indeed, I split the database and copied the front end to each of the user PC's and so far I hear no grunting .... excellent. Banana - thanks for chiming in! QT

Is it a bad practice to have the DB open to a form that is set to the new record? I thought this may have been the issue. When multiple users try to open the database it's trying to access the same *new* record? As for splitting the database, you are absolutely right. [My bad] I did some...

haha! This post was excellent. Kudos to the author of 'The Ten Commandments of Access' !!!

I am wondering if I could get some input on this issue. I originally created a simple access database that tracks the flow of documents in Access 2003. This database is located on a network share and 6 users access the database (via shortcut to their desktop) intermittently. One of the...

I need to know how to hide a report. 2 reports are opened and I need to show 'Report1', hide 'Report2' ... when "Report1' is closed I want to prompt the user and ask if they would like to view 'Report2' I'm just having the hardest time trying to figure out how to "HIDE" or set visible property...

Ok, I found the issue ... http://support.microsoft.com/kb/160819/en-us Cheers! QT = )

In the properties section of the form in question ... click on the 'Format' tab ... find the 'Control Box' property and set it to 'No'. This will disable the min, max and close button. To maximize the form ... in the Open event of the form, code - docmd.maximize taaadaaa! Hope that helps ...

Am I the only one experiencing this type of behaviour? QT

Check: http://support.microsoft.com/?scid=kb;en-us;294555&spid=2509&sid=72 Or: http://www.smartcomputing.com/techsupport/detail.aspx?guid=&ErrorID=21948

I just found something interesting. I have a small db open. One form, viewing info. I notice in Windows Task Manager that MSACCESS.EXE is taking up between 70 to 97% sometimes 100% of systems resources. How could this be? Cheers! QTNM = )

Thanks ... And thanks to all for your suggestions and comments! QT = )

Fixed ... sort of. Yes, no thanks to OKI support !!! I went on a rampage, installing drivers and to my surprise I came acrosss one that kept the margins set at 0.25 on all sides and ACTUALLY PRINTED properly on the form. The fonts seem to be a little off at times and the printing of some...

what do you mean by, "to print the current record that is open in a report". If you have the record open on a form, then set the recordsource of your report to retrieve the record via an id ( preferably your primary key) from your form. Hope that helps. I'm only going on the info you have...

Can you believe this ... This problem has still not been rectified! I have literally install all drivers including ML320 and ML321 Elite and Turbo drivers to no end. This only driver that works is the ML321 Elite driver. What I mean by works is that all margins are actually set to 0.25 and...

Hope this helps .... Here you go ... Create a label in the header of your report, in this case 'lblDateRange'. I just made a psuedo table 'tblDates', then use the vba below in your open event of your report. Hope that helps .... Public Sub Report_Open(Cancel As Integer) Dim db As...

Yes, I am aware of that. Thanks. I am still unable to default all margin values to .25. QT = (

Yes, the problem computer is running Windows XP Home instead of Pro .... why would that be creating an issue? All systems are patched with Office SR-2b alike. Any takers ... I REALLY don't get this. I have played around with this for days. Now I can get the right and left margins set to .25...

... in the 3rd unbound text box all you have is: =[BillableDays]x[DailyAmount] ??? I'm unable to reproduce this issue. QT

All systems are printing to the same Oki dot matrix printer. That's why I can't understand why I am unable to change the right margin from .416" to .25" ( as all the other systems are set up ). When I try to change the right margin to .25" it reverts automatically back to .416" when I tab off...