Search results for query: *

I'm running OE6 on XP and have been having trouble printing out on an old Brother Laser (HL730). I can't control the size of the font that it prints out at and everything comes out extra large. The text of the message comes out about twice the size it should whereas the header is normal size...

How can I find out what program or running service is constantly accessing my hard drive. This happens when there is nothing running for example when I have just started my machine. The only items in the task bar are for volume, directCD, MS sidewinder, touch pad and Norton AV. I have been...

This is getting silly. Where oh where is my password saved in the registry for my dial-up connection. I originally typed in the wrong password when setting up my internet connection, and no matter what I do it will not save the corrected password, but keeps returning the wrong one. I've...

Thanks for the advice. What is strange is that the identical code works fine in another form doing a similar thing. The WHERE False bit came from an Access wizard or sample database (I can't remember which). The code only runs when a clear button is pressed so shouldn't have any effect when...

If only I knew why. Whenever I add the following bit of code to one of my form modules I get the message "This program has performed an illegal operation. MSACCESS caused an invalid page fault in module VBA232.dll at 018f:0fb3b4e0. The code is to clear the form and subform Dim MySQL As...

Thanks for the help guys. I still cant get the old password out of the system. I don't think the password for internet connections is stored on the registry subkeys I deleted. I've searched MS knowledge base and the dougknox site but cant find an answer yet. Any more ideas? Cheers Keith

No, its no use. Every time I delete the old connection and setup a new one using I get the incorrect password being saved. It doesn't seem to matter whether I click on the password box where it says 'click here to change password' because as soon as I close this screen and dial up, all I get is...

I did try setting up a new connection to solve the problem but strangely this didn't work either. I'll give it another go though. Thanks for your reply though

The fool I am, I typed the wrong password into the setup screen when I setup an existing ISP when I installed XP. Whenever I go to try to correct it through the Internet Options dialog box, it always reverts to the incorrect version I first typed. I can delete the password altogether but that...

Thanks Larry, it works a treat. Keith

Thanks Larry. Got it to work today - to my surprise I must have got the rest of the code right as well. Next step is to get the code to automatically add an * at either end of the users entry. Do I just do this by typing "*" & at the start and end? Thanks.

Thanks Larry. Got it to work today - to my surprise I must have got the rest of the code right as well. Thanks.

Such a speedy response! Thanks for your help Larry, I'll try it tomorrow. Cheers, Keith

I'm trying to use 'MyRecordSource = MySQL & MyCriteria' to search for data in a set of linked tables based upon a name typed into a search box by the user. I can do the SELECT statement bit, but don't know how to write the MyCriteria part for the WHERE clause. In effect, I want to find all...

Thanks mac and cmmrfrds. Where would I put the debug.print code? Mac, could you expand on your recommendation as Access is still somewhat new to me, and so far I've only got as far as I have by looking at others people's working code and adapting to suit my database. Thanks

In a nutshell, I have a 'new jobs' form where the 'clients name' is entered. If the client is already in the client table then that clients ID number is 'bound' into my jobs table. However, if the client is new, then on the NotInList event the 'add new client' form is opened. I would like the...

Thanks for your reply. I have actually managed to solve my problem by using an 'on click' event for one of the fields in the 'results' subform which then shows related data in the second subform using a query based on that records ID Ref. Strangely I couldn't get this to work using the 'on...

Thanks for the response. I think I need it to be a bit more automatic than that, since most users will be only using the form to get the information in this second subform. I did think about a command button at the end of each record in the first subform but couldn't do that when my subform is...

I am a newbie and getting slightly bewildered. I've set up a small database for our office and have a main form in which users can enter search criteria in text boxes which then uses a select statement (based/copied from MS Solutions) to show results in a subform. I want to be able to then click...

I am a newbie and getting slightly bewildered. I've set up a small database for our office and have a main form in which users can enter search criteria in text boxes which then uses a select statement (based/copied from MS Solutions) to show results in a subform. I want to be able to then click...