Replies

Hey Rupert
I have expanded my verbal illustration of what I’m dealing with on the original post. Check it out and see if that helps explain things better. I have used Excel to clean up the data quite a bit (i.e. remove nulls and shift data in) but this is a job for Access and expressions are definitely required.
Thanks

I have a table which contains a mailing list that has 6 fields.

I need to group in a report by 2 separate levels.

Because it is a mailing list and succeptable to data entry error, I must search more than 1 field for the criteria of each level.

Group 1 would need to be on the criteria of “District” and would either be in Fields 1,2 or 3

Group2 would be based on a string that would contain “TX” and that data could be anywhere in fields 3-6

Try to picture a 6 field paper form. On that form people are filling in data by hand without any regard to disciplined entry. Here are some examples

1-Name-Address-citystatezip
2-Name-Co Name-Co address-Po Box-CityStatezip
3-Name-Title-Co Name-Address-Citystatezip
4-Name-District-District address-City statezip

…ad nauseum
Most of the data has been cleaned up to conform and respond to sorts and queries…
How in code could I group them for a report?

The Access help section on expressions in grouping for reports is abysmal…

Yes to all.
The option array takes care of itself.
The cmdOK button is also good.
How could I give the user the option to ‘save as’?
Thanks for ALL of you assistance, Geoff.

Yeah, Something very close to that. Thanks
What was the ifileno = Freefile?

Open “c:temp.txt” For Output As iFileno
Print #iFileno, strText
Close #iFileno
End Sub

You guys may not be gurus, but perhaps ‘sages’ would be more applicable.
‘Sage’-one (as a profound philosopher or eminently wise councelor) distinguished for wisdom-Mirriam Webster.

S-S-S-S-Sages

Yes, that worked well.
Sorry for not being clear. The UserForm was my target.

How do you print out everything on the form except the 2 buttons, which are named “Close” and “Print”?

Thanks, I keep forgetting how easy it is to do mass reformats in slide sorter view.
So…I’ve got the graphics over the regular bullets. Of course the animation options are limited. Swivel seems to be the best one. What I’m doing is [after animation /hide on next mouse click]. Is there any way that I can hide the actual bullets while the animation is playing?

VBA is more preferable if you plan on working with existing applications, such as Word etc… while VB is aimed at those that want to develop applications…and as the others have pointed out, it does nothing in helping you with existing applications such as Word.

While a course in VB would show you how it all works, it is primarily designed for those who already know some type of coding.

VBA will teach you the basics of this and the learning curve is much lower. Plus any course designed specifically for one application is probably more suited for your needs.

I know this because I took a course for VB when all I really needed was VBA. It helped alot, but the drop-off was quick and steep.
Hope that helps you decide…

Of course, why not follow the simple naming rules of VBA?

It just goes to show you, learn too much at once and your brain turns into the equivalent of a busy city intersection with a blown out traffic light.
Thanks Gene-o

While a gif conversion does work, this particular project required a pdf page, because .gifs print out badly.
According to Adobe, they have been encountering problems with conversion of Excel graphics to pdf. The official party line procedure is use the Distiller printer and print directly to pdf from there. If you have many prints to do, switch it to your default printer.
Beware of special fonts and objects that won’t pass through Distiller for copyright reasons.
Suspect fonts will be switched for courier (yech)…You’ll notice the difference.

I have this exact problem here too..(See Corrupt Template…Jazman2001

My scenario involved a very time consuming OCR prog that was loading via the VB Editor. r go to Tools/Macro/VB Editor

Look in the left pane for unusual objects.

I’ve asked this before in the previous edition of this help group so I’ll hope for luck and try try again. Maybe the new year will bring me some resolution in this issue.
OK, I know how the code will go. It’s a simple select case statement

I want to verify the users data entry (a simple 3 digit value), in a select case statement. True allows the user to go next and False returns an error message. That part is easy. How do I go about placing this (module) in a range of 25-35 cells of one column? This will only check the contents of the current cell and run the script. No other references are necessary…
Any takers? WOW!! OK I missed something. There is a reference point and that is from a cell in the same row 2 columns back. This will be either a value, or a blank. God, I hope nulls aren’t applicable here.

I’ll comment only for future reference to others who may encounter this via a string search.

Lock or protect the graphic (e.g.chart…etc.) When you convert or post-script, the graphic will shift if it is not protected.