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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.