Basic way to make basic databases work on Access2007?
I tried the Microsoft info on this questions and it was really worthless.
Let's say a "little guy" makes some unsplit Access 2003 databases with
Macros and code which a friend wants to run on Access 2007 without "security"
related hassles, including without wanting to have to click through warnings
every time it is opened.
Is there a simple way to do this?
Thanks in advance
If you trust your friend, you can tell Access/Windows to trust the location
in which the file runs.
Microso...Access to SQL Convertion
I am really new to the SQL world, so please bare with me.
I have an Access dbs that works fine - it allows me to populate tables
there are several forms, queries and tables
Everything works fine until I upsize.
Once the upsize is complete, I can open and enter data into the form -
but the data does not save back to the tables.
What am I missing ?
I have checked permission and everything appears to be fine?
It works in Access 2003 but not the SQL version.
Do you have primary keys defined for all of your tables?
If you do, then do you get any error messages?
Doug Steele,...Is there a way to speed up Calculation !!!!!!!!!!!!!!!
I have this line of code in my macro: Wks.Range("G3:GA732").Calculate
This line of code takes over an hour to execute. The range is all
SUMPRODUCT formulae and I have to run the report daily. It takes about 2
hours to run the report. 90% of that is spent executing the "Calculate" code
What I need to know is this, is there a way to speed-up the Calculating
operation or am I stuck with this?
get more memory and/or faster cpu
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your...How do I calculate interest?
I want to create a spreadsheet that shows my kids the power of
compounded interest. I want to show them what regular deposits
against a specific monthly interest rate results in, at the end of the
year. I want to have the interest rate in cell A1 and starting in row
5, in column A I have the date of deposit and in column B I have the
deposited amount. Then I want to have a total that calculates the
updated balance including the compounded interest rate each month.
Any suggestions? TIA!
"darkwing_duck" <email@example.com> wrote:
> I want to show them...MS Giving VC++ 2003 Away Free?
Anyone know what VC++ 2003 is ? Or how to extract
InstallShield installations without installing?
I don't want to corrupt my machine with free software. ;-)
I didn't create this, I just think it's funny...
Post replies to the newsgroup.
Your questions are answered at the link you provided.
ndy Mortimer [MS]
Please do not send email directly to this alias. This alias is for
newsgroup purposes only
This posting is provided "AS IS...Schedule a Import task
There is a way to schedule a import task, in order to import Invoices?
Like the "Systems jobs"
...Performance CDF and MS CRM?
I am about to try out the MS CRM CDF tool and am looking at loading about
829,626 records into the contact & lead tables -> not sure what the exact
split will be yet and about 256,787 records into the company table. How long
will it take to run all this through the CDF tool and get this loaded into
MS CRM and then how is the performance of MS CRM with this amount of data in
I'll also be loading maybe another 100,000 records at a later date. Can I
use the CDF again for this import even though I'll have a lot of exsting
data I want left alone.
Jerry R...Is there a way to eliminate specific cells from formulas?
I am creating a table showing daily and weekly averages of Production lines.
I want to create a weekly chart but I dont want the weekly totals to include
the daily sum and averages. Is there a way to eliminate those cells from the
Check the SUBTOTAL function. It ignores other SUBTOTAL functions in its
1st argument options:
Does that help?
> I am creating a table showing da...Correct way to delete/stop ...\out\Archive
I seem to recall this has been discussed, but I can't find the discussion. I
see a bunch of files in my C:\exchsrvr\imcdata\out\Archive and
C:\exchsrvr\imcdata\in\Archive . Seems to me that I should be able to delete
them. Is there any advantage to keeping them? Is it OK to delete them? If
it's OK, what's the correct/safe procedure?
You can delete them without any problem. They're used for diagnostic
purposes and aren't required by your Exchange server. In fact, by default
Message Archival is not enabled.
If you want to tur...INTERNET MILLION DOLLARS
INTERNET MILLION DOLLARS - www.InternetMillionDollars.biz
Watch the VIDEO on YOUTUBE... NOW!
MAKE MONEY INSTANTLY using 2007 featured
INTERNET MILLION DOLLARS as a resource.
WORK FROM HOME
HOMEBASED JOBS AND IDEAS
Professor James Bradley's
"Quick and real way to make BIG MONEY on the Internet!"
Finally you have FOUND IT!
Make a FORTUNE each month...
.... every month!
100% ON AUTOPILOT
Read it NOW and CHANGE YOUR LIFE!
Are you fed up with being short of MONEY all the time?
Do you DREAM about a...How to access different glyphs in MS Word?
How do we access different glyphs of opentype fonts in MS word.
The method of opening character map is very cumbersome. Is there any
shortcut key or menu button or any other similar such method which can
enable typing different glyphs of any character.
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
S N wrote:
> How do we access different glyphs of opentype fonts in MS word.
> The me...pull data from an Access database into Excel template
Is there a way to fill the cells in a report set up in Excel from data in an
Access table? I don't want to create a new Excel file, but just populate
the cells with Access data. Thanks,
You can read data from Access into table on worksheet through an ODBC query.
Now create your report using queried data (through links) as source.
(Don't use my reply address - it's spam-trap)
"Randal" <firstname.lastname@example.org> wrote in message
> Is there a way to fill the cells in a report set up in Excel from...No-Interest, No-Payments
I apologize if this is a duplicate message, but this
message didn't seem to post from my office.
I've been fighting with this all weekend, and I can't
find a solution. Is it possible to track individual
purchases in Money 2003 that have a no-interest with or
without payment options? For example, Home Depot has a
special offer where any purchases totaling $299 or more
using the Home Depot credit card is interest/payment free
for 6 months from the date of purchase. I have made two
such purchases (one in March, and one in June), but I
can't seem to track them individu...Inserting an Excel Worksheet into an Access form
I'm working on a project that records various metrics and displays them in a
crosstab type format (date/year as column headings and metric, business unit
as rows). I'd like to insert an excel worksheet in the access form to
display the results of the crosstab query.
So far I haven't been able to make this work. I inserted the Excel sheet as
an object and set the row source type to table/query. I then pointed the row
source to the appropriate query. Thus far I am only able to populate the A1
cell, nothing more. Am I missing something or is there a good reference ...Interest
How should I update the interest owed on a student loan.
The interest that Money has calculated is completely off
b/c I just now put the loan into Money, but have actually
had the loan for quite some time. Should I do an account
adjustment? If I do this, will Money think I am changing
the principal? I'd appreciate any help concerning this
...Can't access bad certificate site
I am trying to access a https:// site. In Safari it always gives me a
certificate error but I can still get to it.
I cannot access it at all from IE 8 and wonder why that might be. What
settings do I need to check, please?
"SteveH" <SteveH@discussions.microsoft.com> wrote in message
> I am trying to access a https:// site. In Safari it always gives me a
> certificate error but I can still get to it.
> I cannot access it at all from IE 8 and wo...send an email in a scheduled time
if i want to send an email in certain time, is it possible? For example, can
schedule to send an email at 12pm at night. Of course, I don't want to
physically click send for that email, but I want it automatically being sent
at scheduled time.
please advise. thanks
Take a look here, it may help:
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google...Change from a 2-way to a 3 way splitter wnd
in my application I have a 2 way splitter window. In the left window a
tool bar is displayed.
Depending on the toolbar button I want to change the layout to a 3 way
splitter or from a 3- to a 2 way splitter. I attach a splitter to the
MainFrame in CreateClient() with CreateStatic() but I'm not able to put
a nested splitter at runtime.
Anybody knows, how to change the splitter layout dynamically?
Thanks in advance,
> in my application I have a 2 way splitter window. In the left window a
> tool bar is displayed.
> Depending on the ...Watch the critical pack which comes from MS Corp.
Content-Type: multipart/related; boundary="kpxeviiup";
Content-Type: multipart/alternative; boundary="mzshzikjtmoenyc"
this is the latest version of security update, the
"October 2003, Cumulative Patch" update which resolves
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now to mai...Is that any way to customize the CRM 3.0 Sales Pipeline Report?
Want to add the 'Company Name' on the Sales Pipeline Report.
Hi CEO, yes - it is possible to modify the report using Visual Studio's
add-in for the SRS reports. To modify the reports, please download the Sales
Pipeline report and Sales Pipeline Detail report (this one shows up in the
"Hidden Reports" view) from the Reports section and add extra data to the
reports. Hope this helps.
Manisha Powar (Madhusudanan)
Microsoft Dynamics - CRM
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for y...access to outlook 2003
Is it possible to have an after update function (in access) open up
the user's calendar in Outlook and create an appt for a specific day
and time from info that is stored in the record in access?
would like to be able to use the reminder feature of outlook to remind
the user of something he has to do in the future etc.
No offense but hasn't got Outlook a great feature for that called 'Reminder'?
> Is it possible to have an after update function (in access) open up
> the user's ca...Scheduled bills from loan going past term of loan
Hope someone can help with this:
I have an automobile loan in Money 2000 that I have set up as a
monthly recurring bill. This loan will be paid off in 2 months, yet
it shows up as a scheduled bill well past this 2 month pay-off date.
The loan account shows an accurate balance and it shows that there are
2 payments left. I looked forward a full 12 months and it's still
Did I screw something up to make this recurring bill continue to show
up in the Pay Bills section of Money, seemingly forever?
P.S. If it matters, this account is not part of my de...users have access to all mailboxes
After recently updating server current patches, no Exchange updates, users
access to all mailboxes. The restriction is still in place for admins, (if
you are a member if both the Exchange Domain serves and one of the Admin
groups, you will not have access to the other mailboxes)
Operating system, Win2K SP4, Exchange 2K Enterprise SP3.
> After recently updating server current patches, no Exchange updates, users
> access to all mailboxes. The restriction is still in place for admins, (if
> you are a member if both the Exchange Domain serves and one of the ...Help! Access shuts down -lost record
Hi...one of my clients is using a form i created to enter interview
data...it's got multiple tabs and is fairly simple. She just reported "got
an error, Access shut down, and I can't find my interview" - This has
happened to her before. It has never happened when I tested it on my laptop.
If for whatever reason Access is shutting down, why were all her notes
deleted. Isn't it saving constantly? (It does on my machine!). She's using
an mde version of the form. Is there any where I can tell her to look for her
record if it's not appearing when she opens...How do you keep your toolbar customized the way you set it up?
I have used different versions of Excel for years; we are now using Excel
2003. I have customized my toolbars the way I want them several times but
they won't stay the way I set them. I read about autosensing - I don't know
if that affects it. Can I make the toolbars stay put?
Zygan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=34423
View this thread: http://www.excelforum.com/showthread.php?threadi...