Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Terkle
  • Content: Threads
  • Order by date
  1. Terkle

    Bolding text in Outlook

    Hi there I'm putting some text into an email from an Access form and want to bold some of it but I can't find anything anywhere about how to do this. For example, if I have the Subject line with text to go into it that reads "File Request", is there any way I can enter code into the form so...
  2. Terkle

    Elapsed time

    Hi there I've got two fields on a form 'Arrival Time' and 'Departure Time'. These are set up as Date/Time fields with an input mask for short time. I'm trying to calculate the elapsed time between arrival and departure but a simple query subtracting one from the other doesn't produce any...
  3. Terkle

    More trouble with getting data into email

    Hi there I’m entering text into an email by using a query but I can’t get it to select the data from the loaded form. I think it has something with the ‘MoveNext, MoveFirst etc instruction but I don’t understand these well enough to make it work. I also suspect I may need a loop statement but...
  4. Terkle

    Entering text from a form into an email

    Hi (I think I posted this originally on the wrong forum so I have re-entered it here and put a reply to this effect on the other forum.) I'm hoping someone can help me. I want to get the text from a combo box on a form into an email. The text that shows in the combo box comes from a lookup...
  5. Terkle

    Getting text into an email

    Hi I'm hoping someone can help me. I want to get the text from a combo box on a form into an email. The text that shows in the combo box comes from a lookup table so it is not the actual value. I know that if I type the code: Me.cboGroup.value it will give me the underlying value but I want...
  6. Terkle

    Type mismatch error

    Hello there I'm trying to run a procedure but keep getting a 'type mismatch' error. To try and sort out the problem, I've created a 'test' db and made a simple table, query and forms and inserted the code below and it works fine. Private Sub Form_Load() Dim db As DAO.Database, rst As...
  7. Terkle

    Form running in background

    Hi there I want to have a form running in the background (i.e. hidden) that I can use to trigger a shutdown of the database if necessary, but can't find out how to hide it. Is anyone able to help me? Thanks Terk
  8. Terkle

    RTrim problem - not removing trailing spaces

    I imported a text field from Excel into an Access table. I tried to link it to another table in a query but it didn't work as the imported field has four spaces after the last character. I ran an update query using the RTrim$ function but it doesn't get rid of the spaces so I have to manually...
  9. Terkle

    Wizards not working

    My table/query/form Wizards as well as the one on the form design Control Toolbox are not working on my home PC. The table/query/form Wizards haze over when I click on them but nothing else happens. The Control Toolbox wizard doesn't function when I click on it. I use Access daily at work...

Part and Inventory Search

Back
Top