Over 1 million tech questions and answers.

Solved: Microsoft Access Error

Q: Solved: Microsoft Access Error

Hello. Whenever I try to use the Microsoft Access 2007 "Wizards" to help create something, an error message comes up stating "Error in DLL." Sometimes this error causes Access to shut itself down completely. I've tried reinstalling, but the problem has persisted. Any ideas? Thanks!

Preferred Solution: Solved: Microsoft Access Error

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Solved: Microsoft Access Error

Read other 7 answers

I am using Microsoft Access 2000. I have the database set up so that on the bottom there is a button that will send one page to the default email and send it as an attachment. it worked fine and for some reason that i cannot find it started giving me an error message
An error occurred while attempting to open the windows address book.
MAPI 1.0 [00000220]

after you sent hit OK to that error another error pops up that says
Microsoft access cant send a message for the reason stated in the proceeding alert

the checked the registry and made sure the correct email was the default, i tried using both Outlook and Mozzila Thunderbird. I dont know enough about Microsoft Access to look at anything in there

A:Solved: Microsoft Access error MAPI 1.0 [00000220]

Hello HarleyiteKaty. I'm not a techie but try here.
http://uk.search.yahoo.com/search?fr=ytff1-&p=Microsoft Access error MAPI 1.0 [00000220]&ei=UTF-8

Read other 1 answers

Every time I try to access Microsoft.com or any of its branches I am faced with the message "Oops! Internet Explorer could not find www.microsoft.com" and in the google search box below it says "microsoft isapi redir" for some reason. Also in the Adress box at the top it has the url "http://www.microsoft.com/isapi/redir.dll?prd=ie&pver=6.0&ar=aboutie&sba=copyr" . This doesn't work on google chrome or IE. I have the IE version 6.0 and because of the fault I can not update it any further, neither can I update anything else on this computer (Compaq Presario). PLEASE HELP.

A:Error trying to access Microsoft.com

Read other 7 answers

Hi Guys,
I am new i got one error that "access run time error 3061 too few parameters expected 1"

i write one query which is run in query build in access, i copied that query and paste in to VBA code but i got above error i dont know whats wrong

my query is

strgrQuery = "SELECT Count(Vendor_Resources.onsite_offshore) AS CountOfonsite_offshore FROM Vendor_Resources WHERE (((Vendor_Resources.[Vendor_Name]) = 'Sujeet') And ((Vendor_Resources.[Onsite_Offshore]) = 'Offshore')) GROUP BY Vendor_Resources.onsite_offshore;"
Set rs = db.OpenRecordset(strgrQuery, dbOpenSnapshot)
If (rs Is Nothing) Then
MsgBox "Sorry rs is Empty"
End If

A:Solved: Access Error access run time error 3061 too few parameters expected 1

Read other 7 answers

I recently installed a new hard drive in my Dell Dimension 3000. I loaded XP and all was good but now I can't access certain sites. I read on a post that there are holes in the early versions of XP (probably my original disks) that the updates fix. I tried to get to the msft website to update and all I get is a DNS error.

mi hijack log is enclosed. Any clue?

Logfile of Trend Micro HijackThis v2.0.2
Scan saved at 10:35:20 AM, on 10/8/2009
Platform: Windows XP SP2 (WinNT 5.01.2600)
MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180)
Boot mode: Normal
Running processes:
C:\Program Files\Analog Devices\Core\smax4pnp.exe
C:\Program Files\iTunes\iTunesHelper.exe
C:\Program Files\Messenger\msmsgs.exe
C:\Program Files\Google\GoogleToolbarNotifier\GoogleToolbarNotifier.exe
C:\Program Files\Spybot - Search & Destroy\TeaTimer.exe
C:\Program Files\Digital Line Detect\DLG.exe
C:\Program Files\Common Files\Apple\Mobile Device Support\bin\AppleMobileDeviceService.exe
C:\Program Files\Bonjour\mDNSResponder.exe
C:\Program Files\iPod\bin\iPodService.exe
C:... Read more

A:cannot access microsoft website. DNS error

Read other 7 answers

