Recent content by M_S_Jones

Thanks Minty, that's a great suggestion.

Hi, Thanks for your suggestions, but I'm not entirely sure that I follow. Are you suggesting that I store the date and time added to the table - say a new field with the default value of the now() function - and then pass the value of the new field into function via the data macro? The function...

Hi, I'm trying to update a linked SQL Server table whenever data is appended to an Access table in a linked back end. I setup an after insert data macro over the table to call a saved query, but I couldn't get this to work. After researching online I found that others had achieved what I was...

Thanks. I'll mark this thread as complete, as you've solved my original problem. Thanks again, Matthew

Wow, thanks for the quick reply Minty! That has resolved the issue, thank you. This is now working when I append a single record. If I append multiple it appears the after insert event is only triggered for the first record. Is there a way to handle this scenario, or is this a limitation of the...

Hi All, I'm trying to update a value in an SQL Server linked table on insert of a value into an Access table in my linked back end. I've setup an after insert macro on my Access back end table which calls a function to update the linked SQL Server table using DoCmd.RunSQL. This works...

Excellent, thanks for the suggestion. That will do what I'm hoping to achieve. Thanks, Matthew

Hi, Is it possible to move a record in a DAO recordset? I have some code that is looping through a recordset and allocating resource time to requirement. A late specification change has arisen and now on rare occasions there will be requirements that cannot be completed on the same day. I'm...

Hi, I've got an Access database system in place at the moment which has a lot of users, and which has a lot of automated procedures updating temporary tables with data from our SOP. It works well enough, but on occasion, probably about every 3-4 weeks, the back-end appears to corrupt. I get a...

Hi, Can anyone provide any tips for making conditional formatting a bit faster to load? I have a continuous subform with several objects subject to conditional formatting, including a long unbound textbox the length of the row. When I scroll in the subform I find that it takes a couple of...

Perfect, thank you. So I just needed to use the object in the expression, not the field. Strange that the field could be used in 2002, but at least I know now. Thanks, Matthew

Hi, Thanks for your message. I have uploaded a sample database, based on the example I gave in my first post. As I said before, if I use exactly this logic in 2002, the font colour of the whole row changes on change of the field used in the expression (in this example, Field1). In 2007 and 2010...

Hi, I'm trying to do something which I have done many times in Access 2002, but I can't achieve in versions 2007 and 2010. I have a continuous subform with conditional formatting applied to every object, for the font colour to change depending on the value of one particular object. This...

Hi, This sounds really simple, and I'm sure I'm missing something. I can't find anything online about what I'm trying to do, maybe I'm not wording my searches very well. I've got a simple report with a detail section and two levels of grouping. In the top group I have column headings...

I have since received assistance from another source, and this issue is now resolved. In case anybody else encounters this situation, individual lines can be specified from a memo field by using the MLINE() function with the following syntax: MLINE(MemoName, LineNo) Matthew