Recent content by Richard G

MANY Thanks - got it! Regards Richard G

Thank you for the quick reply - I'm using MS Access 2003 edition and still learning so forgive me but how do I find the POPUP property for the main form? I've looked at the properties settings but found nothing - or is this something in the newer editions of MS Access? Rergards Richard G

When I open my database is there anyway I can automatically hide the menu bars so my front page displays full screen mode? Regards Richard G

I have a set of data in one table with another set of data in a seperate table, both tables have been linked so I have a MAX and MIN set of values -this works fine however I now wish to work out the difference ie; MAX - MIN = ? but I now get an error as the data is in 2 different reference...

When I run my database it always opens in window mode - I've searched through the help files but unabel to find out how to set the database to open in full screen mode - I have a form as my front page and want this to open in full screen mode instead of window mode Many Thanks and a Happy New...

I have a date / time field in a table which has be imported as part of a dataset unfortunately its in a text format ie: "25/01/2007 1100" Is there anyway I can get a query or report to read this ? The data is imported and creates a .csv file. When importing I have tried the comma seperated /...

Year Query I'm using the Date Serial function: Date: DateSerial(6,1,[Field Name]!Field2) Works fine for 2006 but how can I tell it once the date reaches 31/12/06 the next date should read 01/01/07 - if I change the '6' for a '7' all my 2006 dates change to 2007 ! Regards Richard

Please could someone advise me how to set the YEAR in a query - all my data for 2006 is fine but I have uploaded some data for today (01 Jan 07) and ALL by queries / reports now show to 31/12/2006 then at the top, instead of the bottom, reads 01/01/06 ? Regards Richard

I am trying to write an iif statement which will give me the average figure based on a monthly total - does anyone know how to work this out based on days of the month ? So for example Months 1,3,5,7,8,10,12 have 31days the rest 30, except of course Feb with 28 (or 29) I need to tell the query...

I've built a query against a form and included a calculation to give me the average sum which looks like this : =Sum([data field])/31*12.5 This work fine however, what is the best way to overcome the different number of days in the month ie; 28, 30 and 31? I've looked at the Expression...

Using the chart wizard I have produced a chart of my data onto A4 size paper. I'm well within the margins and the chart looks fine however, the chart repeats itself and I'm ending up with 285 copies (pages) of the same chart - WHY ? I 've scaled the chart to fit well within the layout on the...

I recently upgraded from MS Access 2000 to 2003 I now appear to have a problem with my julian date conversion formulae. Everything was working fine but since 01Sept none of my date/time specific queries work. Please can someone advise me of a Julian Day to Calendar date formula for MS Acces...

I recently moved by database from one hard drive to another - all is working ok after refreshing the links. However I have a few queries and reports that are date or date/time specific. (ie; I input a specific start / end date or start/end hour) Now when I run these queries it returns an error...

How do you calculate the total of 'x' number of values in a report ? I have a monthly report and need to display the total of my data values at the end of the report I new to Access and a bit lost with using the Expression Builder....:confused: Regards Richard

I'm currently using MS Access 2000 - When using the chart wizard is there any way of sorting the data by month ? At present I'm getting all my data on one chart but I want to spilt this into seperate months. (ie; 1 chart for July, 1 chart for Aug etc) I know there is the option for choosing...