Search results

Hi there, I hope you can help me, below is the structure of my form which has a subform. I want to be able to duplicate the CURRENT record to a NEW record. I only want specific fields to be duplicated, whilst the rest will be left as default/blank. I'd like the Company and Purchased Date to be...

Hi, I was using a Append Only Memo Field in Access 2007 to show Column History for "Comments". However, I have now converted the back-end to SQL Server 2008 whilst the Front-end is still Access 2007. Since I have done this, the field that shows the column history for "Comments" does not work...

Resolved. Thanks.

Thanks for the fast reply! :D Although, which part of the macro would I need to change? <--- Newbie :rolleyes:

Hi, I'm getting the following error message "Data type mismatch in critera expression." when running a macro that opens a form and goes to the record clicked on and if "new" is clicked, then it goes to a new record. This only started happening when I changed "Asset_No" from being a 'Number'...

everything is working fine now.

Hey, I'm trying to display the month of the begining of each week in its month in my report (see attachment). So each month would be act as a group (heading) for those 4 weeks in its month. I'm also trying to show the total amount for each week on the right hand side (see attachment). I can...

This shows that theres 53 weeks in a year, any chance I could edit the starting day of the week? It might be due to that. Thanks.

Same problem as above, but thanks anyway!

This still displays the dates in single rows when I want them to be grouped, e.g. if 2 records are in the same date, then the values (amount) should be added together.

Hi, (See screenshot) I'm trying to group the dates by week from the begining to end of week, e.g. 01/07/2010 to 07/07/2010...etc. How would I be able to do this? I already tried Expr1: Format([Order_Date],"ww/mm") But it displays the week number, not the actual week date. Thanks!

Is there no way I can get the totals to be in the subform like shown on the image on my first post.

Hi, (See Attatchment First)... I'm trying to get the sub-form to display 'Subtotal', 'VAT' and 'Total' rows. And at the same time I want them to automatically calculate the values. How can I do this? The subform is being pulled from a query as a Datasheet. Would really appreciate all the...