wood burning stoves*
The moose likes Meaningless Drivel and the fly likes VBA Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Other » Meaningless Drivel
Bookmark "VBA" Watch "VBA" New topic
Author

VBA

Suma MM
Ranch Hand

Joined: Apr 30, 2001
Posts: 31
hi!
'mn't sure if i can post a "technical" question in this forum.....but cudn't figure out where exactly these questions go!
need help on customizin a report usin msaccess '00 database and vba as the programmin language....
'm usin a button on a form which when clicked invokes a report, which in turn is based on a select query (which takes 2 parameters - month, year for which the report needs be pulled)......now, i need make a few of the fields (pulled by the query from a table of the database) appear "differently" on the report....for eg., i need some data of the table which is stored in an abbreviated form to be "expanded" when viewed on the report....Example: "if the field contains data "OS" (say), it need be expanded as "Operating System" on the report.....i'mn't able to figure out as how i need "address" the text field which holds this data.....and as to where (that is in which event) i need place the code....shld the code be placed with the command button's (mentioned above as the one used for opening the report) 'click' event or with one of the report's events??
any help 'll be appreciated....
Suma
Junilu Lacar
Bartender

Joined: Feb 26, 2001
Posts: 4442
    
    5

f 'cld mke snse of the abbvs n ur pst 'd prb'ly try 2 answ'r bt 'mn't abl 2 bcs 'm 2 frkn lzy 2 fgre it al' out! srry
bst rgds,
btw, u wn the prz 4 bst abbv's on JvaRnch...

Junilu - [How to Ask Questions] [How to Answer Questions]
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
Question: why are you asking a VB question on Java forum? Would you go to the Toyota forum to ask them how to repair your Chrysler Town Car?


Associate Instructor - Hofstra University
Amazon Top 750 reviewer - Blog - Unresolved References - Book Review Blog
Junilu Lacar
Bartender

Joined: Feb 26, 2001
Posts: 4442
    
    5

Thomas, do you think we just got trolled? Or do you think he's simply an ... well, you know, an <bleep>? (sorry...)
[This message has been edited by JUNILU LACAR (edited June 18, 2001).]
[This message has been edited by JUNILU LACAR (edited June 18, 2001).]
Conrad Kirby
Ranch Hand

Joined: Jun 17, 2001
Posts: 178
jst nd to becm a frkin rnch hnd, so i thnk 'll jst wrt ths to be fny! I agr wit Junilu!
Suma MM
Ranch Hand

Joined: Apr 30, 2001
Posts: 31
lol! (@lucar)
sorry (not 'srry' plzzz!!!) about that....
The problem is "restated in a more readable form"...i hope this should be alright....
-------------------------------------------------------------
I need help on customizing a report using MSAccess 2000 database and Visual Basic for Applications (VBA) as the programming language.
I am using a button on a form which when clicked invokes a report, which in turn is based on a select query
(which takes 2 parameters - month, year for which the report needs be pulled).
Now, i need make a few of the fields (pulled by the query from a table of the database) appear "differently" on the report. For example, i need some data of the table which is
stored in an abbreviated form to be "expanded" when viewed on the report
[Example: "if the field contains data "OS" (say), it need be expanded as "Operating System"
on the report.]
I am not able to figure out as how i need "address" the text field which holds this data and as where (that is in which event) i need place the code. Should the code be placed with the command button's (mentioned above as the one used for opening the report) 'click' event or with one of the report's events??
----------------------------------------------------------------
Any help will be appreciated....
Suma

Conrad Kirby
Ranch Hand

Joined: Jun 17, 2001
Posts: 178
Calm down on the insults now Junilu. WHOOOOHOOO I'm a ranch hand!
--Conrad
Junilu Lacar
Bartender

Joined: Feb 26, 2001
Posts: 4442
    
    5

OK, sorry for going overboard there. Abbreviations are just my pet peeve here.
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
Which still doesn't answer my simple question... why do you think anyone at JAVARANCH cares about VB?
Suma MM
Ranch Hand

