Search results for query: *

my apologies for being so dense but i still cannot get the combo box and yes\no field to work. it either goes all or nothing and its rather frusterating. if i select yes in ANY of the yes\no fields then all of the items in my entire list is put in the combo box...and if i dont select any, there...

ok...ive been trying to get that to work and i havent been able too...any ideas on how i should write this -Thomas Gunter-

thanks...i'll see what this does and let you know -Thomas Gunter-

I guess i should start at the beginning. I have table with my information(obviously), and i have a startup form which is automatically activated when access opens my database. The for has several buttons, but the one of importance is the "find now" button. It opens another form; that...

If i may be of some bother again, how would i take the union query and make it into a new table? -Thomas Gunter-

thankyou for the tips...the union query had the end result of what i desired and worked excellently. Thankyou again! -Thomas Gunter-

I've attempted unsuccessfully twice to append, well really once to append and once using the 2 tables to make a new table. Anyway, the append query makes more logic to me though i am not real familar with sql, but i have had significantly more success with creating a new table from the existing...

i donno...i saw the end sub and added it before but it still wants the type of query selected...then i select any (procedure, select, etc)and it gives me an error in the code. thanks for all your help though. It is GREATLY appreciated. -Thomas Gunter-

I did notice however that when i redo the sql slightly to: SELECT Source_ID FROM x WHERE (((x.Source_ID) LIKE "*\*") While Not rst.EOF) NewString = "" For i = 1 To Len(rst!Source_ID) NewChar = If(Mid(rst!Source_ID, i, 1) =...

i suppose that i must be missing something but i still recieve the same error and i cut and pasted your sql statement and changed only that which needed to be changed, ie "my field" to "source_id" -Thomas Gunter-

Thanks for the help, though when i run the query i get an error to the effect that it cannot perform the query without knowing if its an update, delete, insert, procedure, or select query. I'm assuming it would be a procedure query. Would that be a correct assumption? -Thomas Gunter-

i want to eliminate some slashes in a table and not every record has one and some even have two...(go figure), could i possibly use a query to apply a filter to table X that lists all the entries that have a \ in it and then eliminate the \'s according to the results of the applied filter? Would...

ok so if i wanted to eliminate the slashes so i can be back at the beginning, could i possibly use a query to apply a filter to table X that lists all the entries that have a \ in it and then eliminate the \'s according to the results of the applied filter? Would that work or will i have to find...

thankyou for your input. i went in and ran the query and found that a majority of the characters when entered had a space at the end of the word (technically its not a word but for a lack of a better definition i'll call it that) and for it appears that the ones without the spaces were updated...

UPDATE X SET Source_ID = left([Source_ID],10) & "\" WHERE x.Image_Source = "\Images\Rollfilm\"; This is a copy of my query i have to insert a "\" at the end of my column. Though when ran only about 1/3 of the cells in the column recieved a "\". I'm not...

greetings! i am not exactly an expert on sql but i recently had a query somewhat like yours and it used a join operation to join the information off one table and update it to my main table and i recieved a similar error. You say it highlighted the section "qdfTemp.SQL = strSQL"...this...

Thankyou Steve! That was very helpful indeed and I even added WHERE into the statement to exclude the \'s i had already manually inserted...thanks again! Thomas Gunter

greetings, i wish to add a "\" to the last four digits in one column and doing the process manually is insane since there is a little over 500,000 entries. How would the SQL look on a statement like that? Thomas Gunter Network Administrator

the only thing different between the columns is the "type" column1 in x table is text and column1 in y table is number. i think that might be the cause but when i try to change i get an error about memory...and i know theirs plenty of it...any suggestions

my apologies for the confusion. what i mean is that "column1" is not the actual name of the column, but rather a simple way of uncomplicating the problem of confusing column names. does that make it any clearer? OH, on the note of errors is simply says "an unexpected error has...