query editor

[still_rookie]

im sorry but thats wat i got ... i put the tbales in the query, and then sql mode... if thats wrong can u give me step by step instructions ?? please ??

thanks a lot !

 

[Uncle Gizmo]

Opps! Sorry about that still_rookie, I was looking at another reply!

 

[still_rookie]

hehe itz okay... so .. now ?? this doesn;t seem to work ...

 

[Uncle Gizmo]

The problem with that SQL is that it will return loads of fields to your combo box. You probably don't want all of your fields listed in your combo box, it doesn't make sense to do that. So before you get that far, I would open your query again, where you generated these SQL. And run it and identify the fields you don't need. Then you will need to delete them from the query.

You have included all of the fields from all of the tables, it would be better if you just pulled out one or two of the fields, only the ones you need. You may be better off starting again from scratch. Once you've got something you like the look of post the SQL for that.

 

[still_rookie]

umm.. i dont want any fields, i want the tables itself... i want to open tables from a combo box. for that i need row source/ sql code for the tables...

so thats why i don't know wat to remove and what to keep

 

[Uncle Gizmo]

I am not sure what you mean? A table, 'IS A SET' of fields! So it doesn't make much sense when you say: "i dont want any fields, i want the tables itself" A table is the fields that it is made from. You can't have one without the other! To quote from old song ............

so I think you need to Explain yourself better .

 

[still_rookie]

ok ill try:

i want to make a combo box, which list tables and when i click on any, it should open. i can handle the VB code, but i need the sql to list the tables in the combo box...

is that any better ???

 

[Uncle Gizmo]

Right! You want the combo box to list the tables. So when you press on the item in the combo box it opens a table.

Well, I suppose that would be possible, but why? It's just not the done thing. You do not let your users have access to the tables directly, and in any event if the tables are designed correctly, they seldom have any information in them that is editable by the user. They should contain key fields which would Mainly list numbers.

I think what you should really be trying to do is create a form, in datasheet view, and give your users access to this form with the combo box. That way you will be constructing your database in the more usual manner.

You can use the form wizard to create your datasheet form. highlight a table that you want to base the form on, and then select the wizard button and it will guide you through the production of the form.

 

[raskew]

Gee whiz, just viewing this thread is painful. Can I jump in? Have to agree that giving users access to tables in not normally the way to go and spells potential disaster. It 'could be' something I might want if I were both the creator and user of the database.

This SQL, copied/pasted as the rowsource for your combo box (name it cboObjects) will return all table names, including those of linked tables.

SELECT
    msysObjects.Name
FROM
   msysObjects
WHERE
   ((Left([name],4)<>"MSys") 
AND
   ((msysObjects.Type) In (1,6)))
ORDER BY
   msysObjects.Name;

This, inserted as the AfterUpdate event of cboObjects, will open the selected table.

Private Sub cboObjects_AfterUpdate()

   docmd.OpenTable Me.cboObjects, acViewNormal

End Sub

Please give it a shot before posting back.

Bob

 

[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