Search results

The combo box updates the serial field but not the rest of the subform fields, ie it doesn't display the whole record. Any ideas? This is the standard code: Private Sub Combo28_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone...

I have a main form which is linked through a [PackageID] field to a subform. i wast to use the same form for both shipments in and out. the subform has a list of serial numbers add for each [package id]. On the main form i have addresses ect and then a combo box onthe [PackageID] field which...

Thanks for the replys, as soon as i read them i realised that i had designed it pretty badly, must have been having a bad day!!! I now have a query to do the calculations for the table, and its all working!! Thanks once again, Edward

Currently i have a table with approximatly 1000 records in it. Each record has three calculations in it 1) to find out the products age 2) to do calculation based on this 3) to multiply stage 2 by 37. As these are date dependable every record needs to be updated every day, at the moment i am...

Hi Ive just come across a problem, i used the code basics from the example database 'FormSave' which resulted in what i wanted - a working cancel button and a save button on a form, brilliant however this is what i descovered when i came to test it: The form has a subform which is linked to the...

Alrite Ken, do you mean move the database compact it then replace it on the server? because i'm afraid this didn't work. i'm not back at the company until next week so i cant get hold of the error message and will post it then. i was hoping that someone might have come across the same problem...

Hi I've just up loaded a database onto a company server to allow all employees to use it. The problem is that now if i try to compact it a warning comes up about not being able to find a file or something (i forgot to write down what it said!!) I seem to remembe reading somewhere that this was...

Sorted!! Thanks a lot Paul, it worked brilliantly 1st time. Thanks to Jerry as well(didn't get round to yours but i'm sure it would) Thanks again (got a feeling i'll be back again!!!) Ed

Cheers i'll give it a go now.

Hi all, this site it a bit of a god send.hope you can help me, i've had a go at trying to code this myself but can't quite get it to happen. i need a piece of code which will cause a message box to pop up if the value of a check box on a form is "True". I want it so that if the value is false...

I'm a bit stuck so any help happily recieved. I have a database where a list of products each have individual expiry dates. I also have a check box field for each called "expired". I need a way of automatically setting the check box value to true if the expiry date comes within 30 days of the...