ms-access-2010

相关标签：javascript jquery android 多少钱 iPhone

MS Access Table with Multiple foreign keys to same table

I have a table in MS Access that has 4 columns in it and they all contain an id that is the primary key in another table and I want to know if there is another way to do this and if not how can I get[详细]

2023-03-31 19:28 分类：问答
Can I add a button in an Access stock program to search Outlook?

Is there a way I can make a button on an access database that automatically searches Outlook? My idea is to have a button besides the email address which ca开发者_开发知识库n be clicked and it will op[详细]

2023-03-29 01:22 分类：问答
Access 2010: filter from multiple records in memo field?

I\'ve poured through here looking for an answer to this, but haven\'t found it anywhere. I have an Access 2010 database with two tables:[详细]

2023-03-28 06:16 分类：问答
Microsoft Access 2010 Link Data Service to SOAP web service

I have been tasked with calling a web service from Microsoft Access 2010 when a row is inserted into a table.[详细]

2023-03-25 17:36 分类：问答
Access 2010 - Need to replace a null with a value

I have a query that looks at two times and calculates the difference and puts the value (in seconds) in another field. I then sort that field. The problem is when one of the times is empty the row in[详细]

2023-03-25 17:13 分类：问答
how do i determine what the next record number (PK) is?

im trying to get the next number in the autonumber sequence for the primary key programatically. For instance, if the last number in the table was 10, i need it to return 11. Before, I would use somet[详细]

2023-03-25 09:31 分类：问答
how to select top N in access report detail section or select top N in sql subquery

I have a report that is based on a query. In the detail section of the report I want to limit the number of det开发者_开发百科ail lines to top N. (likea select TOP N type query). In this sample I want[详细]

2023-03-25 03:10 分类：问答
Using VBA to create a dynamic table in Access 2010

I have an Access 2010 database with a VBA module that does some statistical analysis on the data.The results of the statistical analysis cannot be generated by SQL, but they can be presented in tabula[详细]

2023-03-21 16:47 分类：问答
VBA code works in Access 2007 but doesn't work in Access 2010. Any ideas?

My wife wrote the following code and it used to work fine for her when her organization used Access 2007. They just updated to Access 2010 and it no longer works. I am not familiar with Access at all[详细]

2023-03-18 01:27 分类：问答
ACCESS SQL: TOP 1 of a subcategory (or MAX())

If the question doesn\'t seem very clear, it should be after this explanation ! Here is my table: Flights (AC, hours, cycles, flight_date)[详细]

2023-03-16 03:25 分类：问答