Search results

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?

Worked beautifully, as expected. Much obliged. -cheers

I thought I saw this problem solved before, but couldn't find it in by searching. I have all the megamillion lottery winning numbers. I have them broken up into their positions (1st, 2nd, 3rd, 4th, 5th, MoneyBall). I want to take the flat record and turn it into a relational so I can do some...

I have one update to add. I have found the path to my Address Book folder. I have modified my test code as follows but still open a personal contact form. Private Sub PubFolderContact() Dim olfolder As Outlook.mapiFolder Dim olapp As Outlook.Application Dim MyItem As Object Set...

I am using Access 2003, Outlook 2003, Exchange 2003 I am developing an Access CRM. The DB uses a linked connection to the Exchange server to populate the contacts table. The contact folder used is Address Book in Public Folders. To create new contacts, it seems easiest to simply open a new...

Thanks for the idea. I checked both out, but that's not quite what I'm after. What I desire is a sample DB that tracks leave for each of those categories (sick, vac, etc.). As each pay period passes, our employees earn increments of time toward each of those categories. I need to have an...