Search results for query: *

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

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

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

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

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

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