Recent content by ninsignares

Hi, everybody... i've been trying to make a query and one of the filter is a camp in another table. I mean... my query have the following fields... ID, Price, Tax, etc etc etc and I want to exclude ID's that are in the other table... The table have the following fields... ID, Count, etc...

thnx a lot

ok... i did it... but... excel just open and it doesn't create a new file... if i want that, what i have to add in the command line?

hi, thnx the help, but i've been trying to make it works and i don't know why but it doesn't run.

hi, guys i want to open excel from access. I've been trying to do using the execute command in macros but... it doesn't work. i guess that if i write some code on the vba module i can define an instruction which meets my needs. Thnx

can anyone explain me how to open (just open) excel from access?

Bob, I have a big big problem... the year (item to search) doesn't have a fixed position in the "texto aviso" field. So i can't type in the function an integer that i don't know! If I wrong, then explain to me how i have to do when i use the function. Thnx!

Bob, the first time i did it, i didn't have a MODELO table... but when i identify the problem... i created it. in the MODELO table i have dates... years to be exact... it beggins at 1930 until 2008. in the "Texto Aviso" field I have too many words that I don't need to be filtered in my...

Hi, I've been trying to make a query from a field with text info and i want to return all words from the left to one word which is in other table. How can I get it?... I've been trying with a InStr Command but it doesn't work properly... :confused: Thnx PD: this is the sql command line...