Recent content by sbdproj

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...