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

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

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

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!

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