ms-access
Syntax error when Insert to Access using OleDb
I do not have a lot of experience in vb.net, but I am trying to use OleDB to insert a record with String,string,Yes/no(studentname, number, gender). However when I insert it , there\'s a exception rai[详细]
2023-04-09 18:27 分类:问答Adding an Access 2003 System DSN in Windows 7 [duplicate]
This question already has answers here: Closed 11 years ago. Possible Duplicate: Is there a Windows 7 ODBC driver for Access?[详细]
2023-04-09 17:58 分类:问答MS-Access query does not correctly interpret DBNull.Value using OLEDB.NET
I am connecting to a MS-Access 2007 database using VB 2010 and OLEDB. Conducting the following test seems to suggest that MS-Access does not interpret DBNull.Value correctly when sent as a parameter f[详细]
2023-04-09 16:30 分类:问答List Box enable/disable one column
Access 2007: 开发者_开发百科 Is it possible to enable/disable one column in a List Box on a form.For example: Say you have 2 columns A,B - If Me.A = title Then Me.B.Enabled = True ElseMe.B.Enabled = F[详细]
2023-04-09 15:48 分类:问答How to update information on a table through a query?
I have phone information coming from multiple tables, colating into one query that lists all the pertinant phone information that I regularly need.[详细]
2023-04-09 09:51 分类:问答Updating MS Access Linked Table from VBS file
I am currently working on moving 100s of access databases from a variety of folders to another set of folders and need to update any references to linked tables that will be broken during the move.I h[详细]
2023-04-09 09:04 分类:问答MSAccess VBA code not working on second run
The below code is bound to a button. For some reason the below code executes correctly the first time. On the second time, for some users, it does not populate the fields on the website. What could th[详细]
2023-04-09 07:39 分类:问答Two Values in Dropdown
Access 2007. Is there a way to display two values in a combobox.I realize the combobox is bound to a field in a table, and it can only be bound to one field, but when yo开发者_StackOverflow社区u click[详细]
2023-04-09 07:39 分类:问答Font size mismatched between embedded Word object and text boxes
I\'m developing a new Report (actually a standardized letter) in an Access 2007 db.The majority of the text in this report is static and was provided to me in a Word doc.Because this text is relativel[详细]
2023-04-09 06:37 分类:问答SQL select rows with max repetition betwen two dates
I have three tables Books, Debit and Client. Books (Id, Title, ...) Debit (BooksID, ClientId, BorrowingDate,....)[详细]
2023-04-09 04:48 分类:问答