Opening a database 02-14-08
I have a database that in order to see the contents of the database I need to
hold down the sift key to open it. Otherwise it will not let me view anything
except the switchboard form. I need to change this but I did not design this
database. Is there a way to remove this so that anyone can open the database
and view all its contents without holding down the shift key?
I am using Access 2003. Thanks in advance for any help.
Go to Tools | Startup and ensure that the Display Database Window box is
checked. You can also have it not display the switchboard (should you wa...SUMPRODUCT 05-06-10
I've used this formular to find work piece that gets done per department.
Department 14532 was not picked up even though other department's number was
correctly counted. But if I put a letter, say like C (14532C) and adds C to
my formular as in
=SUMPRODUCT(('Q2'!E13:E150="Done")*('Q2'!G13:G150="14532C")) then it picks
up how many pieces were done for this department.
I suspect this is in my cell format but I could not figure out wh...Query Problem 03-27-10
I have 2 tables, tbBaby and tbVaccineInjection. tbBaby stores the babies'
personal data like Name, BirthDate etc., tbVaccine stores VaccineName,
DoseNumber (1st, 2nd, 3rd, etc.) and InjectionDate, etc. These 2 tables are
one to many in relation, because each baby may have several vaccinations on
I'd like to build a query to retrieve babies with their most recent
injection date, i.e. only one record for each baby with latest injection date.
my query is as follow
SELECT tbBaby.*, tbVaccine.*
FROM tbBaby INNER JOIN tbVaccine ON tbBaby.ID=tbVaccine.B...test103 06-29-07
test This is the body of the article
...App only starts in CMD-Box, not in Explorer
I have a problem on a Windows Server 2003 R2. If I want to start a program
in Windows Explorer by double-clicking, I get the error message:
"Windows cannot access the specified device, path, or file. You may not have
the appropriate permissions to access the item."
The message I get with a user which is member of the Domain Admins and
Administrators. The permissions are also OK, everything is set to Allow, I
have also checked with the effective permissions.
If I start the application from a CMD box, it works.
Has anyone an explanation for this strange behave...Finding, Comparing folder names then opening explorer
i tried posting this earlier, but something seems to be wrong with either my
browser or the site, so...
i have a project where i have a field that stores the serial number of a
product. i need to take the field, trim it to 5 characters and then use it to
search a folder and all the subfolders, trimming thier names to the first 5
characters, and then capture the full name of the folder, and use that to
open windows explorer at the found folder.
so if i have a field with the value "08003" and i want to find that
sub-sub-subfolder in the folder "c:\WO\" and then...outlook calendar #10
How can I set up the calendar so that each of my appointments are
automatically given 15 minutes or 10 minutes ?
set the time scale to 10 or 15 min. right click on the time scale in day
view or change it in tools, options, calendar.
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.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Join OneNote Tips mailing list: http://www....Cumulative Security Update for Internet Explorer 8 for Windows XP
Last night I was going about my regular buisness of (after work) getting on
and vegging in fron of my laptop while I watch TV. An update came around
(mind you everything was working fine yesterday) which was: Cumulative
Security Update for Internet Explorer 8 for Windows XP (KB980182). Now for
some reason I can't access yahoo.com or lotro.com? These two sites are the
only ones that I can't seem to access for some reason? I have tried to
search for malicious spyware and viruses nothing comes across (McAfee, and
Malewarebytes) I have tried to System restore to a date I ...CRM VPC Internet Connection
How can you make Internet Connection in VPC to work, for example, you type
www.google.com in IE? because I did that and it could not open.
You need to check the Virtual PC or Sever options and change the network
connection to External.
If I recall correctly the VPC image is set to the static IP of 192.168.1.1
so you want to make sure this will not be duplicate IP on your network. You
may also need to change the default gateway to match your network. (I have
found that if you change the Static IP on the VPC you need to make changes in
DNS for http://crm to work)
"...Contacts Permissions Problem
I am running OL2003 on WinXP & 2k with Exchange 2k.
I have a large public folder of contacts. I can edit all of them. I
created a new user, gave her owner permissions on the folder, but she
cannot edit many of the contacts. When she opens them, they show as
Today I was researching this and I found something interesting - some
of the records show Outlook Version 10, and others show Outlook
Version 11. It turns out that the recs that are version 10 can be
edited by the new user, but those that are version 11 can only be
opened as read only. I tried to change the ve...DATEVALUE("10/30/2009") Fails with #VALUE! Error
Operating System: Mac OS X 10.6 (Snow Leopard)
I need to manipulate some date/time strings that I'm importing from an external source. The strings look like this: <br><br>10/30/2009 3:19:08 PM <br><br>I need to separate date & time, and use subtotals etc. on change of date & change of hour. <br><br>I thought the best thing would be to separately extract the date and time, then use DATEVALUE() on the date string so I can format it as yyyy-mm-dd and do calculations. <br><br>...Sendung mail from Explorer (shell menu)
I just migrated from OE to outlook2000. (due to use of my Ipaq )
Why is my mail stuck in the outbox if i sent some documents from the Shell
menu in Explorer ?
Can i avoid having to open the items in my outbox to get the actually sent ?
...Removing Senders from the Blocked List 07-12-10
For months I have been unable to remove blocked senders. I have tried from
Windows Live Mail and from the Windows Live Hotmail website. After a short
while they reappear.
If someone can tell me what I must do, or if this can be resolved remotely,
I will be most appreciative.
It is most frustrating and I have been unable to receive any assistance.
kur NFztoa"o un petit essai bisssses louisa
...external connector 10-17-06
I am just wondering what kind of license we would need if we are to create
an online system that will integrate with MS CRM 3.0. The online system will
have its own database. We would like to integrate our database with the CRM
db. Clients will access the system through the internet. Do we need the
external connector license for us to access the data on CRM? Like write data
from our db to CRM db and vice versa?
The external connector license is designed to enable external access to
MSCRM for an unspecified group (unlimited number) of non-CRM users. If these
external use...Vista 64 Critical Updates Without Internet Connection?
I bought a refurbished computer for a customer and we're having problems
detecting a Netgear WN111v2 USB wireless adapter. The first thing I think is
update Vista 64 Business but there's no Internet connection on the machine.
Is there a way to get all of the Vista 64 critical (and related) updates
downloaded to my local dev machine then burned to a disk I can then install
manually? I'm paging through the test.catalog.update.microsoft.com website
at the moment but haven't done this before so confirmation may help me out.
> I bought a refurbi...Recovery Console 03-04-10
I had Recovery Console installed, but as I ticked the box in
msconfig/boot.ini to the origianl boot, the line in c:\boot.ini disappeared.
As to uninstall the Recovery Console you need to delete that line and two
folders in the root directory, I decided to complete the task. However, I
am unable to get rid of cmdcons. Can anyone help?
Please, ignore. I found solution. Thank you
"JB" <firstname.lastname@example.org> escreveu na mensagem
>I had Recovery Console installed, but as I ticked the box in
...Sales Process Question 08-02-06
Is it possible to create a sales process based where stage progression is
based on a field value - for example a pick list rather than the status of an
activity? I want to create a pick list with sales stages and have a process
evaluate the picklist value before progressing to the next stage.
...GP 10 fails to store menu toolbar locations
GP version 10.00.1237 Standard
The menu/toolbar fails to keep the menu options and buttons in the location
I put them in and then lock the toolbars. Sometimes they work, but other
times if I work on other programs while GP is starting up after selecting my
company to work in when I return to GP the menu is all rearranged, but is
I searched and there was one question directly relating to this and another
that references locking the "toolbar", but neither really address the issue
or offer a solution.
Does anybody from Microsoft have a solution to this problem or...Internal server information broadcasted over Internet via SMTP
When I Telnet to my Exchange 2003 SP1 server from the Internet, it
responds with the below information. Does anyone know how to prevent
it from broadcasting it's internal information?
220 servername.domain.net Microsoft ESMTP MAIL Service, Version:
Here you go:
> When I Telnet to my Exchange 2003 SP1 server from the Internet, it
> responds with the below information. Does anyone know how to prevent
> it from broadcasting it's internal information?
>...6 bottles of wine gets you 10% off?
Has anyone figured out how to do this without an add-on? RMS Out of the box,
or is it impossible?
One way is using the discount section. But you have to figure out amount
for the 6th bottle and above.
"Vince" <Nagarra@yahoo.com.(donotspam)> wrote in message
> Has anyone figured out how to do this without an add-on? RMS Out of the
> or is it impossible?
> Thank You
> Vince :)
Can you elaborate any further? If in using the discount section won't tha...COUNTIF Function 04-19-10
I am trying to use the countif function by rows and it is not calculationg
correctly. I try to drag the formula down and it just repeats the same value
as the origin cell. Is there some type of malfunction with tis function?
It would help immensely if you had posted your formula for us to evaluate.
Without it, my best guess would be that your formula currently looks
when it should be:
"csmith13" <email@example.com> wrote in me...Use this correction pack for MS Internet Explorer
Content-Type: multipart/related; boundary="fclwclut";
Content-Type: multipart/alternative; boundary="isrqoatsqo"
this is the latest version of security update, the
"November 2003, Cumulative Patch" update which eliminates
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now to maintain the...Format 05-11-10
In table A I have Paid_Amount which is stored as currency. In table B I have
Membership which is stored as a number long integer. In the query I have
PMPM:([Paid_Amount]/[Membership]) The query runs fine, but the data is a
long number. I then changed it to say
PMPM:FormatCurrency([Paid_Amount]/[Membership]) and I end up with $0.00 for
all my answers. What can I do?
well technically, Paid_Amount is being stored as Double or Decimal,
but being presented as currency. When you divide by an integer,
Access thinks you are "integer math"
the solution, is to convert the...MS Chart Control for VC++9 03-14-10
I am trying to use MSchart control in my Visual C++9, However, the MS
chart control in not available in activex list!. I ve downloaded the MS
chart control for APS. Net but I couldnt use it with my VC++ programs.
Is there any clue?
"Azed" <firstname.lastname@example.org/> wrote in message
> I am trying to use MSchart control in my Visual C++9, However, the MS
> chart control in not available in activex list!. I ve downloaded the MS
> chart control for APS. Net but I couldnt use it with my VC++ programs.