Search results

Hi all, I hope someone can help. I use an ADO function to sort and rank a table which worked fine in my old Access 2003 setup. I now have a new machine and I've upgraded to Access 2007 and I'm finding the function doesn't work. My suspicion is that I'm missing an ADO reference, but don't know...

I've just changed from Access 2003 to 2007. In 2003, I had a quick and dirty way to allow users to update data in a table using the inbuilt switchboard manager. The user goes to a sub-switchboard from the main switchboard then clicks a button which uses a macro to run the open table command...

Until yesterday I had never had this issue. I've been experimenting with Visual Studio and it suddenly decided to make my XP SP3 machine decide that no MS Office applications were installed. This resulted in the need for a clean install of Office which has now been done. Normality is...

Hi all, this is my first question on these forums, so please forgive any unintentional bloopers or faux pas! I have a database which is really simple - it's actually only a linked table. I use it to change the format of a text field which contains a date. All I do in the database is select the...

...glad to be on these forums. I've hacked around in Access for years without needing VBA, but it seems there's no escaping it. Having ghosted around and mostly found answers to my questions without needing to post, I've seen this is a good place to come to, so I'm hopeful I'll get over my...