I ma working on Access 2003
I have not set Shrink Property.. I will ook at this option
Implementing in the records is not possible as it couold affects the totals
I am hiding individual controls.. How do i hide the record?
Your first click will print a report that lists all records related to Area 2. Correct?
Now you wish to email this report?
What is the name of the report?
Hi,
I have a two main reports ('Maintenance' and 'RepairsInvoice'). they use the same sub report (MaintenanceDetails) that lists all the purchases with grouping.
As long as I don't implement the options listed below, all is fine.
mainreport has field: 'HidePrices: Yes/No'
SubReport has field...
of course.. I got busy implementing it...
Create a module with the code given below.
download the file msldbusr.dll and copy to windows\system
From within your applciation, you can get the no of users connected with GETUSERS()
The rest is upto you how you as to how you implement it.
if you...
This still does not combat the system crash issue, unless we wait the specified time before login (say 15 minutes!!!).
When we have several forms that could be open at one time, how can I run the timer that can check activity on any form?
I have a global constant 'LimitUsers=x'.
I have a users table that allows to add many users, but only x number can be active at any one time.
problem is that one user can have multiple logins.
I added an extra field 'LOGGEDIN" that is set to true when users logs in and set to false when user...
by reading the main LDB, if no of users is breached, I can throw a message to ask to restart main server in which case the LDB file would be reset.
if a system crashes or user logs out erroneously, same user can log back in.
How do I reset my table?
providing a RESET ALL USERS button would...
is your report ready to be printed?
are there more records than one for every sale order number?
you can get the query to filter all records related to Sales Order Number and print all labels in one go.
Otherwise, you can display the filtered query in a subform and select the appropriate record...
Hmmm... and where do I start?
I did try to implement a scheme where I created a table of users that updtaes as each users logs in and after the license number is reached, it refuses further connections.
However, if the system crashes, or user logs out inappropriatly, technically, he remains...
Hi Serious Programmers,
I wish to read the LDB file to limit the no. of concurrent users to an msaccess database.
On a test database that has nothing but FORM1, I have implemented thread705-278774 but I get Error 53, Bad filename or number.
I have checked the filenames and datapaths but it is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.