Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tasawer

    How to hide details on subreport based on value from MainReport

    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?
  2. tasawer

    Emailing a 'filtered' report from Access 2007

    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?
  3. tasawer

    Update Value in Another Open Form

    can you please explain this in a bit more detail and step by step as to what you are trying to acheive.
  4. tasawer

    How to hide details on subreport based on value from MainReport

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

    Limit no of ConCurrent Users to MS-Access 2003/2007

    Could you please elaborate on this unforeseen problem!
  6. tasawer

    Limit no of ConCurrent Users to MS-Access 2003/2007

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

    Limit no of ConCurrent Users to MS-Access 2003/2007

    I have found my perfect LDB solution. Thanks
  8. tasawer

    Limit no of ConCurrent Users to MS-Access 2003/2007

    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?
  9. tasawer

    Limit no of ConCurrent Users to MS-Access 2003/2007

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

    Limit no of ConCurrent Users to MS-Access 2003/2007

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

    Reference query field

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

    Limit no of ConCurrent Users to MS-Access 2003/2007

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

    Limit no of ConCurrent Users to MS-Access 2003/2007

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

Part and Inventory Search

Back
Top