Recent content by PaulMilnes

Can anyone help, I wonder? I've created a macro in PowerPoint to make an invisible object visible On Mouse Over (in the Action Settings, I've chosen 'Run macro' and selected the correct macro). When I run it from Tools - Macros,in design view, it works fine. When I try it out in Slide Show...

Dzshanno If you want full control over your font, create a small popup form instead of using a message box. Set both Popup and Modal to Yes to insist that the user gives a response. HTH Paul

Dear Ray Yes - it's a case for SelStart. I can't lay my hands on the details at the moment, but I needed to do this some time ago and that was the solution. All other fiddling about, including SendKeys "{END}" etc., didn't work for some reason. If I can find 'chapter and verse' I'll...

Steven It seems to me that your code makes it possible for value2 to be assigned if it's null, as you haven't checked it. This would give an error, which wouldn't be triggered if value2 is populated. Perhaps you should do a general check first, to determine if both values are null. HTH Paul

Thanks for that, Andy. Actually, a colleague here found the 'web' location. We think it's there because of something to do with Active Desktop, although it might be nice if Microsoft, instead of just saying 'select Folder Options' and leaving you to it, said what to do if it's not there! We...

Dear Lloyd I do the opposite to make Word visible - ie: issue a command that says objWord.Application.Visible=True. So I suppose you could ensure that Access stays in front by using the reverse (ie: = False). However, I think there is a way to start programs in Minimized mode, which might be...

I'm using Windows 98 SE and for the life of me I can't find Folder Options anywhere. It should be in View in My Computer or Windows Explorer, but it isn't. It could've been moved to Control Panel (as in Windows Me), but it hasn't. Where on earth can it be? Any help gratefully received. Paul

Dear Aishaa The tabs are turned on and off in Tools - Options. Select the View tab (at the top) and down to the right-hand corner you'll see a check box for Sheet Tabs. The only other thing that could remove them would be going to Full Screen (on the View menu). Select it again to go back to...

One more thing, Dale, on the password front. I was right about the InputBox - there's no way of obscuring the password. If this is important, create a pop-up form with a text box on it for the password and set its InputMask property to Password. Then anything typed will appear as asterisks...

Dale Here's the code I use for launching Word. I guess if you replace Word with Excel throughout that should do the trick. On Error GoTo Merge_Err Dim objWord As Object Set objWord = GetObject("Word.Application") **** Do things here. You'll have to find out how to give commands to...

I have had to implement this for several controls on a form under just the circumstances you describe - ie: someone in authority should be able to change values. I put my code behind the 'On Enter event' which triggered a MsgBox asking if the user was sure they wanted to change the field. If...

Jason - What you want to do is clearer in your code if you use a recordset. If you're OK with Lonnie's SQL, well and good, but if not, I can send you some typical code which will create the recordset and add a new record. Best regards Paul

Tim - You can put an event in the MouseOver section for a button, but you can't change its colour (I don't know why, but Microcoft don't provide a property for that. You can change the colour of the text, though. A better effect can be created by making the button invisible and putting the...

CountryBoy - There is a more reliable way to keep 'them' at bay. In the Tools you'll find Startup. Here you can set your system to start with a particular form, suppress the database window and menus, and so on. In the Advanced section you can also suppress the Access shortcut key which would...

Dear Martin I'm not absolutely sure about this, but I believe you always have to use US dates in your SQL, even if you're set to British. I seem to remember falling foul of this myself sometime ago and discovering that this was the case. Worth a try, at least. (Why, oh why couldn't they have...