Search results

Good morning, Basically i have two forms 'Customer' and 'Job', a user can create a new job in the job form via a subform. Now there is also a subform in the customer form that displays all jobs for that particular customer. If a customer has NO jobs is there any way of making the customer...

was there suppose to be an attachment to your last thread chap?

Am i on the right track? i understand what you are getting at. I have created a subform based on the tblJoints table including the FK field. 2 things, does that mean i delete the second combo box? and, when i try and set the Link Master and Child fields to flID it tells me i cannot build a...

Rich hi, the PK & FK issue has been sorted as you suggested. I don't want to keep bumping this but its annoying me! My procedure and query are displayed, i think i need to add some IF statements to the procedure i.e. if i select 'Face Brick' from the first list box, i want only 'english' and...

Hey, Ive come to abit of a halt on my error trapping. I can relate Dave's link to the form "How One List Box Changes the Contents of Another by query" to my subform closely but problems occur when trying to replicate it, especially as it kind of conflicts with my original unbound controls. im...

Thanks Dave and bjackson, Just browsing through the forms from the link you sent me and i think 'How one list box changes the contents of another by a query' is the most appropriate. Going to try that today.

HI, I have a subform that uses unbound controls to calculate a Subtotal from various text boxes and combo boxes. However i am trying to implement some error trapping because i dont want certain values from each combo box being calculated together. The basic scenario is ComboBox2 contains...

thats great thanks, one small question on loading the form is there any way to prevent '#Error' being displayed in the SubTotal. When you start entering numbers though it works fine.

but when you look at the actual subtotal is still doesn't equate with the variables you enter. for example : 20(flemish) + 20(facebrick) * 10 is giving = £220 and not £400!

Apologies Mile... Here is the converted db, Hope it works.

Hi The_Doc_Man, Without the greatest amount of coding skills, im struggling to implement your code in a practise example. Does the Label refer to the text on the button? And whereabouts do you implement: - loTop = ctlExitButton.Top loRight = ctlExitButton.Left + ctlExitButton.Width + 1...

hi, even with column 0 is doesn't calculate.

Hey, I had a calculating problem with a subform that Rich fixed. The fix that Rich gave me contained 1 list box and when i edited & implemented the code onto my form it worked ace. However i now want to add another list box, and use its value as another variable in my subtotal. Look at the...

Thats good advice Fornatian, thank you. Most of my buttons dont need to be displayed all of the time, and that got me thinking. Setting visible etc. QU: I have a Customer Details form with an 'Add Job' button and a 'Save Customer Details' button. How for example could the 'Add Job' button...

Hello, As my forms contain more and functionality, im finding that menu buttons im implementing in the header are using up to much space. Is there a kind of menu structure guidance thats standard when using forms that contain many menu buttons or am i being a freak!!! Any advice welcomed

Hey Rich, One last question ive created a quotes table, doing as you suggested using the PK as Foreign keys etc but am abit miffed on joining the tables in the relationship window. As you can gather from the attachment, i have three joint tables, two tables containing the estimation variables...

Rich thats great help, thankyou very much, the estimate variables (thermalite bricks) can be stored easily enough can't they if i create a table for the value to be stored? BEN

Rich, ok, but can you create a list box that contains two columns i.e. cost and description? ...and shall i get rid of the tables? B

Hi - please find attached jpg of subform Currently trying to create a subtotal calculating data from the fields shown in the image. The values from the list boxes are obtained from two tables respectively. Each table contains three fields, Description (displayed in the list box) Primary Key...

SORTED, panic over fixed it.:o a spelling mistake! Such a simple thing. Thanks for the patience KevinM