Recent content by hmenzel

Thanks Spikepl makes sense now, I wil have to change the output display and tell the people entering the data not to use line feeds. Harold Menzel

Here it is. Thanks, Harold Menzel

Sorry, the SQL file had no header line 37 and 45 are bad. Thanks, Harold Menzel

AND does not give the correct results . Records 36 and 44 are in error. Thanks, Harold Menzel

see attached SQL was SELECT tbl_Visits.vst_VisitDate, tbl_Visits.vst_Complaint, tbl_Visits.vst_Diagnosis FROM tbl_Visits WHERE (((tbl_Visits.vst_Complaint) Like "*liver*")) OR (((tbl_Visits.vst_Diagnosis) Like "*liver*"));

SELECT tbl_Visits.vst_VisitDate, tbl_Visits.vst_Complaint, tbl_Visits.vst_Diagnosis FROM tbl_Visits WHERE (((tbl_Visits.vst_Complaint) Like "*asthma*")) OR (((tbl_Visits.vst_Diagnosis) Like "*asthma*")); returns records with no occurrences of asthma. about 4 of 638 hits. Thanks, Harold Menzel

I accidently found that executing it which produces an empty report then allows me to open in design mode. Thanks, problem circumvented.

This is what I have been doing and getting the error which repeats and keeps me from doing anything. Harold Menzel

The report normally requires an id number which and the report prints. When i try to view the report in design mode, I get a box which says - "The stored procedure executed successfully but did not return records: It has OK as a choice and if that is clicked or X is clicked it comes back again...

I checked for other queries and used V-Tools and did not find it. I think the table is a view of 2 tables in SQL Server. I need to learn about that and look there. Thanks

I am taking over responsibility for a complex Access application (2003 and 2007) and am having trouble finding where a table is being updated. I tried stepping through the VBA code and did not find it and did not find a reference to the table in the various forms. Thanks, Harold Menzel