Search results for query: *

Hi That does not solve Newcomers problem, he requires top6 for each of the different task nos. This cannot be done in sql. I remember putting the same issue in one of the forums. I had to finally solve it by putting the whole table through a form, using a counter that is reset at every change of...

That does not solve Newcomers problem, he requires top6 for each of the different task nos. This cannot be done in sql. I remember putting the same issue in one of the forums. I had to finally solve it by putting the whole table through a form, using a counter that is reset at every change of...

There are many sites which allow you to dial up any telephone no. You have to only download the software from the site and pay up a small fee for using the facility. In this setup you dont have to buy any equipment, use ur computer. net2phone.com is one such site. It is not legal to use voice...

Tried out all possiblities, no success. Finally loaded WIN2k on the office computer. Could dial in from my home computer. The connection holds. However, as per the book, my office computer should appear in my network neighbourhood. This is not happening. WHY ARE THE SHARES ON THE COMPUTER NOT...

Thanks for the replies, but my problem has not been addressed. webmaster999 says it requires VPN etc. But the dialup networking in Win-98 has a menu item called connections and the last item of the menu is dial-up server. Clicking on it gives u a dialog box in which there is the option 'allow...

I want to connect up to my office computer and download files. Configured win-98 DUN on office and home computer, setting server type as 'PPP: internet win NT win 98'. When I dial up, it goes up to verifying username/password, then drops off giving aerror message to check my dialup settings...

Yes, I've been doing some reading up-and its been good. Thanks for drawing attention to the multiuser enviro where other users may set about changing the yes and no. Yes this may come up at a later date. Right now users dont have permission to fiddle with tables. In fact if you recall, the...

Hi rafe/Gord Quite a bit of heavy coding rafe-I'd need the aspirins now! But I did pull out a few more of my hair and finally got to a very compact code solution. Drawing upon the various ideas put up here, I found the flagging proposal very neat and have used it here. This is how it's done. I...

Hi Gord Thanks a lot for the 'record grabber' code. I think it will make my d/b faster as i can avoid running through many many 'dlookup' statements. I did download and run your 'tigireport'. It is a fast solution and will serve my purpose as a stopgap arrangement. On giving some thought to...

Hi Gord No,no, any case you've given me a fast solution to the top value problem. As for this, its not 6 tables, rather 6 fields in a table. I pull them out one by one using dlookup 6 times. Its like this. I have a table 't1' with daily data. I open up a form which has a different table 't2' as...

Gord Eureka! Thats a nice fast solution, though a plate-full of queries. How true, often we fail to see whats below our nose. I'll try and look into possibility of generating and deleting the queries dynamically so that the query window will not look overcrowed. Of course before running...

Gord Hope you saw the posting on the reports forum. I saw your 'Dlookup' solution here and it just reminded me of a problem I had faced. I have to get multiple fields out of a table to update labels in a form. I do the 'dlookup' business about sixtimes in every record for six fields. Is there a...

Martinf Your solution is very elegant. I had the same problem, and had been living with the constraints of a fixed height grid.Now I'm liberated from that constraint! Thanks Tigi

rafe/ghubbell Thanks to rafe for the alternate route. Your suggestion of flagging the same records looks very interesting, but i persume, a bit of heavy coding will be required. Your suggestion of using forms is also interesting. What crosses my mind right now is to use a form to do the...

rafe/ghubbell Thanks very much for putting your efforts on my problem. As suggested by rafe, I have tried out a programming approach for reports. The solution i have struck on is very simple and as follows. sorting and grouping is set so that grouping is formed on month followed by...

Rafe/ghubbell There is a related problem that that I had faced and posted in one of these forums(Access reports), for which I did not get any response. I am putting it again. Problem relates to getting top values in a GROUP. For eg. I have a table of monthly productions for a whole year from...

Hi Access experts I am a new user to Access. I have a table of monthly production running into years of data I want to make a report that shows only the top 3 values for every month - how can I get it ? I tried topvalue(top 3) but that gives only top 3 values for the whole table, not every...