Search results

Yellow Lab name Dook. Will be 1 yr old here soon. He is a moose!

can you post up a sample of your database? I dont think [P1.DRV] & Chr(13) & Chr(10) & [P2.PASS] can ever be null since you are putting the Chr(13) & Chr(10) in there

Don't know. I only have 1 baby and its my Dog!

And this one has seemed to remain fairly pleasant also!

Private Sub Notes_AfterUpdate() If Me.Notes.Value Like "*ddendum*" And Me.[Addendum Yes] = False Then DoCmd.OpenForm "See Addendum Error", acNormal Else Exit Sub End If End Sub

Well I think you would want something like Issues: IIf(IsNull([DRV]) And IsNull([PASS]),"No Issues",[DRV] & [PASS])

Why not do that In the query itself rather then messing with it in the report? Might work better for you!

Start a new post in the queries section that explains this! You wont find much help in the introduce yourself section. Welcome!

How about a CountA function? =COUNTA(A1:K1)

Can you just use the count function? I created a test sheet using 1_2_3_456 and used count to get the total of 6... _ are blanks Or am i missing something?

Have you seen this? http://www.mvps.org/access/datetime/date0001.htm Age: DateDiff("yyyy",[Date_of_Birth],[Date_Of_Death])+Int(Format([Date_Of_Death],"mmdd")<Format([Date_of_Birth],"mmdd"))

Check this out http://www.access-programmers.co.uk/forums/showthread.php?t=38364&highlight=Mouse

Post up your Database, we will take a look at it.

Agree with Access_Guy You should look into programs such as Net Nanny (Not free but if they are serious about it then they may want to cough up the cash) and the like, I think you can set time limits... but im not sure if thats done by user login or what.

Well I don't know, does it work?? You said month is stored as a number in your table, so why bother converting it to text to match it to your combo value? Why not just use the ID column of your combo box and match it that way? Not a big deal, just how I would do it. LSQL = "select * from...

Nice one. Much cleaner than mine! Knew it could be done another way, just couldn't get my mid attempts to work correctly!

OK.... This is really ugly, but it worked for me I had to do this in 4 parts..... Here is the sql... Table 5 is the table name and test is the name of the field that I have your examples in... Get Ready... its ugly SELECT Table5.Test, Right([expr1],Len([expr1])-(InStr([expr1],Chr(34)))) AS...

If its stored as a number then you should be able to use your code that you posted up.. I realize you have no code written as of yet, but can you post your actual database up here so we can see what you are working with?

possible...... You said one is a month? Is it stored that way in your table? Can you post up a sample of your database like coach asked?

OK! That was just an example of the structure using a table I had in one of my databases... So lets break it down.. Transaction is the name of the table that I am trying to get the records from. SupplierID is the field that I am matching against the combo box to return the result that I am...