Replies

figured it out my code is fine I had in the combo box
something like: ………………………………..Tom’s………………….
so the……………………….. ‘……………………….was stopping the code!

Thanks Charlotte,

I needed DAO 3.6

Thanks Patt for jumping in,
I think I final came up with a solution, and would like anyone’s oppion,
I think I should do below in the query:

=UP
= IIf([number] Mod 2=1,IIf([forms]![frmm]![First]<[forms]![frmm]![Last],"NBL","SBL"),IIf([forms]![frmm]![First]<[forms]![frmm]![Last],"EBL","WBL")

UP can be with any of the four choices of NBL,SBL,WBL,EBL
Friday I just got stuck into thinking that I needed UP in the IFF statement but I think I can get the results I am looking
for by pulling UP out by itself,
Does this help you understand what I am trying to get?
I won't be able to test this until tuesday.

HansV,
Thanks for helping me, I can get my Iff Statement to work in the query if I take out the “Or up”….I can get the n,s,e and w….
records…I am going to try and work with it for a while…your last post is what I am trying
if you come up with a way to add the “Or” statement with an “up” let me know….if I can not get it to work then I will
try your solution for me…Thanks again.

up is not a name of a field but is text just like…n,s,e,w ,that I have to look for …..
let me add that I need …………..n Or up to go into the critria can I place that whole Iff statement in the
critria area and depending on the Iff it will put n Or up, s Or up, e Or up, w Or up in the blank for me?

[n] is a number…….but when I go n or up ……the n and up is text
the [n] is a road number……..so depending on if the road is odd or even then I need to look for a direction, so the critria will be one of four…….odd number road ……..n or up
s or up
even number road e or up
w or up

the up is text but has a meaning(other than up) and is looking for values of up…..just as the n should be looking for values of n

[first] and [last] are numbers miles post number which will indicate a direction also

when I take out the double quoates “n Or up” access makes it “n” Or “up”…………..and when I ran that query it comes back with
the error expression type incorrectly or too complex?????????/

One way would be to do a query and in the critria of the date field put something like
Between 01/01/02 and 12/31/02…..
does this help?

Thanks dcardno and AndyAinscow for your suggestions,

And thanks Charlotte on how to pull on the search, because my searches at first was not giving me much!
I do have it working now!because of all the help!

Thanks Hans will try it Monday when I am back at work and let you know If it worked for me!

I was trying to validate from a field in a table but I can do this validation from a from……
To tell you more about the validation ……I need to make sure if a code is A*(EX….A01,A02,A03) or B* or C* that the field
called [Des] has a number put in it…..but if the code is D or E, J or anything else then dont worry about a [Des] having a number put in it.

Thanks Hans,
Yes I agree with you….had a coworker ask the question and I found how to hide the tables but did not see how to hide the
tables tab on the database window…… I agree about the part of making a start up form and hiding the db window.

thanks the set focus works great but I had a requery working after update and now it doesnt?
Combo6.Requery…….this in the box that i set focus too ….Combo6 is next thing tab too after input in
text box….how can i refresh or requery that combo box?

Figured it out that
Me.Refresh
fixed it for me

yes working with a form and I think that when it clears for a new record its starting at the sub form I want it to
start on the main form.

I think I see what you mean about the report table. Yes want the begin date to be different for each des no and
some cases no date will be put in. I dont know how to answer your question about ” Is GCDESIGN a temporary table”
it is meant to be able to hold certain des numbers for as long a manager wants and it also there so that more than
one manager can have their des number and yes this table is only for the report nothing to do with data storing.