Recent content by Guy Boswell

Hooray! All works fine. Thank you very much for your help.

I want to date stamp a record in a table when a user amends a value via a form. I have a simple form, frmRiverLevels that displays values from a table tblRiverLevels. The fields are fldTargetArea (text field, linked to another table of places for which I can hold river level information)...

Well done Daniel Klann. I like that. Thank you for passing it on Rob.

Thank you very much Mailman. Think that is just what I needed.

Guy, you stupid boy! It isn't the DoCmd.ApplyFilter , "fldTargetArea = '" & strStartArea & "'" before the button is pressed that matters. There s another DoCmd.ApplyFilter , "fldTargetArea = '" & strStartArea & "'" after the button is pressed after the message has been created and...

lol Lots of coding but none of it referes to filters!!! Arrrgh! But the button is on a another form, 'frmTargetAreas'. The form is filtered when it is opened. When the button is clicked the filter it tries to apply to frmWeatherForecasts is the same filter! So, DoCmd.ApplyFilter ...

Hi Mailman, Yes, the filter saves into the filter property of the form. I delete it. The form opens OK again from the database window or the switchboard. But as soon as I open the form from the code the filter is back!! So not as simple as deleting the filter I'm afraid. I think I have...

Yes, sounds like you are on the right lines. Rlate the tables. Build a query to bring all the information you want to display or update together in one place. Create a form using the Wizard, not from scratch until you understand what you are doing. FIrst thing the wizard will do is ask you...

I am having problems with a form that tries to apply a filter I don't want when it is opened. :confused: Can anyone please help me? :) * I have a database that generates flood warning messages * The messages incorporate a weather forecast * The weather forecasts are stored on a...

Thank you very much Nidge - that works a treat :-)

I have database that creates and sends emails. It all works fine :p Doesn't matter if Outlook is running or not. If it isn't running it just opens Outlook ;) But! The way Outlook is set up in our organisation it takes about three or four clicks and a couple of moments to open and give the...

Ok! Got it now. The wild card I need is an asterisk * Option Compare Database Dim LongString, String1, String2, String3 As String Public Sub testlike() LongString = "This message is ok!" String3 = "But there isn't any fruit" If Not (LongString Like "*bananas*") And Not (LongString Like...

It was the, 'not like', bit that was foxing me but MS Access Rookie put me on the right lines thank you. THe following is what I ended up with. Option Compare Database Dim LongString, String1, String2, String3 As String Public Sub testlike() LongString = "This message is ok!" String1 =...

This should be so simple but I can't work it out. I want to add a paragraph to piece of text if some other information isn't already in the text. That is to say if the long string doesn't include string1 and the long string doesn't include string2 then add string3 to the end of the long...

Thank you dbDamo et al. It was as simple as changing field data type to text. Not sure why I had hyperlink in there in the first place. I think it might be because I recycled the table from one I created as an Outlook export a while ago. And it seemed like maybe not the right type but...