Recent content by Cedarguy

Pulled in each group (tables, queries, etc.) one at a time compacting after each All good Thanks again :) AMB

I followed your instructions and after doing a decompile, have the same problem. Do I now go to the "new DB and copy everything over" solution? Thanks

Many many thanks, HTH. I get the decompile bit but the VBA related suggestions went over my head. Perhaps I'll get it later after I finish the book I'm reading on VBA and start transitioning from macros to VBA :) Oh, how do I credit you for the excellent help I received form you? Best...

Thanks again, isladogs. Passwords are empty, hence corrupted :( Is there a better way to de-corrupt than creating a new DB and copying everything over? Regards

Thanks for responding, isladogs. No, its all together in one DB; I only use macros not VBA, thus far. Regards

Hello, Compact on close is asking for a password all of a sudden When I enter the password, it doesn't accept it Opened the DB exclusive and entered password, says its invalid When I open the DB normally and enter the password, it accepts and opens. Would appreciate any suggestions on how to...

Many thanks; I'm the same; must have a reason to learn. Regards

LOL I've been wanting to learn vba; can you recommend a resource I can draw upon? Thanks

IT WORKED!! Thanks Mark! So I'm still using TempVars in the macro to set up the values then opening the Query where the Field values are being substituted with TempVars. To set up the right select statement I followed your suggestion to code the sql statement and it worked beautifully. Many...

Thanks Mark, I'm not well versed in sql or vba; the suggested sql is similar to what my query has. What I gather from what you've stated earlier is that an append only works if the sourse is another table; did I get that right? I am attempting to mimic the import function in access; I...

I'm creating the data on the fly by using temp vars Thanks

I see; that's the problem then; I'm trying to add a record to table 2 (Task) while I'm in the form for table 1. What I'm trying to accomplish is to add a task record by clicking a button on the form for table 1. Is there a way I can do this? Thanks

Here's the SQL: INSERT INTO task ( Who, What, Completed, Comment, Bypass ) SELECT Task.Who, Task.What, Task.Completed, Task.Comment, Task.Bypass FROM Task WHERE (((Task.Who)=2476) AND ((Task.What)=1) AND ((Task.Completed)=Yes) AND ((Task.Comment)="No Answer") AND ((Task.Bypass)=Yes)); A record...

Thank you. Yes the values are correct; I've double-checked. In the form for table 1, I execute a macro via a button; The macro sets up the tempVars for the values for table 2 needed by the query and then opens the query; The query is set up to append a record to table 2 using the temp...

Thank you; I tried that with values codes in the query and a got a blank datasheet; it seems as though the record being appended must exist first; please clarify this confusion for me; thank you.