Search results

Hi I have a form based on a query. I wish to apply more than one filter to the form.I am using the docmd.applyfilter event. I have created two filters strcriteria and strcriteria2. If I apply these seperately they work fine, if I use then consecutively then only the latter...

Have worked out that the reason it started working was that I already had frmenquiry open and that when the cmd button is clicked on frmenquirysearch it takes me to the correct record. When frmenquiry is closed and the button is clicked, frmenquiry is opened but only at the first record!!!!!

I have now taken out the ' from your first suggestion and the thing is now working Women and computers can never be understood truly by man Thanks for your help Richard

Enqref is a numeric field Have put in your suggestion and now I get the error message Open Form Action is cancelled the debug takes me to the line DoCmd.OpenForm stDocName, , , stLinkCriteria any more thoughts??

Hi I have a form (frmenquirysearch) dwhich displays a summary of all the records in tblenquiry in continous view. I want to open up frmenquiry which is a detailed view of the records using a command button on frmenquirysearch. I used the command button wizard and it has given me the code...

Using the similar threads at the bottom on the post I found an answer on Allen Brownes website. Link below for others if needed http://allenbrowne.com/casu-18.html

Hi I have a costing database. With a structure of tblenquiry where the primary key (enquiryNo)appears as the foreign key in tblparts, tbllabour and tblpaint Not all enquiries will have all three parts, labour and paint. This is giving me a problem when I run estimate report to show the total...

Hi I have a form with a command button which on the 'On Click' event has the following code: PasswordCheck DoCmd.OpenForm "frmStartFormCarSales" Password Check is a Public Function which allows the user to have three attempts to enter the correct password, at which point the database...

Chr is a typo here should have been chr(32) as per the second part of the string

Thanks for replies Bob I have tried &" "& before still get the same problem Micks55 The font is Arial 10 Also thanks for the tip on the reserved word any other thoughts Thanks

Hi I have a report for repair estimates, part of the estimate is the make, model and type of car, this is concatenated in a query, using [Make]&Chr&[Model]&Chr(32)&[Type] On my computer this works fine in the report, however on another computer I get a square between each of the fields when...

Ok thanks I tried this and the total came back as the last record returned in the detail section. If I run the sub report outside on the main report ie on its own it works with the Sum() adding up all of the records, yet in the main report it only shows the last record Anything further??

Hi I have a report with a sub report on it in the detail section of the main report. I wish to sum() one of the fields on the sub report but I am struggling. This is the field I am trying to sum() =rptEnquiryPaintCalc.Report!SumPaintCost I have tried as...

Hi I have a table called Table1 which has the address details for sites we work at. I have an ID field (in table1, also primary key) which is Autonumber. We have just won a contract to work on 3000 houses and to input this information would be very labourious I have tried to import a test...

Hi I have a calendar on a field which a user selects a value from, to help with the selection I want the calendar to appear with the year already set by another control So if controlA = 2002 then I want the calendar to open at the year 2002, I am not bothered what month as the user will have...

I forgot to mention that I have tried to put a Sum() in the report footer of the subreport but this just shows the last record displayed on the report

Hi I have a report which uses sub reports in the detail section of the main report. In the main report footer I wish to sum the results of the detail section, however I can get the report to see the field in the sub report but when I add the Sum() function, the field name I am Summing appears...

Hi I have two tables tblBatchDetails which has the fields CreatedBy, CreatedDate, BatchNumber tblSampleDetails which has the fields BatchNumber, MTNumber, CreatedDate, CreatedBy The structure is that each batch has multiple samples and Batchnumber is the foreign key field in tblSampleDetails...

Hi I wish to insert a date into a field SalesDate in table tblStockBook from a form frmSalesInvoice which is based upon another table tblSales. Could someone please help me with the WHERE part of the sql statement InsertInto tblStockbook(SalesDate) Date() ("&StockNumber&") Thanks Richard...

Hi I wish to insert a date into a field SalesDate in table tblStockBook from a form frmSalesInvoice which is based upon another table tblSales. Could someone please help me with the WHERE part of the sql statement InsertInto tblStockbook(SalesDate) Date() ("&StockNumber&") Thanks Richard