Replies

The form now has a filter permanently set and when it is invoked a second time, the result is a filter is on with no selected records, so I cannot check it by record selection. Before I coded Lookfor though, updates could be done
Andrew

Hansv

Thankyou for both the reply and its speed and accuracy – another step forward that seems to work very.
I’m now happily editting – but when I go to save I get a message saying that the record is locked by another user (it isn’t)
I’m obviously now missing something else – any ideas?

Andrew

[indent]

---

Or do you just mean that once it is created and saved, then you can drag it to the desired time slot?

---

[/indent]
Yes – that’s what I meant

… and then of course, once its on the correct date, you can drag it to the correct time (to the nearest resolution interval) by doing the dragging in the calendar’s day pane.

Thanks Jefferson
I’m hopeful that this is the answer, and I’m going to convince myself of it by snapshotting the traffic count at my ISP before and after – should be entertaining

Hans
Thanks very much
That was one of the by-products of having Access generate code – I remember my early days with Excel code generation all too painfully

Dave & Hans Yes I was looking for a parameter form and Dave, the first link worked a treat. I’ll use the dropdowns in another part of the task.

Another day, another thing learnt. Thank you both.

Hans
Thanks for responding – sorry about the confusion
I want to filter the form based on a date and or an item name and then do data entry on the resulting filtered tabular entity.

Heck – I wouldn’t know if a combo box would solve the problem because I don’t know how one would be used – I’m assuming “no” because a date is just a date and a name is presumably a wild-card lookup.

It’s very rare to see text files without a final CRLF pair – generally that would be an error, even in a text editor such as notepad

700MB – really MEGA bytes and not 700KB?

Eight pictures, in word, taking 700KB would be about what I’d expect, depending on size of picture.
If all eight fitted on one page, then that would be a different story and I’d expect less – say 150KB or so

Andrew

I find the word compression works very well for the function described and would recommend it as by far the easiest method for word users who don’t want to be bothered by geeky things.

Insert the picture(s) into your word document and drag it to the size you want, then, on the picture toolbar select ‘compress pictures’
Personally I find 200dpi is an excellent compromise for mere mortals.

I have 2002

My POP3 account is the only entry included as an account and is not called ‘personal folders’ (although ‘personal folders’ is isolated as the default location for the inbox.)

As a suggestion, I’d
1 save the Outlook .pst file under a new name (outside Outlook)
2 configure a new reference to the POP3 account via Tools > e-mail accounts add
3 make the new account the default
4 blow away the bad account
5 Exit Outlook
6 copy the Outlook.pst file over the top of the just created one

and to add to Hans’s comment – you have to leave Outlook running, for rules to be processed.
I’m assuming you knew that because you do similar things in Outlook Express

I’d also suspect that there may be other rules involved in processing this.
I agree, generally adding ‘stop processing more rules’ after all rules when they have identified their unique action is a good defense for odd behaviour.

[indent]

---

The drawback of this (in Office 2002 and 2003) is that you can’t move your other places up and down anymore

---

[/indent]
I’d never noticed and of course its obvious once you point it out
For my five or six key references I’m going to live with the inconvenience

I sometimes wonder if Microsoft has to deliberately code for these kinds of side effects or whether simple incompetence covers it.