ms-access-2007
Export From Access to Excel
I want to export some data in one recordset in Access to Excel. I know the DoCmd.TransferSpreadsheet command but it works only with stored queries, and in my case it\'s a runtime-filtered record开发者[详细]
2023-03-19 17:20 分类:问答Access2010 to PowerPoint2010
I have a VBA program in Access able to write to shapes in an already existing PPT.It also will make copies of slides and insert/paste them as wel开发者_如何学JAVAl.[详细]
2023-03-19 14:23 分类:问答Retrieving rows from a MS Access Database View using Vb.Net
I\'ve managed to get the following code... con.ConnectionString = My.Settings.dbConnection Dim sqlCmd As System.Data.OleDb.OleDbCommand = New System.Data.OleDb.OleDbCommand()[详细]
2023-03-19 13:28 分类:问答VB.NET SQL UPDATE command returns error "Argument not specified for parameter."
My update query (built from the dataset wizard) does not update anything and I am not receiving any errors.[详细]
2023-03-19 08:15 分类:问答Nz() not working in MS Access
I have a cross tab query that is counting Patient_ID\'s as the value. Total = Nz(Count(Research.Patient_ID))+0[详细]
2023-03-19 03:51 分类:问答Error in Code - dbCommand.ExecuteReader()
Can anyone tell me How do I solve this error. Error: NullReferenceException was Unhandled - \"Object reference not set to an instance of an object.\"[详细]
2023-03-19 03:26 分类:问答Splitting MS Access Database
I am working on a database with one other person. We have successfully split the database into a frontend and a backend, where the frontend contains t开发者_如何学运维he queries, reports, and forms, a[详细]
2023-03-19 01:23 分类:问答ADO.net How do you make a database cell into an integer?
I\'m new to ADO.net and I learned how to get stuff into data grid views and how to use Insert/Delete commands. However, I would like to take a cell from the database and turn it into an integer or any[详细]
2023-03-18 22:24 分类:问答MS Access: Auto update fields in same table
Sorry but I\'m not very experienced when it comes to things like this. I have a table called \"Measure Table\" with the fields \"ID\", \"Proxy\" and \"ProxyID\".[详细]
2023-03-18 19:27 分类:问答Access 2007- #Name? Error
I am trying 开发者_如何学Cto specify a controlsource. I basically just create a text field in a report, use the build tool to find the relevant field from a subreport/query, and then set it. I know th[详细]
2023-03-18 17:38 分类:问答