Search results

  1. I

    max 255 letters in a box

    hint: when you use a memmo field dont set its control format to ">" in order to capitalise the data or it will be treated like a text box and only show the first 255 characters. Likewise if you format the memmo field in the table to ">" in order to capitalise the data it again treats it as a...
  2. I

    Sending Emails

    Russell i believe you can create a table containing the email addressed eg "address" field use some code to open the table and loop though the adress field, setting the "strTo" mentioned in harry's reply to the "adress" field in the table. of course this will only work if the email adresses...
  3. I

    Not Like

    Doc man is correct as always in that you should have it in your query criteria section. if your looking for records with "aftershokk" shock any where in them then you would use like "*"&"aftershokk"&"*" as the criteria. As you looking for records without aftershokk in i assume it would just be...
  4. I

    comboBox open a form and close a form

    on the open event of the new form try docmd.close acform, form1 check the help file for syntax ian
  5. I

    Global variables in a query

    i have a set of combo boxes that is currently used as a criteria in a query. This works fine. What id like to do is assign the combo box data to a global variable that can be used at other points in the database. is it possible to assign a global variable as a criteria so i can use the combo...
  6. I

    Option Groups

    There are 2 ways of doing this. 1> you can use the option group button from the toolbar to create an option group. Follow the wizard to input the name of the labels etc manually. 2> You can insert a frame using the same option group button but without the wizard working. with this method you...
  7. I

    Node trees

    I have seen the use of node trees to make navigation of databases have a similar look to windows explorer ie. expanding trees. As records in one of my databases can be updated with the same details I thought it may be benificial to have this feature on it. So far I have used the in built help...
  8. I

    How do I add a Yes/No button to a Macro?

    Try sams taech urself in 24 hrs. its a bit more basic and does cover the basics of message boxes etc. i think you can view portions of it on informit.com i may be wrong on the last bit
  9. I

    This is SOOO ANOYING!

    I had a similar problem with outlook. I required users to confirm some actions which required them sending an email. If outlook wasnt open it came up with a profile request message. I couldnt find a way round this using vb code so I cheated a bit. I told everyone when performing this task to...
  10. I

    Memmo fields

    Just realised that formatting with > makes the control act like a text box and truncates the data to 255. by taking off the format it displays all the data in there. hope this helps anyone else to
  11. I

    Memmo fields

    I have created a form that relates to data in an underlying table where the field is set to memmo. when i bind a text box to the memmo field it only displays, allows input, for 255 characters. How can i get the text box to display the full contents of the memmo field? i have tried the help...
View older results
Back
Top Bottom