Search results

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

Thanks a lot, I did a search for 'concatenate' and found this sample database which is similar to mine. Works great! http://www.access-programmers.co.uk/forums/showthread.php?t=74272&highlight=concatenate+records

I need help with location query. I have a table of three fields Location Item Qty I want a query or report to display locations of an item in one field instead of multiple records. Data: Loc Item Qty N024 AA77 88 N025 AA77 87 N026 AA77 28 N038 AA77 89 N039 AA77 25 N44 BB77 100 N46...

The resulted value is not stored as new records . Text4 and text 6 should be stored as new record in the table. The above forumla replaced current ptype used qty. See picture.

I think I either didnt explain my problem well or it's more complicated. I have attached of samiliar database to look at. How can i have text4,text6,text8,text9 stored into pinven table text4 and text8 into ptype field text6 and text9 into used field

They have to be stored for records and reports purposes. Here is a picture of the form and fields