Search results

Ok, is there something im doing wrong here? I enter all my data into my forms and it works... but when i close the form and go to open it again the data isnt there anymore. it goes to the next autonumber file number and if i open the table the info is stored there but the form wont let me go...

oh, so right on... worked like a charm, ended up making a new query though because well i needed to remake a different query, but i tested it out before hand... thanks though

ok, maybe this is just me being new to the access world but if i take info out of a query and put it to a form, if i change the query then do i need to make a whole new form? IE add one more field to the end?... gosh and i thought I knew access

Thanks So much... I didnt realize in the thing that I did before with the same fields that it was autonumber and number as soon as you wrote that I checked and you are SO right. thanks again for the help

no pat, MRNO in the actual table MRNO is an autonumber, in the main table it is text... I took your advice and changed the fields of last and first to LastName and FirstName, didnt change a thing though any suggestions?

Im thinking it has something to do with my MRNO table. I cant do an update query either. Any Info would be GREATLY appreciated

Im trying a query here and I keep getting a type mismatch. Whenever I take out the MRNO table and fields that I want from it it works fine but as soon as I put that in I get the error... This is the SQL code if this helps SELECT MAININFO.LAST, MAININFO.FIRST, MAININFO.MI, MAININFO.SSN...

tried the Val() and the totalsum() neither worked... i have no idea i must have done something totally screwed up and i really dont know how to fix it... sad i cant even do an add query

well, that was a problem but not the reasoning behind why it didnt work. it now created all of the rtf files this time which is a positive but it still only made 3 slides... i dont know what is wrong it still isnt working correctly do i need to make a seperate macro for each of them and then...

ok, this code works, well sort of i wrote a few days ago about moving stuff from access to powerpoint well i figured that making a report, making the report richtext and then taking the richtext word file and making a powerpoint slide... it works but not really heres the code it only works for...

Option Compare Database ' add constant for each slide/file Const tgt_file = "H:\NewDatabase\MPF1.rtf" Const tgt_file1 = "H:\NewDatabase\Depord.rtf" Dim ppt_file As Text ' ppt_file = "G:/I_and_L/LX/26APR02Right.ppt" Const pp = "C:\Progra~1\Micros~1\Office\Powerpnt.exe"...

what i ended up doing was creating a report and then calling the report in vba once the report called it exported it to an RTF file in word... that word file linked to powerpoint... yes a bit of a strech but it works... go me

i cant send the database... its on a seceret site and i just plain cant ill write down here exactly what im trying to do the query is all taken from the same table now maybe where im screwing up is the grouping of the numbers the fields are correct i pulled them right off the table list...

the function im using is this sum[total]=[udp/deployed]+[forwardbased]+[forwardstationed]+[deployedfortraining] every time ive changed it, i continue to get the number next to each other... but if i change + to - or * or / it works but not with the adding... i still cant figure out what im...

well the fields are in a form. obviuosly i want the data as soon as its done in the form to be put from the form into power point the form changes every day but there are 14 forms with all of them making slides, with the slides they do a presentation with. now the matter with the presentation is...

any one have any suggestions on this one?

uh, if you guys could explain to me what this "cheat" is id appreciate it. I really dont have any idea about VBA or the use of macros

Ok i figured out the error of my ways but now i keep getting this error message the document on path is not valid try these suggestions *check file permission *use the file open dialog box to locate the document c:\winnt\profiles\kingmr\personal\;.doc the wierd thing is it opens just fine...

ok in the regular macro screen, is there a way to make it run a module instead of anything else? it has run macro and after the continous loop i created by opening the same macro over and over again and not figuring out why, yes i had an unintelligence problem at the time, is there a way to make...

all im doing is adding a few fields that have numeric values together like imputing the ammount of people involved and stuff and its through i think 4 fields and i want to total it no matter how i word the expression it just puts the numbers back to back to back. the multiplication and...