Recent content by RpbertS

  1. R

    update subform

    oops [This message has been edited by RpbertS (edited 06-07-2001).]
  2. R

    error message

    hi, when a form I have loads up and not all fields are filled in I get a runtime error '13' how can I trap this error and change the message or just not display it? thanks
  3. R

    audit log problems

    thank you for the reply. I gave up and made my own probaly not as good but it does the job thganks
  4. R

    auto kick

    thanks for that link its really good. I have a problem however. I set the timer interval in the properties section of the form to 5000 (for testing) pasted that code into the ontimer event and Iget a sub or function not defined error. any ideas? thanks
  5. R

    audit log problems

    Ive been trying to set up Allen Browne's, I just cant seem to get it to do anything is there any other examples or sample databases out there? thanks
  6. R

    auto kick

    anyone have a sample dbase showing how to autokick someone if they have been inactive for 10 minutes? thanks please send to
  7. R

    make a combobox default to first item in list?

    have you tried putting: [cboname].[ItemData](0) in the default value property of the combo box?
  8. R

    Zip code table available for FREE use?

    i do to please send to thanks!
  9. R

    sub form total

    yup, I would assume you'd put some code in the before update event that checks to see if the fields in the subform have any value and if not prompt the user to enter data into those fields. this is just off the top of my head so it may not work but should help you get started. in the before...
  10. R

    Form won't allow additions!!!

    hmm...I had this problem once before and the steps you've done solved it. Im not sure what other advice to give. I'll be heading home in about an hour..if you want you can send a sample dbase to my personal email acccount and I can see if I can get it to work. Ill try to think of soemthing...
  11. R

    Assign values to Variables

    here is some code that may help you out: For Each i In Me![list0].ItemsSelected If Criteria <> "" Then Criteria = Criteria & " OR " End If Criteria = Criteria & "[" _ & Me![list0].ItemData(i) & "]= " _ & [TextNull] & "" Next i it builds...
  12. R

    Form won't allow additions!!!

    1)make sure the query you redid is the same name 2)check to see if the data source of that form is the right query 3) you may have to go into the record source of the form, then delete the query from there then re add the query. hope that helps
  13. R

    Passing a Query the Condition and Value from a Form

    doh..dougs right about passing the logical operators..wasnt thinking straight thanks for the catch
  14. R

    Passing a Query the Condition and Value from a Form

    okay you want to pass 2 values from 2 differnt combo boxes to the query, correct? in the queries criteria field why not jsut put like: [forms]![formname]![cboname] And [forms]![formname]![cboname2] that way the value in combo box one can be used as a criteria and the conditional values in...
  15. R

    Password Form

    well heres an idea..pretty simple but the password is hardcoded..but anyway create a form that has a field and a command button. for the field code to properties then the data tab then go to the inputmask field and select password. now on the OnClick event for the command button put this code...
Top Bottom