Replies

Thanks.
Looking forward to hearing if/when you solve the size problem.

the image fix works like a charm.

By the way, how do you create the hotlink back to the other thread?

Hey — thanks for looking at that one. I am still awaiting an answer!! And you are right, it is bizarre.

Got another one if you are up to it…

What property holds the width (or height) of the current slide. I’ve tried ActiveWindow.width, but that seems to be something other than the actual slide size.

What I am trying to do is to allow the user to drop any size file onto the slide, and have it resize itself automatically to fully occupy the slide space, whether the slide is portrait or landscape. I keep getting overhang.

Drat!!! I had feared that was the answer. My macro already does what you suggest.
Thanks for the clarification.

WOW!!!!!

AJF – you have gone above and beyond the call of duty! Thanks very much. The key to your trick was how to get that average onto the secondary axis. I had been able to get it onto the graph, but as you know, adding the data series dropped one of the other four. I didn’t know how to recover all five series. Your trick of hover and right-click was just the ticket!!

Thanks again.

Create a new query that contains both tables. Drag the phone number from one table into the other table to create a JOIN between them. double-click the asterisk from one of the tables to indicate that all the fields should be shown in the query. Run the query. the resulting records are the ones in which the phone numbers are equal.

return to the query design and change the query into a MakeTable query. Run the query, and it will create the new table for you.

Done.

You will see the range that defines the chart. What I would like to do is to add the data from row 6 (avg), and have it appear as a line overlaying the stock chart.

I kinda get the feeling that it’s not possible, but was hoping that somebody has found a way to do it.

Thx.

A method I use to get the syntax right is to always complete the “skeleton” of the IF before writing any of the “guts”. For example, type:

equal sign
IF
opening bracket
comma
comma
closting bracket

Then go back and fill in the blanks. Doing it this way makes it easier to get the right number of commas and brackets. In this case, the first term would be the comparison (a2>=25), the second term would be the value (5), and the third term would be another IF statement, which you would build the same way. Continue for each additional IF.

Here’s a little stub that I use in an application. On my system (before I loaded LookOut as an experiment…), it would launch my preferred email (Pegasus). On the client’s machine (he uses LookOut ), it would launch his preferred email software. Hope it works for you:

Private Sub cmdEmail_Click()
Dim sText As String

If Len(Me![uFrmContactSUB].Form!) Then
sText = Me![uFrmContactSUB].Form!
End If

If Len(sText) Then
sText = “mailto:” & sText
Call ShellExecute(Me.Hwnd, “open”, sText, _
vbNullString, vbNullString, 1)
End If

End Sub

Extremely powerful… and it takes a while to learn. I suggest that you pick up a good book on programming Access. Any good computer bookstore will have a variety of books to choose from. Look for one that goes beyond the basic Access introduction into the area of programming. One of the best is Access Developer’s Handbook by Litwin, Getz, and Gilbert. It’s not really a beginners’ book, but is very thorough.

One of the things you will learn is how to apply an SQL string as the recordset for a form or a listbox.

For this specific example, you will notice that the WHERE xxx IN (SELECT… ) part is very structured. If you design a form with “bits of code” attached to various controls designating the various languages, you can build up a SQL string as the user clicks each control. Then once the string is formed, you apply it to a form or a listbox.

Experiment by building the string manually and applying it to a listbox. Nest some additional WHERE xxx IN (SELECT….) clauses. Then move on to building the string when the user clicks the various parts of the form.

HTH

Answered my own question after reading “Don’t know what to call it” thread by LonnieB. The answer there inspired me to write this VBA code:

Private Sub cmdExtractMaxHours_Click()
Dim MachineID As Range

Sheets(“copyMax”).Select
Sheets(“CopyMax”).Range(“a2:m1000”).ClearContents
Sheets(1).Select
Range(“CurrentID”).Value = 0

For Each MachineID In Range(“a5:a5000”)
If MachineID.Value = “” Then Exit Sub
If MachineID.Value Range(“CurrentID”).Value Then
If MachineID.Offset(0, 6) <= Range("MaxHours") Then
Range("CurrentID") = MachineID.Value
MachineID.EntireRow.Copy
Sheets("CopyMax").Range("A65536:FA65536").End(xlUp).Offset(1).PasteSpecial Paste:=xlAll
End If
End If
Next
End Sub

Don't know if it's possible to do without VBA, but this works for me.

I’ve had good success with the MDBDiff utility from http://www.pb-sys.com/ The web site lists this software as “retired”, but it is still available. I’ve used only the Acc97 version, but A2K is also available.

Done.

In anticipation of your next question, you build up the more complex query by building the SQL on-the-fly. Combine as many AND operations as you like by concatenating successive IN statements. The result of one query becomes the basis for building the next query.

Tried to post an attachment, but was unsuccessful. If you send me your email, I will send it to you directly.

You can’t do it directly. Instead, you need to select the people who speak English, and then from that group, select the people that speak Dutch. It can be done using a Subselect

select IDName from connect where (IDLanguage = “dutch”) and IDName IN (select IDName from connect where IDLanguage=”English”)

The key to this technique is using the IN operator.

Hope this helps.

Gee — it’s kinda reassuring to know that I’m not alone. I’ve read a lot about VB and its power, but most of my experience has been with Access. I am always spinning my wheels with VB — thought that it was just me. Glad (???) to see that someone with Charlotte’s depth of knowledge is similarly befuddled.