Search results

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

Hello, I'm modifying a report that retrieves data from a FoxPro-based system. One of the fields returned is a memo type field. Currently the report just returns the whole field, which could consist up to seven lines. Up until now this hasn't been an issue, but recently some records have been...

If no one has any further ideas on how to get this to work, can anyone suggest another way of doing this? Is there a way to call a macro in a spreadsheet from a batch file or VB Script that would execute the macro within the open workbook, and not try to open a new instance of it? If so, then I...

Thank you for your reply, David. I have just tried using that in an if statement and I still have the same problem in that it runs fine as long as I open the file myself. As soon as the batch file comes into the equation I get a problem. The problem I am getting now is 'subscript out of range'...

Hello, I'm trying to ensure that a particular workbook (named Despatch_Schedule) on a particular machine is closed at certain times of the day. The workbook is populated with data from an SOP, and needs to be closed while the update takes place. I have made a new workbook and given it a...

O.K., thank you for your suggestion. Matthew