Search results

Cheers Thanks that was exactly what I was looking for

Sorry my mistake Pat It seems that I have been misleading as what my dataset looks like. It's too easy to assume that everyone knows what the hell I'm on about. Anyway tbl as follows: HOLEID From To SampCode UDD1234 0 1 WHOLE UDD1234 1 2 WHOLE UDD1234 2 3 WHOLE UDD1234 3 4 WHOLE UDD1234 4 5...

cool Thanks AncientOne that's exactly what I was after.

Hey Pat I am after the from/to intervals for all of the occurrences of each Samplesize code. They are spread over the entire table in blocks of each code. The first 50m (0-50m) might be sampled using WHOLE then the next 25m (50-75m) using HALF then the next 25m (75-100m) using WHOLE again and...

Hi I am trying to create table defs for a new table called tblMainAssay and would like to know if I can create 2 primary keys. I know I can do this in the relationships window but not sure how to insert it into the vbCode. I want HoleID and Depth_From to be the P.Keys. I know it goes in the...

Hi I am trying to find multiple occurrences of a value, SizeCode. I would like to show the minFrom_Depth and maxTo_Depth for when each SizeCode occurs. Each SizeCode may appear more than once at different depths. I have the following tbl tblSampleSize HoleID From_Depth To_Depth SizeCode I...

cheers Thanks Rich Now you mention it I have used that function before. Mind spasm I guess. So much to remember, So little space to fit it.;)

Hi I have a report coming of off this table tblDrill_MnthCosts Year Zone Coresize Metres DrillCosts I have grouped by the Year and Year and am trying to sum([metres]) and sum([DrillCosts]) for each Year. To do this I put a control in the Year Header. It sums both fields for the Year but they...

llkhoutx You, like many people on this site, are a lifesaver, Thank you for your help. Cheers Cress

No avail llkhoutx I have tried many different combination up there but no change Most are not recognised 'user defined' error

Huh? Sorry I don't really understand what you mean? I have attached part of the form from my database to give a clearer picture When the user clicks or puts the focus on in the next record of the SampleID field it show an incremented number [SampleID]+1

I wish to make a new table with ID as a autonumber field. I am using the code below to achieve most of this. I can't find the right data type to get the ID as autonumber Can you? Function makestag1() Dim db As Database Dim tbl As TableDef Dim fld As Field Dim idx As Index...

YES YES YES You guys are Jets Thankyou both I have been struggling with this for the longest time Cheers Cress:D

I moved it from 4th to 3rd the highest it will allow but??? same same no different

Yes it is I have recently changed from Access97 to 2000 and it seems some of the code is no longer supported

Here's the attachment

Hi My form is used to calculate sampling intervals and assign sample numbers based on the depth of the hole drilled The user enters the following HoleID HoleID USD04441 sample prefix Prefix USD04441 1st depth Depth From 0 last depth...

You could put this in the onclick of the item button you select DoCmd.close acForm, "SwitchboardName"

Hi In my subform frmSampleDt I have a table with fields; tblMainSamp FaceID Channel SampleID From To Lithology MCode MCodeVal This subform is used for data entry and as such is in a datasheet view. The user will enter many sampleid's (alpha numeric) which they increment by one each time...

Thanks Thanks Pat and Fizzio The only other thing I had to do was change strPrevTo as String to strPrevTo as Integer and it went like a charm Thanks again :p