Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by air1jcw

  1. air1jcw

    Saving txtbox names as values

    PeteJohnston, I appreciate your help!!! Air
  2. air1jcw

    Saving txtbox names as values

    PeteJohnston, I am trying to take the label names/captions, concatenate them, and transfer that into a table. Green labels will be transferred into a field, red labels will be transferred into a field. I am NOT looking to put the label names in color into a table. Just the names themselves...
  3. air1jcw

    Saving txtbox names as values

    PeteJohnson, I am not quite sure if I can use this example??? It looks like it will do what I am wanting... However - I need to be able to strRed, strGreen and strBlue and put them each into the same table in their own fields, along with several other values in txtboxes. Also, some of the...
  4. air1jcw

    Saving txtbox names as values

    I have a form that when a IID is entered into a txtbox - the "After update" runs a couple of MakeTable Queries and populates several txtboxes on the form - you can then click on a color coded legend (box) - and if the name of the label=the value in a table - the label changes to a...
  5. air1jcw

    Help with Transfer Database Please!!!

    Below is code I am working with that I got from another post. I am having troubles "breakin it down". How exactly do I apply the code for the file path AND name of database/table I want to import into current d/base? AND - I would like to run this from a command button on a form - Can...
  6. air1jcw

    Concatenate Scenario

    dhookhom, Thank you very much for your help!! Your code examples and d/base example is awesome and is exactly what I need. Thanks!! Air.
  7. air1jcw

    Concatenate Scenario

    dhookom, I should give this info to ya - it might help you to help me!! Table structure Query results The way I would like it fldIID fldMPN fldIID fldMPNs 112 AA 112 AA, AB 112 AB 113 BB 113...
  8. air1jcw

    Concatenate Scenario

    dhookom, I tried the "... WHERE [TextField]=""" & [TextField] & """" and the concatenate field returns null. I am not getting any errors messages. Just a null field. Heres the SQL I am working with: SELECT EffectivityMAIN.IID, Concatenate("SELECT...
  9. air1jcw

    Concatenate Scenario

    dhookom, Is there a way to do this without a primary key and with out numeric data type? I have a good "linking" field to use between 2 tables - it is a text field. And that field resides in both tables. If this don't work... If there is an other way - The data I am wanting to...
  10. air1jcw

    Concatenate Scenario

    MichaelRed & CosmoKramer - Sorry for the confusion and I appreciate the extra effort. I solved the space issue. I was wanting a space after each comma: 727,757,767, to 727, 757, 767, etc... Perhaps you can help me with another issue of concatenating. I am using a code, maybe you have seen it...
  11. air1jcw

    Concatenate Scenario

    MichaelRed, Yeah - I don't know what all that "denormalized" is all about?? Anyhow - Thank you very much!!! What you provide worked great!! How do I get spaces inbetween?? From 727,747,757 to 727, 747, 757 Air
  12. air1jcw

    Concatenate Scenario

    The end result would could look like: FldA FldB FldC FldD FldE New field 112 A300 757 767 A300,757,767 114 727 727 115 757 767 757,767 116 A300 727 757 767 A300,727,757,767 Does this make better sense? Please advise if...
  13. air1jcw

    Concatenate Scenario

    I have a table I am working with structed like so: All are text fields. FieldA FieldB FieldC FieldD FieldE etc... 112 X X X 113 X 114 X X 115 X X X I would like for this to be concatenated into 1...
  14. air1jcw

    New email message with default signature

    Below is the code I am working with. It works like a charm!! When the email message opens - it does not contain the default email signaute. Is there a way to call the email message with the signautre? Thank you in advance!!! air. Private Sub Command101_Click() On Error GoTo Command101_Err...
  15. air1jcw

    Emailing from form

    jrbarnett, AWESOME!!! What you provide has helped!!! Thank you very much. As far as the text turning bold... This email is used internally throughout our office, and I know that everybody is using the same email format. If you could supply the code for making the text bold - that would be...

Part and Inventory Search

Back
Top