Search results for query: *

When you say "try hard coding the filter sql statement in the filter property" do you mean the 'On Filter' event property of the form, or somewhere else? I took you to mean the 'On Click' event property, and inserted it there. Unfortunately, it comes to the same result. The filter will work...

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

That was it. Knew I was missing something. Thanks!

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

I am getting a very similar error as the original post. I believe I have enough disk space - nearly 8 gig, more than I had the last time it worked - so I don't think that is the problem. I'm running Exchange 5.5 on NT4.0 with Backup Exec 8.60. I started having this problem after the exchange...

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

Thanks that is exactly what I needed!! Works great. I have a couple questions, though. Once I have added other tables and fields to the SQL statement, what is it that associates the [districtname] and [districtname2] fields together as the [district] field. Is it the order they appear in the...

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

Oops. Just noticed a typo in my previous post... The part, "the answers I'm looking for are: test test style2 test2 test2 style1 test3 test3 style8" Instead, should be test test test2 test2 test3 test3

This is almost what I'm looking for, but not quite. In end it may serve my purposes, though. I am able to achieve the same result by using the DISTINCT function, then counting the results. What I'm really after, is if there is a way to query the unique values of SITUSNUM/SITUSNAME first...

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

The problem I've had is not with the field names, nor with the data being displayed. Rather, it is in the duplication of the layout design. Even with copy/paste you still have to take some time to readjust the pasted layout objects to match the originals. It would be much easier if you could...

Because we don't yet have a set policy for information management, the staff at my firm reuses copies of old databases for work on new projects as they come in. The individual users tend to make changes to these copies such that, while the core data fields remain essentially the same, the...

Perhaps you could create a new field that automatically parses the first letter from your original field. Then base your grouping on the parsed information?

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

Thanks for the help. The Form_Open() function didn't work for me. The compiler didn't recognize the .ApplyFilter statement. Alternatively, I tried a similar statement using Me.Filter = "" and doCmd.ApplyFilter, neither of which produced the desired result. The second response was a...

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

I think I have figured it out on my own. It appears to work using the sub-summary part settings.

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

Thanks, that solved the problem I was having...at least as I described it. What I didn't include before, and what I'm still having trouble with is this: frmAddEventData contains a subform, frmAddParticipantsList, that contains a field with a value list, based upon a query. The query returns a...