Search results

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

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

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

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

I am trying to structure a select query in Access 2010 that would allow me to create a form/list of owners and parcels that can be filtered on multiple fields. Tables: OWNERS OwnerID (key) OwnerName OwnerAddress Category (lookup with 7 options) PARCELS TLID (key) County Acres PropClass...

I have a large table of property parcels and need to create from it a separate owners table. For the new table I need an OwnerID for each unique Owner. I would prefer to use a simple incrementing number for each unique owner value. Many owners own multiple parcels. So if I create an OwnerID...

I'm new to the forum, but have found several helpful solutions and insights over the years. I've been using Access off and on for about 10 years. Thanks, Tom