Recent content by Terkle

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

Thanks everyone for your help and suggestions. Remou solved it for me first off with his advice to use the DateDiff function. I had tried that but had left [] around the letters instead of replacing them with "". I'd also forgotten I needed to log in to be able to reply and have just realised...

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

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

I meant to enter this in the Access forms forum which I have now done. Please don't reply to this thread. Thanks Terk.

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

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

That's why this forum is so great as there are always smart people out there who know the answers. Thanks for your help, fellas and your solution works fine. terk.

Sorry, I should have added that. It's the line below: Set rstNames = db.OpenRecordset("qry1Data", dbOpenDynaset) Thanks

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

Thanks for the inspiration from just being on this site. I have found the code I need from the Access Help file (is this a first??!!) By adding: Forms!frmHidden.Visible = False to my startup code, it seems to do the trick. Terkle

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

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

Hey fellas Thanks for taking the time to reply. I'll give this a try. terkle

Hi AceMan I came across this which seemed to answer a similar sort of problem that I have that when users requery a field that is not the first form, it jumps back to the first form. When I enter the code, however, I get the message 'Syntax error (missing operator) in expression. I copied the...