Search results

Thanks for the suggestions. The images I posted are just small subsets. The actual dataset has 26 attributes and ~27000 records. So while option 1 is doable, it wouldn't be very fun, especially if I have to reimport or maintain the data on regular basis. I am hoping to find a tool or module...

I need to import data in this format: The top row of numbers are AttributeIds In order to import it into my DB I need to convert it into the following fields and records: etc. Any fields that are null should not get a record in the conversion. Any ideas? Thanks Much! Tom

I could edit the Sales2Acre Table to add an autonumber field...

Yes I also don't understand how multiple transactions can occur for the same parcel on the same day but that is what the data is. You mean a unique sales ID for each transaction? Unfortunately no.

Here is what I ended up with: SELECT Max(Sales2Acre.Instrument_Date) AS MaxDate, Sales2Acre.MapTaxlot FROM Sales2Acre GROUP BY Sales2Acre.MapTaxlot; SELECT Sales2Acre.* FROM Sales2Acre INNER JOIN qryMaxDates ON (Sales2Acre.MapTaxlot = qryMaxDates.MapTaxlot) AND (Sales2Acre.Instrument_Date...

I have this table that records sales events for properties, with multiple sales records for some parcels. Each parcel has unique field: MapTaxlot. I want to create a select query or make table query that shows only the most recent sale event for each parcel. Instrument_Date is the date field for...

This workaround works well for saving a custom column order and column widths in datasheet. Thanks for sharing, Markzaal!:) booo to MS for such a silly bug....:banghead:

I have a form that accepts user input to create a filtered subset of data. Two of the fields, Owner and PropClass, are set up to use wildcards, "*", for text strings. Right now if I enter sa* in the owner search field because I want to find owners whose last names begin with sa such as Sanchez...

I am trying to get multiple image buttons behaving on an Access 2003 form. Following is a little bit of the code. The rest is in the sample DB attached. It works for the first command button, but not additional ones on the form: Public Sub InitButtons(Form As Form) Dim ctrl As Control...

Have you successfully used this technique with multiple image buttons on a form? It works for me with 1, but as soon as I add more buttons following the same recipe, I get error: Access can't find macro.... I've attached an example. This is in 2003 format as that is the required...

I was missing the "cmdbutton" in the tag property. Thanks Much! This works great now.

Did you have any luck getting this code working? I get Compile error: Expected variable or procedure, not module I have the following code in the On Form Load property: Private Sub Form_Load() InitButtons Me End Sub I tried changing the name of the module to InitButtons2 but still get...

I am trying to make some custom buttons using image controls on a form. I simply want the image to change on events such as mouse down etc. Here is the code I am using in the event property for On Mouse Down: Private Sub GreenButton_MouseDown(Button As Integer, Shift As Integer, X As...

Trevor, Thanks for quick response. I solved this shortly after I posted. Extra spaces got added to the report names that were imported from Excel to the reports table. When those were removed it works fine. In the process of troubleshooting I did learn a more elegant way to source report...

I am trying to use a list box control on a form to open reports. Form name is Form1 Listbox control is lstReports Row Source is from a table listing all report names: SELECT Reports.ReportName FROM Reports; On Dbl Click calls a macro named ReportList: ReportList OpenReport ReportName...

Pat, Are you suggesting there is a way to create an "excluded counties" query that dynamically changes based on the county filter selected by a user? Thanks,Tom

Simon, Thank you for this sample demonstration of these types of multi part forms. It definitely opens my eyes to possibilities. Unfortunately none of these really approaches what I am shooting for yet, which is a filtering form that simply allows users to experiment with various...

Simon, That would be great. I would welcome any insight. I've attached an exerpt of the DB. Thanks! Tom

Ok. So it sounds like my original vision of having a form that performs all these filters on the fly is not possible because of the aggregate issues. So kicking out a formatted report works, since that is the ultimate objective for the users. But I still have to provide a user interface form...

More details Help? Ok, I'm going to try this again and try to be more clear on intent. I'm still hitting my head against the wall on this form. I have the two tables (Owners and Parcels), of data detailed above, linked in a one to many relationship. Owners can own multiple parcels, in...