Search results

I'm making a simple code to open a detail report using a clicked text box as a filter. First part works fine, activated on click from the [Fee Description] text box in the header: Private Sub Description_Click() Dim Filter As String Filter = Me.[Fee Description] DoCmd.OpenReport "Tap and...

My bad, I somehow read this as being about the 255 character/field limit.

Cityworks uses something like this for their comment fields to allow unlimited space for comments on each workorder. Their setup is something like this: Workorder: Workorder ID (pk) Workorder details WOComment: CommentID (pk) WorkorderID (fk) SeqID Comments The SeqID field counts...

I already posted on a couple of question forums (probably a board faux pas, sorry), but I figure you guys should see my intro first. My name is Tyler, and I'm the Wastewater Utilities Coordinator for a city in the Dallas area. Not sure where the name came from, but I basically do the database...

I've been searching for a solution to this, but I can't find anyone discussing the same issue as I have. I'm working in Access 2010 and need to link to a set of .dbf files from our GIS database. Access db will be used for quality control against GIS data, the DBFs are map layers that we export...

Came up with a solution for this after I slept on it. Set the spec to import without using first row as column heading. Then, part of the import query runs a DLookUp to find the column name based in min of ID (auto-numbered), and this gets plugged into the location name in the master table...

Chris - Do you have a unique primary key in addition to the data you showed us? If not, there's no way to determine which is older. I would add an auto-number primary key field, then query out Max or Min of that field when grouped by other fields. Then you can pull out one of your 2...

Hey guys - I've been getting a lot of help from searching your forums, but I have a problem I haven't been able to solve yet. I'm setting up a db that will house data imported from small sets. One key component is the location the data came from (it's reading water pressure at different points...