Search results

I’ve got an application that allows a user to export data to word as a RTF file extension. On my laptop it works perfectly, but for some reason on the client machine it randomly cuts the last few words of the text. Some records will work others do not and from the results I’m getting it has...

I've done a few searches on this board I can’t seem to find a post with an answer I'm looking for. I have a report in my database that can be multiple pages based on the amount of data queried. I want to be able to export the report as an htm file as one page or one document. Basically what...

Thanks FYI, The sample submitted by Mile-O-Phile worked like a charm. Thanks you all for your suggestions and time! matt

Hello, I'm using an API call to open the Windows "File Open" Dialog form. I can open the form, but I need to be able to capture the file path that the user selects. Then I want to store that path in field on my form. Below is the code I'm using. The append works when I use the string "Matt is...

I'm hoping someone has some simple code that can accommodate my request. I have a form that matches tutors to students based on 2 sets of criteria. The user will then select 5 or more records to send an automated email. I have a query that contains these records selected as well as there email...

Question: I have an Access 97 Front_End datasbe that I'm trying add a reference to another database with. It works fine when both db's are the same format, example both Access 97. Is it possible to set a reference to another database version, i.e., A2k? Thanks for any help! MD

Function with double qoutes on each section looks like... faq_ConnectLink("Employee", ""C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE"" ""C:\My Documents\db1.mdb"" /WRKGRP ""C:\My Documents\Secured.mdw"") Still does not work?

Tried the Double Quotes at the beginning and ending, but it still does not work. I get... Complie Error: Expected: List Operator or ) Any other ideas???

I downloaded from a FAQ the following function.... faq_ConnectLink(strTable As String, strSourceDB As String) The function is basic, Table Name and Path to a db. It works great when the path is something simple like... "C:\My Docs\db1.mdb" but, the path I'm trying to use is like...

Hello, When printing a report using columns is there a way to hide the labels of your fields after the first column? When i set my report for 2 columns it displays the labeld for both columns when I only want to see it once. Thanks fo any help! Example of what it shows: First name: Mike...

I've got 2 db's a front_end and and back_end. In the front_end the user has a button to import a text file into a table called tblWebCourses. This table actually is stored in the back_end. I'm getting and error message "Numeric field Overflow". Any help would appreciated! matt

During my import I transfertext all my data into [Table1] that has a [ID] field that I have indexed with "NO" duplicates. If the user trys to import the text file a second time that get the error message "Microsoft Access was unable to append all the data to the table. The contents of 0...

Here is my problem... I want to create indexed fields in a table after my data has been imported, but before the import starts I want to remove all existing indexes from previous imports. Do I have to do it individually on each index using the DROP statement or is there a way to remove all the...

I have an outer loop the runs 1200 times. After each year (12) loops I need to run additonal code reseting certain vaules. Example after 12, 24, 26, 48, 60, etc. Is there a may to determine the loop without ading each value.

The INT function worked great. Thanks so much.

I have a vaule that calculates to 218.50. In my report I only want to show whole dollars. I've been trying to use the format function, but have had no luck, it always rounds the number up to 219. [Text1]=218.50, I want to display 218. Any help would be appreciated!

Hello, Using the On Activate event my code populates text controls on a unbound subreport based on criteria on my main report. When I preview the report everthing looks ok. When I print the report the sub report data does not print? Any help would be apprecated. Thanks