Search results

i think i know, there's a problem in a query, that's why it wasn't creating just can't find it yet Bob, you're amazing

wow, i spend half hour trying to figure out how to get this on a cliboard thank you for another lesson SELECT AllMkts.State, AllMkts.Mkt, [42010].Acute, [52010].Acute, [62010].Acute, [72010].Acute, [82010].Acute FROM AllMkts LEFT JOIN 42010 ON (AllMkts.Mkt = [42010].Mkt) AND (AllMkts.State =...

Dim TblName As Long Dim FMonth As Long Dim FYear As Long Dim FSort As Long Dim TMonth As Long Dim TYear As Long Dim TSort As Long 'delete after the form is made with a date picker FYear = 2010 FMonth = 3 TYear = 2010 TMonth = 9 TblName = 2 'delete after the form is made with a date picker...

Thank you so much, I will check it out as soon as I get to work

i could never write anything like that myself, at least, not in the near future i was hoping that someone has some code that i can use, same way i was able to for FTP, but wasn't able to fins anything online yet

Hi is there any way to upload a file to a folder already created on an sftp site by using VBA? i have code (complicated, and a library db to come with it if anyone needs) to do it to an ftp site, but not sftp thank you

Its freaking horrible. Its due tomorrow and I'm nowhere near done. Just left work (got kicked out by the cleaning crew))) and will be up all night trying to finish from home You, guys, saved me a bunch of time. There's 7 sets of 5 sets of columns that have to be spread out like this. I had a...

))))))))))))))))) it's contageous with this many smart people here something had to rub off

i'm sorry, disregard the last post, i'm an idiot

ok, i understood how it works, but one slight problem i can't do anything with this data, i can't make it into a table, or append it or anything

this and stopher's example (they're the same) is amazing!!!!!!!!!!!! please explain how you did this, this is so simple that i'm in awe

this looks similar to stopher's, no? i'm trying it out right now also, i didn't understand what you meant by C3 not existing (columns names and data are fake, the column names they want are long and with spaces so i used C1, C2)))))))) anyway, yes, this column doesn't exist in the table and...

i do, autonumber you mean?

i'm a she))))))))))))) with a name like lala)))))))))))))) i'm not on vacation))))))))))) i wish i checked this topic over the weekend, i'd get so much done thank you thank you thank you all!!!!!!!!

i think i'm slow but i don't get what the report is showing or i have to create the query and use the function to see the results?

few questions do i use your code in vba as a RunSQL, or just as an sql query in access there's a primary key (just an autonumber, will that help? if not, i have a bunch to choose from) i'm gonna try this out right now, hopwfully it works for me thank you so much!!!!!!!!

i say this all the time, thats why i love access so much despite all the "big shots" that diss it everything else - i already explained why it has to be done this way in the future i will explain it right away when asking a question i do understand why you'd question this design, i would too...

i didn't realize this had to be specified, you're right the columns hav to be created in the order the entries appear the states is an example, i'm working with doc degrees, specialties and stuff so they have to go in the order they appear (they have a rank) i thought once i figure out how to...

i do, it can go up to 5 for each case if i show you this spreadhseet with 220 columns you'd cry trust me, i'd never design a database so poorly organized but in this job i got into something new, using access, vba, excel macros and vbs to completely automate pulling data from oracle, manipulate...

it did, if noone else replied that'd definitely be enough to get it to work not as ingenious as you guys do here, but i'd manage)))))))) wow, i get all this praise from the people i work with for my access skills, when i come here i realize i don't know anything at all you guys are freaking...