ms-access-2010_开发者

Migrating from Access 2000/2003 to Access 2010

I want to use access 2000 and 2003 databases in access开发者_开发问答 2010. Since I don\'t want to check if everythings\'s working manually I am looking for a tool that analyzes VBA code for errors or[详细]

2023-04-12 00:15 分类：问答

Maximum Length of a SQL Query in Microsoft Access 2010?

Attempting to copy/paste a 159KB TSQL query into Microsoft Access开发者_如何学Go 2010 passthrough query editor (to a Microsoft SQL Server 2008 backend).[详细]

2023-04-11 12:09 分类：问答

MS Access to ASP.NET MVC 3 via SharePoint: using Linq to SharePoint

I am trying to see if you can use Microsoft Access Services, as available in Access 2010, to synchronise data between an MVC web app, and a Microsoft Access desktop solution.[详细]

2023-04-08 13:48 分类：问答

Is there a way to disable Access 2007's Code editors CTRL+Y Shortcut key?

Background I have used MS editors and applications for years including Visual Studio and office products and got use to CTRL+Y being redo. In fact so use to it doing that that I use undo CTRL+Z multi[详细]

2023-04-06 21:31 分类：问答

access 2003 application runtime error in access 2010 runtime

Hi I have a application designed in access 2003 that has its front-end and back-end split. The front-end has some tables used in the UI and a lot of queries, 开发者_StackOverflow中文版forms, reports,[详细]

2023-04-05 03:01 分类：问答

Subform not updating from other subform input in Access 2010

I h开发者_JAVA百科ave a database with 2 sub forms within a form with fields as below Sub Form 1: \'Qty Booked In\', \'Qty Booked Out\'[详细]

2023-04-04 16:37 分类：问答

how do i add multiple columns to a listbox using mixed data types in vba?

I\'m trying to add items (multiple columns) to a listbox. As I understand, in order to add multiple columns, you normally send them as strings like so:[详细]

2023-04-04 05:19 分类：问答

Can i create stored procedures in MS Access 2010?

Can i 开发者_运维问答create stored procedures in MS Access 2010 ? If yes please tell me how Yes, you can create Stored Procedure & Triggers.[详细]

2023-04-02 17:15 分类：问答

creating a mailing list from recordset in access 2010 vba?

I\'m trying to pull email addresses from a table and format them into a string that can be used in the \"TO:\" field of an outlook message. For some reason, the loop that i wrote is freezing the progr[详细]

2023-04-02 09:06 分类：问答

How to simulate UNPIVOT in Access?

UNPIVOT is available in MS SQL-Server 2005,开发者_StackOverflow but AFAIK not in MS Access 2010. How can it be implemented with on-board means? For example, I have a table[详细]

2023-04-01 17:36 分类：问答