Joined: Apr 30, 2001
Posts: 31
as such, i do not see any "java" question on this part of the forum (meaningless drive). so thought some "wise soul" would look at the question as a "general one" rather than as a "non-java one". ofcourse, i did lately realize what this part of the forum is for!
Andy Ceponis
Ranch Hand

Joined: Dec 20, 2000
Posts: 782
There is to be absolutely no brain activity involved when browsing this forum!!
Dave Vick
Ranch Hand

Joined: May 10, 2001
Posts: 3244
Conrad: congradulations on your ranch hand status.
Junilu: I hate them too.
Thomas: I agree.
Suma: I hate VB, VBS, and VB. Why in the world a company (micro$oft) would create 3 versions of one language in whcih the functions and methods one version don't work in any of the others is beyond me. I only use them when forced to at work because some user can't figure out how to make excell or acess work by themselves.
just my $.02

Dave


Dave
Stevie Kaligis
Ranch Hand

Joined: Feb 04, 2001
Posts: 400
Sorry...
You need to buy another microsoft product called VB for Java
hope that helps
microsoft customer support
Sahir Shibley
Ranch Hand

Joined: Apr 08, 2000
Posts: 275
Sorry about all that Suma. I have never used MSAccess but I will try to help you with this. It appears you want to get rid of field names like Cust_ID that look awkward on a report. So why dont you do it in your query ?
as in
"SELECT Cust_Name AS Customer , Phone_Nbr AS Phone FROM Customers"
The catch is you cant have a space between two words ( as in "Customer Name" ), however with a little lateral thinking you can think up some single word column headings for your report.
Cheers
Sahir

[This message has been edited by Sahir Shibley (edited June 19, 2001).]
Rahul Rathore
Ranch Hand

Joined: Sep 30, 2000
Posts: 324
Originally posted by JUNILU LACAR:
OK, sorry for going overboard there. Abbreviations are just my pet peeve here.

Suma don't mind JUNULOO. He is basically a sweet guy, who loves his pets - the playful peeves. He loves to make them PEE on the JRanch. This gives the otherwise drab JRanch, a lively aroma ... Lively enough to make corpses screw-up their noses and spring back to life.
With love
JUNU's Rihal
Yoga Guru

[This message has been edited by Rahul Rathore (edited June 19, 2001).]
lehmanra
Greenhorn

Joined: May 08, 2001
Posts: 27
Open your report in design mode.
Then goto View/Code.
Then select Detail from the left dropdown box.
Then inside this subroutine, you will need some look up code for your substitution.
Also on your report, you will need to make your original field not-visible.
Then create another text box that is unbound.
In your lookup code you will use your original field (not-visible) and assigne the substitution to the new unbound text field.
I hope that this helps.


Richard A Lehman
Eager Beaver
Ranch Hand

Joined: Feb 26, 2001
Posts: 187
Hey Rahul,
You are at it again.....playing casanova,eh! My sixth sense.. which has been honed at your Yoga centre and which has never let me down since tells me so.
with malice,
-EB.
Sahir Shibley
Ranch Hand

Joined: Apr 08, 2000
Posts: 275
Rahul,
If you are trying to give me a hint by editing your message the hint is taken. I have removed all references to Junilu's unprofessional and immature behaviour from my previous post.
Junilu,
If you dont like a particular programming tool or language then you dont have to use it, that doesn't mean you have to insult and abuse every one who does. Microsoft is still the most successful software company in the world. All your ranting and raving cannot make that go away but only serves to make you look rather silly. She may have posted this message here under the assumption that her message may be seen by a programmer. Some people still labour under the old fashined view that a programmer is someone who is familiar with several programming languages.
In my view someone who only understands Java is called a troll

Cheers
Sahir

[This message has been edited by Sahir Shibley (edited June 19, 2001).]
Cindy Glass
"The Hood"
Sheriff

