andymartin3186's latest activity
-
Aandymartin3186 replied to the thread Search box to find parts to add to job instead of a combo box.I tried changing the subform to Allow Additions Yes and that stops the error for now and the box is blank. It would be nice for it to...
-
Aandymartin3186 reacted to June7's post in the thread Search box to find parts to add to job instead of a combo box with
Like.
I edited my previous answer and no longer has that suggestion because it did not work in my test. I should have tested before posting. -
Aandymartin3186 replied to the thread Search box to find parts to add to job instead of a combo box.Why doesnt the parts total box display an error but the box which points to parts total does? The other box just has =[Job...
-
Aandymartin3186 replied to the thread Search box to find parts to add to job instead of a combo box.This is the code I put into the box for the line total. Does the code need to go into the other box which is showing the error...
-
-
Aandymartin3186 replied to the thread Search box to find parts to add to job instead of a combo box.Quick question and probably one that is easily fixed Parts total at the bottom is a calculation from sum of line totals. If no parts are...
-
Aandymartin3186 replied to the thread Search box to find parts to add to job instead of a combo box.Just to show you how it now looks, I've added tab pages to make it more neat so the components section of a job is on its own page...
-
-
Aandymartin3186 replied to the thread Search box to find parts to add to job instead of a combo box.Hi June That was really helpful ive amended this and prefer it without warnings. I might do the same when deleting a line but may be...
-
Aandymartin3186 replied to the thread Search box to find parts to add to job instead of a combo box.Many thanks, this worked brilliantly. The code I used at the end was Dim intPartID As Integer Dim intJobID As Integer intPartID =...
-
Aandymartin3186 replied to the thread Search box to find parts to add to job instead of a combo box.Update - I've done all the work to add the 2nd subform. I just need the code now to put into the button so when I choose a component...
-
-
Aandymartin3186 replied to the thread Search box to find parts to add to job instead of a combo box.Hi everyone, I've attached a few screenshots of the existing design, and also the last one which is how I filter to look up my jobs...
-
-
Aandymartin3186 replied to the thread Search box to find parts to add to job instead of a combo box.That works as long as you know what you’re searching for which is sometimes difficult as electronic components have part numbers...
-
Aandymartin3186 replied to the thread Search box to find parts to add to job instead of a combo box.Thank you The (link table?) jobparts links job.jobid & parts.partid and also has a qty field. Apologies Im not a programmer Ive built...
-
Aandymartin3186 posted the thread Search box to find parts to add to job instead of a combo box in Forms.Hi everyone I currently have a job form, which has a job parts subform which looks up components from a components table. There is...
-
Aandymartin3186 replied to the thread Display a list of previous jobs with same serial number on current job form.Cheers for that, just knocked one up works a treat 👍
-
Aandymartin3186 replied to the thread Display a list of previous jobs with same serial number on current job form.Sounds good. Is the popup a seperate form with critical info?
