Recent content by scorpio_x73

Hi i would like to make a question about ODBC i have created an access database that connects via ODBC to an SQL server database, with the help of someone else i have created this code that works well for the link of 1 table that i choose to link the problem is that i want to link all tables...

Not Sure if this is the right place for this question, but it involves reports so i have a report that use this code to check if a file is in place but i want not to show the corect ones but only the wrong ones as u can see in the code the problem is that i cant "delete" the corect ones and...

Hmmm Difficult :( Something more easy :( :(

I have 1 a table named Products and i'm using group by, i have a field named etc witch contains free text and i want to merge all data from that field to 1 filed called all_etc (from all records i mean) so my table looks like this : id name code...

Thank You !!!!!!!!! Thank you 1000 times. It works superb. Again Thanks you for your time and answer :)

a have a form with a combo box that displays 3 values (columns) in a bound form i can display the second value in a text box with the following command =Forms!MAIN!field_2.COLUMN(1) but i can't write it to the table my main table has 3 fields field_1 field_2 field_3 i have a secondary table...

a have a table with 10 fields (col1,col2,col3...col10) i want to make a query that will show in a custom field all the data from that fields example col1=red col2-green col3=blue in my query i have one custom field with name COLOR when i run the query i want the field color to show all the...

I have a combo box witch holds products from table products but in table products i have also color and size for every product In my main form i select products,but i want also to show in the form in a plain text box the size and the color can this be hapen, i tried with this code from another...

Sorry I was not shouting i forgot that i used caps i'm very sorry,sorry,sorry

IS IT POSSIBLE TO SEND A MESSAGE FROM ACCESS TO A TERMINAL PC IN A LAN ????

DON'T UNDERSTAND SORRY AGAIN BUT I CAN'T UNDERSTAND HOW TO PASS THE VAR MY DATA ARE ON THE TABLE SETTINGS !! HOW CANI PASS THE RECORD FROM TABLE SETTINGS TO THE VAR, AND HOW CAN I USE THE VAR IN VARIOUS FORMS PLEASE HELP ME THANKS IN ADVANCE

How do I make global variables? I have a settings table, which holds some information, which I need in every form I got. So how can I access this information from each form? I'm using usually other tables as a source of the form for the form needs, so I can't set this one as the source in these...