Search results for query: *

I have the pleasure of following another developer who cannot be contacted and who left no documentation. Access 2003, fairly simple tables layout. He consistenly has managed to place a "report within a report" in numerous reports. The application is invoicing; the "imbedded" report shows in...

Hello all, I've searched Tek-tips and found no likely posts. What do most developers do in your MS/Access applications to provide HELP to the users who need it "inline"? I wrote MS/Word based User Guides in my last Access application project and it seems the users would never open...

Hi all, I've been out of development for a couple years, may have a project on the horizon. My experience is in Access 2000; is it considered "current" (function, MS support, etc.)? If not, what versions are recommended. Saw that Office 2003 has a lot of new stuff for...

Have just bought new Compaq laptop, it has Windows XP Home edition. MS/Works is installed, I prefer MS/Office. Have an install CD for Office 2000 and have been running Office 2000 for years on our desktop under Windows 98. Will the Office 2000 install and run OK under XP Home? This is first...

Hello friends, I saw some good posts on networking a previously non-networked database on this General discussion forum and the advice is helpful. I need to ask some questions that the posts did not cover. I have an Access 2000 student tracking and reporting application that uses...

Hello friends, I have read somewhere, but cannot remember where, that there is a technique to optimize query performance; that Access (Access 2000 for me) does not necessarily optimize a query as it is written, and specifically if it is modified, unless one does some particular system function...

Hello friends, This is Access 2000. I attempt to add a Yes/No field named "Selected" to an existing table in a replicated database. Required is "NO", Indexed is "Yes, duplicates OK). I only plan to manage the field in VBA, operator will not need to input a yes/no at...

Hello all, I have a moderately complex report in Access 2000. While adding controls to a report I got the error message "Microsoft Access Can't Create Any More Controls On This Report". There is no "Help" offered. Suggestion on error message is to rename the report if...

Hello All, Can we get to the Report Sorting and Grouping "properties" (I am not sure there are such properties) programatically in Access 2000 VBA? I don't see anything in report properties to indicate that I can. Basically, I would like to be able to say FieldOne grouping is either...

Hello All, If this appears twice, I apologize. I wrote first copy, wanted to edit it a bit, it disappeared. Hope I did not post it. I have a data entry application in Access 2000 that uses a mainform/subform approach. I want to use column(5) from a combo box on the MAINFORM as a...

Hello friends, I am using a grouping query to sum fields that are passed on to a report. This is Access 2000 with SR1-A applied. The technique in the query seems to yield OK results in the query and sometimes in the report. The summed fields are type "YES/NO" data. I have not seen...

Hello friends, I have an Access 2000 report that Must sum counts of "goals" and their corresponding "accomplishments" by control group (county=groupfooter0 in report) and final totals(groupfooter1). The problem is, it must also calculate a percentage of accomplishment...

Hello friends, I am experiencing a problem with issuing the DoCmd Applyfilter in the code behind my Access 2000 report. It appends the filter in my apply filter statement to the last filter issued in the report's filter property. You can imagine the nonsense results I get, since sometimes I...