Search results

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...

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 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]...

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...

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...

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...

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...

i hope this is an easy task I want to enter an IIF statement into my criteria. the expression is "chkboxstat=true" the true part is set the combobox value for the field's criteria "[Forms]![FrmParam]![CmBxStat]" the false part would be to leave the criteria alone (that is i don't want...

below is code i have written to use for a simple password action. all im trying to get is: enter a password and either make it into the next screen or not. im not used to codeing in VB, and i think i may be trying to simulate a subroutine the way i would do it in fortran. trouble here is i...