Search results

On the picture there is 5 In quantity box, on the sub-form there is 5 rows which i filled, but i want that if I or someone clicks for the new record... it must not be added on the sub-form rows list

Hello vbaInet, where to use this? Number of rows = Quantity Is the best choice i think Because If I enter in Quantity 4 or 5 on the sub-form list maximum number of rows must be 4 or 5

Hello Friends, I have a Question about limiting rows by given number in continuous form.... Please look at picture: I want that the continuous form on my sub form to be limited by a product quantity, that users accidentally not enter some extra data...... Thank you In advanced

Thanks missinglinq For your suggestion.... According with some examples i came to this: I think this variant is very simple 1. Create Unbound Text box and Set control-source of unbound Text box to = RowNum([Form]) Then Let use the Code: 'Copyright Stephen Lebans 1999 'May not be resold...

Hello missinglinq Thanks For the reply, I checked the given Links and found some variants, but they're query based.

Hello I have very simple Question... I wonder How to simply Auto-number continuous form as we simply do in the Reports like: =1 (With Unbound Text-Box) I searched, but found nothing. Thanks

Solved! I Used Me.DePreciation = Me.Unitprice * (((100 - Me.DePercent) / 100) ^ Int(Format(Date, "yyyy\.mmdd") - Format(Dateofpurchase, "yyyy\.mmdd"))) :)

Hi vbaInet When I tested it In VBA, got some errors.... I'll Check everything precisely, I thought that it needed something other...... Thanks for the reply...... I'll Post the results

Hello Friends.... I have a question I need to rewrite my code which I made in Expression and need to convert to VBA, if it is available: =[UnitPrice]*(((100-[Deprpercent])/100)^Int(Format(Date(),"yyyy\.mmdd")-Format([DateOfPurchase],"yyyy\.mmdd"))) the idea is: I Placed this code on unbound...

Thanks Bob Very Good Site

Thanks Jon, Please Add More Video Tutorials

Hello Jon Very Nice updates... Jon It will be also a good if you add something like "Solved Sign or a Mark" That We could mark our threads as "Solved" Thanks

Hello speakers_86, It Says: The Expression On Open you entered as the event property setting produced the following error: I think something is not loading

Greatest Thanks Bob I'm Sure I can do it! I'll Shift all my expressions and put them like this P.S I changed whole report like this and it is flying :) Displaying so fast...

Waw! Coollllllllllll Greatest Thanks Bob! You're Super Works Perfectly P.S. This was also a greatest lesson for me... I thought and this is a real good thing So handy and so needy.....

Thanks Bob for the answer, Sorry but I can't understood this, how to put this in a query? I wonder if I can count the records of LossMoney in the footer of the report why cant sum them?

In QT3 expression I use is: =DCount("*","DATA","Product = """ & [Product] & """ And Brand = """ & [Brand] & """ And Model = """ & [Model] & """ And Dateofpurchase = #" & [Dateofpurchase] & "# AND Status In ('WriteOff')")

Hello Bob! Actual names are: For The Price is Unitprice, but QT3 is Unbound text box with expression in it

- I Put ToTalSum Unbound Text Box on the report footer - I entered The expression exactly as Bob gave me - No error, But Saying: Enter parameter Value for Price, Enter Parameter Value For QT3 and when the report is opened it displays zero "0"

Hi vbaInet Please Look at my post in Reports Section Here is the link http://www.access-programmers.co.uk/forums/showthread.php?t=217681