Search results

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

Many thanks for your comments David... I did try replication (for synchronising laptops to main office, not this issue) - but I didn't like it - it was okay for adding child records, but too complicated for full synchronisation. I think I'd rather code my own way of getting stuff updated...

Sounds like a novel idea George and many thanks for your response. Just to clarify so I get this right... Using your approach, for your point 1) I'd use e.g. a Shell copy command to copy the "main" backend making a "snapshot in time" exact copy... 2) This takes care of point 1) in always...

Hi guys, I've been asked to come up with something whereby management can create their own queries...thereby being able to design their own reports with their own chosen data, filtered, sorted to their own needs, etc....blah blah... My first thought would be to design a customised form so you...

Thanks for the links, however I'm okay at working with time conversions although your last sentence has opened new ideas for me...(i.e. storing date/time in the same field)... Currently, internal staff enter shift start and end times and I only reference the time and not the date (although a...

I guess it's two fold: 1) Examples I have seen take say 20 appointments/shifts to see if ANY clash - we can have 100+ shifts per day and I only want to see if individual employees clash on their own shifts. We accept certain shifts will overlap because you could have say 3 employees on the same...