Search results

When filtering using dates in a pivot table the year quarters (Q1, Q2 etc.) start in January (Q1). Is this a USA based standard for financial year quarters and if so can I change change this to meet UK quarters where the year (Q1) starts in April?

I want to open a specific MS Word document using a button within an Access XP form. I used to be able to do it in Access 97 but the code didn't work when I converted the database from 97 to XP. Could someone point me in the right direction please. In 97 I used stuff like Word.Application...

Regional Settings Regional settings are set to dd mm yyyy in Windows which is right for UK. I need to input 02/03 for Feb 2003 and display 02/03 or, better yet, display Feb 2003. Thanks for staying with me on this one!

Still Stuck! Sorry Des, couldn't get it to work. I changed the format in the table design to mm yyyy but when I entered, for example, 02/03 (Feb 2003) it took the 02 to be the 2nd day of the month and recorded a date of 02/03/2003. It DISPLAYED 03 2003 when I clicked out of the field but...

Please can anyone help me? I need the user to be able to INPUT a date but only the month and year e.g. 02/03 for Feb 2003. I want the text box into which the input was made to also only display the month and year. Is this possible and if so how do I do it? Thanks in advance.

I have 3 tables: ClientDetails, StatusLookUp and ClientStatusHistory linked. ClientStatusHistory has fields: ClientStatusHistoryID (Primary Key), ClientID (Foreign Key), StatusID (Foreign Key) and Date. This table records how Client's Status changes over time, hence the Date field being...

Thanks, Rich - Worked a treat!

I have a combo box which has 4 columns. The bound column is col 1 but I need to refer to columns 3 and 4 in a query in order to use the values they contain as parameters. Cols 3 and 4 contain dates i.e. start and finish dates. I want the query to find records that have dates between the 2...

Many Thanks for your help and quick replies !

I am running a make-table query from the code behind a command button. When the query runs a warning about the existing table being deleted pops up. The table being deleted is OK but how can I stop the warning appearing every time ?? Thanks in advance.