Search results

Hi, Thanks for the advice i tried this and it seems to work, but it puts everything on one line and not under each line. Any ideas thanks in advance

Hi, I have 3 address lines, town , county and a postcode, On a report i would like to print this information but as these are seperate fields, if any information in any of the lines is not entered a gap is left before the next field. Is there a way to stop this? i.e by having all the address...

Hi, I want the user to be probpted to ensure they have printed the report. i.e - are you sure you have printed? Yes / No box If yes then close the Report Else Do not. I have tried to enter a Msgbox expression on the reports close Event, but i cannot get it to work Any ideas Thanks

Thats a large subject line!! Anyway I want to work out the difference between two times, both of which are date/time fields and then multiply this by a rate, i have tried this Hours/Mins*24*rate this works only if the hours/mins is of a whole number. if i have a figure of 9.35 hours/mins -...

How can i store down values of a caluclated field.?? ie Start time finish time Hours/Mins = <Calculated Fields> - needs to be stored Rate: Line Total <[Hours/Mins]*[Rate]> - needs to be stored down? Any ideas Thank you

I need some advice, i am creating a database, which has a few standard reports, but the user's would like to create ad-hoc reports, i dont want the database window to be displayed, but i will need to give them access to them to create the report. Any ideas?? Thanks in Advance

Hi, I have a small problem. I have a start time and finish time each having a field data type of Date/Time (Short Time) and a calculated field which shows the number of hours/mins between the two which is also a Short date field, the control source for this field is a running total. Hence i...

Hi, I have placed a calender control ActiveX object on a form of mine, but the default date showing is not the one of the current date, how can i default the calendar to the current date?? Also does anyone have any experience of having a actual diary with-in MS access 97, where you can view...

Ok!! I am trying to calcualte the number of hours and minutes between two fields which then are stored in the database - (not a running total) and then multiply the number of hours and minutes by a Rate (i.e £2.50) and then also store this value down. can any body help?? can you please also...