Search results for query: *

Depending on how you will "connect" the main database and the remote databases, you may have an easy solution with replication or a very difficult one. If each laptop can be network connected to the main database at the work location, then the replication and synchronization should work well...

OK, I solved the mystery. I had said the report within a report was not a subreport; it IS a subreport. I found this same mystery in many places in his reports. Eventually, if one moves the mouse around enough in design mode, and moves the scroll arrow around, and keeps left clicking, the...

Duane, Thanks, I'll have to try that and see if it looks like what I have now. I did try setting up a subreport with the wizard but the result looks nothing like the subject "horizontal scrollbar" that I have. The wizard's result had all the properties including the fact is was a subreport...

Addendum to my post about "report within report": Using object dependencies, I can find that the "imbedded" report shows up as an object that the main report is dependent upon. This is the first place I can actually see the true name of the depended upon object. Small progress. Regards...

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...

xlbo (Geoff) Thanks for this older post on random sort. I was able to solve a little spreadsheet for my wife. She wanted a random ordering of 5 specific exercise routines. Neat solution. Regards, Harry(xbigblue)

Larry, Thanks for your post. Google located RoboHelp for me, and the phrase "Help compiler" led me to a few posts here on Tek-tips. Should I conclude from your comments on the MSDN supplied Help compiler that it's not worth pursuing? What are its limitations/drawbacks? Regards...

Peter, Perhaps another wild guess - PC Magazine's March 2, 2004 edition has an article on Spyware starting on p.79 that sounds just enough like what is happening to you that you might take a look. The article describes a PC infected with CoolWebSearch, a very nasty late-breaking Trojan Horse...

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...

Hap, Appreciate your thorough response. I guess Access version I end up using will have much to do with potential client's existing software environment, which I have not been able to determine yet. This is still a "maybe" project. regards, Harry

Kudos to: Steve, Omega36, John, and Hap for on the mark replies. Hap, do I understand your reply to say that Office 2000 (and therefore Access 2000) is no longer supported by Microsoft? I recently used my old Desktop Windows 98 update function, applied one "critical" update, then...

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...

To: TSSTechie Thanks for your advice. I installed Office 2000 and it went perfectly. All apps seem to open and run OK. I guess there is another question - several years back I had to apply an update from Microsoft for bugs in Access. Guess I had better try to get my newly installed app...

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...

Brbarto, You can do exactly what you asked in your post. I have an application that uses a query that chains 4 queries together, then unions 4 queries including the one I described, then queries that result. Access 2000 SQL seems pretty tolerant about letting us do these things, and I have...

Hi Locosh, I know of no way to do exactly what you ask, but you could add lots of learning to your school project if you used the NoData Event of the Access Report. To do this, you would prepare a report design that uses your query as its data source. The report wizards might help here if you...

A quick update for all who have contributed to solving my slow-running report problem: Performance that was as bad as 6 to 8 minutes to produce the complex report is now reduced to 30 seconds by using an intermediate table to save query results, cleaning up unnecessary grouping, dropping...

Mymou, Thanks for the refresher on using the technique of creating "working" tables rather than joining queries. I already use it elsewhere in the application but had not thought of trying it here. I will give that a try when other fires burning brighter have been subdued. xbigblue

Thanks to all who responded and gave excellent advice. The notes on table indexes did give me some new insights. I had already applied most of the other thoughts given with no success. Having no better ideas, I fell back to a backup copy of the database and retried it. Performace was the...

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...