Search results

Command Button not working on one user station? Hello, I can't figure this problem out ... one user is using runtime MS Access 2000 and have been able to use this form with an OK command button to launch a report before but now she is unable to do so. I can't duplicate the message as it's...

hi! thank you. i will once I get a chance. we have to pack and be ready to evacuate Poway, CA the fires have gotten worse due to the strong winds and it's close. they have evacuated Rancho Bernardo which is just our neighboring city.

Hi! thanks ... but, doesn't ([option_item] & " " & [OptionCombo]) mean combine option_item optioncombo? there's nothing in OptionCombo field. i need it to run the update query to update the OptionCombo field with just the data from Option_Items ONLY when the Option_Items are Body from...

Hi ajetrumpet, yes, but for a different approach. it's been a difficult task and i've come up with another direction and needed help with the SQL statement using a new field OptionCombo. basically trying to now get ONLY the Body Option_items concatenated into the new field OptionCombo and if...

I'm using: IIf([OptionCategory]="Body",Concatenate("SELECT Option_Item FROM GuitarOptionDetails WHERE GuitarItem & Option_Item =""" & GuitarOptionDetails.GuitarItem & GuitarOptionDetails.Option_Item & """"),"N") and the result is this: InvoiceDate InvoiceNumber GuitarItem Option_Item...

i thought this: IIf([OptionCategory]="Body",Concatenate("SELECT OptionCombo FROM GuitarOptionDetails WHERE GuitarItem & Option_Item =""" & [GuitarOptionDetails].[GuitarItem] & [GuitarOptionDetails].[Option_Item] & """"),"N") but still needs some more tuning ... thoughts?

thanks for the attempt. no, not combine GuitarItem and Option_Item. but combine all of the Option_Items when it's OptionCategory = Body don't worry, i have a Concatenate() the SQL will be written in. i just need to get the SQL statement to be correct. :-)

so when it updates it would have the following results in the OptionCombo field as such: InvoiceDate InvoiceNumber GuitarItem Option_Item OptionCategory OptionCombo 9/7/07 2365186 AE185 38 Body 38 BB 9/7/07 2365186 AE185 AB Neck 38 BB 9/7/07 2365186 AE185 ABL Options 38 BB 9/7/07 2365186 AE185...

Hello, Run-time error ... No value given one or more required paramete UPDATE GuitarOptionDetails SET GuitarOptionDetails.OptionCombo = Concatenate("SELECT Option_Item FROM GuitarHeader WHERE GuitarItem & Option_Item =""" & [GuitarOptionDetails].[GuitarItem] &...

thanks! we will dump this and move onto it another way to simplify more. thanks for ALL your time and effort! greatly appreciate it!

Hi, i am confused, in this you state that you select the combo for each invoice ... this is the problem. that's not going to happen for each time there's a new invoice. each new invoice should look at the guitar w/ options (if available) and pull the programming codes combo set for that...

Hi CraigDolphin! WOW! major problem here ... the guitar programmer user will not be assigning the programming codes per order but define all the sets per unique guitar and guitar w/ options and maintain when that changes. this is not to every time there's an invoice as this is inefficient. the...

to: UNCLE GIZMO - could you jump in? CraigDolphin has been helping and is very close ... but was wondering if i can get some reinforcement :) and get to closing this with a couple of good mines sooner? summary of discussion: This is a separate db JUST to get the correct set of guitar...

this is not the greatest and basically the path you are describing that my husband helped with ... again, not the greatest but it's the same thought in having some match back to the invoice. basically 1. another field in the invoice table that has a combined list of the options 2. replace or...

thank you! it seems this has gotten the best of a lot of great Access gurus! i hope someone can come up with a solution. it's odd, i would think something like this exists with other companies and therefore other users needing help. it's seems like a 'normal' process of manufacturing something...

THANK YOU! we are so so close now. your later part is true. i'm including another guitar with more options (there can be a combination of several, not just 2 options per guitar) so to show that example, i'm including this: Guitar Option Code ComboID DC200 RB 200R-RB 1 DC200 FA 200R-RB 1...

Hi! ah, thank you! we're so so close now. it's the later part that you are correct on. please advise what I can do to achieve that result: "AE185 Finish X only ... A,B,C AE185 Finish Y only....A,B,D AE185 Finish X and Finish Y ...A,B,E"

Hi! thank you. i did not receive a notice you had replied. i thought i'd check and contact you for a follow-up and saw that you did in fact post and came up with something. however, the results on the form for the programming codes for invoice 2365186 is incorrect. it needs to ONLY show the...

hi there! yes, most all of your interpretations are correct EXCEPT that there are more then one programming Codes. guitar item AE185 has 3 codes with no options, all these 3 codes need to display when NO Body options were selected for this guitar on an invoice. the PK and FK is easy to do. i...

Bob, yes and thank you for keeping this going! Ok, you see, i thought i've explained what you asked in the prior reply :-( let me try again ... The "guitaritem" is the name of the field that holds all the partnumbers for Guitars. And is the base model or standard item for a guitar. you can...