Search results for query: *

PeteJohnston, I appreciate your help!!! Air

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...

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...

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...

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...

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.

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...

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...

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...

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...

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

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...

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...

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...

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...

jrbarnett, I have tried using your examples. Thank you for the help. What happens is when a field on the form is null - the code cuts out that entire string. I can't have this happen. I need the string to be present in the email wether the field is null or not. Is there a way to to do this...

I have a code that I am working with that is really neat, and works great. I just don know how to get rid of Error.number 94. I want the code to be able to ignore a field if it is null. Here is the code I am working with: I am having troubles with the Command101_Err. I what have thus far...

I have a form that I am working with. I am using the DLookup function. Here is my example: varFLEETTYPE = DLookup("FLEETTYPE", "Fleet Effectivity", "!IID =[IID]") varCPWOH = DLookup("OH", "gtiaiq", "[MATL TYPE]= 'SV' And [GTWY]=...

I have a code I am working with and it works great. I am trying to modify it so the fields on the form are outputted in bold and uppercase. Any help on this? Also, it there a way to build an email message template - like a MSWord mail merge, and have the current record on the form populate the...

Below is an example of the code I am working with. This code changes the BackColor of lables on a form. This code works just, except I would like for it to "pause" while the user enters a small bit of data into 1 table/1 field. I have a query that deletes the previously entered data...