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