Search results for query: *

Hi. I'd like to know how to automatically make the first character of each data entry uppercase 'On Exit'. I think it'll use something like below, i'm just having trouble reffering to the first charater only. Private Sub FirstName_Exit(Cancel As Integer) FirstName = UCase(FirstName) End Sub...

I have a button in a sub form called [frmJob] which has been made from [tblJob]. The button runs the following code with the intention of finding the number of items in [tblItem] which have the same [JobNo], and also totalling their total values. Private Sub Command28_Click() [ItemsInJob] =...

I use the entry into [tblItem]![MouldingID] in a form to lookup a field called [tblMoulding]![MouldingPriceBand]. The field that does this lookup should use the returned value of [tblMoulding]![MouldingPriceBand] in a multiplication, but it only seems to return the first record from the table...

Hi again. I have inputted the above suggestion into a form as stated. It will not allow me to have 'Date()' though, and it doesn't display a result in the form. I have replaced QryPendingJobs with 'QryDueDate', and within this, the 'PendingJobs' expression currently returns the result '2'. I'm...

I have developed 3 expressions within queries to allow me to predict dates which jobs can be done by. the system works on a 5 jobs per day basis. It takes the current date, adds on one day, and then adds on another day for every 5 pending jobs. It looks like this: PendingJobs...

When I go to look at my relationships table after a bit of fiddling around, Access seems to have duplicated some tables, calling them, 'originalname_1' and 'originalname_2' etc. I guess this is something to do with how i've set stuff up or to do with queries, but could someone let me know how to...

In the creation of a POS system, I am using both Excel and Access in it's development. I need to be able to open a particular Excel template file for data entry on clicking a button in Access. Is this at all possible? I am using Execel as a Data Capture form using the Template Wizard to export...