Over 1 million tech questions and answers.

Microsoft Access 2010 Error

Q: Microsoft Access 2010 Error

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.

RELEVANCY SCORE 200
Preferred Solution: Microsoft Access 2010 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: Microsoft Access 2010 Error

Read other 6 answers
RELEVANCY SCORE 68

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
RELEVANCY SCORE 58.8

Hi there,

I am working on a database in Access 2010.

I am trying to create a report that appears once a specific combo box is filled out for a particular field in the form I am working in. Basically, when a value is put in the combo box, the combo box will filter the form for all the records that match the criteria in the combo box. The filtered records should then populate into the report that appears.

The reason why I need this report is because I would like to be able to view all the of the particular records and be able to sort for various fields more efficiently.

Can anyone help?
If you can solve this I would really appreciate it!
 

A:Microsoft Access 2010 - Report Help II

You cannot sort a report once it is presented. You can easily set the report criteria to use the combo box value on the report. Just create a query that runs the way you want it with all of the fields you want to be presented in the report along with the combo box value. Set the combo box filed to be the criteria for this query and then base the report off of this query.
 

Read other 1 answers
RELEVANCY SCORE 58.8

I have a simple document tracking database that I wrote in the late '80's and have migrated up through the newer versions of MS Access. Recently when I am editing a date entry form it will crash while I'm working. The error message is always similar in that only the "Exception Offset" changes. I have never gotten a response in any form MicroSoft regarding the error that one would receive for an error message being forwarded. [See 1st attachment]

Today I got a notification saying that I was not forwarding information to MS - so I did. This time a get a different "Problem Reporting" message. [See 2nd attachment]. I was looking at the temp files it created and decided to "Send information" and clicked the button. Again no response from MS. I went back to the temp files folder and now it was empty! A lot of good they did luckily [maybe] I had the AppCompat.txt open so I was able to save if someone can understand the code.

A:MicroSoft Access 2010 keeps crashing w/ W7

Perhaps you could try a repair by doing the following:

Click Start, then click Control Panel.
Click Programs and Features.
Click the Office 2010 program that you want to repair, then click Change.
Click Repair, then click Continue. You might need to restart your computer after the repair is complete

More details here:
Repair or remove Office 2010 - Project - Microsoft Office

Read other 2 answers
RELEVANCY SCORE 58.8

I need help trying to set up an "auto number" that formats like ###-# which represents the month/yr-number, ie: 111-1 for January 2011-1....is there any way for this to work so that each month this will automatically change to 211-1, 211-2, for February's days and 311-1, 311-2 for March, etc. I would appreciate our help so much. Thanks!!!
 

Read other answers
RELEVANCY SCORE 58.4

Hi Guys

I have a question..

I have a database called customers with their information (First Name, Last Name, street address etc)

I have written a personalized letter and would like to send it to each customer in the database

Dear Joe Bloggs
It is with great pleasure that we would like to inform you ........

Your Sincerly
...............

What I want to do is, Replace "Joe Bloggs" with the name of each of the customers

If I had Sue Rain as a customer the letter would be

Dead Sue Rain
It is with great pleasure that we would like to inform you ........

Your Sincerly
...............

I will need to Email the personalized letter to each customer

Hope someone can help

Mark

A:Microsoft Access 2010 Personalized Letter?

You can do this by having Access drive either Outlook or the system's default email program, but you have to do this with VBA code. If you know how to write VBA I can send you some sample code that works. There is a condition though - if the email requires attachments the code is more complex and must use Outlook. If it is just a simple text-only email then the code can be simpler and can use the system's default email program. In my case I had to accommodate attachments (up to 5 of them!) so I had to do the more complex code for Outlook.

Read other 1 answers
RELEVANCY SCORE 58.4

I have been making a database spreadsheet on Microsoft Access I was wondering does anyone know how to make it read only so no one can change the data when reading it. 
 
Also are there any software applications I could get to make the security better? 
 
 thank you  

A:How to make Microsoft access 2010 read only?

You can make a file read-only by navigating to it in Windows Explorer, RIGHT clicking on its name then selecting 'Properties' from the pop-up menu. At the bottom of the general tab in properties you will see 'Attributes'. If you then tick the 'Read-only' box you set the file read only. This will only protect the file against accidental changes since it is just as easy to un-set the attribute.
 
In 2007 and 2010 you can password protect the file against unauthorised readers but it adds no more protection against authorised readers !
 
There may or may not be any third party applications which will do what you want, it's not an area I know anything about.
 
Chris Cosgrove

