Reply:

Check Box Format
Is there a way to change the appearance of the check boxes. My form uses small font and the option box appearance shows up much better since it is blackened in (as opposed to the small check which barely shows up). Any help is greatly appreciated. The best way I can see to make the box show up colored when printing, if you right click on the check box and open the Format Control box. Click the Control tab (last one) and click on the Mixed radio button. that will make the check box shaded until the user checks the box so if you are printing the box will be dark. If you are creating the for...

Manual check taxes
I ran payroll on Wednesday this week and may have to cut an additional check for someone that did not get paid a bonus. If I run a manual check to them, how does that affect the taxes for the IRS which I have already paid? Can I roll that amount into the next payment on the next payroll run? Thanks You could probably cut the check via Bank Rec and adjust in the next payroll cycle. -- MG.- Mariano Gomez, MIS, MCP, PMP Maximum Global Business, LLC http://www.maximumglobalbusiness.com "danrose03" wrote: > I ran payroll on Wednesday this week and may have to cut an additio...

Multiple users checking same email account
I have a workstation that checks emails for my small business. Soon I will want more then just one profile (windows xp Porfesional account) to check the emails. I am thinking that this will cause a problem, if profile A checks emails, will profile B see the emails that came down when profile A checked them. I am thinking of creating an offline folder that will store all incomming emails. What do the tech gods think? So I just set the other accounts to leave a copy on the server. I think this will work, I have one account, my main account that does not leave a copy on the server. ...

Mailbox not created when adding new user
Hi all and Merry Xmas I have just successfully added a 2K3 Server alonside my existing 2K (Exchnage) Server in my 2K domain. All went well, adprep, forestperp, etc. FSMO transferred to new 2k3 server OK. However if I now create a user in A.D. on the 2K3 FSMO a mailbox is not automatically created. If I create the user on the old 2K (exchange) server the mailbox is created automatically. Is this a FEATURE and not necessarily a FAULT. TIA Gary D Did you install the ESM in the new server? -- Gustavo Del Grosso Laboratorios Andrómaco Gerencia de Tecnología gustavodelgrosso...

Updating Chart fails
Hello everybody, I have problems updating charts in Excel when using VisualBasic to calculate values. I calculate values with a self-written function "func". My sheet looks like this: x y 1 =func(a2) 2 =func(a3) 3 =func(a4) This function "func" depends on some variables that I set in a sheet. If I change on of this variables, I have to do a "Application.CalculateFullRebuild" to get "y"-values updated. All fine. But now I have a chart that plots this x-y data. This graph is not updated by "Application.CalculateFullRebuild". It only updates ...

