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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by dpedley

  1. dpedley

    Compile error (Saved Operation Failed)

    I have a database which uses the ucase and mid functions. These functions won't run unless the database is compiled. When I open this database on any of three other machines it opens as compiled. When I open it on the pc it (of course) needs to be installed on; it opens uncompiled. Once you...
  2. dpedley

    Database won't compile

    I have a database which uses the ucase and mid functions. These functions won't run unless the db is compiled. When I open this db on any of three other machines it opens as compiled. When I open it on the pc it (of course) needs to be installed on. It opens uncompiled. Once you compile it...
  3. dpedley

    On No Data print report header and a message

    I have a series of reports that print consecutively for hours and automatically email themselves to the appropriate parties. Right now if a recordset is empty the report says "error". I can cancel the event using the OnNoData property but that halts the flow. Does anyone know of way to print...
  4. dpedley

    Undefined function error message.

    I have a database I have been developing in a folder on my D: drive named "Access Database Workarea" with a subfolder named "XXX Project" and other Subfolders beneath. Some of my modules have been hard coded to specific folders. Now I'm trying to test moving this database out into the...
  5. dpedley

    Using variables with the docmd.openreport

    I'm trying to write code so that a user can open a form and pick a report from one list and a city from another. The form is working fine. But my problem is trying to get the right syntax to use the docmd.openreport. It should be simple DoCmd.openreport test, acViewPreview, ...
  6. dpedley

    Visio and Access

    I inherited a db which maintains the office floor maps in Visio and Office details in Access. And it hasn't needed any revisions to the underlying maps for some time. Now the original designer is gone and everytime I try to update one of the maps the image comes back larger than it was before...
  7. dpedley

    Multi-Line txt files

    Thanks so much, both of these are working great.
  8. dpedley

    Multi-Line txt files

    The second type of data has a potential of having more than one line per entity and each some fields may need to be included in more than one record. (ie: below Mercedes Abad and the rest of the data on the first line would need to show on both the 25711940 and 31573533 records.) Also there is...
  9. dpedley

    Multi-Line txt files

    There is some code a the end of each line. (When I view this in Word it is a paragraph mark, but I'm not entirely sure since I can't see any code in its original format.) Anyway your code works great (mostly) at finding the --> which separates the two pieces in the first example. But I end up...
  10. dpedley

    Multi-Line txt files

    reply to Caution MP. I think this was a cut and past error as I truncated the text as described in the response to Dhookum above. Also when I use Open "C:Sourcefile.rpt"... When it gets to this line it fails and says it can't find the file. I simply changed the name to ???.txt and it could...
  11. dpedley

    Multi-Line txt files

    Reply to dhookum; Q1) goal would be to have the data in the first example come in with the code, assignment, status, type and date/time in a single record. (There are more fields, but space limitation here made the data confusing so I truncated it to a smaller sample.) The same would be true...
  12. dpedley

    Multi-Line txt files

    Example two Mercedes Abad JP010691 -> 000025711940 01/01/1986 00:00:00 -> 000031573533 06/22/2007 20:57:37 Samuel B Abrams JP006522 -> 000031573437 01/01/1986 00:00:00 Paula Abramson JP001977 ->...
  13. dpedley

    Multi-Line txt files

    Thank you both for your suggestions. Here is what has occured. Essentially both methods failed for the same reason. Access does not see .rpt as a valid import extension. When I convert to .txt I can't determine the paragraph mark code to include it in the Const cContinuation or to separate...
  14. dpedley

    Multi-Line txt files

    Anybody have any ideas on how I would go about importing multi-line txt files into a table? One of our systems here exports in .rpt format which is basically .txt files. Each field is fixed delimited, but the data is in multi-line format with a --> connecting the items which go together and a...
  15. dpedley

    Printing half of line on one page half on the other

    Thanks for the reply. Due to the nature of the data I don't see how a counter would work. And yest all of the data on the report is set to can grow/shrink. I have tried moving items up and down and around on the report, but eventually, similar to what Aelonwy describes, it will recur. I...
See more

Part and Inventory Search

Back
Top