Hello I am inserting a subform in a main form but in the subform wizard I cannot see the forms that I already have in the database to insert. I could see them before . I have no idea why this is happening . I used a different computer and triedand the wizard worked fine .

I did some search and it seems a problem with the references but even they seem to be fine when I go in the module view and check them
PLEASE HELP !!!!!!!!!

A:Microsoft Access Subform error

Read other 8 answers

I'm trying to plan an event for school and I keep getting this Referential Integrity error message. I am trying to make a One-To-Many Relationship between the Clients Table & Events Table. The error message reads:

"Microsoft Access can't create the relationship & enforce referential integrity. Data in the table 'Events' violates referential integrity rules."

I tried to upload a screen shot but it was too big for the attachment so I can't do that I guess.

Please help me out. Would I need a foreign key for this to work? Just wondering.

A:Microsoft Access 2010 Error

Read other 6 answers

the following message appears when i run a function

The instruction at "0x6502c51b" referenced memory at
"0x00000008". The memory could not be read".

Click on OK to terminate the application
Click on Cancel to debug the application

A:Application Error in microsoft ACCESS

gack. That ain't pretty. Need some more info, though: what function are you running? one you wrote? if so, does your code compile? under what circumstances are you running it? what's your db like?

Read other 1 answers

I tried installing a trial version of Living Cookbook on my desktop computer and it would not run. The following errors popped up. I installed the same program on my Laptop with the same windows 7 64bit configuration as my desktop and it ran fine. The only difference between the 2 computers is the laptop has Windows 7 home premium and my desktop has Windows 7 professional. Both computers have been fully updated with the latest Microsoft updates and are Malware and virus free. I don't know why the desktop is giving me this error when the laptop works fine. I have tried running this in Administrator mode, in window xp compatible mode all with same results. It ran with no configurations on my laptop.
I Googled MDAC 2.6 and all versions seem to be for XP systems. Again what ever is on my laptop doesn?t seem to be on my desktop.
I believe this is a System problem not a software problem, so I am posting this to see if any of you Great Windows 7 Gurus have any suggestion?

Application: Living Cookbook 3.0.34
OS Version: Microsoft Windows NT 6.1.7601 Service Pack 1 (Windows 7)
Message: The .Net Framework Data Providers require Microsoft Data Access Components(MDAC). Please install Microsoft Data Access Components(MDAC) version 2.6 or later.
Inner Exception: Retrieving the COM class factory for component with CLSID {2206CDB2-19C1-11D1-89E0-00C04FD7A829} failed due to the following error: 80040154.
System.Data.OleDb.OleDbConnectionInternal.GetObjectPool: 0/0
System.Data.OleDb.OleDbCon... Read more

A:Microsoft Data Access Error

I don't know if the findings in this Blog will help, but read it just to see. Mystery of the Server 2008 + IIS7 + OLE = "MDAC Not Installed" Error - Avian Waves : Blog

Read other 5 answers

When I try to Access the Management Control using the start button, right click mouse in my computer, it won't let me let me access it, it gives me the following error;

Windows can not find '(null)". Make sure you typed the name correctly, and then try again. To search for a file, click start button and then search.

I don not know any other way to access the console, . How can i fix this problem?? Thank you for your help.

A:Microsoft Management Console Access Error


Originally Posted by jackyandjoe

When I try to Access the Management Control using the start button, right click mouse in my computer, it won't let me let me access it, it gives me the following error;

Windows can not find '(null)". Make sure you typed the name correctly, and then try again. To search for a file, click start button and then search.

I don not know any other way to access the console, . How can i fix this problem?? Thank you for your help.

Have you tried going to Start> Control Panel>Administrative Tools>Computer Management. It sounds like there's a corrupted file or a service is denying you access. You are the Administrator of windows? After trying the first scenario go to Start>Run and type services.msc and when the services window opens make sure Event Log, Windows Management Instrumentation(WMI), and Remote Procedure Call (RPC) are started and not disabled. Let us know how you make out.

Read other 2 answers

When I try to import or export items to or from Microsoft Access 97 I am receiving this errer: "Could not find installable ISAM." Any suggestions?

A:Microsoft Access Import/Export Error

