Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. vfisher

    Cookie Problem?? Losing entered data

    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!
  2. vfisher

    Cookie Problem?? Losing entered data

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

    Use copybook field name

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

    Windows95 User Name

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

    Display message when no records in Search

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

    Display message when no records in Search

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

    Display message when no records in Search

    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].
  8. vfisher

    Display message when no records in Search

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

    Display message when no records in Search

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

    Subform Problem with Cancel Update

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

    Problem with AllowAdditions Property

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

    Problem with AllowAdditions Property

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

    Problem with AllowAdditions Property

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

    Problem with AllowAdditions Property

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

    Problem with AllowAdditions Property

    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, , ...
  16. vfisher

    Compare date field to Part of current date

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

    How to pass the password to the backend of a split database

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

    Set AllowAdditions Property in subform from Main form

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

    Set AllowAdditions Property in subform from Main form

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

    Set AllowAdditions Property in subform from Main form

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

Part and Inventory Search

Back
Top