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

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

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

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.