MS Access 2003 and Outlook 2003/Website
I'm working with someone developing a website for our company, and had some
questions. I've read alot of resources and articles on how to integraste
these thigns, but can't seem to get to the right spot.
What we want to do, is have a webpage, that a customer can access, fill out
a small form for RMA requests, then either email that to a specific email
address which would be filtered to a folde rin outlook, and then have the
Access database look in that folder for new emails and add that info in to
the db. I have that part partially figured out, but another option we were
...Access 2003 Upsizing Wizard does not work.
I can not get the Upsizing Wizard to work.
SQLServer 2k Developer
I can get the Wizard to run on my laptop, same OS and SQL. Access 2002, no firewall.
No matter what I do, when I run the Upsizing Wizard it always tells me the it can't find the server or access denied. I've tried both kinds of authentication to no avail.
I am the Admin. I have granted myself every permission I can find.
I can go into EM and work with the DBs. I can link them to Access via ODBC and it works.
I updated the MDAC libraries.
I suspect the Firewall but I ha...Try on this important update from MS Corporation
Content-Type: multipart/related; boundary="lahdmgqhtxy";
Content-Type: multipart/alternative; boundary="htsmekhwqjgb"
this is the latest version of security update, the
"November 2003, Cumulative Patch" update which resolves
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express.
Install now to help protect your computer.
System requirements: Windo...Vlookup Rounding
I am "trying" to build a spreadsheet at work illustrating a gain/share
model that is triggered off of revenue & volume in work. Given that
information, here is one part of the spreadsheet I am having
For a plug number I have my current revenue set at 13,000,000. If i
was to receieve an additional 200,000 in work next year the following
year (13,200,000), that would make a revenue increase of 1.5% (VALUE #)
from the previous year. Based off of the the percentage of increase, I
would like to offer the customer a "discount" capped at a certain
perce...Permissioins required to give access to a IT user to add/remove mailboxes only
I'm looking for instructions to add the necessary permissions for 1 user (or
group) to have the ability to add/remove and configure mailboxes in exchange
2003 (mixed mode). This user needs to mail enable an AD account, change
email addresses and configure information on the exchange tabs.
Any good documents out there that you can point me to?
Joe Richards Microsoft MVP Windows Server Directory Services
> I'm looking for instructions to add the necessary permissions for 1 user (o...Passport Sign-In Problem
All of a sudden, I'm not able to log into MS Money '03,
Passport says incorrect password! Nothing has changed, as
I'm able to log in through MSN's homepage without problems.
MS Money Support suggests to re-install application if all
else fails. Did so, and now backup file I'm trying to use
to restore files asks for password - Says incorrect
How do I rectify this problem and/or remove password
protection from the backup file?
Didn't see this problem previously raised, thanks for any
In microsoft.public.money, James wrote:
I m preparing invoice for my company which have multiple sheets like Customer
List and Pipe Size detail with rate of specific pipe.
I want to locate rate of specific pipe in Invoice. For this purpose I m
using vlookup function but when in that position second row is blank or same
then it returns #N/A.
I just want only want that it should be returned blank when row of Pipe
detail remain blank.
My worksheet have this type of data.
A B C D E F G
Description No. of Pipes (Qty in Mtr) Total Meter Rate Amount
1 063mm x 4Kg TKT 25 6 150 17.42 2613.00
2 075mm x 4Kg TRN 25 6 150 21.76 3264.00
...How can I fix broken Access database
My Office Access 2003 SP2 got corrupted and upon openning shows the message:
The Microsoft jet database engine could not find the object 'MSysDB'. Make
sure the object exists and you spell its name and the path name correctly.
I've tried to use Compact and Repair utility but it got the same message
with openning the corrupted file.
I also tried to import to empty database all of the object but with the same
message and result.
Can anybody help me with this?
> Can anybody help me with this?
Restore from last night's backup. You do have a bac...Summing the results of the VLOOKUP command
I am using the vlookup command several times to return values found in another worksheet. I would like to SUM the results of the vlookup command but since the values are not constants the SUM funtion is returning an error. How can I sum the results of the VLOOKUP command?
You should be able to sum (numeric) results of formulas, no matter what
What are the results of your lookups? What does your SUM formula look like?
What result did you expect? What did you get?
Microsoft MVP - Excel
"James" <email@example.com> wrote in message
I hope you can help with the following:
I have to lookup a number in worksheet A within a range, "Range", i
the number is not available in the range, I want a "" in my cell. I
the number is available it should lookup the 18th cell. In the 18t
cell, I could have a date in there OR a words such as confirmed, route
e.t.c. If it is a date, it should provide me the date in my cell, i
it is anything other than confirmed, it should put a blank, if it i
confirmed, it should take cell m2+3 workdays. I have the followin
formula but I all blanks, something is not righ...tableadapter Query linked to Access 2003 table
I'm trying to write a query for my Dataset's table adapter. It is
linked to an access 2003 database. Basically, I'm trying to duplicate
the following query.
SELECT Parts_Inventory.Aisle, Parts_Inventory.Rack,
Parts_Inventory.Shelf, Parts_Inventory.QNTY, Parts_Inventory.MFG_PN,
WHERE (((Parts_Inventory.Manufacturer) Like "*" & [?] & "*"));
I'm using a text box as my control to the manufacturer field. If it
is blank, it will show all my parts.
I'm able...vlookup in a chart
I am trying to create a chart which looks up a value and then depending on
this value uses a certain set of data to draw the chart. I know it can be
done, as I have seen it, but I am not sure what I need to do
Can you bee a little more specific?
Microsoft Excel MVP
"Lottie" <Lottie@discussions.microsoft.com> wrote in message
>I am trying to create a chart which looks up a value and then depending on
> this value uses a certain set of ...vlookup range
vlookup table array - QOH!R1C1:R844C5, is there a way to specify range as
QOH! xlright,xldown as the number of columns and rows can vary?
ActiveCell.FormulaR1C1 = _
Dim ws As Worksheet
Set ws = Worksheets("QOH")
LastRow = ws.Range("A1").End(xlDown).Row
LastCol = ws.Range("A1").End(xlToRight).Column
ActiveCell.FormulaR1C1 = _
"=IF(ISNA(VLOOKUP(C2,QOH!R1C1:R" & LastRow & ...Delegate Access Problems
Recently one of our Exchange 5.5 servers failed and all mailboxes have had
to be restored from backups.
Since then I have had some problems with certain mailboxes. Now when I
click on the delegate access tab it says "The Delegates page is not
available. Unable to access Outlook folder". I do not understand this as
the mailbox is open and functional.
Can anyone offer any advice on how to resolve this issue?
...5 access 2000 users and 1 AccessXP user
I have an Access 2000 database that is used by multiple users. The DB is
split with the backend on a server.
I have 1 user who wants to use the DB but they have Office XP (Access 2002)
I feared that the 2000 users may have trouble using the backend if a 2002
user accessed it ( I recall having these issues with 97 and 2000).
I tested this theory on a copy of the backend and 2002 seems to be able to
use the 2000 backend and preserve 2000's ability to access it thereafter.
My problem is that I can get the mdb version of my Access 2000 front end to
work on t...if then statement with a vlookup?
I am trying to come up some code to search a workbook for numbers and
then put them in a column on the last page but if the number already exists,
do nothing. I need it to do this everytime I run the macro. Any ideas?
here is an example:
look for "day" if true then i want the number in column j on that page to go
to the last page in column k, but if the number is already there then do
nothing. if it is not there then the next cell down.
Does this make any sense? I think I confused myself.
Any help is appreciated
A little clarification ple...Access XP Import (from Excel XP) Errors
I am using Excel XP to import a single sheet to Access
XP. Every single time I get this error:
"The wizard is unable to access information in the
file '<pathname>'. Please check that the file exists and
that the file is in the correct format."
The cause is not an ISAM issue as I checked the files and
registry entries for same as suggested in Knowledge Base
#209805; 283881; 90111; and 142473.
My work-a-round is to export from Excel to a text file,
then to import that text file into Access. This is the
long way around the barn.
Also, where can I obtain a comp...Hook procedures in MS Flight Sim
I'm writing a .dll that gets loaded by MS Flight Simulator, and I'm trying
to monitor what the user chooses from a dialog box by using hook procedures.
Using Spy++ I've located the listbox I'm interested in, but the Control ID
shows as 0xFFFFFFFF, and the class is
"Afx:00400000:2b:00010013:00000000:00000000" What is that? Some kind of
ActiveX control maybe? How am I going to get data out of it? Help would be
Entering a value of 02/29 into a form (mask is 00/00;0/_) and (format is ddd
mmm dd\,yyyy) yields a date of "Thu Feb 1,2029". Entering a value of 02/28
yields a date of "Thu Feb 28,2008". How can I get a value of "Fri Feb
29,2008" for this "leap year" date ? Windows-Control-Regional and Language
Options look OK.
You'll need to provide the year as well. To be honest, I don't understand
why you're getting Feb. 28th of next year if you only enter 02/28: I get
Feb. 28th of this year when I do.
Doug Steele, Microsoft Access MVP
http://...Using VLOOKUP wrong?
Hey all, I've got 2 columns "A" has names & "B" has percentages. I've
been able to use the VLOOKUP function w/in the same workbook as the
data with success, however when I try to make a new workbook using
VLOOKUP I can't get the formula to work.
Here's what I thought the formula should look like:
Can someone please point out my idiocy & get me set on the right
Thanks a ton :)
> Hey all, I've got 2 columns &qu...MS CRM Users & Contacts
Should CRM Users also be setup as CRM contacts? Our organization desires to
do this. The problem we have is when both the contact record and the user
record have the same Email address the system cannot resolve the address
without user intervention.
I ran into the same problem here. Luckily I have two e-mail addresses, .com
and .net. My User account is .net and my Contact is .com. However, if you
have an internal domain such as .local, then your Contact could have the
..local. That will work internally. Or you could just leave the Contact
e-mail field blank.
Larry Len...Can't access CRM home page or reports
When a user trys to access the CRM Home page (http://name_of_crm_server) from IE, the user gets redirected to http://name_of_crm_server/_common/error/errorhandler.aspx?errNum=0x80049001 and the following error message "User Access Error - The system could not log you on. This could be because: you are not a Microsoft CRM user, your user record has been disabled in the system, you have not been assigned any security roles, or you have not been assigned a license. For more information, contact your system administrator."
The same thing happens when I try to run reports from Outlook CR...vlookup or what?
I have a little database which arrives periodically, and I would like to
chart the number of members by nation. I can't recall ever having this
opportunity before. The nations are standard ISO codes (UA, UK, US, UY)
and not numeric. Is there a way to organize these entries somewhat
automatically for charting?
Alternately, I wondered if I filtered the nation column, is there a way
to export all the unique entries, preparatory to counting this by hand
(so to speak) . . .
Any advice would be gratefully appreciated.
P D Sterling
New York, Texas & Texas, New York
PD,...remote access #3
is it possibe to use a email program other than outlook to Access email from
a remote location.
If so what is the correct information for the remote server ?
Thanks in advance
> is it possibe to use a email program other than outlook to Access email from
> a remote location.
> If so what is the correct information for the remote server ?
> Thanks in advance
Sure. Any IMAP4 (or POP3) e-mail client can be used. You would need to
put external IP or name in the settings (as server for incoming mail),
setup port forwarding on your firewa...vlookup is not a macro is it?
I have a sheet and it's a vlookup, I do not remember recording
anything, but howcome everytime I open the vlookup sheet, it has the
dialog box with button "disable macro" "enable macro".
Is this a bug?
Also I've protected a sheet, usually when you protect a sheet it also
hides the formula, isn't it? if so, why then some formulas are indeed
protected (can't see it) while some formulas are still visible?
Is this a bug?
Also, howcome every time I open my excel program, the personal.xls
Is this a bug?
thanks for all your answers and pati...