Search results for query: *

This one gave me an error saying "argument not option". For List1.Selected, I tried using List1.ItemSelected and List1.ItemData, but still gave the same message. Private Sub Form_Current() Dim listitem As Variant For Each listitem In List1.Selected If listitem > 18 Then...

Thanks... I'll check it now

It keeps saying variable not found for listitem when I inserted the code. I also tried changing it from listitem to age.

I have a form called "frmAdd". Inside this form has a list box called "lbox1" I have a query called "Age" that captures age. I am able to get the age into the listbox from the Query, but What i want to do is for the listbox, any age that is below 18, I want it to turn blue, and anything over 18...

Thanks alot AceMan, this really made it easy for me. thank you Mikee for helping too..

yeah the query is running from the form. As for the command button, I made it to execute the Query, but nothing works.

Ok, I added =[Forms]![frmSearch]![Months] under the Months criteria and =[Forms]![frmSearch]![Year] under the Year criteria Is this all to it, because now I am getting nothing out of the query? It does pop up an Input message box for me to type in something, but now it is giving me nothing...

Hi, I have a query called 'Query1' and a form called 'frmSearch'. In the frmSearch, I want to be able to use two listboxes to limit the search for Query1. One listbox is called 'Year' and the other called 'Months' So if I choose January under the listbox Months and 2004 under the listbox...

nevermind, I solved the problem L)

For a Clearer question, I'll give an example There are 25 Clerks under position, Under BegnnersType, there are a total of 12 clerks And under ExpertType, the remaining 13 are clerks. So under BeginnersType is 48% and the remaining 52% is under ExpertType I want to be able to count the total...

I have 3 texfield(no numbers but all letters) called position, BeginnersType, ExpertType. What I want to do is Count up the total positions,BeginnersType, and ExpertType itself. After that, I want Position divided by beginnersType get apercentage of how many positions belong in the...

here is the code: import javax.swing.*; import java.util.List; import javax.swing.*; import javax.swing.event.TableModelEvent; import javax.swing.event.TableModelListener; import javax.swing.table.*; import java.awt.*; import java.awt.event.*; import java.util.*; public class...

Hi, I got this code from java.sun.com, and i inserted into a class called classCars. I also created a class called classYr. What I want to do in the classYr is put a code that can capture the top 3 highest, lowest 3 price. I tried looking for example codes online, but coudln't find anything...

Thanks so much!!

it is date formatted as 99/99/00;0;_

I'm having problem getting this to work... The message error is "Data type mismatch in criteria expression". I tried modifying the things, but still popping up the same error.

I have a table called "table1". Within table1, i have a field name called "date inputted". In query, I want to try to pull out all of the dates older than 3 mnths from today. So today is March 12... what I want is pull out any date that is 3 mnths and above from today.

Thanks alot randy!!

It'll be great if you can give me some examples of that. I really really appreciate it. Thanks!!

I have one more thing to ask, I have a 2 other fields that uses checkboxes... 1 called "received" and the other is "shipped". If from the report "recieved" is checked, then I want it to be visible on the report. But if it is not checked, then I want visible to be false. How would I do this...