Search results for query: *

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

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

I have a form with date fields - [Initial Date] and [8 Week Follow-up Date] I would like to change the background to another color if the [8 Week follow-up] was not conducted ~ something like: [Initial Date]+ 56 Days I don't know much VB and have been trying the Conditional Formatting - but it...

I have a table that I'm trying to make changes to the data - I keep receiving the following error message "error 'Error evaluating CHECK constraint'. in validation rule. Problem is I don't see any validation rules on any of the fields in the table - I'm tyring to insert a look-up combo...

I have a four digit number that I would like to sort by the last two numbers - which I can do through a string - but after I sort by the last two I would like to sort by the first two so they will be grouped by the last two but in ascending order by the first two - Make sense? i.e. 1201 1301...

I would like to run a query the pulls the first letter of a persons last name AND pull just the last four characters of their Social Security Number - Is there a way to limit the selection of characters in a text field? Is there a way to sort by the last two digits in a persons SSN? I have...

I have looked everywhere and cannot find anything on how to change the background color of every OTHER line in the detail seciton of a report (light gray then white) - I believe it is rather simple - but to complicated fo me - Any help would be appreciated!!

I have an unbound text box with the following IIf statement =IIf([Check132]=Yes,"UNCONTROLLED") I have additional check boxes and statements that I would like to fill that unbound text box with - dependant upon which box is checked - How do you add more than 1 IIf statement? I...

I get the following error when I try to pullup a third parties calander: COMPILE ERROR: Can't find project or library. Then the VB - goes and highlights: Format$ Am I missing something? A library or something? I'm totally lost. Any help would be appreciated.