Search results for query: *

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

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

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

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

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

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

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