Search results

are there any samples out there that I can how it works?

I want to hide 3 boxes in a report then have them show up is a set of conditions are met. I made my 3 'label' boxes and named them hidden1, hidden2, hidden3. I set them all to vissible 'no' Can I make something and say: if [Color]=Red, then Show [Hidden1] if [Color]=Blue, then Show...

Have any of you ever used some really good online training? I really need to get good with ASP.NET, VB.NET, ADO.NET and SQL 2007 Server ect. I want to do some self pased online training, anyone used a really good service for this? Thanks you!

Here is my current code: FROM tbl_COMPANY INNER JOIN tbl_TESTS ON tbl_COMPANY.CompName = tbl_TESTS.CompName WHERE (((tbl_TESTS.DateBilled)=#3/5/2008 7:15:02 AM#)) ORDER BY tbl_TESTS.CompName; I no longer want to refrence the exact date and time. How can I change this to look at the most recent...

Adam I have been sick for a few days so I did not have a chance to check this. I will try this script in the morning. THANK YOU VERY MUCH FOR THE HELP.

OK, so if it is needed what would I have to add to that VB to also look at 'Refusal' If IsNull(DLookup("TestResult", "tbl_TESTS", _ "EmpSS = '" & Me.SSN & "' AND TestResult = 'POSITIVE' OR 'REFUSAL")) Then would this work? Sorry I suck at this stuff man.

thank you Adam Thank you for the help so far. Do I even need this code in my VB Public Sub CheckColor() 'use the built in DLookup function... it's a bit slower 'if no records exist for this SS with POSITIVE, go grey If IsNull(DLookup("TestResult", "tbl_TESTS", "EmpSS = '" &...

Private Sub Form_Current() CheckColor End Sub Public Sub CheckColor2() 'using a recordset will be faster, but you might not notice Dim rs As dao.Recordset 'get the recordset from the subform Set rs = Me.frm_TESTVER_TEST_HIST.Form.Recordset.Clone 'search for...

thank you pual. I could find it in the forms, but was hoping to set it on the table. THANK YOU SIR.

I have a simple "Value List" with about 5 choices. I only want my user to be able to select one of those 5 options, I do not want them to be able to add any other value into that column. What option do I select to lock the column down to only allow what is on that list? Second question. The...

Nellie, This works perfect THANK YOU so much. great work, I told my coworker this would take me a month to figure out. instead I am done in one day that is GRETA! Paul, I see what you mean about only doing it one time and having the function around for other queries. Luckily I will only...

or do I need to make each one its own line [TestType] = 'DRUG' AND [TestReason] = 'PRE', 'DODTD' [TestType] = 'DRUG' AND [TestReason] = 'RAND', 'DODTD' [TestType] = 'DRUG' AND [TestReason] = 'FUP', 'DODTD'

tehNellie, Your style works pretty well & it is easy for me to follow. Can I add an or in there somehow? [TestType] = 'DRUG' AND [TestReason] = 'PRE' or 'RAND' or "FUP', 'DODTD'

Paul, Thank you for the reply. That is over my head, but I will start reading up now. I understand that a function needs to be created in VB so I will starting reading so & see if I can make something work. It is good to know the best way to attack it so thank you for the blueprint. I have no...

I will need to create a new column in a query with data based off of two columns currently in my DB. Current fields are: [TestType] & [TestReason]. New TEMP field will be [TestCombo] TestType has 4 possible option via drop down. TestReason has 21 possible options via drop down. TestCombo...

thank you Jon K I will try it at lunch when I can get to the system. :)

SampleID2: IIf(Left([SampleID],1)<=4,"RED","BLUE") This is original code which works great. Well my client made a change. Now the number "3" should be BLUE as well so my <=4 red no longer works. What is the best way to set this up so numbers 1,2,4 are RED and 3,5,6,7,8,9are BLUE? Thanks.

I see. I am not ready for that yet, but still good to know. You are a life saver.

Perfect. Thank you for all of your help tonight. you have saved me once again. Thanks!

also a logic question: Why do this: Format(DateAdd("d",15,Date()),"mm/dd/yyyy") When you can: Date()+15 Is one better than the other?