I've heard on the grapevine that the forthcoming Access2010 has a Data Macros feature which will for the first time add trigger-like functionality to Access data engine tables. Does anybody have an further details on this? For example, can they created in code (ACEDAO, SQL DDL, etc)? Does the Data Macro run if the data is modified from o...
I've been asked to research the ability to publish Access solutions directly to SharePoint as demonstrated in the demo below. http://channel9.msdn.com/shows/Access/Microsoft-Access-2010-Demo/ I'm going to keep searching via Google / Bing - but I thought I'd check here to see if anyone has any good links to information on this feature. ...
I have two queries that I am using to generate a report from, the problem is when I run the report, three fields do not show any data at all for some reason. Query 1: SELECT ClientSummary.Field3 AS PM, ClientSummary.[Client Nickname 2] AS [Project #], ClientSummary.[Client Nickname 1] AS Customer, ClientSummary...
BACKGROUND: The following works in Access 2007, but broke when I installed 2010 I have a WebBrowser control in an Access Form; I set its location as follows Me.WebBrowser0.ControlSource = "http://foo.com" and then execute a script in the page Script = "StartScript(null);" Me.WebBrowser0.Object.Document.parentWindow.execScript Scr...
We run MS Access as the front end for most of our business. When we upgraded from Access 2000 to Access 2003 the image control we used to print out Tif images failed to load Tifs anymore. A bit of Googling showed that MS did this intentionally and I'm wondering if the problem still happens in Access 2010. Can someone with a downloaded ...
Hi everyone, I want to know if there is a way to convert an MSAccess DataBase to a SQL Server database without starting from the beginning. Thanks ...
I recently upgraded to MS Access 2010. When I open a certain .mdb (2000-2003 file format), I am greeted with this message: collating sequence not supported with the specified file format. I'm not sure what it means, but it gives it to me every time the database is opened. I have Googled around but found nothing that I thought seemed rel...
I am using Access 2010 Runtime to run my custom database application. Office 2000 professional is also installed on the same machine. I use DoCmd.RunCommand acCmdSpelling a couple different place to perform a spell check on the data entered. This works great on the full version of Access 2000 but when I open it up in 2010 Runtime I get ...
Does anyone know how to access a Microsoft 2010 Access database from a Java program running on a Windows Vista OS? An open source, or at least free solution would be preferred, but I will consider a commercial product if necessary. I have tried a number of ways that I turned up by searching the web (all based on ODBC->JDBC), but none o...
I am trying to grok the following piece of code: Mid$(strV, i, 1) = Chr$(intChar And &HDF) What does &HDF mean? I also have a similar section that uses @H20. I have Googled high and low and the most I found was nothing that I didn't already know about them...that they are constants. ...
has anyone done this yet? please show me some good tutorials on building websites with databases using ACCESS 2010 you can build a website using it: http://www.youtube.com/watch?v=AU4mH0jPntI ...
I've encountered a strange error when attempting to update a SharePoint 2010 list that I have linked to via Microsoft Access 2010. Error: Data cannot be inserted because there is no matching record. This occurs in 2 scenarios: I attempt to run any UPDATE query against the list in MS Access I attempt to update a record from the list...
Is it possible to host microsoft access 2010 in WPF or Windows Forms as ActiveX or anything? I've seen DsoFramer examples but it's not supported from Microsoft and not to mention buggy. Some articles suggest using webBrowser but it's coupled with registry settings that I would not like to overwrite. Interobility at that moment isn't tha...
I cannot for the life of me find RunCode macro action in MS Access 2010. It should be in the drop down, or in the tree to the right of the macro editor. Where is it? ...
I am helping a friend with this database and when I select a record with the drop down it pulls up the correct record but when I TAB or hit ENTER it goes to the next record. How can I fix this? ...