Recent content by dazza61

Thanks Bob and Paul, Jeeeez, you two are quick off the mark - I'd only just clicked on "Submit" - many thanks for your replies... In 3 years of development I've never needed to use this style of view and I don't want to now - just one day a director looked over my shoulder and said "we need...

Hi guys, A general question so decided to post here... What's the best way of allowing users to see a DoCmd.OpenQuery routine, securely without having access to stuff they shouldn't have? My reason for using this view is because it's dynamic and changes as the data changes... One problem I've...

Sorry this is delayed - I like to try all angles before replying... Well, I tried and tried and then some to use your answer to get it all to work but kept getting an error from the Tony Toews Auto FE Updater - so I kinda gave up......it's probably me because this Auto Updater is EXCELLENT...

Thanks for the reply Scooter and I've used your logic and I think I'm getting closer.... Now I'm getting errors from the *exe...maybe it will help to show you what's in the shortcut: Target: \\P12-abi\amtemt\InitCarlSimon\InitialiseAMTandEMT.exe /cmd...

Hi guys, Not sure if this can be done.... I've used a batch file to successfully open and close the current database.... However, I'm using the Granite AutoFE updater which launches from a shortcut... So, I'm wondering if I can use the same batch file to open/run a shortcut... The problem I...

Thanks for your replies guys - it's really appreciated... David, I found your Master Dates database in the examples section here and had been working with this for a couple of days before posting my question... I need to correct something;the grid at the bottom of the original image is based...

Hi there, I've attached a screen shot of a form which runs amongst other things a cross tab query at the bottom of the form...(work agency scenario)... The records in the cross tab are basically days that a given candidate has worked....(dates being >= today) - the records above show every day...

Ok I managed to work out through trial and error how to solve my problem - and for the benefits of others, I'll explain how ... Firstly, because the multi-select listbox was set to extended - the well known and accepted way to retrieve a multiple selection is to loop through the items to create...

Sorry this question got listed twice - I was at work and our internet was really slow and I couldn't seem to post a message but somehow both must have got through - I've deleted the duplicate question now...

Hi guys, I have a multi-select listbox of employees on Form A that when single-clicked or drag-selected (to select a group) - fires a loop through items sub to create a recordource for a second "detail" form B I also get the above code to fire when I use the Up and Down arrow keys on my...

Sorry this is a late reply - been away for a while... I want to thank each and every one of you for all your ideas and taking the time to reply to me. To get this many replies is a revelation :-) I would thank you individually, but if lots more people reply it will turn into a scenario of Mrs...

Atomic Shrimp is as cool a name as your words to explain my dilemma - many thanks for your input...I'll have to try and remember some of those words at our Monday morning meetings ;-) Our business model has changed steadily over the years and it isn't going to slow down...so a flexible...

Hi Boyd, Sorry, I overlooked George's point (sorry George) - although we have an Accountant (who is the FD) who does all the accounts, we do have an external firm that oversees certain stuff, so maybe this is an avenue I could explore. They visit so infrequently, hence why I missed George's...

Hi guys, Many thanks for all your responses. @ statsman: Both companies are registered separately... @ dcb: Yes, both companies each have a FE/BE database (making 4 DB's in all (to clarify))... @ George: I have already asked the question - we have 4 directors (between the 2 companies) - some...

Hi guys, I asked a question a while ago about maintaining a single or separate databases, etc and got some really good feedback; many thanks for this. This question is an extension to the original question in that... ...We run two independant UK companies (separate company numbers), one is a...