Search results for query: *

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

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

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

I'm in the process of building a new form. I want to be able to "dump" a value in a textbox on this form, that populates multiple textboxes on the same form - based on results from a select query. Is there an example code out there that I could use?? Thank you very much!! air

Below is the code I am working with. I don't have it quite right yet. I am trying to get the results of a select query to show as lables changing color on a form. This is what I got so far. I would like for the labels to change color when the values in the query match the caption (of the...

I have multiple labels on a form. I would like to be able to enter a "IID" into a text box, and then after update, highlight the labels (either text color change, or bold) that are equal to the "IID" entered in the text box. Can ya point me in the right direction?? Thank...

Below is code that works just fine. It outputs text from a form into a MSWord template. I would like to have the output type the text in uppercase & bold. Any help?? Private Sub MergeButton_Click() On Error GoTo MergeButton_Err Dim objWord As Word.Application Set objWord...

I need to be able to "highlight" the text in a label during mouseover on an ACCESS form. I would like to be able to change the text color to blue when the mouse moves over the label - OR change the pointer to the hand pointer on mouse over. If I can get the exact code for this and...

I have a field that is of "number" data type. The data shows up as 123. I need to show the data as 01:23. I cannot not change the data type because the data is transfered from a .txt file. Changing the data type corrupts the data. Some of the data shows up as 1256. Whick I need...

Hi there, Heres the deal. I am trying to build a query that shows misc. values from a field as one value in another field. Meaning I have a value in field A (a repitive value),and I want to see all the other values (associated with the repitive value in field A) from field B in a newly...