Recent content by noobSPX

Thanks, i seem to have it working now :) I created a tabular Form where I could tick the Jobs I wanted to select. Then I created an Update Query to insert a user-entered OrderNo. This is called by running a macro from a button, it runs the Update Query, then refreshes the form. Nice :) Thanks...

Hi and apologies, very new to all this. I have a system where I enter 'Jobs' which relate to individual tasks done by staff members for our Customers. These Jobs can be simple tasks, which I hold a description and price for, then these are charged out to Customers via an Invoice. An Invoice...

Ok I'm back.....partly your own fault for being too helpful previously. I'll try to explain this as best I can but feel free to ask for clarification. Background: I have JOBS which can be numerous per day. JOBS table holds: JobNo, JobDate, CCode (Customer Code), JobDetails, JobPrice (lots...

T Agreed, this is PERFECT !! I simply had to change my ControlSource on the unbound box to: =[Combo31]. [Column](1) It is doing exactly what I want and updating or displaying everywhere. Thanks yet again, this forum is phenomenal !! Cheers all for seriously prompt and well explained...

This looked exactly what i needed but it changes the syntax to: =[CCode]. [Column](1) Then, in my form, it displays #Name? where I'd expect the CompanyName to be. Columns are CCode and CCompany from table Contacts.

You are correct sir, this performs the lookup After Update. My new problem is i would prefer to have this DLookup happen all the time, on rexord change etc. Can I incorporate the DLookup into the Control Source of the Unbound Box...something like: =DLookup ("CCompany", "Contacts", "CCode =...

Screen Shots as per attached, with a couple of variances of the error.

Ok, now that I'm beginning to enjoy myself, and having moved to MS Access 2010, I've found some things easier....but not all. I have a Purchases form, with a Combo Box storing a Contact Code (CCode). I want to display the Contact Name relating to the CCode in an Unbound Text Box (called...

Yep, missed that one again. Absolutely brilliant, my form is acting exactly as i want, subform working great, totals all automatically updating across form/subform and all default data filled in from other tables. You have got me past a bit I've been seriously stuck at, and I've learned a lot...

Tried Nz function but it's not null values that is causing the prob. I call a number of columns and insert the value into form fields, but it only seems to insert the first few, leaving rest blank. I'm using an AfterUpdate prodproedure with: Me.IContact=Me.List51.Column(2)...

Would a null value in one of the Me.... lines knock it off in any way. In the main form I have a CCode combo picking a customer. on AfterUpdate I call a number of Column values, but it only lifts CName, CCompany and Address line 1....it should lift more address, town etc values. The only thing...

You sir are a genius! I googled Trust Centre and enabled macros option...that seems to sort my problem. Yep i notice what you mean re Columns, in the Combo box I'm bound to column 2 as i should, but in Code it starts count from 0. Sorted this too and now able to continue my pet project. Thanks...

No, no spaces, it's just my typing sorry. Tried a few times, not getting anything into the PDesc etc fields. I've attached my database, it's the Invoices Form and Invoice Details subform that I'm stuck on. Excuse my novice attempts at form design, i hadn't expected anyone well versed to be...

Hi and thanks again. I checked column count and it was set to 4 instead of 5. Still nothing showing up in Fields. I'm wondering if my syntax is ok or if i should add procedure to another place.

Thanks for the reply and your patience. Ok, taking the advice from the 2nd link, i should merely be selecting all the required fields (Id, PCode, PDesc, NettPrice, VatRate) as the Control Source of my PCode Combo. Then I have the following code in AfterUpdate property of PCode combo field...