Search results for query: *

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

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

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

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

I have a form with a DataGrid connected to a Access 2000 database with a ADO-object. In the same form I have a toolbar with som buttons. One button is ment for "adding a new record" into the datagrid. When I push the button in the toolbar I want to set focus on the last line in the...

I have a form with a datagrid where I am registering a new record. When I am saving the new record I want to validate the fields and prevent the user from saving if anything is wrong. Is it possible to do this by setting some properties in the "BeforeUpdate"-event for the DataGrid ...

I'm wondering how I can write VB-code to move the user from som place in a datagrid to the last line where the users normally register new records. Can anybody tell me that ? Regards Knut

How can I set maxlength for a column in a datagrid ? (like maxlength in a textbox) Regards Knut

I have just finnished my first VB6/Access application and my customer have received the program. When he tries to register a record in one form he gets the error message: -2147217888 - Consumer's event handler called a non-reentrant method in the provider. The error message is triggered after...

I'm about to finish a VB6/Access2000 application and need some help with a problem when running the application. After we have installed the program we tries to register a record in a form and gets an errormessage : The field 'table.ID_field' cannot contain a Null value because the Required...

When you create a form (design time) i VB with ADODC (against Access) you have to give the full path to database you want to connect to. The path is saved with the form and as a part of the connectionstring. At the "end user site" the path to database will be different from design...

I'm working on a Access/VBA program where I need/want to do check on a field not represented on the form. My code look like this: If [Tablename].[FieldName] = "something" Then ....dosomething End If I get an error-message that says that field don't exist, but that not true. Tablename...

During developing a database I do some tests and the autonumber counters is increasing. How can I reset the autonumber - counter before installing the database at the end user site

Hey! Since I'm very new to Access/VBA I need some help to solve a little problem (I hope). I'm working on a form, which is a typical "order" and "order details" form. The form shows data from det "Order"-table and the "Orderdet"-table. When I create a...

Inside an existing Excel workbook i have an existing "master" sheet. This sheet I want to copy a number of times inside the workbook. Every time I reach 60 sheets inside my workbook I get "Subscript out of range (Error 9)". I have made a smal macro which look like this...