Search results

Hello all again! I have a sub form on my main form. On the main form I have a field called SampleDate On the sub-form I have fields called: CNo Age TestDate The user inputs 1, 2, 3 etc etc into the CNo field. Then selects an age in days from a drop down box in the age field. What I’m trying to...

Thats great stuff, Missinglinq, worked a treat first time.:D Thanks for taking the time and effort to reply! Cheers, john:D

That code worked fine for me after i had to bin out the Autonumber function. I have one issue though - I need my users to see the number as its generated. At the moment it only appears when you use the record selectors to go back one record then skip forward again. Can anybody help out there...

Ok, sorry everyone for the numerous posts I'm making tonight, but I've found the answer here anyway! http://www.access-programmers.co.uk/forums/showthread.php?t=107997&highlight=sub-report It just goes to show how useful the advanced search function is!:D swifty

Hello again, Last question for a while, I promise! I have a main report which contains a sub-report. The Sub-Report may contain anything between 1 and 15 records. The problem arises when I preview the main report - for example if I have 5 records on the sub-report, I end up with five pages of...

Ok, I've reviewed and basically rebuilt the query from scratch and it works fine now. I had two fields in the query, asking for the same parameter. I guess I should probably go back to my books before shouting for help!! Thanks to all those who replied ;) swifty

Hello again, I have a query which has a parameter called [Enter Date as DD/MM/YYYY]. This filters out records from my table which match those entered by the user. However, when the query is run, Access is asking the user to enter the criteria twice. The first time it is labelled Expr1, the...

Yeah, I must admit the DB is not what you would call 'normal' by any stretch of the imagination....I was very pleased with it when it was built but having to iron out the bugs is proving troublesome, to say the least. The problem I have now is that the DB is in constant use daily and its very...

Hi, I have a similar problem in that i have ten fields in a table containing dates. I have a parameter in my query asking for 'Enter date in format DD/MM/YYYY', when this is populated with a certain date I need it to search all ten fields and return only those records which date match. At the...

Hello again, I have a form which has two combo boxes, each containing two values. I would like to link the 1st value in combo one to the 1st value in combo two, and the same with the 2nd values in each combo. There is no other combination of fields. At the moment, users of the DB have to select...

Another issue to resolve!! I have a form called sample register. On it users input data and use combo boxes to populate fields such as date, material type, sample type etc. I'm having a problem with the material type combo box. On another form, I have text boxes displaying a selection of the...

Hello, Having problems with the DateAdd function....I've looked around the forum and found some useful things but as usual I'm stuck with it!! On my form I have a field containing a 'sampling date'. I have a combo box numbered 1 to 56, so the user can select the age in days of the test. The...

Hello, Apologies for bumping this, but it helped me solve my problem up to a point!! The code returns 'name?!' in my text box. I think it might be related to the fact that i'm trying to store the newly generated date in a field in my main table. I need this date available so i can run a query...

Sorry i dont seem to be getting any further with that, I appreciate the help though! :o swifty

hey no problem - i appreciate any help/advice you can give me, thanks!:) swifty

OK, that attachment should be in Access2000. This is the basic flow of things as they stand: Register a sample with unique ID [ID] in sample register. These samples then have tests carried out, which each need reported individually. Then: switchboard>enter test results>then use the locator...

Hi RG The only code for the command button is an embedded macro 'onclick' - to open the form. SQL for the row source of the combo box is SELECT [ETC MAIN TABLE].[ID] FROM [ETC MAIN TABLE]; where ID is the record number; bound column is set to 1, which is ID in ETC MAIN TABLE. I'm gonna keep...

Sorry Rural Guy, thats just way over my head!! I hope its not too cheeky, but i have attached a stripped down copy of the DB if anyone wants to have a peek and give some advice. To recap, the combo box on the form is used to select a record. Then a command button is used to enter results for...

Hello all, (Probably) a simple one, one which I've had problems with before but have subsequently forgot how to rectify!! On my form, I need to pick a record ID from a combo box then use anyone of a number of command buttons to enter results for different tests. Problem arises when I view the...

Hi all, I've got a major problem here, relating to some of my other posts on this forum. I've got a main form which contains a sub-form. On one record, I can go to the main form and flick through all of the records in the sub-form as per usual. However, when I go to my most recently added...