New record only if the last record is filled
What I need, is a code, that just alows to add a new record only if the last
record is filled.
Is it possible?
Thanks in advance
Define "last record".
Are you doing this in a form?
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor
"Luis Marques" <LuisMarques@discussions.microsoft.com> wrote in message
> What I need, is a code, that just alows...Unique Values, not Unique Records
My data looks like the following:
ID Type Amt
1234 A $10.00
1234 B $10.00
1234 C $10.00
I would like to find a way to get only one of the items on to a new
spreadsheet, because they are duplicate records in my eyes. The Advanced
filter does not work because each record is unique. Can anyone help?
in the dialog for the advanced filter, make sure only the ID column is
> My data looks like the following:
> ID Type Amt
> 1234 ...multiple business cards on same page with logo and information ch. #2
looking for info on how to make myself some price cards, they are the same
size as a business card with logos and information change. How can I have my
publisher show me a full page of same business cards(multiple) that I just
edit and change price and iten information? Thanks I have spent way to many
hours trying to figure this one out.
Mail merge the data but the print preview will NOT show you 30 different
cards. It will only show one. (Hint: Make sure you print on plain paper
before printing on card stock.)
MVP Microsoft [Publisher]
"fayzer" <fayzer...importing activity records and linking to account, contact, and op
Anyone can help me on importing phone call, appointment and task records and
link to account, contact and opprotunity records. While I was successful in
importing account, contact and opportunity records into CRM4 with proper
links. I am having difficulty with acitivity records and link to appropriate
account, contact and opportunity records. I've got all the phone call,
appointment and tasks records into CRM but only partial records are linking
to account, contact, and opportunity records via update of regardingobjectid.
How does activitypointer table factor into this? Apprec...Mail Messages HTML Viewing
I am using win XP and Office 2002. When I receive
messages with html format i can only see the url's and
not the pictures. I have checked all the settings, I
have the box in options/mail format/internet
settings/html format checked to receive pictures and
still just the url. I runn norton and zone alarm but
can't see any settings in these that would restrict the
downloading of pictures. Any thoughts?
What are your IE settings?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to the
Swen virus, all e-mails sent to my actual...cant install ms money 2004 small business
i am already logged in as admin. i can't install money
2004 sb. i already have ms money 2004 standard. can't
uninstall that either!
When i try to uninstall it gives me an error:
"this installation is forbidden by system policy, contact
When i try to install ms money 2004 sb:
"the system administrator has set policies to prevent
please tell me what to do.
Well, I can't tell you exactly what to do - you might need to ask in a
windows group, but there could be a couple of things.
Check that you don't have any ...Having users modify theier GAL record
I would like to provide a web based solution for allowing my users to modify
thier GAL infomration. Any suggestions? I heard that there is a web based
version of GALMOD. Is this true? Does it allow the user to modify all the
fileds that GALMODCA allows? Another question about GALMOD. I saw a message
somewhere stating that you should not use it if you are running Outlook2k3 in
chached mode. Why Not? Just curiouse on this one. So back to my original Q.
Is there a decent, non-complicated, web based product that will let my users
changed thier info?
...the webpage you are viewing is trying to close the window
We have an internal web interface for our helpdesk system. When we finish
working with a "call" it attempts to unlock the call and we get the message
as above. More often than not, we need to say YES to the message. Any ideas
how to get it to not appear?
Which security zone does the page/popup load into?
Hint: Is IE configured to automatically detect sites in the Intranet zone?
What 'call' software are you using? Have you attempted to contact the
"Keithmeister" <Keithmeister@discussions.microsoft.co...Restoring Organizational Unit
Is there a way to recreate the Organizational Unit? It
was accidentally deleted. I was upgrading from SBS 2000
to SBS 2003 when it occurred. I had to rebuild my SQL
Server 2000 and do have the db backups for the four CRM
Once I've restored them, I know need to rebuild the
Organizaiton Unit that was deleted. Hence, this is my
Any ideas would be appreciated.
unfortunatly there are no supported way of doing this.
My first idea was to use the Redeployment manager but you
need to know the GUIDs of the items in the old AD to make
Ben...Using custom document peroperties to creat views in Public Folders
How do I use custom document properties to create views in public folders? I
came across an article for Outlook 2000. I tried doing this for Outlook 2007
but I am unable to. Please assist.
The article I came across was
http://office.microsoft.com/en-us/publisher/HA010549541033.aspx However this
only appears to work for 2000 not 2007. Hopefully someone can help.
> How do I use custom document properties to create views in public folders? I
> came across an article for Outlook 2000. I tried doing this for Outlook 2007
> but I am unable t...m_pDocument Doc/View unique id for each view
I'm using the standard mfc mainform with a doc/view. While I'm in the
view portion I need to track the actions taken individually and
separately for each view. So when when I click on view one I track
that in a separate place than view two.
I there a unique id or index for each view? Something like
<firstname.lastname@example.org> wrote in message
> I'm using the standard mfc mainform with a doc/view. While I'm in the
> view portion I need to track the actions taken...View Webpage
How can i view a HTML page in Excel, it should also be automatically update
in 60 seconds. Is this possible?
Please note that, that page contains images
That webpage is on our intranet website.
Though I am not certain this is exactly what you are looking for, try the
Data, Import External Data, then New Web Query...
In the dialog box that appears, browse the site. You will notice that at
certain areas of the page you will see an arrow. Just click the ones that
you want to import. Click import. Select the cell you want to import the
data into and click OK.
Hope...Forms in two differant views
Is there a way to use the same sub form showing two differant views within
the same Main Form. For example: Can I show on one tab a datasheet view and
on the other a regular form view.
Create a button on your form and under the "OnClick" event put
'Me.DefaultView = Datasheet
Alternatively you could use a checkbox
If me.checkbox1 = 0 then
Me.DefaultView = 2 ' Datasheet
Me.DefaultView = 0 'Single Form
This should flick the form between datasheet and form views.
> Is there a way to use t...Business Portal - Adding New User
When I click Add New User in Business Portal; I get the following exception
[NullReferenceException: Object reference not set to an instance of an
I have tried Repair and Uinstall/Reinstall, but error is same...Please...Forcing a view to be the active view
I have an SDI application that has a splitter window with two views. The
first view is an CFormView and the second is a CView. I want the CFormView
to always be the Active view. Even if the user selects the CView.
How do I accomplish this?
Anders Eriksson wrote:
> I have an SDI application that has a splitter window with two views. The
> first view is an CFormView and the second is a CView. I want the CFormView
> to always be the Active view. Even if the user selects the CView.
> How do I accomplish this?
> // Anders
I'd ...Coustom view
I have been given a new work station and for some reason my custom view is
not highlighted and is not working.
I don't think it is as add-in feature. Excel heip has not been of any (help).
Does someone know how to enable this feature?
Custom Views will be disabled if you have more than one sheet selected.
Do you see [group] behind the filename on title bar?
If so, right-click on a tab and "ungroup sheets".
Gord Dibben MS Excel MVP
On Wed, 11 Jan 2006 06:28:03 -0800, "Michael"
>...creating a new business card
Hello, I used Publisher 2003 for the first time today. I created a business
card and all went well until I wanted to create another card. Each time the
same information appeared. I exited, didn't save and to no avail... the same
information inserted in every card. How can I get the original template box
to appear so I can enter new information...thanks.
If you are using a template the information is Personal Information. You can
delete the text boxes the information is appearing in or go to Edit, Personal
Information and change the information.
I'm not sure...Changing View -- All Folders
Using Outlook 2007, Windows XP Pro. I have dozens of mail folders in
Outllook. I would like to change the view (to the right of the folder
tree) on all folders. There seems to be no apparent way to do this.
Any ideas? Thanks,
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EAS...OL98 start up view
I recently had to reinstall my WInXP and now my OL98 has a couple of
issues I'd like to fix.
I've set up my mail account (with POP3 and SMTP servers) but when I
try to use it I get a message saying that internet mail is not
registered properly. What do I need to do to fix this?
Also, I used to start up OL98 so that the first view was not Outlook
Today. How do I change that?
I guess I can't remember how to do things that I only do once every
Thanks for any suggestions!
You might want to have a look at this MS KB ...How do I calculate a cost/benefit ratio for a business proposal?
Calculate the project cost and the benefit. Then, divide the first by
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <B84AAA43-02B1-41E3-AA8B-F145C1875895@microsoft.com>,
Outlook 2000. This seems like a dumb question but in the monthly calendar
view how do I get it to show a regular standard Sun-Sat week with equal
weight for each day (Sat & Sun the same size boxes as the rest of the
right click on the calendar and choose Other settings. Uncheck the option to
compress weekend days.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.ne...Modifying Activities associated view 10-01-04
I have tried the unsuported fix involving:
The view opens fine but I am unable to save as is or make
changes... I get the message "the Item Id is invalid."
Make sure you include the braces around the view ID GUID.
"Sean T." <email@example.com> wrote in message
> I have tried the unsuported fix inv...Custom Fields in Views.. 04-22-10
We are working with a MOPS 2007 and WSS 3.0 SP2 (no c.u.'s) environment, and have created several enterprise custom fields at the task level. We can use and see them just fine in the schedules in Project Professional 2007, but when we try to add them to the 'my assignments' and 'assignment details' views, the custom data does not show up....any thoughts?
Thanks! and have a great spring!
Submitted via EggHeadCafe - Software Developer Portal of Choice
Get Silverlight 4 Installed: Tips and Tricks
http://www.eggheadcafe.com/tutorials/aspnet/05910e...Problem Importing data from excel to Outlook 2007 with Business Contact
I have been trying to import contacts from an excel spreadsheet to Business
Manager Outlook 2007
and my attemps have been unsuccessful. I really would appreciate any help or
tips on how to manage this operation. thanking you in advance.
I got the following response in the Excel Newsgroup: so I thought I would
the Outlook newsgroup.
With your Contacts info in columns in Excel..................
> Save the workbook after giving your list a defined
> name through Insert>Name>Define.
> Outlook likes that.
...removing duplicate records in excel, how to do it?
How to remove duplicart entries within excel?
Data>advanced filter, unique records only
> How to remove duplicart entries within excel?
> How to remove duplicart entries within excel?
Have you notice that the first entry is duplicated in both cases: when header
line is included or exclude
"Peo Sjoblom" wrote:
> Data>advanced filter, unique records only
> Peo S...