Recent content by Datagopher

Thanks for the link, John. I just checked it and you can use hyperlinks in the command buttons on 97. It's been so long since I've used that version, I couldn't remember for sure if you could do that. Dan Access Development

I haven't worked with Access 97 for awhile but if I remember right there is a hyperlink property for the command button under the format tab where you can set the hyperlink location. Dan Access Development

A real simple way to do it would be to just reference the current part # in your duplicates query and have a button for them to push, which would show them the # of duplicates. Dan Access Development

Check your query and make sure that you don't have any fields referenced where theres not an actual field in your record source. That's usually what causes that problem. Dan Access Development

Is Description an actual field in your query? Dan Access Development

You have your data grouped, so it's read only. Why would you need to edit like that? Are you trying to get rid of duplicates or set all records in a set of duplicates to a set value? Let me know what you're trying to do, your end result, so I tell you the best route to take. Dan Access Development

It can be a number of different things. As I'm sure you know, just the smallest little thing can cause issues, sometimes it helps to have a second set of eyes to look at it. That's why I asked if you could upload it, it would make it easier to figure out what's going on. Dan Access Development

That should work. Could you upload a stripped down version of your db with that form and the code? Dan Access Development

Really? Have you tried clearing out the variable before running it? e.g. strValue="" then go into your code to get the value. Dan Access Development

I remember running into something like this a little while back and I ended up using an iteration like below. Dim ctl As Control Dim var As Variant Dim strValue As String Set ctl = Me!MyListbox For Each var In ctl.ItemsSelected strValue = ctl.ItemData(var) Next var It was kind've a...

You can use Access's built in query wizard and select "Find Duplicates Query Wizard". Just add the part number field to the wizard and go into design view and change the criteria from >1 to >=1. Dan Access Development

If they are strings, try converting them to dates by using CDate. e.g. CDate([date1]) Dan Access Development

That's true. I haven't come across that in awhile though. Typically, I'll have it setup where it's a drop-down for the name and they start typing in the name and it will bring them to that name and when they click, it brings them to the record but you're right, it would serve that purpose.

True enough. I forgot about that. Probably because I have not had a need to use that in a very long time since ideally, you would want to be filtering on an ID for the name field in a normalized database.

True enough. I forgot about that. Probably because I have not had a need to use that in a very long time since ideally, you would want to be filtering on an ID for the name field in a normalized database.