Search results

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.

Glad you got it worked out. Dan Access Development

Hi SOS, You're right, it is double quotes. I figured it was single quotes because in VBA, you would use the single quotes around string variables not the double quotes. I'm not exactly sure what you mean by single quotes having issues. The way that a SQL statement for a string variable in VBA...

I'm not exactly new but never introduced myself and was not too active when I initially registered about a year ago. My name is Dan. I have been a Microsoft Access Developer for over 10 years. I have worked for a variety of different companies on both a full-time and consulting basis. I...

Ok, let's break this down. DCount("*","TableNameHere", "[NameFieldNameHere]=" & Chr(34) & Me.YourNameControl & Chr(34) & " * - refers to all the fields in your table TableNameHere - Refers to your record source, which could be a table or query. NameFieldNameHere - Refers to the name of the...

Could you elaborate a little more such as the name of the first combo box, which should not need a SQL statement, you can just use a table or a query if theres multiple record sources and the name of the second combo box. Dan Access Development