Search results for query: *

I have a multi-page report that contains many tables. I must start the report to print page-1 in Portrait, then shift to Landscape for page-2, then sift back to Portrait for page-3. (I have no option to keep the page orientation consistent.) I am looking for VBA that will not only set/change...

I have a multi-page report that contains many tables. I must start the report to print page-1 in Portrait, then shift to Landscape for page-2, then sift back to Portrait for page-3. (I have no option to keep the page orientation consistent.) I am looking for VBA that will not only set/change...

You can add any number and type of field to custom contact forms. The data is available when viewing the contact form, but when you export contact information there is no option to select those new custom fields (only the 4 user defined fields set as default are available). Any ideas out...

I know very little VBA so please be specific & patient. I have a table containing multiple records of "documentation notes" (fields: ID; date; notes). I would like to display all of the records in a text box(?) of a form and later in a report. Table format ID Date Notes 1...

I need to loop thru a record set to determine gaps in enrollment dates and the number of gaps between a start and end date range. A 1 day gap (end date 1/1/01 - start date 1/2/01) is not considered a gap. Here is some sample data and desired output: Tbl_Enrollment Date Range of interest...

I've not been able to get Transferdatabase to export a report or a module. I get errors or it runs without completing the export. Any ideas? Thanks Paul Faculjak paul@DataIntegritySolutions.com

I would like to create an Update.mdb that will execute code which exports a set of new objects (tables, queries, reports and modules) to a user's application. I have gotten Transferdatabase export to work with tables & queries, but I have problems with reports and modules. I ether get an error...

My account is set as an administrator, yet I cannot find the backup option under the System Tools. I am running Windows XP Home (Upgrade). There is no help on this subject on the MS web site. Can someone offer me some advice please? Thanks Paul Faculjak paul@DataIntegritySolutions.com

I have an application that I am distributing. The problem is that it uses a number of References that are not "Typically" installed during MS Office installation. I know that when I have worked on my user's PC, I've had to do "Custom" installation of MS Access and select...

A friend is trying to run an application I wrote in Access '97. It runs fine on other PC's but he gets "Error: 3170 Could Not Find Installable ISAM" when (I believe) this piece of code runs DoCmd.TransferText acExportDelim, , _ "TblAgree", "C:\cholesterol provider...

I have a 230 meg txt file that I append into an empty Access table (Access 2000). The text file contains data from an ad hoc (MUMPS) off of a data warehouse. The access table has 16 fields, 2 of which are indexed. These two indexed fields plus a third make up the primary key. The append...

I have a 230 meg txt file that I append into an empty Access table (Access 2000). The access table has 16 fields, 2 of which are indexed. These two indexed fields plus a third make up the primary key. The append query does no formatting. I consistently have the following problem (I archive...

Is there a string function to locate a number in an alpha-numeric string. It is typical that I get "dirty" pharamcy data: TBL_RX, field Drug_Name Prozac 20mg, 30 $27.90 IMIPRAMINE HCL 100 mg 60 $5.75 XALATAN SOL 0.025mg/ml 30 $42.95 *Notice that there is no...

I would like to build a query that assigns a record number to each record displayed. i.e. The first record would have a record number "1", second record = "2" etc. Is there a way to do this in a query? Help would be appreciated.