query editor

[still_rookie]

yep i know it would be a disaster, but i will be make this function available for the admins by password protecting the command button that will make this combo box visible. ..

btw... the sql code doesn't work, it gives an error which says -

"characters found after end of SQL statement" i copied and paster exactly, and also tried removing "enter" (or next line) ...

 

[raskew]

It's been amazing how much people have tried to help you, and you've thwrated them at every step. Here's a suggestion:

Accept the fact that you have a 'knowledge problem', and it's never going to happen that you're going to excel in 'automation'. Choose another major, (e.g., some of the social sciences, 'they're warm and fuzzy and don't require a great deal of anaytical thought)' because it's more than obvious that you're not going to make it where 'critical thinking' is a requirement.

Bob

 

[still_rookie]

haha... thats not amazing... wats amazing is that you just barge in and try to abuse my "knowledge" when you haven't even tried to answwer the question...

if you think you know better why don't you tell me how to do this ???

and if you haven't already read the thread properly... i have mentioned that i don't know SQL and only know a little bit of VBA ...

So there you go.. i suggest you take up english as a subject... cuz too much computers is affecting your reading ....

and next time before you try and abuse people's "knowledge" think for a solution yourself...

and just for your information, i can bet you that i know more languages than you do, even though injust 16, i know 6 different languages + flash + php.. so there you go... still doubt my "knowledge" ????

and ive had enough arguements on this forum... and im sick of it... i dont want to start another one so please either just give me an answer to the question or just dont post... As simple as that...

 

[raskew]

You're obviously correct. Please post back with your solution, we're all on 'pins and needles' waiting for you to resolve your own problem.

Bob

 

[still_rookie]

lol.. if i were to resolve my own problem, why would i come here ???

 

[Mile-O]

haha... thats not amazing... wats amazing is that you just barge in and try to abuse my "knowledge" when you haven't even tried to answwer the question...

Actually, if you read above he has answered your question. You just haven't taken the time to understand the answer. Much like all your replies you have the attitude of it didn't work so give me more answers rather than taking the time to try to understand why things don't work.

if you think you know better why don't you tell me how to do this ???

Again: he has.

i don't know SQL

You don't need to know SQL. The query editor builds the SQL for you as long as you know what you are doing.

i suggest you take up english as a subject... cuz too much computers is affecting your reading ....

I suggest you take up English also cuz too much computers is affecting everyone's ability to read what the hell you are on about half the time.

and next time before you try and abuse people's "knowledge" think for a solution yourself...

Hey, it's not raskew's problem. Why does he have to think of a solution. He's not the one asking.

i can bet you that i know more languages than you do, even though injust 16, i know 6 different languages + flash + php.. so there you go..

Flash isn't a language. Out of interest, I take it you don't do any connecting to databases with PHP?

just give me an answer to the question or just dont post... As simple as that...

Not really. You can't stop people posting. People are trying to tell you your attitude stinks. Snap out of it, grow up, and learn to conduct yourself better.

 

[still_rookie]

Snap out of it, grow up, and learn to conduct yourself better.

so wtf am i supposed to do ??? cry and kiss ure feet ??? sorry brother... but i ain't gonna go that... i tried to be nice, but you guys just don't wanna take it, so what can i do? also... let me cleriffy some stuff....

1. let me tell you, all the people i know who have come here, say this forum stinks, just cuz of the simple reason that you ppl don't know how to answer questions properly, as i said before, check out www.invisionize.com and look at the threads... it is much more professional that this forum, and you will get your answers in 1 reply. THAT is qualty feedback. Here you guys don't get half the crap. i guess nice is 1 word you guys dislike.

You know what, i think initially, this must have been a forum just in your community and not a worldwide thing. So you guys are used to .. to .. i dunno what... it mysterious.. cuz no matter what i do, be polite, be nice, you guys ALWAYS turn back at me.

2.

Actually, if you read above he has answered your question.

wats the help ?? telling me i don't know sh** ?? is that the help >???

3.

Again: he has.

His solution didn't work

4.

I suggest you take up English also cuz too much computers is affecting everyone's ability to read what the hell you are on about half the time.

wondering how come you guys are the only ones who don't understand what im saying.. rest all the forums get what im saying and more imp they ANSWER THE QUESTION...
i suggest you take up english as a subject... cuz too much computers is affecting your reading ....
i bet you haven't done english lit cuz answering the question is 1 thing you guys don't knw...

4.

Hey, it's not raskew's problem. Why does he have to think of a solution. He's not the one asking.

then what right does he have to say i don't knw crap ??? 1 think yourself if you can answer the god dammed qsn, if not ,... then i guess wer in the same boat !

5.

Flash isn't a language. Out of interest, I take it you don't do any connecting to databases with PHP?

i know flash isn't a language, which is why i said "+" flash .... but you need to know proper english to understand small things as that... also... 4 your interest, i do knw connecting databases with PHP, but im not one of those who sit and write codes all day... i have other things, and 4 simplicity, i chose access....

6.

People are trying to tell you your attitude stinks. Snap out of it, grow up, and learn to conduct yourself better.

let me tell you guys somin, this is not my usual attitude, but you guys are always over the top, i sometimes wonder, do u guys even know anything ?? you just twist and turn every thread and make is unanswerable... Heres wat one of your members has to say:

"they will never learn anythin man...they are year 2 kids pretending they are programmers watever man"

to be honest, you guys do behave as 2 year old kids, even though the society might call you'll "adults"...

so i think it's you guys who have to "SNAP OUT OF IT"...

 

[raskew]

Quote of the day

Stuart -

Guess he told you:

"i copied and paster exactly, and also tried removing "enter" (or next line) ..."

How can you argue with logic like that? We both need to get our acts together!

LOL,

Bob

 

[still_rookie]

hehe..

now that thats sorted... i need a huuge favour...

same question.. but i think i know why you guys are confused about my database..

the thing is.. i don't have any records in my database AS YET.. which is why.. i don't get a proper SQL code from the query editor...

which is why i asked you guys... now ... forget the pervious topic..

i nneed the sql code for a combo box's row source, to get records from ONLY 1 TABLE ... its called - Car_Details...

any bright ideas ??

 

[Mile-O]

any bright ideas?

Yes. Put some test data in it and then you will have some records.

Anyway, you don't need records to use the query editor.

 

[still_rookie]

ok but could you PLEASE give me the SQL code for that ? ill owe you 1 .. if you want to take it taht way

 

[Mile-O]

I don't know the SQL - it's your table.

If you want the SQL of a query you've made then switch it from design view to SQL view and copy what's given.

Or you could just save the query and use it as the RowSource for the combo and forget about SQL altogether.

 

[still_rookie]

ok here's my database...

can you plz create an sql code for the table Car_Details ???

and tell me the code.. cuz i dunno how to do it ... plz ..

btw... itz not the sql code of a query i made that i want... i just want to open that table from a combo box, for which i need the sql code...

If you want the SQL of a query you've made

 

[Mile-O]

itz not the sql code of a query i made that i want... i just want to open that table from a combo box, for which i need the sql code...

SQL does not do that. It selects records. You need VBA in the combo's AfterUpdate event and you've already been given that. Read peoples' responses - they are, actually, helpful.

 

[still_rookie]

no wait...

you didnt get me ...
ok take a look at this...

itz a SOLUTION to the qsn i asked in the general section... but SOME PPL were i guess to lazy to answer.. or ddnt know about it ...

so take a look at this:

First I would have a tblHistory table like this:

HistoryID (PK Autonumber)
CarID (Foreign key to cars table)
InOut
HistoryTime

So I would have ONE form with the Data Entry property set to Yes so the user can only enter records, not edit them. On that form have a combobox where the user selects the car and a button to save the record the button would initially have its Visible property set to No. I would also have two hidden textboxes that are bound to InOut and Historytime fields.

Now look at tha tpart where it says - On that form have a combobox where the user selects the car and a button to save the record the button would initially have

THATS why i need the sql code ... geddit ???

 

[Mile-O]

This is it - goodbye!

SOME PPL were i guess to lazy to answer

If you want to abuse people then do it elsewhere. Nobody is here to pander to you. And as such, you have been given lots of help but it appears you have not bothered to take anything on board and seem unwilling to use any initiative. As such, I hope you get your answer but I'm not going to bother wasting my time on you anymore. I don't even know what you are talking about most of the time, to be honest, because of continuing abbreviations.

 

[still_rookie]

the abusing wasn't sarted by me.. and if you check YOUR posts... you abuse most of the time... so litrally speaking ... you have to right to say If you want to abuse people then do it elsewhere.

This forum is a waste... people like you arejust not willing to give a little time and give a full description of the answer to the question.

If you want to help, help fully.. and dont answer in bits...

All you say is : Do this.

But the question is "HOW"???

We know we have to do this or do that.. but how do we do it is the question... BUT you just don't seem to get it.

Anyway, as unhappy as a footballer with his club, im calling it goodbye fot the last and final time.

for people as annoyed as me - check this forum out - itz MUCH MORE USEFUL than this forum. Pople are willing to give a full description

and example :

My qsn:

Hello there...

Im having the following problem :

My project is about Car pooling system.
Now i need to create a form , that has 2 buttons, this will open 2 forms:

1. Car check in
2. Car check out.

i can manage that bit.

What i can't do is:

I have to make the two forms such that the records cannot be altered in any way, EXCEPT, using the button which might say "check out?". If clicked on this, that record should be removed from the "CAR CHECK OUT" form, and go into the "CAR CHECK IN" form. So later, when the car is returned, the user will go to the "CAR CHECK IN" form, and click on the box that might say "check out?" again, so it is de-selected, and the record will go back to the "CAR CHECK OUT" form.

and the answer is "astonisingly" (for this forum) longer than the question with all information "USEFUL"

Answer:

Umm Why? I assume you want to maintain a record of when the car is checked in and out. First I would have a tblHistory table like this:

HistoryID (PK Autonumber)
CarID (Foreign key to cars table)
InOut
HistoryTime

So I would have ONE form with the Data Entry property set to Yes so the user can only enter records, not edit them. On that form have a combobox where the user selects the car and a button to save the record the button would initially have its Visible property set to No. I would also have two hidden textboxes that are bound to InOut and Historytime fields.

Next I would create a query on tblHistory where the SQL would look like this:
SELECT TOP 1 HistoryTime, InOut FROM tblHistory WHERE CarID = Forms!Formname!cboCar;

Next I would have the following in the After Update event of the cboCar (the Car combo)

Dim intInOut as Integer

intInOut = DLookup("[InOut]","qryLastActivity")

If intInOut = 1 Then
Me!cmdInOut.Caption = "Check Out"
Else
Me!cmdInOut.Caption = "Check In"
End If

Me!cmdInOut.Visible = True

Finally, behind the Button (cmdInOut) I would use the following code:

If Me!cmdInOut.Caption = "Check In" then
Me!txtInOut = 1
Else
Me!txtInOut = 2
End If

Me!txtHistoryTime = Now()

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

DoCmd.Close acForm "formname"

The result here is the ueser selects a car and a command button becomes visible with the caption Check In or Out depending on the last activity of the car. When they press the button, controls are populated indicating whether the record should be an check in or out and the time. The record is saved and the form closed.

HTH

Now that is USEFUL information, and polite talking.

SJ you are just so rude.. i guess it's cause of your ego, that you're the mod, or ego that you know a lot about access....

but HEY ... ure not the best !

so fot the ppl interested in the forum .. here you go -

http://www.utteraccess.com/forums/

 

[still_rookie]

because that is very nicely written Question, and I would imagine that anyone here would have been able to read it,understand it, and willing to help if possible.

HAHAHAHAH !!! OMG !! LISTEN TO THIS !

you know somin uncle gizmo ... I POSTED THE EXACT SAME COPY OF THE QUESTION ON THIS FORUM! IN THE GENERAL SECTION ! .... i also PLEADED for an answer... but you no1 bothered to answer.. itz got SOO many views.

Oh! I didn't realize you had got bitchy again!

yes i have, not cuz im fond of it, just cuz ppl like SJ Mc... watever his name is ... dont treat me properly, and also raskew (watever his name is too) ... personally... i dont blame you, cuz you are not rude and are very understanding...

the trouble makers in this forum are the 2 listen above... they just dont have the sense of how to talk formally... and im not the kind of guy just takes it... If you are rude and unformal.. it puts me off.. plus, their answers are almost close to useless.... what the hell ... go check my older posts... all SJ does is give 1 or 2 instructions... he dsnt even explain the whole answer .... thats not it... i don't know why, but both of them have a HUGE ego problem... ppl.. get rid of it soon ... because if ppl like me come here... you won't have a good time....

I don't want to abuse this forum.. but just because of some people.. this forum will start to have a bad reputation IF nothing is done about it soon...

anyway.. im not blackmailing you or anything.. just cautioning you... cuz im just 1 ... tomm there may be 2,3,4 or more who might "protest" if u wanna call it that way....

so anyway... forget what i asked you about.. i figured it out myself...

Thanks a LOT ! (sarcastic!)

 

[Mile-O]

cuz ppl like SJ Mc... watever his name is ... dont treat me properly

Act like an adult and you'll get treated like one. Act like a whiny kid and you'll get treated like one.

they just dont have the sense of how to talk formally

Have a look at this ongoing thread. Notice the difference in tone betwen the person with the problem and you?

all SJ does is give 1 or 2 instructions... he dsnt even explain the whole answer ....

There's a reason for that. It's better to give someone a nod in the correct direction. That's usually all they need and, when the penny drops, they can quite happily continue with their database. You, on the other hand, don't appear to have ever used MS Access and certainly don't seem willing to help yourself to learn how to use it. You get nods in the correct direction and, because you don't understand them you whinge and moan. If you don't understand then be adult/honest and say so; you are more likely to get a more detailed and considerate response. Raskew also gave you a complete solution and you obviously didn't bother to try it - what are we to do if you don't seem willing to use a bit of initiative to solve problems.

If I remember correctly you said on another thread that this is a school project that you are doing. What has the school been teaching you? A huge part of development, design, and programming is being logical and using your initiative.

 

[still_rookie]

omg man... ull never understand...

Have a look at this ongoing thread. Notice the difference in tone betwen the person with the problem and you?

That doesn't look like a "nod" to me... that look like a whole freaking asnwer to his life time problems...

and btw.. itz not me who's acting like a kid.. its you ... from day 1 your like this.. and whatever ppl may tell you, you just dont seem to get the hint.

You said raskew gave me a solution and i ddnt try it... so i u think im "whinging and moaning" for nothing ?? you think im that bothered to post a reply that says it doesn't work when it does ???

Well think again...

and what the hell do you know about how much i know and how much ive don e ?? ive posted my db in 1 of the posts here... take a look ... you might be impressed... but most probably, ull just come back and "abuse" ,like you say.

anyway ... i can argue with you forever like this... So ... "HINT HINT"