Search results

Further info.... After doing some further research, I have determined that a DrWatsn error is generated each time MS Access crashes. The dump file states that: "Exception code: C0000005 ACCESS_VIOLATION". This seems to indicate that MS Access is trying to access memory that it does not have...

Hi, I have an MS Access 2000 .adp that makes use of SQL Server 2000 backend. Historically the application has worked fine. Recently I added a new continuous form that is bound to a stored procedure. The form has a combo box at the top that enables users to specify which fields in the form...

Hi, I have a label on an access form. I set the "HyperlinkAddress" property to a valid URL in code. When the application launches users are able to click on the label and a new IE window opens with the relevant URL. I am finding however, that when a user closes the IE window, instead of...

Hi, I developed an .adp that is being used by 270 people. Each time somebody connects to the database via the application I see 2 or 3 connections for each person. The .adp has a number of forms that are bound to SQL Server stored procedures. The application also uses ADO to execute stored...

Hi, I have a form in an .adp that is bound to a SQL Server stored procedure. The stored procedure consists of an inner join between 2 tables. Both tables have a primary key. I have set the Unique table property of the form. When I run the form, I find that one of the fields that is part of...

Hi, I have a continuous form that is bound to a SQL Server stored procedure. The form allows users to view and add new records to a table. This works fine. I have another form that contains a Tab control in the detail section. I have added the first form to the Tab Control as a subform. When I...

Hi, I have a form that has a combo box in the "Form Header" section. This form also contains a subform that is bound to a SQL Server stored procedure. The stored procedure takes 2 paramaters. One of the parameters is the value of the combo box. I would like the subform to reload each time the...

Many thanks for that. I have got it working, however I would like only one record to be highlighted at a time. At the moment when I press the "Select Me" button it highlights the text boxes for the currently selected row and the previously selected rows. Is there a way around this? Cheers...

Hi, I have a continuous form that is bound to a table. Each record in this form consists of text boxes. I have added a button named "Select Me!" to the end of each row. When the user presses the button I would like the selected row to be highlighted. I added the following code in the click...

Hi, I have a table with over 10,000 records. I need to show all the records in this table on a form and also make it easy for end users to find records and assign these records to data in another table. I am considering using a tree view control with a node for each letter of the alphabet...

Many thanks for that - it worked a treat.

Hi, I have a Continuous Form that is bound to a table. One of the fields in my form is editable. For each record in my form I have a report button that illustrates the data in a better format. My problem is that when a user changes the value of the editable field and then immediately presses...

I ended up resetting the forecolor property of the text boxes.... weird, but it did the trick. Cheers, Kabir

Hi, I have a form that is bound to a row in a table. The form contains text boxes that are used to store values for each column in my row. The form also has an "Add New" button which when pressed clears all the text boxes so that users can populate the text boxes with values for a new record...

Hi, I have a form within my .adp that is bound to data in a SQL Server 2000 table. One of the fields in my table does not allow nulls. When I edit the corresponding field in my form and move the focus to another control I get the message "Non-nullable column cannot be updated to NULL"...

Hi, I have an .adp that makes use of SQL Server 2000. In one of my tables I have created a check constraint to ensure that all records in a particular column have exactly 9 characters. i.e. ALTER TABLE TableA ADD CONSTRAINT chk_id CHECK (LEN(ColumnID) = 9) I created a form that is bound to...

Hi, I have a text box in a form and would like to ensure that the contents of this text box does not exceed 27 characters in length (it can be less then 27 characters or even blank). How do I do this using a validation rule? I tried LIKE "????????????????????????????" but this only checks for...

Hi, Is it possible to dynamically add a control in ms Access? I was of the opinion that you could do something like this: dim chk as checkbox me.controls.add(chk) however there doesn't seem to be an add option. Any ideas? Thanks Kabir

What exactly are you stuck on?

Hi all, I have an .adp that works fine on a number of people's laptops. One of the users however, keeps getting an error message stating that SQL Server does not exist or access has been denied. This particular user is definitely setup on SQL Server with dbo permissions. She can also ping the...