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
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
> 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
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.
Did you install the ESM in the new server?
Gustavo Del Grosso
Gerencia de Tecnología
gustavodelgrosso...Updating Chart fails
I have problems updating charts in Excel when using VisualBasic to
I calculate values with a self-written function "func". My sheet looks
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
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
SET DGBTestVariations.JURISDICTION =
IIF(DGBTestVariations.JURISDICTION = "NoMoneyMuni",
(SELECT DGBJurisdictionCOO.JurisCodes FROM DGBJurisdictionCOO WHERE
"Municipalities", (SELECT DGBJurisdictionCOO.JurisCodes FROM
DGBJurisdictionCOO WHERE DGBJuri...Outlook2003 not D/Ling updates to GAL
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
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?
Try deleting the folders "Microsoft CRM" and "SQL Server" in Program
Files. Then try to reinstall....CRM Exams 09-17-04
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.
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
> 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,
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
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
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?
Partners that belong to Microsoft's Certified Professional
Program may take the certification exams. Join CPP and
take exams thorugh PartnerSource
The exams are available to be taken on-line.
>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:
> 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
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.
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.
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.
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
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
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
4. Smart Host - You can enter the IP insquare brackets or the machine name.
Software Development Consultant
Check out, ExchangeInbox.com the new MS Exchange Resource site at
"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?
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
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
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?
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?
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
Look at this thread:
checkbox on continuous form
from Design by Sue
Thursday 20 December 2007
"Robert" <cpq1bcle[REMOVE]@verizon.net> wrote in message
> Is there any way to check just the one you checked?