Search results for query: *

Yes, I do have cookies enabled. Sometimes I can go through a few pages before it suddenly goes back to the screen to enter the id and password. Thanks for your input. I welcome any ideas!

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 am using Access 97. I have tried putting the code below for getting username in a module, then in my form using the following code: Me!Text = fOSUserName() I keep getting an error "Expected variable or procedure, not module" Please tell me what I'm doing wrong!!! I know it's...

I couldn't get this to work quite the same way. However, if you have a field that should always have a value on your form and it is null, then display the message and close the form - or whatever you might want to do. I testing it in the "on current" event and it worked fine. Just...

CosmoKramer - Thank you, Thank you!!!! Seems so simple now - but I just couldn't figure out how to get to the query results. This works great!

the search fields on the main from are unbound. The user enters the values, then the query has as the criteria: Like [Forms]![frmBillingSearch]![EnteredPolicy].

Well, I'm not using code. I'm using an access query as the record source for my subform. The query is set up with the criteria matching the fields on the main form. The problem is that when I requery the subform, it doesn't seem to go thru any of the events in the subform because no data is...

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

Kevin - First of all, I really appreciate all your help. The Recordset type was already dynaset. Perhaps I can make this easier. There is really only one table being updated from this form. However, I need to verify data from at least two other tables before I allow adding or editing...

There are multiple fields in the primary key of each table. That was probably a design mistake, but i'm in too deep to turn back now. While I need data for the screen from all three tables, only two are actually being updated. Is there another way to do this other than having all the tables...

Thanks for your response. You are right, the recordset is not updatable. I really don't understand why. Here is the SQL code: SELECT tblPolicyMaster.PolicyNumber, tblPolicyMaster.PolicySuffix, tblPolicyMaster.RecordType, tblPremiumMaster.CompanyCode, tblPremiumMaster.CycleDate...

Once it happens, I can't ever get it set to true again. The property sheet still has AllowAdditions = yes, and even when I try to set it in the code (I tried in the on current and activate events), it still doesn't allow an add.

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.

Thanks for the help. I finally found the correct syntax for this: Forms![frmBilling]![frmPremiumTransactions_subform].Form.AllowAdditions = True I just left out .FORM after the subform name. Thanks Again.

I'm using an IF statement to determine when to set the property.

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