Recent content by chrisk

  1. C

    chrisk; Thanks again, Please respond....

    Sorry not to reply before - couldn't check the board yesterday. Why are you using the .text property? If txtAppName is a textbox you want to set the value property, which is the default, ie Forms![change_timecard]![change_timecard_sub]![txtAppName] = Aname (BTW, it is much easier to follow...
  2. C

    chrisk; Thanks for you quick response BUT...

    So, txtAppName is a textbox on change_timecard_sub which is a sub form of change_timecard? Is AName a field returned by your SQL SELECT? If so: Forms![change_timecard]![change_timecard_sub]![txtAppName] = rs2.Fields(n-1) where n is the number of the field returned by the SQL (ie the first...
  3. C

    How to reference one form to another form

    To refer to YourControl on subform YourSubform of main form YourMainForm: Forms![YourMainForm]![YourSubform]![YourControl] HTH Chris
  4. C

    Events - What is evaluated first.

    Mark This, at least, is something that Access 'help' does actually help with. Search for "find out when events occur" in the answer wizard and select "See the order of events for controls on forms". I've got A2k now, but I know it's in A97 help too. Chris.
  5. C

    Converting number to date?

    Rather than changing the table design, you can put an invisible text box [YourDate] on your report bound to your date and a visible text box with Control Source = DateValue(Str(Mid([YourDate],7,2)) & "/" & Str(Mid([YourDate],5,2)) & "/" & Str(Left([YourDate],4))) and format = Long Date. HTH...
  6. C

    Automatic Opening of Combo Box

    In the form On Open event: Me.yourcomboname.SetFocus Me.yourcomboname.Dropdown HTH Chris
  7. C

    Combo box dropdown

    I've got a combo box on a form which is the only visible control when the form is first opened. From this you select an item then another combo box becomes visible based on the first one, etc. I've set the On Got Focus event for each combo box to automatically drop down (me.combo1.dropdown...
  8. C

    data change on combo selection

    Make your main form unbound. Create a combo box (cmbEmployeeID) for employee ID with a row source of a query based on employees table. In this query include the other employee details you want to show on your main form (first name, last name, address, etc). Make your fields for employee first...
  9. C

    Label Question

    This assumes that there is a space between the words in your label field [yourfieldname]. Add 3 unbound fields (txtFirst, txtSecond and txtThird) to the report, set Visible = No and their control sources as follows: txtFirst: = Instr(1,[yourfieldname]," ") txtSecond: =...
  10. C

    A COMBO of a problem

    The column numbers are an array, so you need the brackets round the 2, ie Private Sub offered_AfterUpdate() Me.txt10 = Me.txtCombo.Column(2) End Sub Chris.
  11. C

    visual basic code

    Your logic is contradicting itself. Your 3rd If statement *ElseIf Priority <> "Z" Then Status = var* is setting status back to "" for Priority "D". You need an Exit Sub statement after setting Status to "Follow-up" for Priority "D". Chris
  12. C

    Next Record - Main form - Sub Form has mult rcds

    If you don't want to move through each record in the subform, set the Record Selector properties of the form and subform (Yes on the form, No on the subform).
  13. C

    Hiding subforms

    I have an A2k form with a combo box to select a doctor's practice. This then populates a subform with the main surgery address. This subform has its own subform which shows any branch surgery addresses. The form, subform and sub-subform are all linked by practice id. If the practice doesn't have...
See more
Back
Top Bottom