Search results

Update : I figured it out After messing around a bit i got it to work by using; rs!labnr = Screen.ActiveForm![labnr] Here is the full code of the function in case anyone needs it. Public Function TrackChanges() Dim db As Database Dim rs As Recordset Dim strSQL As String Dim strCtl As...

Thenks mdlueck. Doesn't this mean the field i would like to refer to has to be 'activated' though? I use the ActiveControl property to get the old value and the new value. I have been using the following function for quite some time now; Public Function TrackChanges() Dim db As Database...

Good Afternoon, I am working on a logging function (to log changes made using forms). I got it almost figured out. There's just one thing that i cant seem to figure out though. I am trying to log the value of a field, on the form that is active at that time. Ive been playing with the...

Chris, first of all i would like to thank you for your help. The graphs are looking way better now. Ive got one question though; What if i have 3-4 different ProctorID's?? Ive noticed that the graph will be generated just fine for ProctorID 1 and 2. But when there are 3, the third graph is...

Oh snap. You nailed it. Thanks Chris for all the time and effort you put into this!

Good Afternoon Chris, I hope this what you are looking for. I copied my subreport (with needed queries and tables) into ur test.mdb.

Hmm, now the graph (subreport) wont even load anymore when using : Option Compare Database Option Explicit Private Sub Details_Format(ByRef intCancel As Integer, _ ByRef intFormatCount As Integer) Dim sngMinRange As Single Dim...

What if my graph is based on a query. Will i still be able to use sngMinRange = DMin(conAxisName, .RowSource) sngMaxRange = DMax(conAxisName, .RowSource) ?

Cheers! Looks like it worked. I will test it with a different data set aswell. Thanks again for your input!

Good morning, Ive got a graph on a report. At this point, the scale of the graph is set to 'Auto' . Which works, but the graph-line is not in the centre of the graph. Due to the fact that we have to send these graphs to our customers we would like the graph to be presented perfectly. What...

Sorry for the late reply. What im trying to achieve is : Samplenr____ Value ____ Average 1....................3.................2.5 2....................2................. 3....................7...................3 4....................3................. But the average for sample 1 and 2...

Good morning, Ive got a (small) question regarding the detail section on a report, which is acting like a continuous report. Ive got a total of 4 records. Each record has a sample number. Ive calculated the average of sample number 1 and 2, 3 and 4. At the moment it looks like this...

Dear Apr Pillai, I would like to thank you for your time and effort. That vba code worked like a charm. Thanks again!

Sorry for the late reply. I will have a look. Been messing around with crosstable queries, but this might be easier. Thanks again.

Good morning, I am working on a database which is supposed to be able to aid the people working in our laboratory by doing calculations, making graphs etc. Everything works great, but theres just one thing that i can not figure out. The basic idea is, that the manager of the lab registers...

Good Morning, I am currently using the SetFocus event to generate a number Private Sub WetDensity_GotFocus() mycounter = Nz(DMax("mycounter", "tblverdgrdnucleair")) + 1 End Sub as an alternative to the Autonumbering option. But, when i use this on a continious form, i have to...

Thanks, I guess i will look into Dmax... Im guessing the Row_Number() function i used to use in SQL doesnt work in AccesS?

Good Afternoon, I started to work on a database a few months ago, but never got to finish it. Now i got some spare time again, i really would like to get back into it. But i am encountering the following "problem". Ive got a table named : tblfielddata This table is the source of a form...

Well.. I only want to display the fields if they are not 0. So lets say instead of presenting the following on a form: PercAsphalt PercSand PercBrokenStab PercCement --------------------------------------------------- ......0 % + ...100%+ .... 0 & + .....4 % I would like to present...

Can i do this for all 4 of the fields in one single label though? Like this? =IIF(Nz([PercentageAsphalt],0)=0,iif(NZ(PercentageSand,0)=0;Iif(Nz(PercentageBrokenStab,0)=0;iif(Nz(PercentageCement,0)=0;""; [PercentageAsphalt] & " % +" & [PercentageSand] & " % +"& [PercentageBrokenStab] & " %...