Search results for query: *

IT WORKED!!! Thanks for your patience and assistance... Going to a book store to purchase a book to get what you're looking for... Hours of searching... Researching pages throughout that book just to get the simple answer you're looking for, but still coming up with nothing... Wasted hours...

I created the module; however, since this is the first time that I am applying this code, hereinafter, where do I place the code to execute it? Please assist on this last leg of the process. Thanks Going to a book store to purchase a book to get what you're looking for... Hours of...

Thanks Hook'D I selected the Hook'D on Access and saw you had useful information provided there as well... You are a gift to Tek-Tips... Thanks for the codes Going to a book store to purchase a book to get what you're looking for... Hours of searching... Researching pages throughout that...

The security is set b/c I created a table with usernames and pw... I have an SQL to verify the username and pw when the employee logs in (login form). When the two are verified, the db opens up. I thought that was the easiest way to have employees log in without going to each local station and...

I created the db in MS Access 2003. I didn't set "User Level Security". I created a log in screen that requires users to login with username and pw... can each user (apprx 30) use the same db - review/update the information? Going to a book store to purchase a book to get what you're looking...

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

That is correct. I want it to check against itself. =DCount("[employeeID]","trail","reports!trialsubform![text182]"="reports!trialsubform![text182]") The IIF statement is returning true because the code is counting all of the employees and returns 500 for each. In reality, I need it to show 1...

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

Thanks MazeWorX. I believe I figured it out by having an Unbound Textbox do a Count to find a salespersons appearing two or more times on a specific day. Going to a book store to purchase a book to get what you're looking for... Hours of searching... Researching pages throughout that book just...

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

Thanks dhookom... I tried the code in my report and it worked like a charm... Going to a book store to purchase a book to get what you're looking for... Hours of searching... Researching pages throughout that book just to get the simple answer you're looking for, but still coming up with...

Thanks dhookom (duane). I appreciate your assistance. I have a Report and a SubReport... I should have written: ------------------ =[trial].subreport![trial].[firsttable] ------------------ Should have the above code qualified? You appear to have, previously, done this type of linkage or is...

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

Thanks JoeAtWork... I went with lameid idea and implemented the following code to increase the db lock while it is opened: Sub LargeUpdate() On Error GoTo LargeUpdate_Error Dim db As DAO.Database, ws As DAO.Workspace ' Set MaxLocksPerFile. DBEngine.SetOption dbMaxLocksPerFile...

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

Yes

Sorry about that. It was the way I copied it. The Code; however, isn't like that in the db. Am I doing something incorrectly with the one you supplied?

I did what you suggested and an error message generated: Compile Error: Sub or Function not defined. (The first line of your Code is highlighted in yellow) Private Sub Command0_Click() (The word Award is shade in a grey box)

Below is the code in the module: Sub Award() Dim rs As DAO.Recordset Dim rsA As DAO.Recordset strSQL = "SELECT t.CustomerID, Rnd([CustomerID]) AS RandCust, t.AwardID, t.AwardDate " _ & "FROM CustomerAwards t " _ & "WHERE t.AwardID Is Null " _ & "ORDER BY Rnd([CustomerID])"...

You are extremely helpful and patient... I put the initial Code for the button back in there, so the Code looks like this: Private Sub Command0_Click() On Error GoTo Err_Command0_Click DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 Exit_Command0_Click: Exit Sub...