Search results

wait I got it now. stupid question. Thanks alot travis that saved a big headache

Thanks for the quick reply on that Nz function, does that only work on empty fields or will that identify an empty field and treat all other fields as regular or does it mess up with fields with actual data in it i found the problem on the second problem. thanks

In this iif statment the query compares two fields. It works if the data is different or the same. However, if both fields are empty access returns it as a difference even though they both are empty fields. Is there any way to make access realize that if both fields don't have anything...

thank you! that did the trick.

yes i know they have to open the db with a shortcut ( i sent that too as well as the security file) i think this maybe the problem thought i would do a preemptive answer the obvious question there

i know you can send regular db over e-mail, but is it possible to attach a secured db on a email and the reciever still be able to open it. if so are there any major tips i should be aware of bc right know it is not working. thanks for any help my coworker needs the database for a presentation

I appreciate all your help. pat your advice did the trick. such a random thing for access to just spit out 13 identical records thanks again!

I ran it as a select query and it still spit out 13 rows...:confused: but there is still only one record with the specified facility name

I want to append a row with a specific selected facilty name This is my append query. no matter what facility_name i use it appends that record 13 times. it probally is something stupid but i have been looking at it for hours and can't seem to find my error INSERT INTO TrackChanges ( [User]...

okay thanks for you help. its good to know that the query results will be refreshed when the pull down box is selected. i would love to have a database with "correctly structured" data but this database has had like 4 different owners. thanks again

i have a "group by" query which outputs all the different enteries for the particular field. this query is the row source for a pulldown box on a form. 2 questions: #1) does access run this query everytime a user uses the pulldown box? or do the query results remain until that query is...

thanks that worked great

this satement below sets the coolant field to what is in the combo box [Coolant]=[Forms]![FrmParam]![CmBoxCool] the combo box is unbound and is used to set criteria for a query. for some of the fields under coolant there is one type of coolant, but for others there is multiple like "H2O...

thank you so much. i guess i was getting hung up on using + as opposed to using &. i saw an example on here were they combined stuff on a field with + and i just went with that. my access knowledge although broad is patchy. anyway thanks fizzio!

you are probally gonna have to be a little more specific. like when does that happen i probally still won't be able to help but someone else might

hello, i am trying to track changes. i have succeded so far and am quiet proud of myself. however, i am having trouble getting this to work for previously blank fields. for everything else it adds "oldvalue=[whatever the oldvalue was]", but for previously blank enteries it only adds a blank...

hey thanks that is great. unfortunaley i get the new error message on entering as an allowed user. i can probally work that out though i just needed that initial coding direction. Thanks again!

ok i have a button and it goes to a form that is restricted to the read only group i have established. when a member of this group clicks it won't let him saying he doesn't have permission to which is great. however i really don't like the error message bc it gives the option to debug the...

wow, this forum is awesome thanks so much!

that was awesome! that is exactley what i needed thank you so much. now, is it possible for me to modify what you gave me to something like this IIf([Forms]![FrmParam]![chkboxThermPS],[Forms]![FrmParam]![TxtBoxmintps]<=[Thermal Power Steady, kW#]<=[Forms]![FrmParam]![TxtBoxmaxtps],True)...