Recent content by Haz

Thanks alot got it working.....

Finally I got it managed to work by adding the dlookup function to a control box in the form. But for some reason, its returning the first value of the first criteria only and the "AND" and "OR" not doing anything, maybe the qoutation is wrong. Here is the function: This should return the...

I have a query that find all duplicate ones the way I want, but how can I make this on the form to prevent the user. I appreciate your help the query sql is like this.

RowSource is query with only one column. Both cborefno and txtrefno are not bound to the table. they are unbound controls.

no errors. it's just not catching the duplicate records. The funtion is called inside the save record button.

I do have the dummy field as long Integer and no duplicates but the form is not bounded to the table and can't have the dummy in it. I have a code that update the table. I used the code with out the primary key but still can't get it to work. I don't have any field that is primaryKey and no...

I have a table with two fields that each can have duplicate values but both can't have the same values in other records. The form has the type field as combo box and refNo as combo box and text box. example of data tbl_main, type refNo small W239 large W239 small W250...

Thanks for your help. Works like a charm and great info.

Sorry I must didn't explain it well. strLoc is not a table field nor a form control. I thought this is just temporary holder to pass the input value to the location field where whatever is selected in the cbocode on the form and the table field type="beginner" I thought is code will work:

Thanks alot.... I have done this: 'this under the edit button dim strLoc as string strLoc = inputbox("Please Enter New Location", "Location Chagnge!") If Not IsNull(Me!strLoc) Then Docmd.SetWarnings False DoCmd.RunSQL "UPDATE t1 SET Location = Forms!frm_entry.Form!strLoc WHERE...

I have a unbound form that update the table with vba code by clicking a command button. One field on the table is called location. On the form I have the code field as combo box, once a value selected from the combo box the location text box populated with dlookup function. How can I have the...

Sorry I meant dates becuase when doing the crosstab query it turn the date into values. the table looks like this field1 field2 field3 field4 StageType date location employee stype type has those stages 1 through 8.

DCrake, Just wondering how would you put that datediff funtion in 3 column query? becuase stage1, stage2, .....and so on are text values that I want to have them as field names and the cacluations for the dates under each stage. Lets say stage 1 and 2 have 400 records of just the date/time ...

Thanks alot guys, the crosstab query works out very well.

I have two fields called stages (8 stages) date ( the format is MM/DD/YYYY hh:mm:ss AM/PM) each stage has corresponding date/time in the same record. I used a query for thse fields and group stages and average the date...thats why my poing is looking for average date/time between stages...