Search results for query: *

No it has to be sort. Order isn't supported by the object

Hi, I'm having troubles sorting a recordset. This is my code: Dim rstMeetwaarde As ADODB.Recordset Dim cnn1 As ADODB.connection Set rstMeetwaarde = New ADODB.Recordset rstMeetwaarde.CursorType = adOpenKeyset rstMeetwaarde.LockType = adLockOptimistic...

thanx, it works fine now!

Hi, can't preview my report when I use a wherecondition in which I use the word "LIKE" . Who knows how to do this. This is a part of my code: dim wherecondition as string wherecondition = "[Kal_date] = 'Like 2003*'" DoCmd.OpenReport stDocName, acPreview, , wherecondition

The on current event works fine. thanx for the quick respond!

Hi, I want to run a sub(cbxGebruiker_Click) when I click on one of the navigationbuttons. How can I do this? I've looked for events from the navigationbuttons but I couldn't find them. Anyone any ideas?

Hi, In my program I use an Access(2003) Database. I've made some reports in it which the user can open within my program when a button is clicked. When I open the reports I need to fill in some parameter values. Now I want to open the reports and automatically fill the parameters so I don't get...

thanks for the help. I didn't know I could use these objects in Access to get information like this.

Hi, In my program I use an Access(2003) Database. I've made some reports in it which the user can open within my program. Now I want to fill a combobox with the reports from the database at the start of the program. This way I don't have to program the reports in the code of my program, but I...

It works fine now! thanx for the help

I've found it: Imports Microsoft.Office.Interop.Access But I still get the same errors. Type 'Access.Application' is not defined. and Name 'Access' is not declared. Am I forgetting something else what could cause these errors?

if I type imports I get this list: ADODB ChristalDecisions Dao Microsoft ReadWriteFile (my app.name) Std System Util Where should I find access?

I've added the reference "Microsoft Access 11.0 Object Library" . It stands in my list with other references but I still get these errors: Type 'Access.Application' is not defined. and Name 'Access' is not declared. any ideas?

I'm checkin' it out now, I've never used it before. I thought it would be easy to open an access report in vb.net but apparently it doesn't...

Hi, I'm having a problem with opening an access report in my program. I'm using an access database(2003) in which I've already made some reports. In my my program I fill the databases and then after hitting a button I want to view the reports I've already made. I got the progam to open access...

Hi, I've made an report in an Access 2003 database and now I want to open this report when I click a button in my program. How can I do this? I've found something like this but it's not working: Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles...

The first time it worked but I got some errors from Access that I couldn't change any records. This was normal due to some referential entigrity rules in my database. But the second time and so on I started to get this error. The dataset is filled correctly

This code: "OleDbDataAdapterP.update(dsp1)" gives the following error now: An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll any ideas how to fix this?

Hi, My problem is that I can't get my Access database updated. I've made a dataview and made some changes to it with some data that I've taken from a textfile. In the try statement under finally I close the textfile and now I want to update the database with the changed dataview. How do I do...

Hi, I want to make a sheet unptotected so I use the function ActiveSheet.Unprotect. This works nice but sometime the sheets is protected and I have to use the password to unprotect the sheet. I want to know if the sheets is protected with a password or not so I can call the unprotect function...