See if this helps


Read other 1 answers

I receive the following error message when I try to open a database:

"The database is not available at this time"

It occurs if I try to open the database right after I perform a docmd.quit on the same database and it closes out. Not sure what would cause this error. Thanks!

A:Microsoft Access 2000 Error Opening DB

Did you create the database? If not go to the database creater / administrator, otherwise cut out all the sensitive data, and attach a copy to this thread. It's probably something to do with the way the database is set-up.

Haven't come across this myself, may be a common known issue.

Read other 1 answers

I have a relatively new install of windows because I formatted a few weeks ago so I had a clean start with my new hardware. The only problem it seems is before I could get antivirus and things patched a virus or something caught me.

I dont think my computer is updating anymore and some applications have recently started to crash and my computer has sporadically turned off a few times this week and the temps were fine so i know it was not that.

I can not get to the microsoft update website, because when I try to go there firefox will open and direct me to the site.

I was getting an error on startup saying rundll32 could not find a file that AVG deleted and the files was called dll32 and sm. I will work on finding out what it used to be called.

I have an application called Prio installed which is a great extension to task manager that expands it abilities and it showed that I have unsigned versions of svchost, alg, and wimprvse running and some other unverified processes that are running under system.
The other suspicious proccess is unsecapp.exe

There are also quite a few open connections sitting on listen for my computer if needed I can put up a wireshark analysis.

Right now I have AVG, ad-aware, a-squared, and Secunia PSI installed.
A-squared pick up some files that AVG seemed to miss yesterday when I installed it so that got me concerned with AVG.

Thank you in advance.

Read other answers

Hello Masters of Access

I have written a reservation program in Microsoft Access and when I open my form I get the following message "reserved error (-1517); there is no message for this error". At this point I can click ok or help When I click help it says "Reserved error <Item>; there is no message for this error. (Error 3000)
An unexpected error occurred. The specified code identifies the conditions under which this error can occur. Please contact Microsoft Product Support Services for more information."

I have shut down and done a compact and repair but it keeps coming back

Any help?

A:Error message in Microsoft Access Program

Read other 16 answers

Where can I find complete # to definition of Microsoft Access Run-time Error list? I used to have url of that list but I lost it.

A:Complete Microsoft Access Run-time Error list

LinuxGold said:

Where can I find complete # to definition of Microsoft Access Run-time Error list? I used to have url of that list but I lost it.Click to expand...

Hmm, how about Microsoft Jet Engine run-time error list?

I'm getting more and more desperate -- trying to understand error number 6933!!

Read other 2 answers

