Recent content by Mmattson

Thanks for the response. I tried your listed items where I hadn't already tried it. Go ahead and "Dazzle" me...:p I checked this - Not the answer This is what I think, but can't find it while reviewing code. Did this, already - Not the answer Tried this based on your tips - Not the answer.

I have some code that runs some code to add a foreign key to a sub-sub-form. To refresh the foreign key data I also run a requery. The code also saves the record. The sub-sub-form is now reset back to the first record of the related records. The problem I have is that regardless of which...

The solution I am working with now is to use a (pseudo) bridge table I have to update the field by executing an update query onExit. CurrentDb.Execute "Qupd", dbFailOnError This works. :rolleyes: If there is a better way, I'm still open. I am also still curious why it is only setting the value...

Here it is. It has basic protection (Shift key). The form in question can be found as a sub in the Marketing Budget form. It is in development, hence some of the sloppiness.

Access 2003 I have a form that is designed for semi-technical and non-technical to enter budget plans for the upcoming year. The form is based upon 5 primary tables/objects (Employees, Trade Associations, Membership, Conferences). Employees: Trade Associations:1 to many with Employees...

I'll give that a try. Thanks!

OK, but won't the GROUP BY still try to count all of the activities? It is >1million records.

I have a SQL 2005 DB with 57,000 accounts and a huge quantity of activities (emails, letters, phone call, etc.) related to the Accounts. I want to find the accounts where there is at least 1 activity...not the number of activities. You can imagine the time it takes to pull this data! Tbl#1 -...

Can anyone provide a VBA version of this code?

I have a number of .TXT files that are output data. Each file is formatted as 1 long string of characters. I have sourced out some code to add CR's every 100 characters. I will need to modify the code for each file because the spec file for each is different (some are 513 characters long, others...

Sorry. I found my solution. Access 2007 has a message bar that seems to be off by default. This replaces the "trusted" settings from previous versions. Cheers!

I am using an update query comparing 2 tables to add new records from table 2 to table 1. This worked fine until we upgraded to Office 2007. Is this a function of 2007? I am not getting any prompts to OK, "You are about to update 1500 records" Thanks for any help. -Marcus

Cancel Request. I found a post that ansered my question. Thanks... http://www.access-programmers.co.uk/forums/showthread.php?t=113689&highlight=navigate

I am experience brain flatulence and need some remedial assistance. I am creating a data entry form. I have envisioned a tabbed format because I will have this idea utilized for Placement, Mentoring and Seminars data entry as well as recruitment. But I am open to other methods. Here is a...

Are you using MS Project Server? What version?