Search results for query: *

dhookum Thanks for that, I shall try it. Can I 'fool' Access into thinking that it has found some data, so that it will print the header and so on, and then the No Data message? Mike

I have a main report with 7 subreports. Some of these subreports may be empty. When one is empty, nothing prints at all for that subreport. I want to print an empty subreport (title, header and so on) and also a message to say that it is intentionally empty. I need the message on the report...

Skip: I was thinking that it had to be PUSHED from Access into Excel, but it could be PULLED by Excel from Access. Either way, the data will always exist in Access first. Mike

I'm new to Access, Excel and VBA. I'd like to create (if not already existing) a named Excel sheet and then populate certain cells in it with certain data from a record in an Access db. I realise that what I want to do is not best suited to my beginner status, but that's just tough on me: it...

Hi Tony (et al) I like the idea of pre-assigning all the numbers (presumably by creating otherwise blank records?) then letting the user(s) choose a number, as it were, I hadn't thought of that one. Part of my problem (I suspect) is that in the dim and distant past, long before OOP came along...

Thanks everybody. I shall try the code and see how I get on and also try letting Access do it by itself. I can't use an autonumber as a) the records will start from 1001 (which I could get around) and b) if a user is part way through entering a new record, then decides against it, Access 'uses...

Cap'n Thicky here! I need to validate a user input value... Table: tbl-Specimen Key field: SpecimenID (integer) Temp variable: TestSpecID (integer) I can't use 'autonumber' for the key field, so I need to check that whatever the user has entered is unique. I'm a very newbie user so please...

And another one in a similar vein... Ninety percent of a project takes 90% of the time, the remaining 10% of the project takes the other 90% of the time! Mike

I heard this somewhere a few years ago (I wish it was all mine!)... When asked how long something will take, work it out roughly, in your head, then multiply by four and tell 'em that. In this way, when the job takes twice as long as you thought, you still complete it in half the time you told...

Just say 'No!'. Actually a little hard to do the first time, but you get used to it, I have! It is the most unexpected answer for any manager to receive. They are used to arguing and pleading and prevarication, but not to a simple, polite, 'Sorry, not possible.' Try it, you'll get to like it...

I have the following code... '--------------------------------------------------------------------------------------------- 'Deletes the current specimen record '--------------------------------------------------------------------------------------------- Private Sub...

Wow! What a mess of things I've made trying to use this thing! User can enter a date (it defaults to day) but I thought having such a calendar control thingy would be neat (ha!). If this is hugely complicated, tell me and I'll live without it, if not... 1. How do I 'popup' the calendar...

I have a form displayed with various command buttons on it. I want to stop the fields from being highlighted automatically. One, it looks untidy and two it makes the user think they can edit them (when they can't because they're all locked). Any ideas? Probably a blindingly simple answer to...

Possibly a silly question... Form displayed on screen with command buttons to go to next/previous records, etc (I don't use the built in next/prev buttons). How can I ensure that the user cannot scroll past the last 'real' record into the 'new', blank record? I don't want some users to be...

RJFost - I like it! One of my most often used properties actually!!! Mike

KenReay, zevw and willir Thanks for the replies, very helpful Mike

Yesterday I was convinced that I needed to find out how many records there were in the table and what record I was looking at at any 1 time...today I can't really see the point at all, but thanks anyway for the tips!

Well, can you? Using autonumber in my table really will make life a whole lot easier for me...but I need to start it at 1001 (its a long story!), then increment by 1 each time for each new record. Is this possible? Mike ps Please keep any reply simple...because I am!

1. How/where can I find out how many records there are in a table? 2. How/where can I find out which, numerically speaking, record I'm currently looking at? Mike

Thank you Foolio12 and Kocheace, I'll try all suggestions and see how I get on. Mike