Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. osurfc

    need an updatable query error

    Thanks for the info.
  2. osurfc

    need an updatable query error

    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]...
  3. osurfc

    dlookup syntax

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

    dlookup syntax

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

    Compare and aggregate data

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

    Compare and aggregate data

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

    formatting data in output file

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

    Help with Sql statement

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

    Help with Sql statement

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

    Help with Sql statement

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

    Import Excel file different name each time

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

    page numbering

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

    page numbering

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

    page numbering

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

    parsing memo field

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

    parsing memo field

    I have a MsAccess XP application that I am revising. There is a memo field that contains text messages. I am trying to split out several pieces of the text and use them to update the corresponding data fields. the text string looks different depending on the individual who entered it. eg...
  17. osurfc

    Insert tab space when text field grows to 2nd line

    Wow I am not sure what to say except thank you. I by no means had envisioned you writing the code for me. I do appreciate the step by step notatation of what is going on. That helps me considerably in growing my knowledge base. I had envisioned this small piece of the project being my "night...
  18. osurfc

    Insert tab space when text field grows to 2nd line

    Pete I'm not a programmer so bear with me on this thread.. Why should the field be an unbound object as opposed to bound? I have started coding in the section for the control using the on formatting event. Having never worked with arrays I am completely lost with your coding. I am tring to read...
  19. osurfc

    Insert tab space when text field grows to 2nd line

    Pete, Where in the coding would I put that and what would be the syntax? Mark
  20. osurfc

    Insert tab space when text field grows to 2nd line

    I am working on an application with a text field width set to 160. The report width for that text field is set to 50 and can grow property is yes. Is there a way to indent the second and following lines by 5 spaces. example of the text breaking would look like this. Which is how my...

Part and Inventory Search

Back
Top