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 - thanks for replying Unfortunatly the sequential number is necessary on the form. I don't mind if the archived record has no index number and when it was restored it could just be given the next in the list - the only important bit is that the form never has any gaps or any duplicates, and...

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

Thank You! works perfectly!

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

Thats perfect! thank you!

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

PERFECT!! Thank you!! ^_^

Hi I was trying to use isnull on the list box after the SQL statement is run but this just displayed the message whether there were results to display or not. This is the code: (strSQL1 and strSQL3 are the select commands which run the search - they work fine so I didn't put them in) Sub...

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

Thanks for your help guys! It works now!!

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 Thanks for the quick reply but I cant get this to work... lots of syntax errors and 'Join type not supported' messages. If it matters, I'm using Access 2003 Lista

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