Joined: Sep 29, 2000
Posts: 8521
You know Richard,
I had actually wondered how to do that myself on occasion. Thanks.
(OH NO, did I actually ADMIT to coding in Visual Basic and MSAccess at times??? Must be delusional ).


"JavaRanch, where the deer and the Certified play" - David O'Meara
Suma MM
Ranch Hand

Joined: Apr 30, 2001
Posts: 31
hello!
thanks a lot....
Richard, that did help....thanks!
-S
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
Sahir, if you want to ask a programming question about VB why not go to VBRanch? Or MicrosoftDevelopersRanch? Why on earth would you go to JavaRanch? If I wanted to know how to replace a timing chain in my Nissan would I go to to ToyotaRanch? Sure, it's possible that somewhere on ToyotaRanch there is a mechanic with experience working on Nissan's but wouldn't I have more luck at NissanRanch?
Andy Ceponis
Ranch Hand

Joined: Dec 20, 2000
Posts: 782
Nissan's use timing chains?
Junilu Lacar
Bartender

Joined: Feb 26, 2001
Posts: 4442
    
    5

Sahir and Rahol, you guys are just too witty and funny...
Conrad Kirby
Ranch Hand

Joined: Jun 17, 2001
Posts: 178
I say Hello! you say Goodbye!
I say screw microsoft you say yes, that would be nice!
I say I like toyotas you say where is ToyotaRanch
I say Repair my freaking Nissan timing chain you say go to ToyotaRanch!
Plenty O' logic around here eh'?
Junilu Lacar
Bartender

Joined: Feb 26, 2001
Posts: 4442
    
    5

I ain't no girl, jack...
and some women might consider it quite sexist to call them that, too.

[This message has been edited by JUNILU LACAR (edited June 20, 2001).]
Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
Originally posted by JUNILU LACAR:
Sahir and Rahol, you guys are just too witty and funny...

Thanks
u r such a sweet kid ! I love u !
However Rahul is a gasbag.
Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
Originally posted by JUNILU LACAR:
I ain't no girl, jack...
[This message has been edited by JUNILU LACAR (edited June 20, 2001).]

What was that ?
Junilu Lacar
Bartender

Joined: Feb 26, 2001
Posts: 4442
    
    5

Originally posted by Jack:
> What was that ?
No offense, jack, but I was replying to a message where Rahol called me a girl, which I'm not. Apparently he deleted that post and now he thinks I'm a kid. I'd like to throw him over my knee...

Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
Originally posted by Daniel Dunleavy:
I have a COBOL question....how do you get the date into the program.
Flowers and a nice dinner is a good place to start.
Sahir Shibley
Ranch Hand

Joined: Apr 08, 2000
Posts: 275
Originally posted by Thomas Paul:
Sahir, if you want to ask a programming question about VB why not go to VBRanch?

Come on, lighten up a little Thomas. Suppose some one at the Toyota ranch fixed your timing chain and said "Mr.Paul, since you own a Nissan Vehicle the Nissan service centre would be able to help you better when you have trouble with your vehicle next time".
And when you plan to buy your next vehicle and are weighing up Nissan and Toyota, you will give Toyota 10 out of 10 for customer service and that may strongly influence your decision to go for a Toyota. That is the power of effective customer service skills. If I am not mistaken, someone who likes Java as much as you do, wants Java to grow in popularity. A language grows stronger when more programmers migrate to it. She might have been a VB programmer who was planning to migrate to Java ie. a potential customer. So who helped Java more here, me the "microsoft mole" (even though I did not know enough about MSAccess to help her, atleast it gave Richard the courage to post an answer here ) or the people who tried to scare her away?
Cheers
Sahir

PS. Do not think a Toyota mechanic fixing your Nissan is a farfetched scenario. I taught customer service skills to call centre agents for a couple of years. We taught them that "if a competitor's customer calls the wrong place and gets you on the line help them to whatever extent you can". Each customer you help that way is a nail in your competitor's coffin.

