Search results for query: *

Thank you for your reference. Unfortunately, I am a novice using VBA, so this level of printer manipulation is beyond my ability to tackle. I have saved your reference for someday in the future. Much appreciation. Paul Paul Faculjak paul@DataIntegritySolutions.com

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

tunsarod, We are getting closer. The first method combines the fields for a single record. I must move to the next record to see the next entry. The loop coding in your second example is what I am looking for, but I don't want to append the concantinated data, rather, I want to display the...

tunsarod, Nice simple answer. This will do the trick, but I still want to know how to loop through the records of a dataset and append each to a single field. Can you walk me through that? Paul Faculjak paul@DataIntegritySolutions.com

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

cmmrfrds You've been so persistent. Thank you. Unfortunately I am losing you along the way. I've got a small mdb file with sample data and the code you've written. Can I send it to you? I don't know what to call the result table? I also get an error when I run the code. Ideally, I'd like...

cmmrfrds Thanks to you and MichaelRed. I didn't get an email notification, otherwise I'd have responded sooner. I feel like I'm getting closer, but its still out of reach. I feel so ignorant reading your code. I see you have me setting the first code to a form open event. I don't need the...

cmmrfrds, What you described is what I thought I needed. However, I am not a programmer. I understand in concept, but can't translate it into code. Is if possible to help me out further here? Thanks. Paul Paul Faculjak paul@DataIntegritySolutions.com

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

Thanks Jim, I am actually trying to export the report and module to another database (user application). I want to put a new report and module in a small mdb file which when opened will export these objects to the application I built. I could send out new applications, but each user has a...

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

Try puting running this code when the user exits your application: Dim dataDB as String 'Assign backend database including its path as dataDB dataDB = "C:\backend.mdb" 'Compacts backend into a temp database DBEngine.CompactDatabase dataDB, "C:\temp.mdb" 'Check to see...

Another way that's not difficult at all is to set a primary key in your Access table. This prevents appending duplicate records. Next link to the excel spreadsheets. Use an append query to add the data to your Access table. Access will automatically "kick out" the duplicates. If...

Steve, Thanks. However, I am not running this from the user's database, but from an update.mdb which contains the new objects and VBA to execute the export. So I am exporting rather than importing. It seems like th export Transferdatabase will delete the object first before exporting. Even...

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

I have used it. It's very fast. One missing feature, though, is it does not compress during the backup. It just creates one large file. When I asked about compression, MS suggested I zip it first. Da, I told them, "Why then do I need your backup utility." Good luck with yours...

CS, Microsoft Support got back to me first. AMAZING response in less than 2 hours!!! Not a very intuitive fix though. Backup is not automatically installed with the Home edition: Double-click on Ntbackup.msi file found on the Windows XP Home Edition CD :\ValueAdd\MSFT\NTBACKUP That's all...

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