Reply:

After update 10-31-07
I'm using an After Update event on a form to update one field with the current date when a checkbox is checked, but the date doesn't display until I scroll down the form. Is there some way to get the date to display right after the box is checked (or at least once the next record is selected)? Thanks, Tom -- Thanks, Tom Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200710/1 Sounds like you have a control that has a Name that is different from the name of the date field. In the AfterUpdate code, use the name of the control,...

"New" button activates send/receive
When I click the Send/Receive button, nothing happens. However, when I click the "New Message" button, in comes all my new messages. Also, the auto Send/Receive under Options (every 1 minute) is not working at all. Any thoughts on how to fix this? Much Appreciated, Dave ...

When is Microsoft coming out with updated version of Publisher?
I've been using Pubisher since 1997 and it's great...but now it's almost FOUR years old with no no version! More graphics, more WordArt options, that would be nice. When are we going to see a Publisher 2006-7?????? There is a new version of Office being beta tested now with an approximate release date of Spring 2007. (No clue about the amount of clipart or WordArt. Sorry) -- JoAnn Paules MVP Microsoft [Publisher] "Nancy O'Brien" <Nancy O'Brien@discussions.microsoft.com> wrote in message news:005128ED-EF3D-4ADA-B02D-B5EB6790BFC0@microsoft.com.....

Creating Dialog Pointer with new, causes Exception
Hello all, I've written an MFC app, which has a tabbed interface. When it starts up, it checks my registry key, to determine how many tabs it needs, it then creates each tab, and puts a custom non modal, child dialog on each tab. The problem is, in release mode, it can only create the first dialog, the second one causes a memory exception. It *looks* like MFC doesnt like me trying to initialize a pointer like so, when that pointer is NULL. m_pDialogs[i] = new CMyDialog; Thing is, isn't that the whole point of the new operator? And malloc for that matter? The only difference, th...

2 updates won't install
Server 2003 SP2 updates KB973354 and 958469 both get error 0x800F0102. What can I look for ? Dave Mc wrote: > Server 2003 SP2 updates KB973354 and 958469 both get error > 0x800F0102. What can I look for ? Gone through this yet? http://support.microsoft.com/kb/906602 -- Shenan Stanley MS-MVP -- How To Ask Questions The Smart Way http://www.catb.org/~esr/faqs/smart-questions.html ...

