Recent content by osurfc

Thanks for the info.

I have a MsAccess app that is/was being used to populate a spreadsheet everyday. Since the Jet was updated it no longer works. From an order form I create a temporary table and use that to push to the excel file. Using the following sql INSERT INTO Sheet1 ( F1, Vendor, Item, [$ each], [# each]...

Duane sorry about confusion, the functioning code I have was DLookUp("[SS_PATIENT_ID]","dbo_demographics","[Patient_id] = " & ' [Forms]![frmdataentry]![medrec]') I had to pattern match my 7 digit medrec to the patient_id at 13 digits. I have to pad my medrec with leading zeroes to make it...

I have a macro that runs looking for patient_ID where it is equal to medrec on a dataentry form. Functioning code follows DLookUp("[SS_PATIENT_ID]","dbo_demographics","[Patient_id] = " & ' [Forms]![frmdataentry]![medrec]') The admin responsible for dbo_demographics changed the length from 6...

Skip here is the code I have, works with names,billingnum,dates the same . Changed date in 2 records and not the correct output. Also the sum of qty didnt work correctly test data lastname firstname billingnum usedate c q Test A 5555555555 051109 691030792 4 Test A 5555555555 051109 691033174 2...

I have a normalized table lname,billnum,usedt,qty,code. the table can have any number of records. I am trying to get a new data that looks like aggregated on name,billnum,usedt james 9999999 12/1/09 3 recs 13 codes 3-35033, 2-14933, 8-49786 james 9999999 12/2/09 1 recs 1 code 1-35033...

I have an application that creates a text file with information from several different tables. I currently create a recordset for each table and place the data in the appropriate order via Open "C:\MArk\test.doc" For Output As #1 Len = 82 Print #1, " B. DEMOGRAPHICS" Print #1, "Patient...

Thanks JoeAtWork. not a required field so option 1 is the correct choice for me. Works great thanks

Sorry I missed [totalBloodLoss]-[Intra_opBloodLoss]. That may make a little more sense. I copied/pasted your code into the module and I still get a runtime error #3075 syntax error in string in query expression. This is what I have strSQL_P_opBlood = "Update tblAts Set tblAts.Post_opBloodLoss...

I created an update query that I want to convert to a sql. The query works but when I view the sql and copy, the code errors at the " marks. I have tried replacing " with ' and # to try to get it to work to no avail ([start_postOp] is a time field) This is the sql statement from the query. I...

I am trying to import an Excel file (different name each import). What I would like to do is in a combo/list box get a list of the excel files in a particular directory. Then select the specific excel file for import and run the import. The questions are how do I get the list of excel files? Do...

Tom buried under a control was a pagebreak based on conditions. I didnt find it until I started disassembling the report control by control. Thanks for the great help and tips. Mark

Tom I have tried your suggestion and I still get incorrect page numbering. I also retried the Insert page numbering wizard, both @ the top and bottom location of the report and I still get the same output problem. Print preview shows 7 pages actual print is 4. The page count is now correct on...

Does anyone know why the page numbering is off in a report. The print preview will say 1 of 7 pages but then there are only 5 printed pages and there is no missing data. The final page says 5 of 7. I have deleted the page# field and saved the report and re-added the field( thinking something was...

Looking at what I am trying to get (the dollar amount). I think the logic would be to Identify the position of the "$" then identify the position of end of the numeric string (not sure how). Then get the difference between the numeric position. At that point I would have the starting position...