George Tekos
Last Activity: Feb 13 '12, 10:27 AM
Joined: Dec 3 '11
Location:
-
George Tekos replied to Combobox:Web DB, how to choose values from combobox and store them in another tablein Accessthank you both, anyway.. -
George Tekos replied to Combobox:Web DB, how to choose values from combobox and store them in another tablein Accessyes. this is what i want to do.
i just had to set the second table's field as 'lookup' , point the lookup to the first table's field , and that's it..it works.
i really thank you.
but one question .
isnt my database normalised now???Leave a comment:
-
George Tekos replied to Combobox:Web DB, how to choose values from combobox and store them in another tablein AccessTo be honest, i realise the need of having adatabse normalized, but i dont understand why having a combobox storing from one table to another is not normal.. (The reason for this is that i really have no idea how to achieve that, alternatively.. ) can you help?Leave a comment:
-
George Tekos started a topic Combobox:Web DB, how to choose values from combobox and store them in another tablein AccessCombobox:Web DB, how to choose values from combobox and store them in another table
I have a web database, with a form that submits data to a table (table1).
i also have another simple table (tableForCombo) that contains names, which are being shawn in a combobox.
i want the user to
open the form,
pick a value from that combobox and
store it in another table...
how can I do this, please? -
ok. i respect it.
the random person is not that random, and the reason he made this database is the same reason you all the experts post back to our threads, by giving examples. His example is a simple database. i just asked your help because i dont get very well the way it works.. (which would be the answer to my question-thread!)..thats all.Leave a comment:
-
i tried that too, after you told me but still nothing.
I found a demo db, made by someone else who supposed to have solved that issue. but i cannot understand much. i will attach it here, if it is possible to see it and tell me how it works.
I think it's, using a specific macro or something like that.I do not know enough programming or SQL that's why i can't "Decode" the solution in the database i found.
...Leave a comment:
-
i would liek to give you one more information.
if i just let the combobox work as before (showing duplicates )
it takes the values from a query, and the SQL of the combobox, in this ocassion is
THIS is working, but without DISTINCT . and it is working uploaded..Code:SELECT Table.Field1 FROM Table ORDER BY Table.Field1 DESC;
i think it helpsLeave a comment:
-
it works ok when i test it. but when i publish it it returns the following error message
Access was unable to convert the query for use on the Web because it uses an unsupported query type, unsupported expressions, unsupported criteria, or other features that are not supported on the Web.Leave a comment:
-
and ofcourse this is it!!!
i really thank you
so in one line should be like this?
???Code:SELECT DISTINCT [Field1] FROM [Table1] ORDER BY [Field1]
no dots?Last edited by NeoPa; Dec 30 '11, 07:07 PM. Reason: Added mandatory [CODE] tags for you and merged separate posts into oneLeave a comment:
-
this is in COMBOBOX>PROPER TY SHEET> DATA> ROWSOURSECode:SELECT Table1.Field1 FROM Table1;
is this what you mean?Leave a comment:
-
Hello.
By right-mouse-clicking IN the form you want to change something on (while opened, go to from properties. (not just properties). The option is thereLeave a comment:
-
there is the navigation form's panel (typically the buttons on the left). every button is one form. if you press another button in the middle of a form's completion, the form switches and if there is no ristrictions, submits the data(something i didnt want).BUT
if you make the form open by a button, AND open as "dialog"... so it opens the form you choose, in a dialog box, where you have no option to press something else, except for...Leave a comment:
-
webDB combobox shows duplicated values - Query works fine
Good evening.
i have a table that stores dates, names (of the students) and courses (that the particular student missed, because of apscence)
i created a query, so i can recall a specific dates' aapscence. i choose the available dates form a combobox, but the only thing i dont want is the duplicate values in that combobox.
for example if, on 12/23 there where 3 students not present, the combobox will show three times 12/23....Last edited by Niheel; Dec 30 '11, 05:19 PM. -
i obviously respect 1)when someone responds to my thread2)the answer itself..
actually the popup of the form is better as a solution for me. Probably not for everyone.
thank you again :)Leave a comment:
-
I found the solution>>
there is the navigation form's panel (typically the buttons on the left). every button is one form. if you press another button in the middle of a form's completion, the form switches and if not any ristriction, submits the data(something i didnt want).BUT
if you make the form open by a button, then the only available
form-opening-method is "dialog"... so it opens the form you choose, in a...Leave a comment:
-
yes i meant to set it in the table so i have the option of setting a custom message if the rule is not ok.
i was thinking of setting something like a macro saying "if (the button submit IS NOT pressed,delete all inputs)" or "if (the other tabs are pressed, delete all inputs" something like this..ofcourse the syntax is wrong but jsut to explain you... would it work(if applicable)?Leave a comment:
-
the form contains courses' fields, a date picker (that has a default value =date() , and two buttons (submit, exit)
i cant make any of the courses lesson required for obvious reasons (maybe one day this course is not taught)
i cant make the button-pressing required i guess,
so the only way is to leave the date blank and put there the "required" right?Leave a comment:
-
Access webDB form- automatically updates the records, if i switch tab
I have a WEB enabled Access 2010 database, uploaded on a sharepoint site. the database contains 3 form and a 1 navigation form. The navigation form is the first to show up in the browser, and has the role of presenting the rest 3 forms, as tabs. So you first enter the navigation form and then navigate by choosing the tab you want.OK with that..
One tab is a form that submits data to the database. BUT> if i choose this tab >... -
Please pay attention to the title >>>Access webDB form-
i am not working on a regular access db.
Access 2010 Web databases have less than the half features enabled or "easily found" [ ]Leave a comment:
No activity results to display
Leave a comment: