Search results for query: *

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...

Dear JerSand All the answers you have received will work fine, but I think there's a better way, avoiding some of the drawbacks. These are: Disabling all the other controls and then enabling them once the user has entered an ID is fine, but will invoive a lot of enabling statements - if you...

I agree with Smack - it's not much bother to duplicate the line of code for a second or third attachgment. I have a database with a button that sends details of students via e-mail to a colleague. It has to send three files, so I just use SendObject three times. If you don't know at coding time...

Thanks, Dreamboat, but I'm convinced this is a problem that Microsoft ought to own up to - it doesn't fir into their proud boast about Office being 'truly cross-platform'. Personally, I'd be delighted if the client would change to Windows, but that ain't gonna happen! Cheers. Paul

Hi, all I've used VBA on Windows quite successfully, and recently developed a system which had a combo box to display a list of some 3000 schools. It worked as expected on a PC, but when I installed on the person's Mac it failed with an 'Out of memory' message. There's something on the...

Thanks, Dreamboat, but I'm afraid that isn't the problem - it's only Outlook Express that does this - all other programs behave as you say.