Recent content by BRANDON99

Hi Thanks for you reply. I had a look at it and I remembered how to do it. It's about 9 years since I last used access so I am a bit rusty.

Hi Thanks again but I did not describe the downloaded data properly. EG the payment ref for EDF is "001007 Edf Pr Qe Clio Bnpp *187801275289 23210 134 Edf Pr " but the last group of numbers change for each payment so what I need to do is just match the edf part of this. I do not know...

Hi Thanks for your reply, that seems like the easiest solution but I would really like to do this with VBA, I would like to get back into writting some code again regards

Hi I think this is a simple question but it is several years since I used Access. I have Access 2010. I have created a table into which I download my bank statements, named tblStatements. One field is “spent_at” another is “Group” I want to update the field” Group” depending on the contents...

Hi It the Declare Statement the line "Private Declare Function" is changed to "Private Declare PtrSafe Function" I thought it was to easy but it works

Thanks for your email - I found the solution and have fixed

Hi I have an Access 2003 Application, I have now changed to Win 7 and Access 2010 64 bit. When I try to run it I get this message " Compile Error: THe code in this project must be updated for use on 64-bit systems. Please review and update Declare statements and then mark them with PtrSafe...

Thanks MajP Can you please explain what else I would need to add to then update the Category field

Hi I only want to match part of the DetailOfOperation field, eg Carte Tesco Gaillac 30/08/2010, the ItemName would be Tesco, Meaning field - Food. Any DetailOfOperation field containing Tesco would cause Category field update to Food

Hi I would like to analyse my spending from the last few years and have downloaded the statements. I have added an extra field, Category which I want to update with code. There is a field, Detail of Operation that identifies each type of transaction giving detail of payment type, card...

Hi I would like to add a text field to a table. I am sure this can be done with a query or code but after searching can not find an answer. Can anyone suggest a solution? I am using Access 2003 Thanks Stephen

Thanks MajP I installed Access 2007, added the pictures to the data base. Iys doesn't appear to be much smaller than if I used Access 2003, down from 84000 to 74000. Am I doing it wrong?

Hi I have searched this forum without luck. I would like to create a continuous form that displays a linked picture. I am sure I have seen this done but I am unable to find a way to achieve it. Can anyone help please. I am using Access 2003 but could install Access 2007 if this helps Thanks...

Thanks Remou I had a look at the link but I think this is over complicating what I need but I also need to display a year or 2 at a time

Hi I would like to create a simple online calendar that will allow viewers to see if a property is available for rent or if it is already booked. The calendar would need to display 12 months at a time, ideally with the ability to scroll forward. The calendar would have one colour block for...