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

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

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

I have been using the simple code (below) for a not in list event for years without a problem. In this particular db I keep getting the message "type mismatch runtime error 13" when executing the 'Set tblONIL = DB.OpenRecordset("tblPosition", dbOpenDynaset)' line. It occurs in any Not in List...

I have a query, which works fine on my pc, which uses the mid function to parse data. When I access the db from another pc I get the message (Undefined function "mid" in expression). Even though this is a standard function, I have checked all the references and everything is the same between...