Search results for query: *

I've definately referenced the subform correctly becasue the result of the calculation is coming through onto the main form . The calculation is done in a field on the subform, then the field on the main form that displays the result of that calculation. Everything seems to be named correctly...

Hi... I have set up a report with 4 fields that come through from the query. I have them as a list on the report. However, if some of the names are a bit too long they go down onto a second line. Now usually if this is the case, the field below just shifts down a bit so that they don't...

Hi Pampers... Thanks for that, still can't get the ****ing thing to work though! I'm wondering if it is because one of the fields I am using is simply referencing the contents of anther field on a subform, and not actually performing the calculation itself?! I dunno... I shall keep fiddling!

Hi Guys... Cheers AceMan1... no luck with that though I'm afraid! D'oh, I'm just going to write in huge black writing across the screen "DON'T CLOSE THIS SCREEN UNLESS THOSE" NUMBERS MATCH!" This is going to drive me mad...

Cheers for the thoughts guys... Pampers: Both fields are on the main form. StrayBullett: your piece of code is almost identical to the code I posted that didn't work... and yours I'm afraid to say doesn't work either?! Still stuck!!! Could it be because the field 'total' on the main form is...

Afternoon all.. Here is my scenario: I have a form - frminvoice - which has a field on it called invoiceamount which simply stores a monetary value. I also have a subform on here that for each row has an issueamount field (number field) I have another textbox on the form frminvoice - Total...

OK PHV! Cheers, Dave

PHV I've just tried Hermans code and it seems to work a treat. Dave

Herman... I've sussed it! Thanks a lot for your help!!! Dave

Herman... Or in the onClick of the button??? Ta Dave

Cheers Herman... So where do I stick that line of code? On the afterupdate of the last field I fill in on frmIssues? Thanks again, Dave

Hi... I have a form - frmIssues - which is based on a table - tblissues. TblIssues is quite a large table with a lot of fields, so frmIssues allows the 4 most important fields to be entered in a row on continuous forms. After inputting those 4 crucial fields, the idea is for the user to...

Cheers for all your help guys... I've gone with Remou's solution as that fits the bill perfectly! Thanks again, Dave

Because along with their name, the combo box displays the person's postcode and phone number. Obviously every person has a unique ID, but the users unfortunately do not know the unique ID when doing the data entry, they do just have a name and a postcode.

I thought about using a listbox but the problem is that you cant jsut type the name you want as you have to physiacally click it. What would be good though would be as you're typing thre name in the combo box, a listbox directly underneath lists all the names that match what you've typed. That...

cheers for your suggestions guys... I'll give 'em a go and let you know how I get on. Dave

Hi... I have a combo box on a form that is populated with a list of names. The user can type in the combo box and it obviously auto fills in the rest of the name if there is a match. the problem is, some people have the same name. And instead of users having to type in the name, then click on...

Hi, here is a nice and easy one for you guys (hopefully!) I have a field called 'CreationDate' in a table called 'tblIssues'. I want the 'CreationDate' field to contain the date that that particular record was created on and I want to lock the field so that it cannot be edited/deleted. I...

Cheers Willif... You're right, I can 'print' it to .pdf, then I can save the pdf as a jpg. Problem solved! Cheers guys, Dave

Hi... No, afraid not. It'll just have to be the sketchy scan! Cheers, Dave