Search results for query: *

Hello all, I have one user on my domain that gets locked out after one failed logon attempt. He is using an XP PC, has no other problems if he gets his password correct the first time, and we have a group policy set to lock out users after 5 failed attempts. No one else has this issue. I...

I have a Dell Inspiron that I just ran the W7 Anytime Upgrade from W7 Home to Pro. This was done in order to connect this laptop to our domain. The upgrade worked without any problems. When attempting to connect to our AP, the wireless network does not appear on the list of available...

Hi all, I'm sure this is pretty easy, but... I'm trying to create a report to total immunization given (immun.immtype), by date administered (immun.servdate), and break that down by age. I created 3 formula fields - Adult: "((immun.servdate) - (patient.dob)) / 365.25 >= 18"; Teen...

Hi! CR Pro v11.0 (and very new to this, please be gentle) I'm sure this is an easy fix, but... I'm trying to find immunization administered by our clinic by date and immunization type. Then I need a grand total count broken down by ImmType. I have the ServiceDate in the Group 1 Header and...

Hi all, I'm kinda new in CR, so please go easy on me. I need to join 2 tables by the first 3 characters in each field. This worked with SQL, but I don't know how to do it CR XI: htrans.servcode[1,3] = immun.immtype[1,3]. Also is there an easy way to copy an SQL directly in to CR? I found...

I can use the following line to link 2 table in SQL: "htrans.servcode[1,3] = immun.immtype[1,3]". This statement looks for the first 3 characters in each field to match instead of the entire field. Is there a way to do this in Crystal? Thanks, Rich

I keep getting the "The ) is missing" error message with the following formula: {mhserv.sercod} = "IS024" and ((not isnull {mhprognew.opendat1}) and (isnull {mhprognew.closedat1})) or ((not isnull {mhprognew.opendat2}) and (isnull {mhprognew.closedat2})) or ((not isnull {mhprognew.opendat3})...

Hi all, I am new to CR (v.XI), so please go easy on me. I am using this report to pull clients seen in our clinic during the date range listed, but I only need them listed once. Here's the Show SQL Query from the Database menu: SELECT encounter.servdate, encounter.clinic, patient.patno...

I have an XP PC that does not get mail notification pop-ups, an icon in the system tray, nor play a sound. Yes, the boxes are checked in the Mail, User Preferences. I uninstalled and reinstalled the client twice. Any help would be greatly appreciated. Rich

Hi all, I think this is easy, but I'm real rusty on my Access. I'm trying to create a Query to display records that do not match RecNum from Table1 to RecNum in Table2. Thanks!

When I start Palm Desktop, I have to cancel on updating software 12 times before the Palm Desktop software actually comes up. Palm Desktop 4.1.2 running on Windows 2000. When I start the Palm Desktop software I get an error message saying that it needs to update software, gives me a dialog box...

How can I map a drive to a W2003 server from w98/ME PCs? I tried this Net Use command: "net use K: \\10.3.1.1\data" and got these results: "The password is invalid for \\10.3.1.1\data. For more information, contact your network administrator. Type the password for \\10.3.1.1\data:******"...

Hi all, I have an XP Laptop syncing with a Palm 500 via Easysync. Every time it syncs there is an error message "Description Cannot be Empty" for a calendar entry on 21 July 2004. There are no entries in the Palm or Lotus Notes for that date, and Easysync has the calendar filter set for only...

One of my users tried to install new wallpaper on her Win XP PC. She found a picture of a beach with shimmering water on the internet (she doesn't remember where she got it). She right-clicked > Set as Background. It set a small 2”x 2” picture on the center of her desktop. So she tried to...

Hi all, I'm working on a Friend's XP Home PC. From her description, it sounds like its loaded with virus' and spyware. It will not boot beyond the blue XP splash screen. I booted to the XP CD and ran the Restore program. It gets all the way to asking for the product key, I enter it (the #...

I have a report that lists all children who received a hearing or vision test within a prompted date range. I would like to create another report using the same criteria, but group by Facility from the Vision_Results and Hearing_Results tables. I can’t figure out how to group by 2 different...

I'm trying to use a Tungsten E with Sheet to go (v6.0) to view an Excel file with 13,000 rows (8 fields per row). We want to use it to look up dog licenses for our county animal control officers. But, when we search on the owner's name or license number, it is too darn sloooow. It takes 1 to...

Hi, I’m new to the forum, and getting better with Access, but I’m still pretty new t it. I’m trying to write a query that will compare dates of food inspections. I need to check over a 3-year period if any inspection has lapsed more than 7 months from the previous. For each record I need to...