Replies

Dale,

Welcome to the Lounge.

This is just a shot in the dark but what audio format are you using? Is that format supported in 2007?
The dramatic increase in size, at least to me, would suggest a conversion of the audio. I’ve done some pretty large presentations with animation effects and all and never approached that size in 2003, 2002, 2000.

Addendum: I just went back and checked and I have a 111 Slide presentation with graphics and animations in PP 2003 and it is only 908Kb!

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Could you possibly post a sanitized version of your workbook?

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Make sure one of them doesn’t have a space preceeding or following it, that would make it unique.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Angela,

I think what Wendell was asking is why isn’t .MDB on the table as a format?

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Patt,

Good Idea. See graphics.

Dad – I hope this solves your problem.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

If possible, I’d like to do this conversion in the query field box, since there are currently no code modules running in this db. Is that possible, or do I need to add a function to do this?

To the best of my knowledge you will have to add a function. Sorry.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Dad,

This shows how to do it. You can integrate it into your code.

Code:

Function NumberToTime(lMyNum As Long) As Boolean

   Dim iSecs As Integer
   Dim iMins As Integer
   Dim iHrs  As Integer
   Dim dtTime As Date
   
   
   iSecs = lMyNum Mod 100 ' Returns Seconds
   
   iMins = ((lMyNum  100) Mod 100)  'Returns Minutes
   
   iHrs = (lMyNum  10000) 'Returns Hours
   
   
   MsgBox "Your number contains:" & vbCrLf & _
          Format(iSecs, "##") & " Seconds" & vbCrLf & _
          Format(iMins, "##") & " Minutes" & vbCrLf & _
          Format(iHrs, "##") & " Hours", vbOKOnly, _
          "Conversion of Number to Time"
   
  'Convert to TimeValue
  
   dtTime = TimeValue(Format(iHrs, "##") & ":" & _
                      Format(iMins, "##") & ":" & _
                      Format(iSecs, "##"))
   MsgBox "DateTime Value is: " & Format(dtTime, "hh:mm:ss"), _
           vbOKOnly, "Shown as Time"
End Function

This is a standalone function so you can copy it into the VBE and call it from the Immediate window to test it.

I hope this solves your problem.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Eric,

I’d disconnect from the internet. Run all your anti-virus and rootkit detectors and see if you find anything. If not I’d reconnect but don’t open your email client. Go to the Anti-Virus vendor’s sites and use their online scanners and see what they turn up. You can also download Malwarebytes and run it.

It sounds like you have something that installed a mailer worm of some sort.

Good Luck.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

John,

Try unchecking “Use smart paragraph selection” in the Options, Edit Tab. This seems to work.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Frank,

My guess would be that whoever created the presentations set the font on each slide thus over-riding the master slide font. The local selection will not be affected by changing master.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

John,

What I do is just hold down my Shift Key and press the back arrow key to unhighlight the paragraph mark.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Liz & John,

I’ve never used TempVars either so I googled it and found this on the Microsoft Office site. It’s new to 2007.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Liz,

See this thread.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Zeddy,

In your first post you mentioned it was an .xlsm file indicating Macros {VBA}. Is there something in the VBA that could be causing the link? Just a thought.

Good Luck.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

The local copy will have no effect on the linked table. I’d give the local table a very different name so you don’t accidentally confuse the two.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs