Search results for query: *

Hi I have a field in a table which has the format 'V99999'. When i call this in a list box the number appears without the 'V' (i.e. 12345 instead of V12345). Is there any way to get the V to appear in the list box? Cheers, Lista

Hi there I've got a subform which needs an auto-incremented number as one of its fields. I was using the following code previously, which works fine - but i recently put in code to allow the user to 'archive' a record (effectivly this stops the record being selected by the subform, but keeps it...

Hi I'm having trouble with some Validation for one of my users. They want a text field to either contain 5 digits (e.g. 41237) OR an 'S' followed by 4 digits 0-9 (e.g. S4123) One or the other would be easy enough but I can't find out how to make it only accept one or the other. Thank you for any...

Hi there This possibly isn't the most difficult of requests, but i cant get it to work I have a column in a table which will be either "general" or a random string (free text entered by the user). I need a subform which always has 'General' at the top (if it exsists) and then in ascending...

Hi I've got a form which allows users to search for specific Archive boxes. The form takes input from a text box and outputs to a list box. The listbox's rowsource is a simple SQL statement. This all works fine but I'm having trouble with searches that have no results - All i want is a 'No...

Hi I'm trying to develop a calculator in an Ms Access form which will calculate the cost of calibrators, QCs and reagents (but not consumables) in storage for a specific study and write to a list box. My problem is that when I run the query below the results come back as 3 separate values...

Hi I'm trying to develop a calculator in Ms Access which will calculate the cost of calibrators, QCs and reagents (but not consumables) in storage for a specific study. My problem is that when I run the query below the results come back as 3 separate values whereas I need one. I was...