Search results

Hi, I was wondering if anyone could shed some light on this problem. I have a pop-up form that is used to filter info on a report for Labels. When I filter info on the report and click the print button. The filter doesn’t seem to be applied to the report when it is printed even though it seems...

Hi, I have a pop-up form which I use to filter data on a report that prints out labels. I also have some code on my report which asks the user if they wish to skip labels, they enter the number of labels the wish to start printing from. This code runs when the Apply button on the form is...

Hi, I put this code in the Form_Delete event as NumberUsed field will change constantly when the user add records they enter the NumberUsed (number of parts) for a job. I only want this code to kick in when a row is deleted. UnitsInStock = DSum("[NumberUsed]+[UnitsInStock]", tblStore!PartNo =...

Hi, I do realise the complications about sorting these values and I know it's against the rules. But, I really need to store these as other calculations in different parts of the database needs the values, which has all worked out well so far. There must be a way to save the unbound test box...

Hi Kh, Have you no other suggestion other than I haven't named my fields correctly???

The subform's recordsource is made up from two tables as follows; tblStore PartNo (PK) PartName UnitsInStock ReOrderLevel Discontinued Remark tblPartsUsed PartUsedID JobDetailsID PartNo (FK) NumberUsed The relevant fields would be PartNo, PartName, UnitsInStock, NumberUsed

Hi, Just wondering what exactly do you mean doing the calculation on the form footer? I need to say if a row is deleted only then add the NumberUsed back to UnitsInStock i.e. DeleteRow=[NumberUsed]+[UnitsInStock] How do I do this automatically on the form footer? could you explain a little...

Hi, I have a continuous subform, where records are saved too. The number of parts used are entered in each row and then the new UnitsInStock value is calculated accordingly. UnitsOnHand:[NumberUsed]-[UnitsInStock]. This UnitsOnHand becomes the new UnitsInStock value which is working fine so...

Hi, I have adapted code from ghudson's example on 'http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=52736 I have a subform called frmsJobPartsUsed, which contains a multiselect list box where the user can select multiply parts used for one job and click a save button...

Hi, I have adapted code from ghudson's example on 'http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=52736 I have a subform called frmsJobPartsUsed, which contains a multiselect list box where the user can select multiply parts used for one job and click a save button...

Hi, That worked. So easy when someone else shows you. Thanks a million for your help. Rita

Hi, I am having problems with an If statement and was wondering if anyone could help me out with it. What I am trying to do is; If UnitsInStock is 0 (maybe this should be null not 0) Then show a Message. Or Else If UnitsInStock is greater than 0 but less than or equal to ReOrderLevel Then Show...

Hi, I need to copy a record in the table tblAccDetails to all other records in the same table that equals the same Collection Type in table tblCollections. (The user will enter the first record in tblAccDetails) tblAccDetails AccDetailsID YearID CollectionID (FK) CollectionDate Status...

Thanks for that, I didn't know. Rita

On my subform (frmsCollectionDetails) I need a combo box that look up values (CollectionID, CollectionType) in a different subform(frmsCollections) on a different form. (there is a one-to-many relationship between these tables). On selecting the CollectionType, I want the corresponding...

Hi, Thanks for your help. Got it working. Rita :D

I have four tables called; tblParishioners:- AccountNo, AccountName tblYears:- YearID, AccountNo, YearPeriod tblCollections:- CollectionID, YearID, CollectionType, NoCollections, AmtPerCollection tblAccDetails:- AccDetailsID, CollectionID, CollDate, Status, Remark, AmountPaid A person will be...

Hi Lisa, Thank you for your response. I tried your suggestions but it does not solve the problem. The combo box produces a list of all records (years) regardless of the persons name I have selected. It also does not allow you to move through the records by selecting a year. Rita :confused:

Hi, I have a main form and two subforms (in datasheet view). On the main form (frmPar), I select a persons name which finds the records for that person on the two subforms. The first subform(frmsParYr) shows a list of years, depending on the record selected, the second subform (frmsParCol)...

No suggestions......ideas??????