Recent content by RpbertS

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

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

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

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

Ive been trying to set up Allen Browne's, abrowne@odyssey.apana.org.au I just cant seem to get it to do anything is there any other examples or sample databases out there? thanks

anyone have a sample dbase showing how to autokick someone if they have been inactive for 10 minutes? thanks please send to wallyg135@yahoo.com

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

i do to please send to fdarouian@yahoo.com thanks!

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

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

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

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

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

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

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