Search results

I'm not sure how your query (and your table structure(s)) look like but for example, if your query has some join to another table, check to make sure your datatypes are the same for your columns. Otherwise, it might not return properly (as I've run into something similiar to that myself). If...

Thanks Treason for your time with this! Actually, frm_Subform_Details2 is the one I don't want them to edit. The form to edit is the subform embedded within frm_Main (called frm_SubformMain_MAIN). Sorry, I should have been more clear in the original post. :o The source of...

Hi There, I've attached my database here so u can see... I have a MAIN form which contains a Subform. That Subform contains another Subform within it. I want to enable two fields to be editable by the user on the Subform (REASON and ACTION). IDEA 1 - frm_Main -------------------- I...

I'm having difficulties creating a sql statement which updates data in another Access database from a current database. I'm able to do an insert and delete statement just perfectly, but not an Update. :confused: For example, here is a dummy sample (which does not work): Update tbl_test1 IN...

Hi Pat, Thanks SO(!) much for your response and for your explanation. I used the AfterUpdate event and it worked perfectly (after figuring out an hour later there was a SECOND reason why it didn't work with the AfterUpdate!) Turns out, my form has embedded subforms. I had only updated ONE...

Hi.. I'm terribly frustrated at this point and I hope someone can help shed some light on this.. I'm running into a very peculiar situation with using "OnChange" and other events (i.e. BeforeUpdate/AfterUpdate) for one of my forms. Not sure whether anyone has ran into this problem, but I had...

Thanks! Thanks SOOOO MUCH Yellow! That did the trick (never would've been able to see that w/o your help!) I don't know why I had those there in the first place! ha! Thanks for your good eyes and explanation!! :D I'm on my way again..! (whew!) :p

Loop through SQL results and copy files Hi! - Need to do something similiar to this post and tried a few things (esp this logic) but with no luck. Hoping anyone can help?! :o I have a sql which returns the list of filenames I need archived. I want to loop through each filename and do the...

Thanks lagbolt for the details! Thanks also for the search string for the Access help. I shall read up on this some more!

Hi folks! I'm new to Access and VBA and just want to say that this site has TreMENdousLY aided in my understanding and coding development (cause I don't think I would've learned, gotten as far, and as quickly, as I have!) :D Now moving along.. I have a question with regards to being able to...