Search results for query: *

Well, it still sound like a Duplicates Query is what you need. If the report is based from a table, you can just create a Duplicates Query against that Part Number field. If it's based from a Query, you can just tweak the query to be a Duplicates Query. Again, that would only list those parts...

If you could zip and email the database, I can take a look at it and get back to you. I'll need to see how you have everything laid out. Hopefully it shouldn't be too big once you zip it. firstamericanstar@cox.net is my email.

Hmmm. No. That's a very interesting database you have there. What you could do though, if you don't care about the sort order of the Destinations, is sort by the DCount column maybe? I'll tell you that if the order of the named Destinations is important, than I'd have to see a shell sample...

Well, if you go into the properties of the Detail Section (right click on the Detail Section header), you can tell it to "Force New Page", "After Section". This makes it so that it will only do a page break when everything listed under Detail is printed. Next thing, if you do "Keep Together"...

Duane, that's very interesting code. And so long as there were comment tags all over the place within it, I would recommend it over my solution, but as is, it might be daunting to some.

If the dates are stored in your table, you can accomplish this very easily with a Simple Query. Design the report layout first, then make enough opies of it. If you create the first query with all of the information from the table that you want to see on the report, you're about 75% finished...

Yeah, that shouldn't be too difficult, but it's tedious. Step 1: Change the CanShrink and CanGrow properties of ALL boxes to Yes. Step 2: Change the Height property of ALL boxes to 0". This is where it gets a little tedious, but you'll appreciate the final output. Step 3: in Design View, the...

Ok, I misread your original post. My apologies. I thought that 'Destination' was the field, but you actually have multiple fields, so I was incorrect. If you set the following code into the OnActivate property of your report. You'll need to select [Event Procedure] and put the following code...

I see, so you're not actually storing the output of that DCount in the table. Then in that case....what is it that the box is actually counting? The number of instances of each Destination in the table?

Ok well my MS Access wants to be stubborn at the moment so I can't verify this, but isn't there a setting in the properties of the Data Access Page (from the Design View of the page) that allows you to turn that on and off? And to your other question - yes, depending on how you designed it, it...

If PDF is an option, it may be your only one, because it's hard to get Access reports to export perfectly to Word due to the nature of the embedded items. Would PDFs work or does the document need to be editable?

Does setting the "Force New Page" to "After Section" for the Detail Section properties work, or am I misunderstanding what you're asking?

Little more info needed. Are you trying to use the report as a log of duplicates? Or are you trying to exclude duplicates and show only non-duplicates? If you're trying to just display duplicates in the same table, couldn't you use a Duplicates Query (through the New Query Wizard) to isolate...

Humor me (because I designed a form that had a similar requirement). What happens when you swap the True/False clauses? So your code would instead look like this: Private Sub Report_Open(Cancel as integer) Dim db As Database Dim rst As Recordset Dim varBookmark As Variant Set db =...

That's what I mean though. SQL is just another way to do what you're asking. Here's what I mean. The name of the box that holds the DCount...let's assume you called it "Destination". When you go into the properties of that Report (by double clicking on the small box in the upper right hand...

Not sure if this is helpful, but I only know how to do this in SQL. You could theoretically get away with something simple, like (assuming "Destination" refers to the digit in your sample): [Destination] > 0 If you put that string into the "Filter" section of your Report Properties and turn...

That USB device...is that a tablet PC by chance? This may be a stretch, but I'm wondering if there's something with that laptop (the working one) - something that's enabling it to do what you need it to do where others fail. Perhaps something unique to the laptop. I know you said you imaged it...

Let me know how it works out with the ActiveX and security setting. It's the only thing I can think of.

I think this depends on how much text is going into this field. If it's not that much, have you (or have you considered doing so) setting the Height property to 0", so that it will only expand based on the contents? The only problem is that if it's enough text, and if it's close enough to the...

Assumptions: 1 - you're using the same version of MS Access on both machines. 2 - you're using Adobe Acrobat Distiller or Adobe PDF (Acrobat 6) on both machines to do the print. 3 - the installation options on both MS Access have all components included (when you run the Setup). Assuming all of...