Search results

I have a query where I want to joing two fields "jobNo" and "sampleNo" to make "sampleid". The format of sampleNo is set to add leading zeros if the number is less than 4 in length, ie 1 becomes 0001. The trouble is, when I join the two fields 0001 becomes 1 again so abc/1234 and 0001 becomes...

I've got a field called sampleNo and one called newSampleNo. newSampleNo runs a query to find the largest sampleNo in the table and adds 1 to it. If I set code for the double click event of this field to Me!sampleNo = Me!newSampleNo.Value, when I double click the field, sampleNo is updated...

I am joining two fields in a query, JobNo which is a text field, and SampleNo which is a number field. SampleNo has to be 4 numbers so if the sample number is 1 it becomes 0001 and if it is 10 it becomes 0010. The sampleno works fine but when I join it to the JobNo field, the leading zeros...

I need to create some forms to use with Pocket Access on a handheld machine. According to the Microsoft site I need their Embedded Visual Tools. I have been trying unsuccessfully to download these tools from their site and the Developer Store, where you can order the tools on CD is...

I have a form that has field which runs a query to find the highest record number in a table and shows that number. I then want to assign this value as a number, to another field on the form when I click on a button but it keeps coming up with an error. I assume this is because the value in...

I have a form with, in one section, 8 fields to be filled in, when these are filled in you can click on a button which will add the values in the 8 fields and then enter a category in another field depending on the result. I want it to come up with a message saying which field hasn't been...