Search results

Good Morning, Using Access 97 SR2 I've been tasked to determine user errors on a new timekeeping system (eBiz) that we are using. In one payperiod there are over 1600 records. I've searched the REPORT threads for using multiple criteria in Conditional Formatting, but have not seen anything...

Did a search at Amazon.com in Books for SQL. I tried to post the link, but it gets truncated. The SQL search yielded several books, though. Bob in Indy

Try This Try this, Stephen..... If Me![CPT] = "99215" Then Me![CPT].BorderStyle = 1 'Solid Border Else Me![CPT].BorderStyle = 0 'No Border End If Hope this helps, as it works for me in Access 97. Alas, I can't help with the "CASE" commands. I would like to see something on this...

Tay, The "OUCH" was not meant for you. Sorry! It was aimed at myself, as I had thought I had properly selected the Link Child and Master fields for the FORM, not realizing I had to do this for each TAB on the subform. My apologies for the misunderstanding !! :) Sincerely, Bob in Indy

OUCH !!!!! Well, found the error. I had set the Link Child and Master fields for the FIRST tabbed form....not realizing I had to do so for the SECOND form. Sorry !! Bob

Greetings, I have a Main Form with a Tabbed SubForm. The Tabbed Subform has two tabs, which are two subforms that I dragged and dropped into the applicable tab. My first tabbed subform is synced to the main form, and works properly. However, the second tabbed subform isn't synced. I've...

WOW !!!!! Jon and Raskew, Thank you both !! I ran both samples (Jon & Raskew) against the main database (22 Meg). Jon, your wonderful example ran in 130 seconds; Raskew's ran in 5 seconds. I am perfectly happy with BOTH examples, and the help you both have offered. Alas, I thought the...

Outstanding !! Jon, It indeed worked like a charm!! My apologies on the typo of that field name. I have several books on Access, and yet none of them really explain SQL such as what you provided. So that I may learn from this, may I ask for an explaination on what is happening in the SQL...

Sorry...didn't work Jon, I pasted the two SQL statements into two different queries, but it's not working. I've created a stripped-down version of the data. It includes; A. 2 contracts with both DFAS and DAFS in the Activity column - POID 528864 and 523204. B. 3 contracts with DFAS as...

Hello all, I'm using Access 97. I have 2 tables in a One-to-Many relationship, 1. t_PO_Contract - PK = Num_PO_Con / One 2. t_CLIN_and_FSN - Key = Num_PO_Con2 / Many These contracts can be processed by more than one activity (DFAS or DAFS). Example: Num_PO_Con = 523204 This particular...

Using MS Access 97 SR2 Greetings, I have been tasked to devise a method of determining which activity has made the most payments against a contract. Most contracts are paid by one activity against one or several line items on the contract. However, sometimes there may be two or more...

Place this parameter in the criteria line of a query: Like "*" & [Put your text here] & "*" Hope this helps !1 Bob in Indy

Greetings, Presuming the name of your field is Grade, this is what would be in the query grid: Grade:Format([Grade],"Percent") HTH

Hmmmm..... Perhaps using a calculated text box in a report..??? I've created a report grouped on Organization Code. ...............Type.........................Tot...........OT..........Percent Org.......... Hr Cd....... Hrs...........Hrs.......... Hrs.........OT IIEB...

Greetings, I am using Access 97 SR2. I want to take an unbound form and create summary information using unbound text boxes for calculations. I'm thinking I need to use DSum and DCount. I have 24 work organizations that I'm required to track their total work hours and total overtime hours by...

Hmmm....didn't work, but... This does: =DCount("EmployeeID","1A_All Employees","Depart_DNO between #10/1/02# and #10/31/02#") The expression... =DCount("[EmployeeID]","1A_All Employees","[Depart_DNO] Between #09/30/02# And #11/01/02#,0) returns an error, stating that a string can only be 255...

Jon...once again...Thanks !!!!!

Jon, Worked like a charm !! In a Report and Form, how would I go about having the user enter these beginning and ending dates and go through the several queries that use beginning and ending dates? I'm guessing some type of popup form, but not sure how to accomplish the task. Thanks again...

Greetings, I am using Access 97 SR2 I have a similar problem I'm trying to address. I'm trying to count the number of employees who have arrived and departed within the past month. I'm using an unbound form, which is heavily populated with other DCOUNT textboxes. I need something like...

DCount between dates Greetings, I am using Access 97 SR2 I have a similar problem I'm trying to address. I'm trying to count the number of employees who have arrived and departed within the past month. I'm using an unbound form, which is heavily populated with other DCOUNT textboxes. I need...