Search results for query: *

I solved it ...I did the following....I like that Tag ...very versitile rivate Sub cmdClearFields_Click() Dim ctl As Control For Each ctl In Me.Controls If ctl.Tag = "T" Then ctl.Value = Null If ctl.Tag = "R" Then ctl.Value = "ACTIVE" Next End Sub

Thank you! Mark....It worked. I appreciate your help and patience. I do have another question...on one of those combo boxes I want the value to change...from "SUSPENDED"...to "ACTIVE". I would like to change it with the same button push as the clear fields. I appreciate you help...it is...

Thanks Mark, Does this look right? I get numerous error messages Private Sub Command42_Click() Dim ctl As Control PRP_Status.Controls If [Date].Tag = "T" Then [Date].Value = Null If [Arm].Tag - "T" Then [Arm].Value = Null Next End Sub

I have looked through various FAQ in search of a method of clearing 5 fields in a sub-form. I would like to push a button then clear those fields. They are simple fields [Name, Date, a yes/no box, and 2 combo boxes]. Is this too difficult? I do not have much VB experience. Any help would be...

I have looked through various FAQ in search of a method of clearing 5 fields in a sub-form. I would like to push a button then clear those fields. They are simple fields [Name, Date, a yes/no box, and 2 combo boxes]. Is this too difficult? I do not have much VB experience. Any help would be...

ZmrAbdulla, Thanks for the tips - it kinda worked....it either kept all of the date fields or made them invisible. I would like each row to be specific to each member - where on row may have all 4 quarter fields and one row many not have any based upon the checkbox. Thanks for the help...

I maybe attacking this problem incorrectly...but this is what I'm having trouble doing. I have a continuous form to input training. Within the form I have a check box - that designates if that selected person requires quarterly training. What I would like to occur is - if the box is checked...

I'm in a form with a button click to another form based on a qurey. If there is no data in the query/form I would like a messge box to pop up. I have seen the code for a report but I cannot use that same code in a form. Can someone help? I have tried this: No luck Private Form_NoData(Cancel...

Background: I have a task table and a month table - I have them linked One to Many - the purpose is to query tasks by month: I have a form with a unbound check box for each month Here is my problem: I'm having a problem getting my query to run - properly: Any ideas how I can pull up my...

I'm having trouble developing a complex query: I'm trying to calculate the Body Fat % (for women)based upon the Waist, Hips and Height measurement using the following formula: %Fat=495/(1.29579-.35004(log(abd1+hip-neck))+.22100(log(height)))-450 Using the following numbers: 29" waist...

I have a combo box for MALE or FEMALE: I would like to make a text box disappear when I select MALE I'm not very VB savy - here is what I got so far Select Case Me.Combo28 Case "MALE" Me![Text40].Visible = False End Sub Thank you

Thanks for the response ~ Since my subform is connected to the form by the employeeID - That when I go to form view I do not get any of the criteria from the table because there isn't any data in the criteria table - where I planned on placing the date of training. I'm confused as to where I...

I'm trying to track training for employees - I have a table of 10 employees with a unique ID and I have a table listing their training criteria - it also has a unique ID. I want to place a date next to the criteria once the employee has been trained. My problem is when I create a form of the...

I have a form with a bound field [Followupdate] I also have another date field [Labdate]: What I'm trying to do is automatically fill the [Followupdate]with a date of 90 days after the [Labdate]. I have tried a couple things 1 - set the default in the form for the [Labdate] field as...

I have a report with a page break between the before the detail section - When I print preview the first page is blank - how can I either delete the first page or prevent it from coming up? Thank you

I have two images one on layer on top of another - I would like to make the top image transparent when either the moues slides over the image or when "click". Any ideas? Thank You!

I have a query with multiple fields -If any of the 4 fields are null I want it to return a name; currently it is returning those names with multiple null fields - not if any are null but if all are null - I imagine it is a rather simple fix - any suggestions would be appreciated!!!!

I'm trying to change the color of my field if the field is empty - I have tried the statement below with both the IsNull and IsEmpty - but it still won't work - I know it is pretty simple but I'm missing a step Private Sub Form_Current() If (Me!Followup7) Is Null Then...

I have a list of 200 names sorted by the last 2 numbers in a SSN field - In the report I would like to group them as follows 01-09, 10-19, 20-29 and so on. I have them sorted in decending oder - now I would like to group them - Any help would be appreciated!!

Check out http://support.microsoft.com/support/kb/articles/Q302/5/04.asp Set your Allow Zero Length property to YES and Required to NO -for all of your TEXT fields