Search results for query: *

I have a database that was designed in Access 2000. However, my firm recently upgraded to Access 2007, and I'm having difficulty with one of the macros I created that had worked in the older version. In the 2000 version of the database, I have a button on a form that runs a macro on the...

I have the following code, which calls the Common File Dialog Box, for the selection of a file. The function returns a filename that is then passed to a CreateObject script I found, and opens the file using Adobe Acrobat. The problem is that if the Common File Dialog Box is cancelled, or no...

Does anyone know if there is a limit to the size of a text string that can be included in a combo box select list? The 255 character limit perhaps? I have several combo boxes that derive their select lists from a single field [fldCRITERIA] in table [tblDATA]. Several records in the field...

I have a reported based on a query derived from two tables. I would like to group my results by a list of "district names" which are common to every record. My problem is that some records belong to two districts, recorded as [DISTRICTNAME] and [DISTRICTNAME2] in the underlying...

Lets say I have three fields in a table. They are: [SITUSNUM] [SITUSNAME] and [STYLE1] The [SITUSNUM] and [SITUSNAME] fields contain street address values, some of which are duplicates. I would like to have a select query find the unique addresses. Then I would like to generate a count of...

Does anyone know of an easy way to copy finished layouts from one Filemaker database to another? The only way I've figured out how to duplicate a layout in this way is to select the layout elements individually (or all together) and copy and paste them to the second database. Unfortunately...

I have a situation where I would like to filter a form using buttons that call two different queries. The queries have conditions that prompt the user to input search criteria. I have successfully used the queries to filter my data by using buttons for each that call the ApplyFilter property...

In MS Access, you have the ability to create reports that group records by a common field. This results in there being a group header followed by the records relating to it. Is there an equivalent way to do this in Filemaker? Creating a Grand Summary layout part creates the visual appearance...

I have three forms. 1. frmEventData 2. frmAddEventData (set as pop up) 3. frmAddPersonalData (set as pop up) A button on frmEventData opens frmAddEventData as a pop up in which new event data can be added. From the frmAddEventData there is another button that opens frmAddPersonalData as a pop...

In a report and in an unbound form text box, I would like to display a narrative description based upon data (text) from various fields in an underlying table. I know how to do this in a form and report using the IIf() function and the "&" operator. My problem is that after...

I have individual images for each record in my access database that are displayed on a form. Is there a way to avoid using a full pathname pointing to the images? I want to dump the whole database (including associated images) on a CD, which will then be distributed for use on other standalone...