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 strongm 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: *

  • Users: MoBetter
  • Content: Threads
  • Order by date
  1. MoBetter

    When is it required to use the Workgroup Administrator in MS Access

    I setup a database with a login screen (user name/pw) and will place it on the network. If I wanted all of the users to share/update the information contained within the database would I still need to use the MS Access Workgroup Administrator to join each of the employees that will use the...
  2. MoBetter

    Using Unbound/Text Boxes To "Intentionally" Track Duplicates

    I'm using Microsoft Access 2003 and I have an employee list with 500 employees. I created a REPORT and used a TEXTBOX to find duplicates because I recieved a "too complicated" error on the QUERY. The Employee ID is in the Report and the FName and LName comes up in the TEXTBOX NAME "text182". I...
  3. MoBetter

    Finding Duplicates Using Text/Unbound Boxes

    In Microsoft Access 2003, I created a Report that has: Customer ID: Customer Name: Salesperson: Office Visit: Out of the ten Salespeople on staff, only one Salesperson can visit one Customer ID on any given day. I created a series of Unbound Boxes to automatically assign the schedules since...
  4. MoBetter

    Linking An Access Unbound Textbox to Subform

    I appreciate all of you experts out there... I have a db in Access 2003 and was wondering if anyone knows how to link a field from a subreport to an Unbound Textbox. I have a Master Report name: Master; and a SubReport name: Trial When I try to link the SubReport to an Unbound Textbox using...
  5. MoBetter

    Access - System Resource Exceeded

    I am currently running Microsoft XP with 1 GB of RAM and the Virtual Memory is set: Initial Size (MB): 1524 Maximum Size (MB): 3048 I have a 75 GB hard drive: 34.6 GB Used 39.7 GB Free I created a Microsoft Office Professional 2003 Access db that grew and I compacted it, so the size is now...
  6. MoBetter

    Applying Modules to Queries, in Access, so it runs automatically

    I was wondering once a Module is created, how does the actual Module work in a Query, so that the Code would run, behind the scenes, automatically when I apply an Update/Refresh Button to a Form. Please note the original Code written by Remou: Sub Award() Dim rs As DAO.Recordset Dim rsA As...
  7. MoBetter

    Random Selection From A DB List

    Does anyone know how to select a random record from a list of numbers already in a table (via Microsoft Access)? If there is a list of numbers: CustomerID 1 2 3 4 and I wanted to assign a specific award: AwardNumber 100 200 300 400 to a customer (i.e. CustomerID 3 will recieve AwardNumber...

Part and Inventory Search

Back
Top