Hello all,
I am having an issue accessing the Developer API access page within the Microsoft Security Response Center website (https://www.microsoft.com/en-us/msrc). When I click on Customer Guidance > Developer API access, or navigate to https://portal.msrc.microsoft.com/en-us/developer,
my browser first asks me to sign in and click which account I would like to use. I click my desired account, and it briefly redirects to the Microsoft Developer API Access page, but then after a split-second it redirects me back to the sign-in page. Is it
a requirement to have a specific type of email associated with the Microsoft account in order to get past this? 

Thank you for your help!

Read other answers

I have created a macro that will run an access database query and copy the results into Excel. It runs fairly well except on one PC where it gives me a:

"Run-time error '3706' Provider cannot be found. It may not be properly installed."

The error occurs in this particular line of code:
' Open connection to the database
cnt.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
I'm not sure if I have to change the version of the provider and if this is case how does one go about doing so.

Thank you

A:Microsoft Provider error - Excel/Access 2000

Look at it's version of ADO in the ODBC manager. Might just need to upgrade.

Read other 1 answers

Is there any url out there on Internet that lists all Access 97 Microsoft Jet Database Engine Errors? I.e. Run-time error: 63933

Tried that on help menu to no avail, paper clip is laughing at me.

A:Access 97 MicroSoft Jet Database Engine Error List

Read other 8 answers

Hello. I created a database, which is split between front end and back end. I was able to make copies of the database and have it tailored to each of our branches. For each user, I had to create a copy of the front end and link it to the back end from their machines. This was done for 3 of the branches (besides head office) on 3 computers in each branch over a OneDrive. At the head office, where the original files were created, everything works fine. However, in the branches, 2 out of 3 branches are giving me an error on the fields which pull the "Current User" and the "Date/Time". I am confused because all fields seem to be working fine on some computers but not other others. Please help.

Read other answers

The following is the error message generated i'm getting when i publish preview an asp page created in Drumbeat2000:

Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect

/jt/media/IIS_Gen_3.0_Recordset.js, line 392

This occured when I created an asp (active server) server generated page (created in Drumbeat 2000) which uses the content from a database created with microsoft access 2000.

When previewed inside the Drumbeat2000 program, this error message is displayed...When viewed with explorer 5 or netscape, the data form elements simply are not visible.

Tech Notes:

Software used to create asp page: Drumbeat2000

Software used to create database: Microsoft Access 2000

Server info: Microsoft Personal Web Server 4 being run on my local computer

Somebody please tell me hot to eliminate this?

A:(Microsoft Access Driver) Error Count Field incorrect

Since no one else answered this one yet I guess I'll take a shot.

I would suspect there is a field being mapped to a field/variable of the wrong type. Do you have an aggregate function on a non-numeric field that's mapping into a field of the same type as the original instead of a numeric field that would hold the result of the aggregate?

Read other 1 answers

Hi, I am at the moment creating a database of information and I was wondering the best way to go about this. I am importing loads of tables from excell to access and I want them to link up for a search function to filter out all datafiles over a certain age into a query you can search for. At the moment I have them all in one table with queries to search for certain things but I think there has to be a better way. Suggestions? thanks a lot, K.

A:Solved: Using Microsoft Access

Read other 11 answers

I have a small problem with Microsoft Access. We have an Access database on our server that is utilized by our company. We have approximately 15 computers that access this database locally and approximately 5 that access it remotely via Terminal Services. Why is it that the Terminal Services users can use the database with more speed than the local users that are directly connected?

A:Solved: Microsoft Access

Read other 6 answers

Does anyone know where I can find a templete for Microsoft Access for a "Check Registry"? I now use excel, but I would rather use Microsoft's Access, so I can do better reporting and entering on a form for "deposits", and "checks". I want the system to automatically subtract the totals as I go along like I do in excel. I used Microsoft suite Access 2000. Thanks Silverado.

A:Solved: Microsoft Access

Read other 16 answers

Hello, I have another problem that I just can't figure out.

I have a query table that I would liek to be able to send as an e-mail. But here is the thing. I have a button on a form that just opens up the query table, but what I would like the button to do, is to make the e-mail pop-up (Outlook2007 at home, GroupWise at work) and put the query data in the message. Basically, when you click the button, I want this:

Subject: "Good morning"
Message: "(My query table here)"

I found a code elsewhere on the internet but I got code errors. I then fixed the errors but then the button simply did nothing.

If anyone can help, I'd really appreciate it.

Many Thanks in advance

A:Solved: Microsoft Access again

Read other 16 answers


I have a form and sub form in my database when i am trying to focus the control to the sub form i am getting a run time error "2110" "Microsoft access can't move the focus to the control; find below the code i am using in my main form;

Private Sub CategoryID_AfterUpdate()
If Me.CategoryID = 2 Then
MsgBox "Please fill out the Request Date", vbExclamation
End If
End Sub

I am getting the error on highlighted above code.

Please help me in solving this issue.

A:Runtime Error 2110 Microsoft access can't move the focus to the control

Read other 16 answers

I am in the process of developing an Access 2003 application, and almost done. While I was fixing some errors with controls on one of the reports, seems like the database corrupted. Now, I keep getting "microsoft office access has detected corruption in this file....etc". It instructs me to Compact & Repair, but when I get the same error message when I try that. If I open a blank database & try to import objects from the corrupted database, I cannot access/view the objects of the corrupted file from the blank database. Unfortunately, I dont have a backup of the file, I can try to restore to an earlier storage point (using System Restore), but will lose considerable work. Any ideas?

Read other answers

Hello all.. just a few questions. I just recently started learning Access and for some reason my brain is not wanting to work with me. ;p

I am trying to develop a database for the company which I work for. It will be a marketing/sales database. And I've looked for templates, but none that I could find did me any good.

Here's what I'm working with:
- List of customers and their basic info. (i.e.: name, address, phone..etc.)
- Different products for each customer and that products info. (i.e.: sales person, ytd sales.. ect.)
- The sales person who handles the individual products for that customer.

I'm just not sure how many and what tables I will need to make for this kind of database.

If you have any suggestions I will be much appreciative!
Thank you!

A:Solved: Microsoft Access 2007 - Help Please!

Read other 11 answers

This will be my first post here, and I'm kind of glad I discovered these forums, they look really nice. I think I might stick around for a while too!

I can't download anything at all from
I just did a fresh install, and right after
installation I attempted to download windows
live messenger, however that didn't work.
There was no way it could be a virus either as
it's a brand new hard disk and a brand new XP
install. I can download from other sites,
including antivirus software without problems.
It's only Microsoft.com I'm having issues with.
I also tried going to the windows update page,
and was also met with failure. I'm not sure if
Automatic updates are working, but I don't
think they are.
This seems a lot like that one virus that was
going around, messing with people's DNS so
they couldn't update their antivirus software.
However, I've never had this virus on my
network or any of my computers so I don't
think it's that.


I've tried several things, including trying to download from
microsoft in safe mode (with networking.)
However, I've got nothing.
I'm beginning to believe it's either my ISP blocking downloads
from microsoft.com or Microsoft blocking me from
downloading. I can access the rest of microsoft, but I just
can't download any software from there.
I know it can't be the conicker virus either, as I've been able to
downloa... Read more

A:Solved: I can access Microsoft.com, but I cannot download

Read other 7 answers

I have a comments field, but when I press enter, it goes to the next field. How can I change it so that, when I press enter, it goes to the next row in that field?

I also want to know if I have a field with two different states listed, how can I select one by pressing enter?


A:Solved: Microsoft Access - Forms

Read other 8 answers

I am in the process of upgrading from Office 97 to Office 2003.

I occasionally write Microsoft Access Database applications and have the capability with Access 97 to provide a runtime version of Access with my applications (using Office 97 Developer Edition Tools). I understand that with Access 2003, I need to have Access 2003 Developer Extensions, which appear to be available only as part of Visual Studio Tools for the Microsoft Office System. This seems to be quite an expensive piece of software which is hard to justify for the few database applications I write. Am I overlooking a way to economically get what I need to have the license to distribute Access Runtime and a setup wizard to install applications that I write that need runtime?

A:Solved: Microsoft Access Runtime

Read other 7 answers

Hi, I would like to know how can I access Microsoft web pages, i can access any web page I want except for the Microsoft ones (no hotmail, msn, messenger,etc), I noticed that since 2 days ago.

Please help meeee I'm using mozilla firefox and Internet explorer, i can not open any Microsoft site with any of those browsers.
I have disabled firewalls, but didnt work, Ive checked for restricted web pages but it is empty, I called my internet provider, but useless. The thing is that i was able to open microsoft sites, but since yesterday i can not. WHAT IS GOING ON!

A:Solved: Can not access any microsoft web pages

why don't you try running pc pitstop and use the auto fixes to set your settings.


Read other 1 answers

Hi everyone...I have created a database with 10 tables and forms. Now for the hard part. I have to be able to sort for approximately 40 different fields (all by just the day's date)...I am having a hard time doing a report or a filtered sort giving me just the things I need.


A:Solved: Microsoft Access 2000

This should be done in the select query or queries. You can either us the query's "sort" or you can filter using the query's "criteria".

Read other 1 answers


I am working on a project for my Data Management class in university, and I am required to create a database from scratch and show the relationships and make it work.

I am currently working on a Vending Machine database, where my tables are as follows: Customer, Item, Order, Supplier, Manufacturer. I have made all the relationships that are needed for all the tables to be able to communicate with one another.

My questions are as follows:
- How can I make a transaction occur in Access?
- How can I automatically update my 'Quantity' field after each transaction that has been made?
- How can I make my database flag or warn the Suppliers whenever the 'Quantity' field reaches 50% of the initial quantity? (For example: I have 10 KitKats in the vending machine, whenever a customer buys 1 KitKat, obviously the quantity of the KitKat will reduce. I want my database to warn me when the amount of KitKats reaches 5 and I want it to automatically send a request to the supplier to get more KitKats.)

I am relatively new to this course and to this major and I am in desperate need of help.

Thank you

A:Solved: Microsoft Access Queries

Read other 9 answers

Hi All,

I just want to have some clarification on the MS access, because i am Microsoft certified access Specialist. I have some good knowledge on all queries, tables and macros. But now my concern what should be my next level in MS access. I have some knowledge in excel macros also.

Give your valid opinion about my next level in access and how i can learn it like e book or training etc....

A:Solved: Microsoft Access 2007

How can you be a certified Access Specialist and have no knowledge of Access?

Read other 3 answers


I have a database in access 2003 i need to put it on a machine that does not have a copy of Access, but i do have access runtime. Could i install Access runtime on that machine and be able to open the database?

Any help will be greatly appreciated.

A:Solved: Microsoft Access Runtime

Yes. The Access runtime is design to allow users that have not purchased Access to still "run" a database. They just con not make any design changes or go tot he database windows.

I normally deploy all my Access apps to run with the Access runtime or with Full Access in Runtime mode.

Is your database split into a front end and back end? I highly recommend this. This is the only way I would deploy a database.

Have you tested your database in runtime mode?

NOTE: Some things are not available by default when in runtime mode. I would urge you to fully test your database with Access in runtime mode.

Basics for Building Microsoft Office Access 2003 Runtime-Based Solutions

Read other 3 answers

I have an Access database that has excel files imported into it. The database was designed to make it simple for users by having a graphical Import button that users click on and the database automatically pulls the correct files. This has been working fine on most systems. I have one system running Windows XP where I am having difficulty with this function. Everytime I click on the Import button I get the following error message

"Runtime error '91' : Object Variable or With block not set"

and then it gives me the option to cancel or Debug. When I look at Debug it takes me to the Visual Basic Editior and has an entry highlighted. I then went to another machine this feature worked on and brought up its Visual Basic editior and looked at the contents and everything looked the same. I am unfamiliar with making changes in this context, but was curious as to whether anyone had seen this before and if there was a fairly easy way of solving it?

As always, thanks!

A:Solved: Microsoft Access 2003

Read other 16 answers

Hi, I have an access database which i want to put on a cd, but i want it 2 autoplay, the way a game does when you insert it. So that when someone puts the cd in their pc, it immediatlely loads the application.

Thanx in advance

A:Solved: Microsoft Access autoruns?


Read other 3 answers

Hi all,

All of a sudden I'm unable to access any Microsoft websites. When I attempt to go to www.microsoft.com I receive an error page saying "Internet Explorer cannot display the webpage". I've attached a screenshot with further details. I can access any other website fine, just not MS sites. Any ideas on how to solve this, please?

Many thanks,

A:[SOLVED] Cannot access Microsoft websites

If you have access to another computer or a friend can print out a hard copy, get this page and follow the solutions:

Read other 12 answers

I can not access microsoft.com websites on my laptop. I just formatted today, so I don't think it's a virus. It was working when I first reformatted, until i installed updates. I have searched the web, but can't find anything on it.

A:Solved: can't access microsoft websites

Read other 10 answers

Hi everyone, i have added a calender to a form in my database. Would it be possible to click on a date in the calender and fill in what i need to.

Then i will be able to book appointments and check what i done on previous dates.

Thanks in advance.

A:Solved: Microsoft Access Calender

Read other 16 answers

I've read most of the forums concerning this problem, but have yet to come up with a solution. I'm running XP on two laptops side by side (both wireless). One has no problem, but I can't access either microsoft.com or symantec.com (I've just switched both laptops to Kaspersky). Can anyone help? Thanks.

A:Solved: Can't access Microsoft websites.

Read other 16 answers

I have a database that includes repeat names but with different dollar value's attached to each name. For example:
| Joe Smith | $10,925 |​| Joe Smith | $10,327 |​| Joe Smith | $10,725 |​
I want to create a query that will find a repeat name, identify the record with the highest $ and then delete the rest. Allowing me to have a quesry that shows no repeat names but keeps the record with the highest $.

Any suggestions?

A:Solved: Microsoft Access Query Help

Take a copy of the Table using the "Structure Only".
Make a Query of your original Table using Totals and group by the Name and set the Dollar value to Max.
Run the Query and it should give you the record you need.
Change the Query type to an Append Query and append the data to the new Table, save and run it.
If it allows you to run it, it will do what want.

Read other 3 answers

I receive error message error 1606 after downloading Microsoft Professional 2010 from digital river link. The download went through and my product key was valid, but after it tries to install, I get the error.
Can anyone help me fix it? I really need it for school.
Thank you!

A:error 1606 (trying to access download of Microsoft Home Professional 2010 on Wind.7)

Here, give this a look ---> "Error 1606"

Read other 2 answers

Hi guys, first off I haven't been here for help in years literally this was the first place I thought of because a few years ago many generous people helped me solve my problem, this place is awesome. Please pardon me as I am only decently literate with computers but try my best.

Ok I am trying to solve an annoying problem for my parent's computer. My dad was typing a normal document in Microsoft Word (OS is XP with System Pack 2, and it is Word 2002) and he said that just yesterday for the first time, after typing for maybe a half hour, a window would pop up with a "runtime error" and it would freeze untill he clicked ok on it, and it would then shut down loosing all his work that he didn't save.

So I got on the computer and opened Microsoft Word, and was able to duplicate the problem time after time but not every single time. When I simply open word, then click to close Word, the box appears, and he verified it is the same box he saw. It says exactly as follows, no more, no less, and every time reads the same -

Microsoft Visual C++ Runtime Library
Runtime Error!
Program:C:\Program Files\Microsoft Office\Office 10\WINWORD.EXE
abnormal program termination

So I tried to research it, and came across a fix on Microsoft's support site saying remove something called COM Add-ins. I did so by following each step removing the one COM add in i found, and it did not resolve the problem at all. It still errors out. SO I grabbed the master disk and un... Read more

A:Solved: Microsoft Word keeps throwing up "Microsoft Visual C++ Runtime Library" Error, Arghh!

First, welcome back!!! (although, vaguely, it's like seeing your cousin after many years at a funeral...nice to see you, sorry about the circumstances....)
Well, this isn't fun - the more I looked, the more "answers" and causes I found...
(I think you probably did what the above is about - COM add-ins)
and two that seem similar, but aren't the same (good ol' MS!)

Good luck and let us know if you get this fixed - and what did it!

Read other 3 answers

Hello ,

I have three tables

1. Company Name Table
2. Address Table
3. Contact Person Name Table

Primary Key of Customer Name is cusid and the other tables are linked to this Company table by this Cus ID .

I have a requirement in which I have to write a query to get data from all these tables .Now it is easily possible if all the three tables have data for one Cusid ie 3 . But the problem is if any one of the table i.e Contact person name for a Cust id =3 THERE IS NO DATA but has address at cust id= 3 my query fails .I know a join can help me to get data from 2 tables but i am not sure how a join will help me to get this data from three tables even though there may not be data in one of the table.
Please HELP !!

A:Solved: Microsoft Access Query Problem

Read other 9 answers

I am trying to set up a field to increment for each new record. I know about auto increment but the way I have it set up their are two sets of numbers. 1 for the group number and one for the Item # of that group. The group number increments when a button is pushed. The Item number would increment either when a button is pushed or the user tabs through all the fields. Example 1-1,2-1,2-2,3-1, ect . I would also like their to be a way that if their is not data entered in a group or field that it can be either easily removed, or give an error that the form is blank and not go any farther. The code attached is in my database but it does not seem to work.
Thanks for looking,

Private Sub New_Item_Click()
Dim intnewrec As Integer
intnewrec = frm.NewRecord
If intnewrec = True Then
MsgBox "You're in a new record."
a = 1 + Item
Item = a
End If
End Sub

A:Solved: Microsoft Access Increment a field

Read other 16 answers