Recent content by Knutjo

I have a form with databound (ADO) datagrid. In the grid I have some columns set up as combobox. When I enter a value in the first column (combobox) and hit TAB to go the next column the BeforeColUpdate event doesn't fire. If I change from the combobox-columns to normal columns the event fires...

....the "button"-solution is of course a way to do this, but if you want to have a automatic resort of records in the datagrid where would you placed the "requery"-method ? (the sort property had no effect...) Thanks (again) CCLINT

....yes, I can remove it but then the records in the datagrid is presented in nonsorted order after inserting records. I want sort the records by a code in one of the columns. Knutjo.

Thank you so much for your help CCLINT. Have been hooked up in some other things so I haven't been able test all your tips until now. You gave me the idea of turning off AllowAddNew in the datagrid and programmatically control everything. That seems to be the soulution for me. I have to do a...

Hi ! I have a problem updating a datagrid connected to a ADODC object and a Access 2000 database. When I am inserting av new record the first time everything is fine. The second time the application stops/hangs up. The same is happening when I am deleting records. I'm doing av Requery in the...

Hello everyone ! Thanks for your help and hints. I solved my problem with a modal form. When I start the invoice report I use a modal form. In this form I can control what to do with some global variables. Actually it was pretty simple... In this form with a recordset all printed invoices was...

Hi ! I'm working on some VBA-code in my project. After I have done som changes in VBA-code I'm not able to save the changes. En error message says (translated from Norwegian): "Cannot execute save operation". After the error message Access/VB is hanging and I have to stop/kill and...

Hi ! I'm working on/creating a invoice report. When the invoice is printed I want to update the invoice record with info that tells that the invoice is printed and shall not be edited anymore. What is the correct syntax to access the records in the report's recordset ? ... like...

Thank you CCLINT, but it still doesn't work. I have just tried to implement what you wrote. The last line in the "DataGrid", which is ment for inserting new records, disappears with your example code. The only way to get the DataGrid to trigger OnAddNew event is to insert records on...

Thanks CCLINT ! ....but this gives me the same result as before. One line is inserted before the "*"-line where new records are supposed to entered. When doing it this way you don't get events like "OnAddNew". Regards Knutjo

I have posted this question here before, but I haven't got the right answer yet. I'm sure someone must have done this before.... I have a form with a DataGrid connected to a Access 2000 database with an ADO-object. In the same form I have a toolbar with som buttons. One button is ment for...

How can you send a report directly to the printer without first having a preview on the screen ? When in preview.... How do you know that the user sent the report to the printer or he canceled the report before making a hard copy ? Regards Knutjo

I have a VB application with an Access database. All reports in my application is sent to excel. When I have finished on sheet I want to my excel-sheet to fit into 1 page wide. How can you do that ?? (I have tried "Mysheet.Pagesetup.FitToPagesWide = 1" but nothing is happening) Knut

I have been writing some VBA-code in my Access project. When I am trying to save I get an error message that says...(translated from Norwegian): "You interrupted previous operation" and then I am not able to save my sourcecode or forms. Can anyone tell me what's wrong ? Environment...

Thanks binky, but I have tried that and it doesn't help. Those commands are adding a new blank line at the end, but before that line used for registering new records (the line marked with a '*'). If I use your commands I don't get the event "OnAddNew" which I use to set some default...