Read other 1 answers
RELEVANCY SCORE 58.4

I'm running Windows 8.1 via BootCamp on a 13" Retina MacBook Pro. Everything seems to be running great, apart from some images being distorted or out of place, which I'm assuming is just due to the higher resolution.

One of the big annoyances I'm having is with Microsoft Access 2010. The spacing on the Navigation Pane much much larger than it should be, and though it doesn't seem that much, its tripling the time it's taking to do anything productive. I've noticed on some other programs (such as Visio 2010) things like dialog boxes aren't showing all the content (text fields being off the screen with no way of filling them in).

I have tried several different resolutions and changing the scaling, none of which seem to do it any favours.

I've attached an example of the Access problem below.

Now I'm not sure if this is a BootCamp problem or something specific running these applications on Windows 8 but does anyone have any ideas how to fix problems like this?

Read other answers
RELEVANCY SCORE 58.4

While working on Access 2010 in design mode, I get a message "Access not responding" with the following error message

Problem signature:
Problem Event Name: BEX
Application Name: MSACCESS.EXE
Application Version: 14.0.4750.1000
Application Timestamp: 4b8bade7
Fault Module Name: MSVCR90.dll
Fault Module Version: 9.0.30729.4940
Fault Module Timestamp: 4ca2ef57
Exception Offset: 0006ccb5
Exception Code: c0000417
Exception Data: 00000000
OS Version: 6.1.7601.2.1.0.256.48
Locale ID: 13313
I have to close the program and open it again

A:Microsoft Access 2010 not responding message

Does this happen with one specific database or all?

Read other 2 answers
RELEVANCY SCORE 58.4

I'm trying to make a command button on a form that opens a report filtered based on the current form record. All the fields on the form that match the report would be filled in on the report. I'm not quite sure how I would do this. Can anyone help? Thanks.
 

A:Solved: Microsoft Access 2010 - Report Help

Read other 15 answers
RELEVANCY SCORE 58.4

When I attempt to open it the message reads MICROSOFT WORD STARTER 2010 CANNOT BE OPENED. TRY AGAIN OR REPAIR THE PRODUCT IN CONTROL PANEL. I attempted to repair and can't locate the repair link.

Please Help

A:cannot access my microsoft stater package 2010..

Open Control Panel, select Programs & Features, find Microsoft Office, Right Click on it & select Change & that should give you some options to try.
Hope this helps.

Read other 1 answers
RELEVANCY SCORE 58.4

Hi,
I need to access a workspace on Microsoft SharePoint Workspace 2010, But I do not have Office Pro 2010, and I can't find a download link.
Does anyone know any way I can connect to this workspace?
Thanks.

A:How can I access a Microsoft SharePoint 2010 Workspace?

Is this work related? From my little experience with SharePoint, the "owner" of a site must grant permissions for users to access it.

Read other 2 answers
RELEVANCY SCORE 55.2

I am getting an error message when I use Office 2010 Word & Excel. The message is 'Offspon.exe has stopped working'. Any suggestions please?
I am using Windows 7
Many thanks
 

Read other answers
RELEVANCY SCORE 55.2

hey guys i'm just want to install microsoft office 2010 in my windoww 7 sp1...






Quote:



but something say like this:






Quote:



anyone know the solution?
thanks.

A:something error with my microsoft office 2010

??? Whats the error message?

Regards,
Golden

Read other 3 answers
RELEVANCY SCORE 54.8

I have a form to update the hardware of a PC for an asset database (see image attached), it features a main form which shows the current information for that computer and a subform which creates a new record for that PC with all the new information. The problem is that when i enter new information into the subform and click onto the main form it automatically creates and saves the new record which is what i want to stop.
I would like the subform to save/cancel the data entry through the save and cancel buttons i have rather then it creating a new record automatically.
Any help would be appreciated.
 

A:Solved: Microsoft Access 2007-2010: Stopping Automatic Saving On Data Entry Form

Read other 8 answers
RELEVANCY SCORE 54.4

Running win 7 64 bit.
keep getting same error.
what should i do?

A:Error when installing microsoft office 2010

Are you installing Office 2010 over 2007 and are you installing it as Administrator?

Read other 9 answers
RELEVANCY SCORE 54.4

could someone please help

im installing office professional 2010 from disc the setup runs fine and then asks me to agree the license terms etc that runs fine then its says upgrade or custom i just click either and this message comes up and it wont let me go any further could you please advise me.

the message says

