Search results

Oh what a good idea, that is definately the easiest way, thanks a lot Helen

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...

change the criteria of the business sector field to is null, then it should only show the records with no value in business sector

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 got the button to work, I deleted the code and copied the code I used for the double click (which was exactly the same) and then it worked?? very strange. I am using a listbox as that was the only control I could get to work, the control source is the result of a query, if I use a text box...

that does work but I don't want to do it that way. The listbox with the new number in will be hidden. This is to be like an autonumber but I can't use auto-number as it has to be changeable. Why doesn't the same code work on a button?

My one field is called NewSampleNo and its a listbox with the row source set to SELECT Max(sampleNo+1)as Expr2 my other field is called sampleNo and is a textbox my button has the code: me!sampleNo = me!NewSampleNo when I click on the button, I get an error message saying "the field...

I saw another posting here about using a text box with the default value set to the query, I have tried this and nothing shows in the text box at all. The default value I have is =[qrySampleNo]![Expr2]. The other field I tried was a listbox field with the row source set to SELECT...

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've got this working now, I created a macro that did what I wanted then converted it to VB, what it came up with was if (eval("[forms]![formname]![fieldname] is null")) then MsgBox "You have not entered a score for etc" end if etc then after the last endif for that lot, it adds up the scores...

I have already got a validation rule I've got 0 or <=3 as the value has to be 0 1 2 or 3 but that doesn't have any effect unless you try to enter values that are not 0 or less than or = to 3. I want to check that a user doesn't click on the caclulate button without entering any figures at all...

Thanks, that works, the only trouble is 0 can be a value in the field, I tried setting the default for the field to -1 then checking for < 0, but I don't really want the -1 to appear in the field

Fizzio I tried what you suggested. If I leave my error checking code in which is: on error goto Err_cmdCalc_Click: Err_cmdCalc_Click: Select case Err.Number Case 94 ' You haven't filled in all the scores" Resume next case else msgBox Err.description end select end sub Then, I get an error...

I've got this nearly sorted now by adding error trapping to the sub, but if someone doesn't fill in 3 fields it comes up with 3 error messages, is there a way to make it only come up with one error message? Helen

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...