Recent content by lennyBaby

Thanks alot Wayne - Will give it a try

I am writing some search results to an excelsheet for reports using the time and date functions to build a filename. I downloaded a StripSpecialCharacters() module, but it doesn't take them all out (only takes ascii above 127). Does anybody know of another function to do it. searched the...

Thanks Pat for replying. I worked out what was happening, I was opening an older version of the main form....sorry

I am building a database for a client that tracks construction drawings. The client came today to check on progress. Just before he came, I changed the start-up properties to hide the database window, menus etc so it would look more like the finished product. Problem was, I lost alot of the...

Thanks alot for that

I am trying to add a common dialog to my form from the toolbox and get the following error 'you dont have the license required to use this ActiveX control. Is there any way I can sort this out? I am using Access 2002. I am getting desperate and any help would be much appreciated

Thanks dude

I am new to VB and want to know how to chop the last three characters off a string. Am writing dynamic SQL and have to take the AND off the last WHERE clause if needed. Any help greatly appreciated

I am doing a search form on a database and after the search, I have 'new search' & 'refine search' options. The list box is filled from a query and when the user selects 'new search' I want it to show nothing selected.