Setup has detected legacy groove or microsoft groove server software on this system. you must uninstall all legacy groove and microsoft groove server software before installing or upgrading to microsoft sharepoint workspace. for more information see your microsoft sharepoint workspace administrator.
The big problem is i don't even knows what the Groove Legacy is and have looked into the programmes and can't find the Groove legacy there,

could you please advise me

A:microsoft word 2010 installation error

See if Groove is in your Programs/Features in the Control Panel.

Read other 13 answers
RELEVANCY SCORE 54.4

I have installed Microsoft Office Professional 2010 and used it but now I can't use it anymore because it comes with the message that says, "Microsoft Office Professional 2010 cannot veriry the license for this product and that I should repair it by using Control Panel and yet I have tried that several times but it couldn't help so what must I do now?
 

A:Microsoft Office Professional 2010 error

You don't use control panel just the Office Software, you can double click it and when asked what you want to do you choose repair.
If it still doesn't work then I suggest the Microsoft Support site. I imagine you have the original DVD / CD?
 

Read other 1 answers
RELEVANCY SCORE 54

I had this error when I was trying to open a file in Microsoft Access. I believe this is the first time I have opened a access file and that's why it started to configure. Any solutions? Excel, Word, Power point and everything else opens just fine.

A:Microsoft Professional Plus 2010 Office Configuration Error

Something here could assist:
Error 1935 when you try to install Microsoft Office 2010 or 2007

Read other 1 answers
RELEVANCY SCORE 54

I am running Windows Vista and when I try to install Microsoft Word 2010 it comes up with the following error message "Microsoft Word 2010 encountered an error during setup" but does not give any error code.  I've tried more than once to install
making sure I was under an administrator account but it still does the same thing.  I've searched for answers but nothing has helped.
Does anyone know what is going on and how I can fix this so I can use Word?
Thank you for any help you can provide.

Read other answers
RELEVANCY SCORE 54

I have microsoft office 2010 on my laptop. I get the following message when I try to use any of the office programs (excel, word, etc.). "The operating system is not presently configured to run this application". Does anyone have a solution?
 

A:Solved: Error message for Microsoft Office 2010

Read other 6 answers
RELEVANCY SCORE 54

Hey TSG,

I use Microsoft Office 2010 and am receiving the error message "There was a problem sending the command to the program" whenever I open a Word document from My Documents. [see screenshot]

This error message does not pop up though if I open the file from within Word.

All documents being tested are .docx file types saved using Word 2010.

After Xing off the message or clicking "OK", Word is fully functional.

I'm at college and the installation disks are back home, so there's no hope for re-installation being my fix anytime soon (unless I go home this weekend).

Any ideas?
 

A:Solved: Microsoft Word 2010 Error Message

Read other 12 answers
RELEVANCY SCORE 54

Anyone has any idea about Microsoft SharePoint 2010 servers?

I am trying to click "Manage User Profile" under the Service Application. But whenever I do so, I get this below error.

The service is already running. I am trying to setup personal sites for each user to access their /my page. But I keep getting that above error.
 

Read other answers
RELEVANCY SCORE 54

Hey Guys,

I have office 2010 installed on my laptop, I am trying to launch Office OneNote 2010 and I get this error. The specs on my laptop are Intel Core i3 2.27GHz 4GB DDR3 500GB HDD 17.3" Screen. The error is in the following attached image below.

I can't not under stand why this part of Office doesn't work meanwhile all the other components of Office 2010 work just fine. I have gone in and tried to check the Permission with the Office OneNote 2010 with my user account and it was set to full control. I have tried reinstalling Office as well, and still nothing same problem. I have 410GB Free space on my hard drive. I have plenty of free ram left as well. This problem is driving me nuts because I don't see any reason why it's not working, when I installed it I didn't get any error nothing through out the installation.

Thanks
RitualJman

A:Microsoft Office OneNote 2010 Start Up Error

How much free space on the partition where office is?

Read other 3 answers
RELEVANCY SCORE 53.2

Hi guys,
I cant this update for days:
Definition Update for Microsoft Office 2010 (KB3114412) 32-Bit Edition - Error 0x80070643

It fails every time. What can I do?

A:Microsoft Office 2010 (KB3114412) 32-Bit Edition - Error 0x80070643

Bumperinjo.

Read other 0 answers
RELEVANCY SCORE 53.2

I am running Windows 7 64-bit on an Alienware M14x.

Okay, let me list out all the problems.

It will not install updates correctly, meaning it will reboot two times before it says, "failure to update, reverting changes" and allow me to log into my computer. Sometimes it will take 15 minutes per "Configuring Windows, please wait" screen.

