Recent content by ttomw

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