Search results

Lots of interesting stuff. Cheers Rich. Arthurdenhoedt. If you want a copy of either the function or the whole kit caboodle post back or PM your email and I'll forward it... Save Rich doing it all again.

The only sure way I have found is to unsecure the db first and then rebuild the .mdw. Open the db in its origonal form and log on as admin. Change the permissions for the Users group to give full permissions for everything. Exit and restart Access and log on as Admin. again Create a new blank...

That would be nice. I checked P.H's ref as well and it dosn't appear to exist any more :( Either that or MS is lying again :mad: Cheers

That would be neat if I could find it :confused: any chance of a link?

A lot of this will depend, not only, on your OS but on the printer software as well. My colour laser doesn't allow split printing either. Try printing as two seperate jobs and print page one as one job, page two as the next etc, I know it's a messy workround but it's the only way one of my...

I've seen a few utilities on the net for such things though I can't remember exactly where. Try doing a net search for 'db naming conventions'. If you don't have any luck post back and I will try to dig up some links for you.

Err have you tried looking at the sticky thread "recomended reading list"? It's in the top section of this forum :D

A lot depends on how you are opening your second db. You need to start another instance of Access. If you go to the file menu or use a standard commwnd within an already open db then, by default, Access will switch to the new db rather than open another instance. I believe there is a way to...

You might use a checkbox as a field to indicate the status of an item. I.e. you could use a check box to indicate that you are reading a book.......... If it is checked then that book is being read if unchecked it is not. You can also group controls like this to indicate a number of different...

Ok thanks for that. One more question though. It is easy enough to set the width of a report and work within it. But how do I set the length so that I don't oversize the page? I'm not going to work on it now............It is a h:D lliday. Is that half rendered or half plastered? :D My...

Thanks Rich Yes a driver could have many stops. Each work order is dedicated to one job but the form has to handle all eventualities. The job can entail anything from a simple airport pick up to multi stops for meetings etc However, on the first page, the table for driving and waiting times...

Hi Annie It's a bit quiet here today and I'm not an Access Guru but I will try and help where I can. First, if you want an easy delete record option I would include a command button on the form that you use for input. You can do this by adding a command button in design view and using the...

Sorted Thanks guys I knew it would be easy but I’ve never got me 'ead round reports-----always put it off and nicked examples from elsewhere. I've seriously got to do some work in this area now though 'cause my main db is now at the stage where I need to produce reports that are compatible...

I think the line you need is: Command47.HyperlinkAddress = "mailto: " & Me![email] Where 'email' is the name of the text control on your form that holds the e-mail address you want to send to.

Charlie There are a number of different ways to achieve what you want. I have just done a forum search and there are lots of posts on this subject and lots of code examples. Do a forum search on 'email report' and look for the best solution for you.

Time to get my head round reports. I am building a db for the club my wife runs. As part of the db I have to account for inventory movement of bar stock and she would also like this to be able to produce the legal price list for display. No problem with a price list as such except for the fact...

I think what you are looking for is Cascading Combo Boxes? search the forum for such there are loads of examples etc.

Wouldn't say that I would do that. Create a FE/BE tie up the front end and let them create their own reports and queries.

Why not just use a command button to launch your show?

Take a look here and also search the forum for 'concatenate' there are many useful threads.