Search results for query: *

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...

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...

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...

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...

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...

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

Dumb question no. 243: I have a form displayed which includes a command button to delete the current record. How do I delete the current record? Below is the code I have managed to get so far... . . . 'Deletes the current specimen record (confirmation box) Private Sub...

I'm writing a small application and wish to record the user's name in each record (so I can find out who entered all the wrong data!) Has anyone got any hints, tricks or tips about doing this such as entering user name (can this be retrieved from Windows XP?), best way to store user name...

Background... MS Access 2000 Table tbl-Specimens Form frm-SpecimenView In tbl-Specimens, I have 2 fields (amongst others!) which I'm having trouble with. One is called 'code' and is obtained from a lookup which get's its data from a separate table. The other is called UNS. The combo box for...

Hello everyone, this is probably another mind-numbingly simple question, but here goes... I have an open form on screen displaying data from a single table and wish to print that data as a report rather than print the form. I guess I need to use a query to retrieve the record currently...

Hi All I hope this isn't a dumb question, but here goes... How do I maximise a form on screen, automatically? I have tried manually maximising it (design view), then 'running' it, which is fine, until I open it again, when it has shrunk. Aaaaaarrrrrgh! I expect I'm not doing something...

Don't get all complicated if you do reply: what I want to do might be clever...I'm not! MS Access 2000 on XP Pro. I have a form open for editing and want to automatically close the form say 5 mins after last key press or mouse click. I can get the form to close after n millisecs, but I cannot...