Search results

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

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

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

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

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