ms-access_开发者

MSAccess Error: Class does not support Automation or does not support expected interface

The issue is that it\'s looking for the OLE Automation reference in C:\\Windows\\SysWOW64\\stdole2.tlb[详细]

2023-04-13 07:34 分类：问答

SQL query updates then revertes changes

I\'m currently baffled by the one problem. I can insert and delete records from my table but I can\'t update certain fields. It does update it temporarily before reverting changes 0.5 seconds later, I[详细]

2023-04-13 07:19 分类：问答

Setting VBA Excel Chart Legend Position Property in MS Access not working

This is a very strange issue I am facing for a while now, when creating some Excel worksheets programmatically from MS Access 2003.[详细]

2023-04-13 05:40 分类：问答

Access: run-time error '2176' - The setting for this property is too long, but it is not

I\'m not an experienced vba programmer and working with access is not my cup of tea. I\'ve been asked to fix some errors in an MS Access 2010 VB application.[详细]

2023-04-13 02:33 分类：问答

Access Listbox based on value list - sorting on column

I have a Listbox with 3 columns on an access form which has as it\'s row source a value list (not a recordset from the db), which is passed as comma seperated string. The third column is a numeric val[详细]

2023-04-12 23:42 分类：问答

Create a comma-separated string from multiple rows of one column?

I\'ve an access table like this ID | UserName | CarBrand ------------------------开发者_高级运维-[详细]

2023-04-12 21:59 分类：问答

Access VBA Form current record is deleted

I\'m using Access 2003. I have a form (FormA) that displays the fields of a row in TableA. On the form I have a button that opens a dialog with a listbox that lists all of the rows of TableA. A delet[详细]

2023-04-12 21:41 分类：问答

How do I save an embedded image in Microsoft Access to a file?

I have a lot of images embedded in an Access database.I need to save the images 开发者_如何学运维to a file.How do I do this in VBA?You need the GetChunk and AppendChunk functions.[详细]

2023-04-12 21:25 分类：问答

Access vba: listbox additem multicolumn truncating on comma

I have a combobox with two colunms, but the first is hidden that adds values onto a listbox in the same manner. I am noticing that the list box is truncating the string in the second column.[详细]

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

Specify target columns on import (CSV to Access)

I\'ve found out how to import a CSV into my Access database via another question. But in the answer there is no information on how to target specific 开发者_StackOverflowcolumns upon import. How can I[详细]

2023-04-12 20:19 分类：问答