It is also not allowing me to download Microsoft Office 2010. I keep getting this error code:
Error 1935. An error occurred during the installation of assembly component {A75F2217-AD54-3EA6-AE14-F255F8660531}. HRESULT: 0x8007054F.

And none of the updates are sticking.

Every time I close out of Windows Update after installing a Security update, it says there are updates available, and it's another Security update. wtf? Also, I get the error code "Code BC9, Windows Update encountered an unknown error" when it tries to install Internet Explorer, so that doesn't install either.

I did a diagnostic test, and nothing came up as an actual system error, so it's just all Windows itself.

Here is the HijackThis log.
Pastebin

Edit: I ran a full scan on Microsoft Security Essentials and it found a trojan and two other issues. I promptly removed them. However it still didn't repair my update issues (which might be due to a connectivity problem) or my Microsoft Office 2010 problem.
 

Read other answers
RELEVANCY SCORE 53.2

I have been trying to install Microsoft Office Standard 2010 for two days on my laptop running Windows Vista. Every time I try to install it I get an error message that simply says "Microsoft Office Standard 2010 encountered an error during setup." That's it. No error code, no description of the problem. I have tried many solutions I've found on Google, but nothing works. I have uninstalled my Office 2007, and even taken steps to ensure that it was completely removed. I've also renamed the Microsoft Help folder, and tried some "fix it" programs on Microsoft's web site. I cannot find the right solution anywhere. I know it's not my copy of the installation disk, because I installed it on my Windows XP netbook earlier this week and had no problems (I have multiple licenses). Does anyone have an idea?
 

A:Microsoft Office Standard 2010 Encountered an Error During Setup

Have you used the microsoft office removal tools that Microsoft offers on it's site.
You'll have to google for these because I don't know the exact link.
I ran these because I have rests of other MS Ofice installtaions on my disk, and yes the error codes are just as clear as a foggy day in London.
You could also use a tool like CCleaner to have it chekc the regsitry for invalid items.
Good hunting, it's a nuisance
 

Read other 1 answers
RELEVANCY SCORE 52.8

My Microsoft Office package was already activated, until couple days ago while opening Office Word I had this kind of message:

This copy of Microsoft Office has not been activated (*translated from Finnish)

[--]

Error code: 0xC004F074


I don't understand what's wrong with this. The message just suddenly came without any major updates taken place. I have tried to google other threads, without any succeed.

Any suggestions?

P.S. I'm quite handy with computers but not an expert, so please instructions which can be understood.

A:Problem with Microsoft Office 2010 - activation error code 0xc004f074

The License type here appears to be KMS - which requires a dedicated KMS server to activate against at least every 180 days.

It's a Volume License - if you purchased this license retail, then it's counterfeit.

Read other 1 answers
RELEVANCY SCORE 52.8

whenI try to install Microsoft office +2010 a new computer with windows 10 I get error code 1935. Is it compatible? Just bought the new pc

A:1935 error when install Microsoft office 2010 on new comp windows 10

Is that the full error message?

Sometimes it pops up when you try and install a program and there's another program running that 'clashes' with the install process or it could possibly be an issue with the correct version of .NET not being installed , but it depends what the full message is.

Read other 1 answers
RELEVANCY SCORE 52.8

I am getting "Microsoft Office Professional 2010 cannot verify the license for this product. You should repair the Office program by using Control Panel." error this morning after booting up the system.

There was a MSFT update that ran last night, and I'm suspicious of it being the trigger of the error.

I have tried the "repair" option for MSO 2010, and have also re-entered the "key", to no avail.

Has anyone else had this problem? Any other ideas?

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Professional, Service Pack 1, 32 bit
Processor: Intel(R) Core(TM) i5-2400 CPU @ 3.10GHz, x64 Family 6 Model 42 Stepping 7
Processor Count: 4
RAM: 3493 Mb
Graphics Card:
Hard Drives: C: Total - 476837 MB, Free - 401466 MB;
Motherboard: Intel Corporation, DH61BE
Antivirus: AVG Anti-Virus Business Edition 2012, Updated and Enabled
 

A:Microsoft Office Professional 2010 cannot verify the license for this product ERROR

Hi there, welcome to the board!

Have you tried uninstalling the update? Do so from the Control Panel. There's a button which will toggle showing updates. I'm not aware of any updates which will do this though. I'd start there, maybe trying to open in safe mode, but that seems like a stretch.
 

Read other 2 answers
RELEVANCY SCORE 52.8

I have spent at least six hours (probably longer) researching and attempting to install a recently purchased download version of Microsoft Office 2010 Professional Plus.

