Recent content by scossar

thanks for the help used the hyperlink idea, and it works great thanks mile-o-phile for the quick response thanks to oldsoftboss for your help aswell later

looking for a bit of help!! basically what i want to do is to put a control button on the main switchboard that will open a word document when pressed (an information/basic insruction manual) currently 1. Command button 2. Run Application 3. Network path of MS word doc to be opened When the...

thanks for that, will give it a go and get back if i can't get t to work later :cool:

hi all, i'm a total newbie at access and need a little guidance. what i want to do is to design a single report that can be used for a number of different variables : i have a number of options in a drop down box - peoples names, and the records in the database are categorised by the name...

thanks will give that a go

The reports are the same, except based on a specific query which has a (Like "xxxx")as the only differential. Layout, field headings etc on the reports are identical, only the actual report name/heading changes to show which option was chosen. The reason for allowing users to enter variables...

I have reports based on the value chosen in a combo box. The combo box values can be edited added to etc, but if a new option is added there is no report for this. Is there anyway to automatically create reports (based on a existing report) for any new options added. Also is there anyway to...

wanting to create a macro that will give different outputs dependent on an input from a combo box have tried using 'setvalue' and an IIf statement which says : IIf([Forms]![xxxxx]![typeselect]="1",DateAdd("d",28,(DateAdd("m",5,[Forms]![xxxxx]![yedate]))),"") which works fine on its own. If I...

forgot to say this is part of an IIF statement in setvalue macro There is a combo box with a list of options and depending on the selection in that box and the date value entered, the calculation on the output may differ "...

Looking to output a static day and month with a variable year based on a date input on a form (UK dates) So essentially if I was to enter a date of say 10/06/01 or 20/06/01 the output would be 31/10/01 if the input was 10/01/02 the output would read 31/10/02 ie the day and month don't change...

thanks will try both of these

thanks for the help working great now thanks again

when using my reports they randomly change from landscape (to which they are all set) to portrait has anyone else seen this happening and if so any suggestions how to stop it thanks

Well first of all I'm new at this so any help would be greatly apreciated. What I am trying to do is set a date in a field based on a date entered in a previous field on the same form. The second date I want is 5 months and 28 days after the first date but I can't figure out the combination of...