Search results for query: *

I'm running Windows XP and Internet Explorer 7. When I enter a website, put in id and password and start going to other pages, suddenly it sends me back to home page as if no data has been entered. This happens on all websites I've been to that requires id and passwords. It seems to be losing...

Is there a way to reference the actual value of a field name in a copy book? Example: 01 Test-record 05 recordkey pic x. 05 field1 pic x. What we would like to do is move the value of the name of the key field - "recordkey" to an output field. Thanks.

I'm using Access 97. I have a main form that contains unbound fields used for search criteria and a search button. The search results will be displayed in a subform. The subform has a query as it's data source with the criteria matching to the unbound fields on the main form. When the search...

I am working with Access 97. I have a subform(continuous form) which has 4 data entry fields. If the user starts entering a record, then deletes all the data in the 4 fields I don't want to save the record. In the BeforeUpdate event of the subform I have code to check for null values in all...

My form has the Allow Additions property set to Yes. When I first created the form, everything worked fine. However, after working on the design, record source, code etc, suddenly the form will not allow records to be added. I'm calling the form with: DoCmd.OpenForm stDocName, , ...

I'm using Access 97. I have a date field (format short date) on my form. I need to validate that the month/year of this field is not greater than the current month year. I tried using datepart and format in every variation I could think of but I get an error everytime. if I don't get a...

I am using Access 97. I have a split database. I don't want any of the users to be able to get into the data (backend) without going thru the front-end. I know I can set a password on the database (back-end), but I don't know how to pass that from the front-end. Any help is greatly appreciated.

I'm using Access 97 and depending on certain criteria, the properties of the subform (AllowAdditions, AllowEdits) need to be set from code in the main form. I'm sure it's easy but I cannot seem to get the syntax correct. Here is the latest iteration...

I am using Access 97. I have a form with a subform. There is a field in the subform that is summed in the footer of the subform. When the data in the subform is altered, I am validating it from the main form via a save button. The problem is that the sum in the footer of the subform may or...

I'm having a problem with the tab order on a form. I set the tab order using the Access tab order window. I also tried to set the tab order in code using tabindex = 0, 1 etc. However, when I tab, it still bypassing the fields. I am prefilling the fields from a previous record and suspect...

I am using Access 97. I have a subform containing a DSum field in the footer. As the user is entering data, the field is calculated - but not until the focus goes to the next row or to the parent form. I have a "Save" button on the main form which validates the DSum field to a field...

I am using Access 97. I have a sum field in the footer of a subform that sums the values of each record in the subform. However, it doesn't add the value of a record until the focus goes to a new row. Since I'm validating that value against a field on the parent form, I need to set the focus...

I'm using Access 97. I have a main form with a subform. The main form has a "Save" button. I have validation on the subform (which is a continuous form) to validate the data in each row in the beforeupdate event. When there's an error, I get the error message. However, if you...

I'm trying to stop Access from saving a record unless the "Save" button is clicked. I put the following in the "BeforeUpdate"Event. DoCmd.CancelEvent I have the following code on the "Save" Button: DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, ...

This is probably an easy thing to do but.... I am using Access 97. My users select a record and on that form is an edit and add button. When the Add button is clicked I open a new form in add mode, but I need to populate most of the fields from the current record, which is data from two...

I'm using Access 97. I have a form that is opened as add and has some data preloaded from the previous form. Everytime I switch to design mode it tries to save the record. I have no idea what's causing this. I have a cancel on the before update because there's a save button. Any help will...

I have a combo box getting values from a table. Once the value is selected, either the ADD record button or Edit record button must be selected. Then some validation needs to occur: For an add, only some of the values available in the combo box are valid. The probem is that the record is not...

Access 97. I have a form that is opened from another form and getting default values from that form. However, I need to close the previous form because it has a table locked that will be needed. I've tried to close the form in the "current" event of the new form but I can't get that...