Search results

Hi All, FIRSTLY I HAVE POSTED THIS PROBLEM ON ANOTHER FORUM I have a routine than has been working perfectly up to now. My save routine was called by clicking a Command Button called cmdAdd. I tried to change this Command Button to a toggle button by deleting it then creating the toggle...

Hi All, I need some kind of routine (probably a batch file) that can look at a user's PC and find if Access is actually on the machine or not. If yes - no problem my install programme just installs my app. If not then I need to install Access RunTime. Any thoughts as to how I can do this...

Hi Guys, I need to look through a table (tblVAT). If I find a record where field VATMonth is equal to my variable (varMonth) then I need to edit the other fields in that record. If I reach EOF then I need to add a new record to the table. The SQL I've used (Which doesn't do half the job -...

Hi All, I've just spent a few frustrating weeks trying to resolve an error that occurred when I tried to build a "Restore" programme in VBA. I want to add that if one googles the web for Error 70 Permission Denied one finds thousands of cases and none are ever fully resolved so I think that it...

Hi All, I'm thinking of creating a central store of routines used in my various programmes. Does anyone out there have a routine in Access that will look through several other Access programmes (even one by one) and make a list of what subs and functions exist and where they are (Mdb name...

I need to search for similar words in a file. eg In a Master table the CoName might be "Ben's Boutique" - If in another file (imported data) there is a name "Bens Boutique" it would be great if one could either just accept it or ask user to confirm. Other examples might be Bens_Boutique, BENS...

:) Hi there, I'm Alan and I live and work in Blantyre, Malawi. After a career doing banking, accounting, then software development in Clipper/dBase I spent 10 years running an Asset Finance company. (Who says that all that time spent doing system specs is wasted) I'm now back to...

Hi All, I live in Malawi where the majority of machines do have MS Office installed BUT most often will be 2003 or earlier. I'm doing all my development in 2003 as a result. However, I read somewhere that one can use a 2007 or even 2010 run time with an mde developed in 2003. 1. Is this...

Hi, Is there anyone out there based in Malawi? I sometimes feel like the only Access or Excel programmer around:( Regards Alan

Hi Guys, There's a site in the UK called DatabaseAnswers run by Barry Williams. It contains literally hundreds of data structures which seem to be great. Unfortunately there seems to be something wrong as any emails sent to the site are bounced but nevertheless its really worth looking at...