[This message has been edited by Sahir Shibley (edited June 21, 2001).]
Matthew Phillips
Ranch Hand

Joined: Mar 09, 2001
Posts: 2676
Originally posted by Sahir Shibley:
Originally posted by Thomas Paul:
[b]Sahir, if you want to ask a programming question about VB why not go to VBRanch?

Come on, lighten up a little Thomas. Suppose some one at the Toyota ranch fixed your timing chain and said "Mr.Paul, since you own a Nissan Vehicle the Nissan service centre would be able to help you better when you have trouble with your vehicle next time".
And when you plan to buy your next vehicle and are weighing up Nissan and Toyota, you will give Toyota 10 out of 10 for customer service and that may strongly influence your decision to go for a Toyota. That is the power of effective customer service skills. If I am not mistaken, someone who likes Java as much as you do, wants Java to grow in popularity. A language grows stronger when more programmers migrate to it. She might have been a VB programmer who was planning to migrate to Java ie. a potential customer. So who helped Java more here, me the "microsoft mole" (even though I did not know enough about MSAccess to help her, atleast it gave Richard the courage to post an answer here ) or the people who tried to scare her away?
Cheers
Sahir

PS. Do not think a Toyota mechanic fixing your Nissan is a farfetched scenario. I taught customer service skills to call centre agents for a couple of years. We taught them that "if a competitor's customer calls the wrong place and gets you on the line help them to whatever extent you can". Each customer you help that way is a nail in your competitor's coffin.

[This message has been edited by Sahir Shibley (edited June 21, 2001).][/B]

Thank you, Sahir. I couldn't have said it better myself, but I will try.
Java is the language that I am concentrating on, but it is not the only language that I am learning. I would like to think that in Meaningless Drivel, we could answer questions about other programming languages if we know how the answer. At the very least, JavaRanchers will be known as nice guys/gals.
Matthew Phillips
P.S. Add the line ACCEPT "insert your user-defined name here" FROM DATE to the procedure division. (I am not yelling, it is accepted COBOL form to type commands in all caps).


Matthew Phillips
Ling Wu
Ranch Hand

Joined: Jul 19, 2000
Posts: 184
Originally posted by Matthew Phillips:
Thank you, Sahir. I couldn't have said it better myself, but I will try.
Java is the language that I am concentrating on, but it is not the only language that I am learning. I would like to think that in Meaningless Drivel, we could answer questions about other programming languages if we know how the answer. At the very least, JavaRanchers will be known as nice guys/gals.
Matthew Phillips
P.S. Add the line ACCEPT "insert your user-defined name here" FROM DATE to the procedure division. (I am not yelling, it is accepted COBOL form to type commands in all caps).