Seeking new Bank Recommendation
I am currently a BankOne customer, but am dropping them due to the new ATM service fee. BankOne now charges $1.50 per non-BankOne ATM transaction - this is in addition to what the local bank that runs the ATM charges. I travel A LOT and am always needing cash from a non-BankOne ATM. Unfortunately, BankOne is also the dominant bank in my area - ATMs in Walgreens, Dominicks, lots of branches. I am going to stand on principle and cancel my accounts w/ BankOne however. I was a Preferred Checking customer w/ BankOne for 10 years (no fees for anythign if you kept a $2500 minimum balance - maybe it ...

Permissions after 12.1.2 update
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Question. Not sure, but I after running the 12.1.2 office 2008 updater, I noticed this when repairing permissions using disk utility Permissions differ on "Library", should be drwxrwxr-t , they are drwxrwxr-x . Now, I also noticed other disk utility repair permissions that take place after the weekly overnight sripts run. I am just trying to figure out if running the office 2008 updater 12.1.2 could generate the permissions fix reported above. I installed this on 2 exactly the same computers, and didn't g...

HowTo disable cell reference update
I want to disable cell reference updates when I am inserting a row. My chart has series data in A2..A7. After row insert with MoveDown at row 2 the references are updated to A3..A8 How do I preserve the original cell refernce? ...

How to determine whether update rollup is installed
Hi, I've just installed the update rollup on test machines both for client and server. However there's no obvious change - even the build version numbers shown on the web interface remain the same. Is this to be expected? How can I tell that the update is installed successfully? Thanks! Tom Not sure why they didn't update the version number. On the server, go to add/remove programs and check the 'show updates' checkbox at the top. then, under the Microsoft CRM Server, you should see 'Update Rollup 1...' Dave Ireland "Tom" <thisisme_ithink@yahoo...

New Folder
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel How do I open a new folder to organize my documents? The document list in Word2008 for Mac is not like Word I've used before. Your description is very minimal at best, so I assume you are talking about the Save dialogue, and the fact that you cannot see all the folders in this dialogue, but merely a dropdown list with the most recently used folders. Click on the blue square next to the field in which you enter the document name, with the tiny triangle that is pointing down, and the dialogue will ...

New to formulas
I need help with formulas, or a math function. Bacically what I need to do is have Cell A2 subtract Cell A1 and be outputted to Cell B2. I have no idea how to start this. Thank You "Money 2006" <Money2006@discussions.microsoft.com> wrote in message news:030C062F-6374-4690-9829-3B0F25174C8C@microsoft.com... >I need help with formulas, or a math function. > > Bacically what I need to do is have Cell A2 subtract Cell A1 and be > outputted to Cell B2. > > I have no idea how to start this. > > Thank You > In cell B2 type "=A2-A1" (without...

Subforms won't refresh after new record 11-17-09
Access 2003, XP Pro I have a main form with two separate subforms. I view various records by clicking on some list boxes. To add a new record, I select Records, Data Entry. I then (1) Make a selection in a combo on the main form. (2) Make a selection in a combo and enter some text in a textbox on subform1 (3) Make a selection in a combo on subform2 Subform2 has some code on the After Update event that saves the new record and goes to a previously selected record in cbo1 on the main form (cbo2 has code on the After Update event to go to that record). Here's the cod...

Updating links
Hi, In one of our office spreadsheets, everytime it is opened it asks do you want to update cells from another spreadsheet. I believe when this spreadsheet was set up, a work sheet was copied from another spreadsheet. I thought that all the references to that other spreadsheet had been removed. Is there anyway to identify (other than manually checking each cell) which cell has a formula linked to the old spreadsheet. Thanks in advance, George Download and install Bill Manville's FindLink add-in, which you can find at: http://www.bmsltd.ie/MVP/ In article <bYd1d.27315$Z14.90...

Check for Values
Hi I have 2 tables, requirements and stock on hand. In the requirement table, I have a part number, qty and due date and a related record in the stock on hand table using part number showing current stock. My question is can I use a query (and how!) to tell me a) I have enough stock to fulfil the requirements and b) If not at what date will I not be able to fulfil the requirements and by how many? Have been working on this for a while, and cant work it out Regards Alec Alec You are there, we are not ... the following may not fit your situation ... If you have a [Par...

Update a radio button by combobox selection
Hi, In a VS2008 VB project, I have a combobox that gets its value from a table with three columns. I want to display one column in the combobox, write the value of the second column back to a different table, and I want to change the value of a radio button (on the same form as the combobox) based on the value of the third column of the selected record. I'm setting the ComboBox.Text value to be the first column, the ComboBox.SelectedValue to be the second column, but how would I change the radio buttons in the most efficient way? Thanks in advance, Steve Wrong g...

Update cell based on date range
Hey guys! I was wondering if I could get some help here. I would lik to update a cell based on a date range. For example, I would like t update the value of a cell to the value of another cell if the curren date is between July 1st and July 10th. However, if the date i outside the date range, I want the value for that cell to not b updated, and be the previous value. Can anyone give me an example a to how I would do this? Thanks!! -- deversol ----------------------------------------------------------------------- deversole's Profile: http://www.excelforum.com/member.php?action=geti...

Check if data has already been formatted.
Hello, I have a sub() as part of a larger set of macros. This particular sub() will take the raw data pulled from an in-house reporting system and format it to suit our needs (adding a couple of columns with formulas to facilitate pivot table creation). This is the code as I have it so far: Sub FormatData() Application.ScreenUpdating = False ActiveWindow.DisplayGridlines = False ' Declarations Dim DataWks As Worksheet Dim LastRow As Long Dim LastCol As Long ' Set the DataWks variable Set DataWks = Worksheets("Data") ...

How to add new entity?
Hi. I'm now researching the customization abilities of MS CRM 1.2. So I have a small task, which I'm not able to accomplish with SDK. The main question is how to add additional entity to CRM? I need to add entity "Pets", and dictionary "PetTypes". Pets should be linked with Contacts (1:M). Pets should have 3 attributes: - Name (string of 150 chars), - Type (value from PetTypes dictionary), - Description (string of 1000 chars) PetTypes should have 3 entries: "Cat", "Dog" and "Parrot" I expect that i...

A first look at the new Office Snapin for MSCRM
http://blogs.msdn.com/jstraumann -- John [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights. Use of any included script or code samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm. ...

Vendor transactions and checks
I'm trying to create a vendor payment report from my program. From which tables I can get the vendor payable transaction information??? I also need to know whether there is a check aleady issue to a transaction. Thank you. ...

Keeping a table in a form editable and checking that fields are filled in before allowing a save
Firstly apologies if this is the incorrect forum but I was looking for a general word forum and could not find one. Please point me to one if one exists. I am trying to create a form where I want to specify what items need to be filled in. (Review minutes from design reviews). I want to make certain fields mandatory like the date, attendees and check list used and want to block saving of the document with a warning until they are filled in. Is there a way of doing this? Also as a part of the review actions are filled in to a table. depending on how many actions there are the table...

Setting Outlook settings to new server
We are in the process of moving mailboxes to a new server. Is there a utility or ad policy to automatically configure outlook to point to the new exchange server? Instead of manually configuring the users outlook profile. On Tue, 21 Nov 2006 11:15:01 -0800, Rich <Rich@discussions.microsoft.com> wrote: >We are in the process of moving mailboxes to a new server. Is there a utility >or ad policy to automatically configure outlook to point to the new exchange >server? Instead of manually configuring the users outlook profile. If you are moving the mailboxes in the same org vi...

Email accounts are not created for new user
I had a severe system crash several days ago because of bad memory in my domain controller (Server 2003 R2)/Exchange server 2003 (small site - no extra systems). I had to reinstall Exchange 2003 and reload the exchange store from backup. For existing users everything works great. Everybody can send and receive email, the calender works correctly, etc. OWA works. However, when I create a new user account in Active Directory Computers and Users, the account is created and the new user can log onto a system. However, Outlook 2003 cannot be configured to use the exchange server. In t...

Error creating new task
Error .. "Could not complete operation. One or more parameter values are not vaild" ...

New message opens up behind outlook window
Everytime I click new in my inbox to open a new message, the new message pops up behind the main oulook window. does anyone know how to make this stop? ...