Replies

Thanks again. Looks like I’ll have to do a load more studying before I can begin to use the server.

In Access 2003 I just used username sa and password ‘admin’ and I was up and running.. Ah well, Andy.

Thank you. But I just want to use SQL Server on my PC to learn about it. So I’m hoping to just connect to it from an Access adp.

If I select Local Service and it is running, why wouldn’t it appear in my list of available servers in the adp connection dialog? Andy.

If you want to learn more on OOP:

http://www.visualbasicbooks.com/progVB6samplepg1.html

Thank you. This is a great site for my purposes.

Andy.

Thank you

Hello again.

Someone asked for this during a course. A Flash file can run in it’s own space on a slide so I thought it might be possible to do
a similar thing with a hyperlink to a web page. Is it possible to modify the hyperlink and persuade it to open the page in a full screen view?
I think the main intent is to hide screen clutter during the presentation.

Andy.

Hi again.
Yes I just want to demonstrate recording. There isn’t much useful to do that can’t be done just by copying, pasting, deleting, etc.

However, if I select a shape before recording, I can make it a specific size and add a specific shadow to it. I can then align
it to the right of the slide. (I can’t move it really because that generates code that increments it’s position..)

I presume Microsoft removed macro recording in 2007 because no one could make use of it. Andy.

I don’t think this can be done in 2003; I believe I can only move the existing place-holders around, not add another.

I believe I can achieve what I need in a few stages.

Re-order the Word document to separate Titles/ Subtitles and Titles/ Bullets.
Change the slide layouts (possibly twice).
Then drag the slides to the correct order.

Messy, but it should work. Thanks again, Andy.

Thank you (again).

I can convert the Heading 2s to subtitles this way, but still lose my original bullets. Andy.

Thank you.

I’m not sure I can record much when running a show – it says go to slide show, go to next slide, exit show – probably not much else?

I assume you mean that if I record applying 10 timings to a sequence of slides, when I run it will apply the same timings to the current
sequence of ten slides?
I will try copying and pasting formats etc., as suggested, but if I click on a specific shape it will use that shapes name. Perhaps if I tab
to a second or third object on the slide it might work.

Thanks again. Andy.

Thank you very much. These look like good examples for me to study.

Andy.

Thank you very much.

So a Public Sub is a method, but for a method to return a value it must be a Public Function? Is there any point in using Public Sub
to represent a method, when I could use a function and just not return a value?

My second question was – is it possible (with VBA) for a class to have another class as a member? Andy.

Hi, and thanks. When I did that the first time it showed as a second total within the same salary column. I just did it again and it initially
displayed a separate salary column – so I had one for Min and one for Max (as required).
I have a row area of Office; if I hide the details for this the max again becomes a separate column. Perhaps this is the way it is supposed to behave?
Andy.

This is a bit sad, but I think I’ve answered my own questions. I’ll post the answers in case anyone’s interested.

Snap to grid requires the Grid X and Grid Y co-ordinates (of the form) to be reduced below the default value of 10.

Anchoring of controls applies in form view, not design view. For example, a control can stretch if a user increases the size of the form.
(I found this from a YouTube video from Access 2007: The Missing Manual.

Going direct to Design View and creating a form from scratch defaults to removing the controls layout feature. It is on by default if,
for example, a tabular form is first chosen.

Andy.

Hello again. Thank you for your response.

I’m going to leave as is – firstly because it’s on a company’s computer. Secondly, it’s very messy: the description appears under the dates and you can’t sort
by them (as you could in 2003 when they were listed in separate columns).
Ideally the description would appear as a ‘tip text’ as you point at an object, but Microsoft didn’t seek my advice!

Andy.

Hi. I thought so too, but a colleague has the description showing alongside the query dates. Andy.