Now I can finally breathe a little easier and slowly and cautiously come out of the closet. I am a VB programmer. That is what I do for a living. But I have been learning Java on the side, very slowly (I don't have a lot of "spare time"), since last summer. I have hardly posted anything in the "serious" forums because I'm the greenest of the green horns. I do visit those forums to learn what other people's problems, questions, answers, solutions are. But I can't say that I can just give up VB and devote 100% to Java because my employer is not using it yet. And I do need food on my table and roof over my head. But I want to be prepared once it is used in my office. I believe It will just be a matter of time when that happens. Thanks a bunch for validating people like me. I love this site and don't want to stop coming if I don't have to.
Suma MM
Ranch Hand

Joined: Apr 30, 2001
Posts: 31
I would like to think that in Meaningless Drivel, we could answer questions about other programming languages if we know how the answer. At the very least, JavaRanchers will be known as nice guys/gals.
---------------------------------------------
Atlast!!! that waz surely a 'great thought'!! (Noooooo!! not bcoz i've some more questions on delphi/smalltalk/python/.....???, atleast as of now!) A 100% objective opinion, plz!!

[This message has been edited by Suma MM (edited June 22, 2001).]
Rahul Rathore
Ranch Hand

Joined: Sep 30, 2000
Posts: 324

Originally posted by Suma MM
Atlast!!! that waz surely a 'great thought'!! (Noooooo!! not bcoz i've some more questions on delphi/smalltalk/python/.....???, atleast as of now!) A 100% objective opinion, plz!!


Hi Suma
While I think Junilu could either have been more polite or ignored your post, I do agree with his view about abbreviations.
Abbreviations do irritate. A nicely formed sentence is more attractive to read and easy to comprehend. Not that there is any rule against using abbreviations (I think).
However I do think that your reuse of abbreviations, in the controversial context of the current thread, is in bad taste.
Otherwise, I think, anything goes in Meaningless Drivel.
[This message has been edited by Rahul Rathore (edited June 22, 2001).]
Suma MM
Ranch Hand

Joined: Apr 30, 2001
Posts: 31
Whoops!! I have to mention I tried being careful but I guess I need to be meticulous!
Chucha Kana
Greenhorn

Joined: Jun 22, 2001
Posts: 4
Obviously, VB is hated more than COBOL here. The real question is: what do locals hate more: VB or C++?
------------------------------------------------
Chucha Kana,
head of spiritual-lingual disorder department in the Base Scoundrel Psychiatric Hospital dedicated to the memory of Father Johnson Chongson.

Chucha Kana, <BR>head of spiritual-lingual disorder department in the Base Scoundrel Psychiatric Hospital dedicated to the memory of Father Johnson Chongson.<BR>
Cindy Glass
"The Hood"
Sheriff

Joined: Sep 29, 2000
Posts: 8521
Originally posted by Chucha Kana:
what do locals hate more: VB or C++?

c# of course . Much worse than VB.
c++ is sort of tolerated due to the fact that it influences so much of the evolution of Java. We just like to think that Java is so much BETTER that c++ .
Chucha Kana
Greenhorn

Joined: Jun 22, 2001
Posts: 4
JavaRanch codex of honor
...� 135. List of languages to be hated (most hated first)
1. C#
2. VB
3. COBOL
4. C++
5. ...
Come on guys! What about JavaScript? Lisp? Perl?
------------------------------------------------
Chucha Kana,
head of spiritual-lingual disorder department in the Base Scoundrel Psychiatric Hospital dedicated to the memory of Father Johnson Chongson.
lehmanra
Greenhorn

Joined: May 08, 2001
Posts: 27
Come on guys....
A language is a language. Do any of you speak any other language than English? If so, who NOT?
If you have been around as long as I have (25+ years) you see them come and go.
However if you have your own favorite (mine is Ada) go for it.
JAVA is just another mouse trap that is driving people to its front door. Nothing is perfect. That is why G-d made man/woman. To achive perfection in noble. However some are better at it than others.
Just my 2 cents....
Cindy Glass
"The Hood"
Sheriff

Joined: Sep 29, 2000
Posts: 8521
Richard,
It's a JOKE. In real life I actually program in Visual Basic, I have applications that I have written and support in MSAccess and some unbelievably complicated Excel applications (not to mention COBOL, FOCUS, Oracle Stored Procedures etc. etc.). I often admire how MicroSoft has evolved these products over the years.
However, when I have my Java hat on, I have to admit that MicroSoft has tried every devious way that they can to make a buck out of Suns language. Sun offers it for free, MicroSoft wants to charge for basically the same thing. It's the philosophy thing that causes the Rivalry, not the actual languages themselves.
No one actually hates any of these languages, after all, as you say, they are just languages. But that isn't going to stop me from making remarks about c#, even though I will lay you odds that within 3 years I will have coded a whole application in c# (don't tell my fellow moderators ).
 
permaculture playing cards
 
subject: VBA
 
Similar Threads
Need to "simulate" multiple full outer joins on db2
jdbc driver not found
Selecting data from more than one table: I am getting exception
Populate Excel Spreadsheet
Determing if Form Data Changed