Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. PaulMilnes

    Running macros in PowerPoint

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

    can you change the font in a message box?

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

    placing the 'cursor' at the end of autoentry in a control

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

    Simple Addition Fomula

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

    No folder options!?

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

    Automating MS WORD

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

    No folder options!?

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

    Excel Sheet tabs vanished!

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

    Does anyone know the code for launching Excel from within Access ?

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

    Does anyone know the code for launching Excel from within Access ?

    ...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 Excel. Here's an example where I start a new document based on a template and...
  11. PaulMilnes

    Password protect one field

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

    Need to create a new record in a table using known values

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

    Create rollovers on forms?

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

    Need to keep others out of design view.

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

    Can you tell me why my SQL query returns nothing?

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

    REQUIRE AN ENTRY BEFORE PROCEEDING IN A FORM

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

    Multiple attachments on E-mails?

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

    Using Excel VBA on a Mac

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

    Using Excel VBA on a Mac

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

    Paper orientation in Outlook Express

    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.

Part and Inventory Search

Back
Top