Search results

I have what I refer to as a master table. It is a list of samples with fields for common metadata only (date, location, form, source and [type]). There are two possible entries for [type], QC or BH. There are different tables for samples that are QC and ones that are BH because they have...

Activate. So the information stream that is not relevant for the particular data type is disabled.

I would like to activate different controls on a form based on a required entry (lookup table). Basically I have a master list table of all records. These records then require additional information based on what feature the record represents. The additional data are in different tables as they...

restructuring the tables is the fix I agree. But, any thoughts on why the code returns a "#Name?" to the text control box. That was a very good small tutorial on how to use a public function and return it to a control. I am keen to get more knowledge on this side of things.

Yes, I would use a combo box for the prefix however, so people don't go making up their own codes. I would like to get to the bottom of this VBA coding though. It appears very simple and would seem to fix immediate problem. I would like to learn more on VBA also. I think I will alter...

You have me thinking more about this Galaxiom. Like what happens when someone uses a different prefix or different number of numerals in the sample identifier

Mihail, I get a #Name? in the txtSampleNumber control

Mihail. It is not a calculated field. The object txtSampleNumber is a bound text control on a form that reports back to a table. I am trying to get the field to default to the previous +1 for a new record. But it is an alphanumeric field so some fiddly things like Right function have to be done...

Thanks Galaxiom, I had thought earlier about this but the AK000... needs to be saved in a field as the actual SampleNumber. I will think about this some more. I did have a calculated field in the table at one point which I used to generate a new number. But I had calculated it from the...

Thanks Mihail, I got the VBA code working on a text box on the form, but as with my earlier attempts, the text box does not update when I TAB to a new record Any thoughts? Brian

I have a problem with a nested arrangement of Right, DLookup and DMax functions. The function is for a default value in a text control =Right(DLookUp("[SampleNumber]","tbldat14A_MasterSampleList","[SampleID]=" & DMax("[SampleID]","tbldat14A_MasterSampleList"))+1000001,6) I am trying to...

My name is Brian. I am working at a self-owned consultancy in Malaysia focussing on Resource Geology (Minerals & Mining). A large part of this is database development for the large amounts of data collected during exploration and production. I have previously been a Manager directing...