I spent a good deal of time uninstalling (completely) a previous, nag-screened unregistered, copy of Office 2010. I used the Microsoft Cleanup Utility. I ran several programs to clean up after all this, including Crap Cleaner.

Each time I go to install Office, I enter the key (#), and get the prompt saying that there is ERROR 1402. Setup cannot open the registry key.

I have done at least a dozen things to resolve this issue, including doing a diagnostic boot, with only essential services and processes running; disabled the firewall and virus protection; read of various other remedies, none of which has worked.

I have gone to regedit several time trying to change permissions of certain registry files. Some seem to change okay. Others will change, then when I click okay, the permissions resort back to what they were prior. Other things, like clicking certain boxes about inheritance, won't stick ticked. I find the whole permissions thing a nightmare.

My head is spinning. Is there a tried-and-true remedy for fixing this issue?

Another question: Does Microsoft provide free installation support for its Office products?

Any and all suggestions would be greatly appreciated!

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 64 bit
Proce... Read more

A:Solved: Error 1402 While Installing Microsoft Office 2010 Professional Plus

Read other 9 answers
RELEVANCY SCORE 52.8

Greetings,

I have a control, ďAge When VictimizedĒ with the code listed below thatís automatically populated with the personís age at the time they were assaulted. I added a list box to the form and now rather than display the personís age, Iím receiving ď#Name?Ē. I made no changes to any of the fields/names referenced in the code. If I delete the list box, the age is displayed. I would really appreciate assistance on this as I would like to keep the list box. Thanks.

=DateDiff("yyyy",[Victim_DOB],[Incident_Date])+IIf(Format([Incident_Date],"mmdd")<Format([Victim_DOB],"mmdd"),-1,0)

Ellie,
 

A:Solved: Access 2010 #Name? Error

Read other 10 answers
RELEVANCY SCORE 52

Hi this Christmas my laptop started giving me bluescreens and corrupt windows messages (even though it was installed with the same windows it came with) so I formated it with the original CDs installing again the original windows 7.
But since then I've been having some troubles with some windows uptates: 
KB3020399; KB2901983; KB2984981; KB2913545 and others and I can't install Microsoft Visual C++ 2008 or 2010 so I cannot instal software that requires it.
Can anyone help me with this please?
Thanks

A:Can't install Microsoft Visual C++ 2008 or 2010: Error 997. Overlapped I/O operation in progress

Hello Tbtouaki,
About the error message ?Error 997. Overlapped I/O operation in progress.?, please take a look at the following blog.
Error 997. Overlapped I/O operation is in progress: KB2918614 breaks Windows Installer Service
http://blogs.msdn.com/b/vsnetsetup/archive/2014/10/27/error-997-overlapped-i-o-operation-is-in-progress-kb2918614-breaks-windows-installer-service.aspx
Resolution: Please apply this hotfix
http://support.microsoft.com/kb/3000988
About the error code ?Code 643 Windows Update encountered an unknown error.? When you use Windows update.
Please take a look at the following KB.
http://support.microsoft.com/kb/976982
1. Use the fix tool in the link
2. Uninstall and reinstall the .NET framwork
Best regards,
Fangzhou CHENFangzhou CHEN
TechNet Community Support

Read other 6 answers
RELEVANCY SCORE 52

Well I have run into a problem. In installing Access 2010 on my Windows 7 64 bit ultimate I get to the point where my product key is verified on line via MS BUT part way maybe 2/3 through the install ( all security turned off ) it pops up an error message 1402.

I do still have MS Basic Office on the setup but I received no information I can't do that.

See attached image of popup. This error relates to being unable to access a registry key and questions the permissions. There are others with the same issue. Installing in safe mode gave a no can do message.

Please advise.
 

Read other answers
RELEVANCY SCORE 51.6

I have run this code before successfully on my database numerous times and today it decided it didn't want to so it any more and i can't find a solution. It runs the code fine and saves the report as C:\CATTLE_PAYMENT_EMAIL\CATTLE_PAYMENT.PDF absolutely fine.
However it errors on the final line of code "Name File As NewFileName" with Run-time error '5': Invalid procedure call or argument.

I have tried all of the following: Renaming the variables, compacting and repairing the database, running the code on another computer, cross-referencing other access programs that run the same code to make sure they contain the same references, checking all the code on the same database to make sure the variables are not declared twice, checked the form for anything named the same as the variables.

I have 6 references:
1. Visual Basic For Applications
2. Microsoft Access 14.0 Object Library
3. OLE Automation
4. Microsoft Activex Data Objects 2.1 Library
5. Microsoft DAO 3.6 Object Library
6. Microsoft Outlook 14.0 Object Library

Here is the code:

'Save Cattle Payments Report
Dim File As String
Dim NewFileName As String
Dim MsgAtt As String

FileName = "Cattle Payment Authorisation:" & Me.BatchID & " " & Me.TradingNameFarm & " " & Mid(Date, 1, 2) & Mid(Date, 4, 2) & Mid(Date, 7, 4) & Mid(Time(), 1, 2) & Mid(Time(), 4, 2) & Mid(Time(), 7, 2)

MsgAtt = "C:\CATTLE_PAYMENT_EMAIL\&... Read more

A:Access 2010: Rename File & RunTime error 5

I can't really think of anything that would cause that to happen other than an MS Security Download affecting the Registry.
Can I ask why you save the File as "C:\CATTLE_PAYMENT_EMAIL\CATTLE_PAYMENT.PDF" and then rename it "C:\CATTLE_PAYMENT_EMAIL\" & [FileName] & ".PDF"?
Why not just save it as "C:\CATTLE_PAYMENT_EMAIL\" & [FileName] & ".PDF" in the first place?
 

Read other 3 answers
RELEVANCY SCORE 51.6

I am trying to get my Access database to send an email to the user when a subpoena is due. Listed below is the code:

Option Compare Database
Option Explicit

Function GenerateEmail(MySQL As String)
On Error GoTo Exit_Function:
Dim oOutlook As Outlook.Application
Dim oEmailItem As MailItem
Dim MyEmpName As String
Dim rs As Recordset
Set rs = CurrentDb.OpenRecordset(MySQL)
If rs.RecordCount > 0 Then
rs.MoveFirst
Do Until rs.EOF
If IsNull(rs!Email) Then
rs.MoveNext
Else
'Set oOutlook = GetObject(, "Outlook.Application")
If oOutlook Is Nothing Then
Set oOutlook = New Outlook.Application
End If
Set oEmailItem = oOutlook.CreateItem(olMailItem)
With oEmailItem
MyEmpName = DLookup("empname", "tbl_RecsReq", "[reqID] = " & rs!EmpName)
.To = rs!Email
.Subject = "Task due in 30 days Reminder for " & MyEmpName
.Body = "Request ID: " & rs!reqid & vbCr & _
"Case Name: " & rs!CaseName & vbCr & _
"Employee: " & MyEmpName & vbCr & _
"Task Due: " & rs!DueDate & vbCr & vbCr & _
"This email is auto generated from the 3rd Party Subpoena Database. Please Do Not Reply!"
'Display email in Outlook
.Display
'Send email out without open Outlook, silent sent behind the screen.
'.Send
rs.Edit
rs!DateEmailSent = Date
rs.Update
End With
Set oEmailItem = Nothing
Set oOutlook = Nothing
rs.MoveNext
End If
Loop
Else
' do noth... Read more

Read other answers
RELEVANCY SCORE 51.6

I have two cascading combo boxes. I set up three tables. The first table is the distributor table that contains the distributor name, address, etc. The second table is a list of services the distributors may provide. The third table is a list of each distributor and the service they provide. (Dist Services).

Each distributor only supplies a limited number of services. So I use cascading combo boxes to limit the services to only what that distributor supplies. In the After Update of the first combo box, I have the following code:

Me.Service_ID.RowSource = "SELECT DISTINCT [Service ID] " & _
"FROM [Dist Services] " & _
"WHERE [Distributor ID] = " & [Forms]![Sale Form]![Sale Coupon Subform].[Form]![Distributor ID] & _
" ORDER BY [Service ID]"

When I go to the second combo box (services), the services listed are for the previously chosen distributor. I have tried adding requery, but it isn't working. Any suggestions?

Barbara
 

A:Solved: Access 2010 Cascading Combo Box error

Read other 16 answers
RELEVANCY SCORE 51.6

I'm working on a search form in Access 2010 that when the reset button is clicked, all of the controls in the form's header is cleared of info (All combo boxes, text boxes are cleared). I've used this code on 3 other search forms with no problem, but when I try it on this one, a dialog box pops up that reads, "Run-time error '2448': You cannot assign a value to this object" When I hit the debug button it highlights the line of code that just clears the controls for combos and texts. I cannot for the life of me figure out what is wrong with it. Like i said, I have the exact same code being used in other search forms, with no problems.
Code:
Dim ctl As Control

'Clear all the controls in the Form Header section.
For Each ctl In Me.Section(acHeader).Controls
Select Case ctl.ControlType
Case acTextBox, acComboBox
ctl.Value = Null '<--- This is the line that get highlighted when i press the debug button on the error message
'Case acCheckBox
' ctl.Value = False
End Select
Next

 

A:Access 2010 Runtime Error 2448 So confused

Is there a control source set for either of the controls in the case statement?
 

Read other 2 answers
RELEVANCY SCORE 51.6

I was recently hired to work in a recreation department on a special event that happens every year. The Rec Department uses an Access database. I have no idea how old this database is. My boss has been working here for 10 years and she said the database was in place when she was hired.

One of the things my boss wants me to do is to add the date on the page footer of all the reports. I have tried using the wizard on the ribbon, using the expression builder, and just typing in =Date() into the control box. Any way I try it, I still get an #Name? error when I run the report. I was hired because even though I think of myself as a complete beginner when it comes to Access, apparently, I know more than most Admins about this program. That being said, I am an Administrative Assistant and not a programmer, nor do I have programming experience, so please keep that in mind when you answer this.

I checked in the VB editor under tools - references and it seems this organization is missing the utilities.mda file. I tried a search but it was not found. Could this be a reason for the error? If it is the reason, what would be a work-around?
 

A:Access 2010 Report #Name? error in =Date() control box

Read other 6 answers
RELEVANCY SCORE 51.6

Can someone help me?
I tried to install Microsoft Access database engine 2010 (file ver. 14.0.6119.5) but I got error message:
"Error 1935. An error occured during the installation of assembly component {9DA4DC8A-9731-3F0E-8BD5-FC17CA6848AD}. HRESUL: 0x80073712"

I tried to install this DB provider on computer with
WIN7 prof. 64-bit (DELL) SP1
MS Office 2013 32-bit.
.NET Framework 4.5.1

I tried to reinstall .NET Framework (I found some procuderes how to solve this kind of errors) but without success, still the same error message.
I have also similar computer with the same configuration (Win7 Professional 64bit + Office 2013 32bit + .Net 4.5.1) and installation succeeded without problems.

Have anyone some idea how to solve this problem? Thanx

A:Cannot install MS Access DB engine 2010 - Error 0x80073712

Hi tsarbomb, welcome to Windows Seven Forums.

Have a look at these MS website & see if it helps you. Read through them first & see if the solutions fit your problem.

https://www.microsoft.com/en-au/down....aspx?id=13255

This one might help you as well.

Error 1935. error during installation of assembly... - how to fix? - Microsoft Community

Read other 1 answers
RELEVANCY SCORE 51.6

I'm working with query that is used to keep track of what items need to be calibrated and when. The fields being used for my particular situation are Last Calibration Date, Calibration Interval, and Calibration Due date. What I want to happen is for the Calibration Due Date field to display the Calibration Interval (in months) added to the Last Calibration Date. Using the DateAdd function, I was able to do that fairly easily. My problem is, there are some entries that do not have a Last Calibration Date entered into their record. For those records, I don't want the "#Error" to show up in the query, I just want it to remain blank. I'm using Access 2010 on Windows XP.

Thanks,
Dobber9
 

A:Solved: Access 2010 Error Handling with DateAdd

Dobber9 , welcome to the Forum.
You can enclose your current calculation in an IIF() statement, something like
iif(isnull([Last Calibration Date]), "", your calculation goes here)
 

Read other 2 answers
RELEVANCY SCORE 50.8

I have found from several forums and support sites including Microsoft that many users are asking solution for the error generating by MS Access 2010 or 2007 while running their custom made Access 2003 database usually after after upgrade.
The error is showing as "The expression On Click you entered as the event property setting produced the following error: The expression you entered has a function name that Microsoft Office Access can't find."

The solution is as below:
This error is causing due to disabled macro setting by default. So you will need to enable the macro as per the following method.
Go to File > Options > Trust Center
Then Click on "Trust Center Settings".
Here click on the Option " Show the Message Bar ... ..."
Re-open the Access File in exclusive mode
Now click on the yellow message bar on to to enable macro..... ..... problem solved.
 

A:Access 2010 or 2007 upgrade error for 2003 database

Welcome to TSG and I appreciate the pro-active post.

A another solution is to learn the Trust Center. In there you can enable all macros.
 

Read other 1 answers
RELEVANCY SCORE 50.8

I have multiple office locations that don't have a network or computer expertise but they do have email. I needed to get them to enter their budget data, export it and then email it to a central office where each department's export to excel will be imported into the master database to be worked with further there. I didn't want the employees to have too many difficult operations so I set up a query to combine all their tables into one query and then one button click exports it to an email to a guy at the central office. The problem is that once he gets these emails in, I want him to be able to append each of their spreadsheet data back onto the three tables that they were originally on. He will have to do this for each department that sends him info. The problem is the append query only works for the first table. I have set him up with imports into an IMPORT DATA table. Once there, the append queries are to query out just the data to append to the PROJECT table, then another append query is to get the data for the COST table and the third is for the FUNDING table.

Only the Project table which is the lead table in all the relationships will run this append query. The other two keep losing the data in the query. Everytime I reopen the query I see that the fields I had put on them are gone and the query is blank again. I am getting this message "Reserved error(-3087); there is no message for this error".

Can you point me in the right direction?

Marg... Read more

A:Solved: Access 2010 append query error message

Read other 6 answers
RELEVANCY SCORE 50.8

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM) i7-2600 CPU @ 3.40GHz, Intel64 Family 6 Model 42 Stepping 7
Processor Count: 8
RAM: 8172 Mb
Graphics Card: NVIDIA GeForce GT 555M, -2048 Mb
Hard Drives: C: Total - 1881952 MB, Free - 1827181 MB;
Motherboard: LENOVO, 7745
Antivirus: Microsoft Security Essentials, Updated and Enabled
I have a command button on an access 2010 switchboard in a program I made that is supposed to launch an excel program I made. Most everything was created in Access 2002 and excel 2002 though some features were added in Office 2010. This command button and others which launch other reports and forms in access all were working well. I use all of this in compatibility mode.