'Operation must use an updateable query'
I have an issue with a query that I cannot figure out the answer to. I keep getting the error 'Operation must use an updateable query'. The query I am running is: UPDATE DGBTestVariations SET DGBTestVariations.JURISDICTION = IIF(DGBTestVariations.JURISDICTION = "NoMoneyMuni", (SELECT DGBJurisdictionCOO.JurisCodes FROM DGBJurisdictionCOO WHERE DGBJurisdictionCOO.ID=3), IIF(DGBTestVariations.JURISDICTION = "Municipalities", (SELECT DGBJurisdictionCOO.JurisCodes FROM DGBJurisdictionCOO WHERE DGBJuri...

Outlook2003 not D/Ling updates to GAL
Hello, I have a SBS2003 server and Outlook 2003 clients in 'cached mode' aren't download updates to the address book. But if I go to an Outlook 2000 client, they see the new user's mailbox no problem. This was a problem when the server was initially setup but I was able to do a manual download and it would then download the updated version of the GAL, then I got sidetracked and forgot about the problem...until now when I created a new mailbox. And now, even if I do a manual download of the address book, it still doesn't get the update. There's no errors in t...

can't uninstall and make a new installation on laptop client
Hi, I installed a laptop client and tried to uninstall it. In the uninstalling process the the setup started again and detects that an 'incompatible version' of Microsoft CRM Client is already installed. I tried to delete the correct registry keys but that only effects that there is no 'Microsoft CRM-Client' in the Software to uninstall anymore. Can anyone give me the right registry keys to delete, so that I can make a new installation? Thanks J�rg Try deleting the folders "Microsoft CRM" and "SQL Server" in Program Files. Then try to reinstall....

CRM Exams 09-17-04
Hi everyone, I am new to this news group but I was reading the comments on the exams and was just looking for an "atta girl" ! I passed my application exam back in mid May and my customization in mid June. That was when they were 80% and really hard. Thanks for listening! ...

Replication of Public folders not showing up on new server.
Hello, We are trying to replicate and/or copy public folders and the offline address book from one server 2003 Exchange Server (which was upgaded from 5.5) to another new 2003 Exchange Server. Both servers are Standard Edition. When we go through the steps from that article the public folders and the oab do not show up on the new server. First thing is when we go to administrative groups it looks like the original server was upgraded from 5.5 because its in mixed mode and we cannot change it to native mode, its all greyed out. All we want to do is move or copy the public folders to ...

IE8 -can IE8 open new tab when click on hyperlink
Is there a way to force IE8 to open a new tab when I click on a hyperlink. If you do that in the present state, IE8 opens the new page on the same page you are reading. Then you have to click on the go-back button. In order to get a new tab I click control-hyperlink. I want to skip the control step. Thank you. Roxy Roxy wrote: > Is there a way to force IE8 to open a new tab when I click on a hyperlink. If > you do that in the present state, IE8 opens the new page on the same page you > are reading. Then you have to click on the go-back button. > > In o...

set up a worksheet in excel like a check register with auto sum
I would like to set up a worksheet in Excel for my check registor that will automatically give me the balance. jthhousing, have a look here and see if this will do what you want, http://office.microsoft.com/en-us/templates/TC010186511033.aspx If not I have one set up, if you would like to have a look at it let me know and I will send you a copy -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "jthhousing" <jthhousing@d...

Certification exams 08-28-03
Hi there, Does anyone know if there are microsoft certified exams available for MS CRM yet? I know there are courses available through certified ctec's but are there any exams available to write? If not does anyone know when these might be available? TIA Partners that belong to Microsoft's Certified Professional Program may take the certification exams. Join CPP and take exams thorugh PartnerSource (https://www.greatplains.com/_mem_bin/FormsLogin.asp? SSL=0&/partnersource/Default.asp) The exams are available to be taken on-line. >-----Original Message----- >Hi the...

updating pivot table #2
I have pivot tables that I update weekly with new data. Unfortunately, the prior week's options are included in the updated drop down lists. The old data is not included in the calculations so it doesn't affect the report in that regard but although I only have 18 weeks of data in the source worksheet, the drop-down lists show the 32 weeks I have been running the report as options. It is confusing to users of the report. There's information here on clearing old items in a pivot table: http://www.contextures.com/xlPivot04.html Gibran wrote: > I have pivot table...

vlookup update when inserting columns in named tables
Good evening all, I have an annoying problem which incurrs lots of additional work, whick I would dearly like a work around for. I have many vlookup formulae which references a named tables,eg: A B C D E 1 M1030 200 300 400 500 I have named this list, 'table1', from which I have I have a vlookup function in another worksheet eg =vlookup($A10,table1,3,0), where $A10 in the other worksheet is 'M1030', which will return the value '300' This works fine, but if I insert a column in table1, eg between col...

Mappings not working when creating a new entity
Hi, Not sure if this has been discussed yet but I noticed that depending on how I create my new record the mappings work or do not work. Scenerio #1: I am in an entity "hotel setup", I click on an associated entity Selected Hotel. Click new and the hotel name mappings come over. This one works as expected. Scenerio #2: I am in another entity, click on the associated entity Selected Hotel, click new and add the lookup to the hotel setup. Click save and no mappings come over. Is there a way to do this? Thanks in advance. Brian Hi Brian, Yes, it is the expected behaviour. Map...

help with update to Office 2007
Updating computers running Windows XP from Office 2003 to Office 2007. Office 2003 is removed with the install. When the user logs on and tries to open an Office document Office 2003 reinstalls. When Admin logs on Office 2003 is not in the Add Remove Programs. When the user logs on Office 2003 is in the Add Remove Programs, but cannot be removed because they do not have admin privileges. How can I prevent Office 2003 from reinstalling!! ? We do use Roaming Profiles over here. ...

Transferring SMTP server to the new exchange
if I introduce new exchange server into the network how do i transfer SMTP server to the new exchange so that outgoing emails use it instead of the old exchange server? thank you On your current servers setup smart host to the new server. Do this from: 1. Exchange System Manager virtual server settings. 2. Delivery property sheet 3. Advanced 4. Smart Host - You can enter the IP insquare brackets or the machine name. cheers, Alexander Zammit Software Development Consultant Check out, ExchangeInbox.com the new MS Exchange Resource site at http://www.exchangeinbox.com/ "asdf" &...

Updating an unbound table
I have a form that contains controls that are bound to an underlying table. I want to update a summary table when the update of a displayed record is complete. How can I tell when the update is complete, and can I tell what the contents of the updated record are? Am I making this harder that it really is? Thanks... If you are taking about the time it takes to write the record to the table and get it in memory, it should be immediate. There are occasionally what are called "slow writes" in Access if you are writing tons of data. But you should be able to see that ...

HR Accruals not accruing for new employees (GP10)
I've been having a problem with new employees. We accrue through Human Resources, and after the employee is added, we make sure their PTO code is filled in with a last accural date and a hire date. We then put in our payroll batch, reconcile HR to payroll, and accrue the PTO (after the batch has been built and the checks have been calculated). The first time we do this for a new employee, it never accrues. I've tried adding PTO hours when we make sure the code is filled in, but it doesn't accrue until the next pay period. Is this a bug? Why won't the hours accrue th...

Outlook 2007 - New Mail
Hi there, I'm using outlook 2007, and for some reason, when I go into Tools > Options > E-Mail Options > Advanced E-Mail Options and tick the "Play a sound" and "Show an envelope icon in the notification area" and click OK twice to get back to the Options window, the "Apply" button is greyed out. The sound and envelope indicators work for the duration of the Outlook session, but when I restart Outlook, the settings haven't been saved. Any suggestions on how to remedy this would be appreciated. Thanks in advance Try a new mail...

update ... grouping ... replace ????
Pymt No. txr ref dr cr 34567-1 25 20628941 130.00 24685-1 32 20628941 100.00 34567-1 30 20628941 20.00 24685-1 29 20628941 10.00 34567-1 24 20628942 100.00 24685-1 32 20628942 100.00 I have inherited a database structured as above, a transaction may have as many as 4 entries (records) however the ref will be the same, I need to count the number of transactions where the txr is 25 (simple enough) and sum the corresponding cr for these transactions (where the txr = 32). Here I having some difficulty becaus...

Notification of new messages with IMAP
I recently switched from POP to IMAP. I have rules set up elsewhere, so new messages may appear in any one of a number of folders other than Inbox. However, Outlook does not reliably show me when there are new messages in these other folders unless I actually click on the folder. This is very tedious as I have about 20 folders to click on. Is there a solution for this? Thanks, - Andrew. Thank you very much! I went into Tools -> Send/Receive Settings -> Define Send/Receive Groups and clicked the checkbox to send/receive all the folders that email comes into. Hopefully that will w...

Problem using "Update retirement account" in Money 2005
I'm having trouble updating my 401k account using "Update retirement account" for my end of 2004 statement. There is one specific investement that produces the following error: "... will cause the balance of 'xx' held in this investment account to become negative at some point. Please cancel or revise the transaction." If I try to do the "Dividend" and the "Buy" transactions manually then I get the following error when I try to do the "Dividend" transaction: "You have not purchased 'xx' in this Investment Account...

Unbound checkbox on datasheet subform
Is there any way to check just the one you checked? Robert Hi Robert, this issue was discussed at length recently on this newsgroup. The short answer is No. The long answer is that you can make the checkbox bound, but it is not very easy. Look at this thread: checkbox on continuous form from Design by Sue Thursday 20 December 2007 Jeanette Cunningham "Robert" <cpq1bcle[REMOVE]@verizon.net> wrote in message news:4778181a$0$19883$bbae4d71@news.suddenlink.net... > Is there any way to check just the one you checked? > > Robert > > "Robert" &...