Search results for query: *

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

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

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

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

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

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

Thanks so much, both of these are working great.

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

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

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

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

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

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

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

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

thanks for the reply. Unfortunately this doesn'ts work either. These reports can often be several pages long and changing the font size only works as a temporary fix. Eventually some report ends up printing the same way. Perhaps I wasn't clear. This isn't obvious all the time. Only now...

I have a simple report. The data all comes from one table. The table has about 150 Y/N questions which are answered in a survey format. After the responses are entered a report is created for the individual listing all the yes responses with some lines of additional text. So the report...

The DAO change worked. Thank you both so much for your efforts.

Thanks for both of the suggestions. A user is currently working in the db, so I will try these the first chance I get and let you know what happens. Thanks.

Thanks for the reply. To answer your question. It was intended to be a recordset object. And so far has never given me a problem. I had thought the same thing about removing the dbOpendynaset, but it didn't work either. As I may have stated this is just odd to me. I will give the...