Now I have updated to a new computer with Windows 7. Everything else seems fine. However, the command button to launch the excel program gives me a message: "There was an error executing the command." It opens the program anyway though keeping the access switchboard and the error message in the foreground.

Additionally, and this may be unrelated, if I close the excel program and then attempt to reopen it with the command button, I get the same error message but excel does not open at all. If I close down everything and open the access program again it is the same cycle.
 

A:Access 2010 command button error since updating to Windows 7

Read other 8 answers
RELEVANCY SCORE 50.4

Sorry, this might be resolved in the archives somewhere but the problem is so uncharacteristic I'm just going to post it.

I'm doing some data validation on a pair of combo boxes that can't have identical values. The code is really simple:
Code:
Private Sub cboFirstField_Change()
On Error GoTo ErrorHandler

If Fields_Match() Then
[B]Me!cboFirstField.Undo[/B] [COLOR="SeaGreen"]' <-- This is the line that breaks[/COLOR]
End If

ExitHandler:
Exit Sub

ErrorHandler:
MsgBox "Script execution error in cboFirstField_Change" & vbCrLf & vbCrLf & _
Err.Number & ": " & Err.Description, _
vbCritical + vbOKOnly, _
"Error"
Resume ExitHandler
End Sub
I put the same routine under the Change event for both combo boxes. Every time I test it on either field, I get a 438 ("Object doesn't support this property or method") on execution of the Undo statement.

