Search results

  1. A

    Multiple entries on one form

    Please excuse my ignorance but what exactly does testing the frame value mean?
  2. A

    Multiple entries on one form

    Setting up the subform as a continuous form worked out great. One question though. The "On Click" command is not available on the individual yes/no option button. It's only available on the option group. What would be the code I would need to build an expression to get a blank subform to...
  3. A

    Multiple entries on one form

    Help for the helpless once again. I have two tables, Log and Sample. The Sample table will only have 2 fields (SampleID and Sample). Its a many to many relationship so I created a simple junction table to link them. On my main Log form (frmLog) I would like one of my yes/no option buttons to...
  4. A

    Clueless about Option Group Buttons and Coding

    Got it to work. Big Thanks!
  5. A

    Clueless about Option Group Buttons and Coding

    Greetings everyone, I developed a form (frmLog) based on several tables including a table called tblLog. On tblLog, I've have several (5) yes/no fields which I will be using on frmLog. These fields are "Alarm", ""Lost", "Call In", "Routine", "Required". I want the user to have to physically...
  6. A

    Conditional Calculation formula Using "Case"

    Conditional EXP Calculation formula Using "Case" Ok, so I did a debug and I didn't find anything there. Nor did anything change with the change to Me.txStartupTemperature. I went back and omitted the stand alone Public function and transferred some of the code from there into the form's code...
  7. A

    Conditional Calculation formula Using "Case"

    Bummer. I tried as suggested and it didn't pan out. I only get "0's" if I insert number^exponent. I'm definitely looking for the EXP function. I also tested my formulas on Excel using EXP and they come out fine there. Something else I've noticed though. If I insert any values <=25 I always...
  8. A

    Conditional Calculation formula Using "Case"

    Howdy, I'm missing something because my calculations are off on a form. I have a form with a textbox labeled "txtStartupTemperature". The value I insert here will affect another value in a textbox labeled "txtStartupTCF". If my temperature value is <= 25, I will use one formula for my...
  9. A

    Select Case on Subform

    What does error #Name? mean?
  10. A

    Select Case on Subform

    Ok, so I created the standalone module with code and I added the subform code to its Control Source. All code I transcribed verbatim. I am still seeing an error message ((#Name?) in my TCF field. Any idea of what I'm doing wrong now?
  11. A

    Select Case on Subform

    I'm going to give it a try and see what happens. Does the subform code go into the control source property or into the subform module (This is probably self-evident to most people here but I'm a novice.) I'll get back and let everyone know if I was successful.
  12. A

    Select Case on Subform

    You are correct. I've been getting by with what I learn here and the Access Help menus.
  13. A

    Select Case on Subform

    By function I assume you mean "If-Then-Else" statement? I was thinking that with as many alternatives as I have it may be too complicated. Unsure how to write this function. Could you provide me with a little lead to get my code started? My temperature value in the Main form is stored in a...
  14. A

    Select Case on Subform

    I'm new to Access and know very little about VBA so please bear with me. I have a form (formProfile) which contains a field for (Temperature). Now associated with this form is a subform (formNPF). In this subform is a textbox (TCF) which will automatically populate with a certain value based...
Back
Top Bottom