Per the Access 2010 reference, ComboBox objects support an Undo method, and the relevant statement in my code is identical to the example provided.

So, I guess I'm really confused? Does anyone see a glaring issue with my code?

chris.
 

A:Solved: Access 2010 combo box Undo method throwing an error

Read other 11 answers
RELEVANCY SCORE 50

I have an Access 2000 database that I'm having some problems with. First, it's using replication, and I need to get away from that. So I'm creating a new database and bringing all the existing objects into it. The new database is in Access 2002-2003 format (according to Access) at this point, but I am working on it in Access 2010 (every copy we had of Access 2003 running older machines was destroyed in Tropical Storm Irene). I note at this point that I didn't write this code or create this database. It was built a long time ago by one employee who retired and doesn't remember much about the database, and another who retired and had added on it I can't even get to answer my emails right now. This database was originally written in Access '97, then converted to an Access 2000 database and it hasn't been touched with conversions since then. So, to the actual problem:

When I try to open up the first, most important form in the database, I get this error:
Compile Error: User-defined type not defined.

And it's highlighting a line of code that reads:
Dim Cmd As ADODB.Command

I tried doing some searching for this error and added a reference to ActiveX Data Objects 6.0 library based on some of what I read. That didn't help. I'm not entirely sure what this sub is trying to accomplish, and so it's hard for me to figure out if these ADODB commands even make any sense to be doing when everything is self-contained (this databas... Read more

A:Access 2000 to 2010 convert ADODB.Command error on page load

Read other 8 answers