Search results

hi, i have a form "main" and a sub form "submain" i have some code in the sub form on a button click event. i need to take the infomation in the current record in the sub form and a piece of infomation in the main form, put them together and write the data as a new record to an unrealted table...

the code works, great, i looks like it shouldn't work or we shouldn't do this but it works.

Yeah I did and still same error the K variable get set to the right string, whatever I type in the box, but it wont type match with the [surname] field on the new form, is it because the [surname] field is on the other form ? and there is a surname filed on the present form ? I can't get it to...

hi nether worked ? text78 or "'" system, still same error

Can any one tell me why I get a type mismatch here ? private sub text78_keydown(keycode as integer, shift as integer) dim k as string if keycode = vbkeyreturn then k = me.text78.text docmd.openform "address query", acnormal,,,"[surname] = " & k,acformreadonly, acwindownormal end if end sub...

hi can u say where datevalue would go into the SQL ? not used to sql..

its a bit difficult because to dateof fields is date and time and i need to pick out the same date only, so "1/1/2009 18:00:00" and "1/1/2009 18:03:11" would sum together. ..

Hi I have data 1/1/2000 : aTime : Text 1/1/2000 : aTime : Text 2/1/2000 : aTime : Text 3/1/2000 : aTime : Text I need to return the sum of fields that have the same date. so, (2,1,1) as there are two entries for 1/1/2000, 1 for 2/1/2000 and 1 for 3/1/2000 can anyone help ? Gregor.

Hello, I have a problem with text boxes and memo boxes. When I do a form and am entering text into a text box,when I hit return the cursor sometimes goes to the next line and sometimes it goes to the next control ! The only way around this is to hit ctrl return to take a newline ? I am not sure...

I think this is right

Cool ........................

GREAT it works !,can i ask you to explain how ? as in ID in (select min(ID) from Gregordstableofthefollowing group by field1); i tried to use the First() command ????

so the data is more like ID---field 1------- field 2 ----------------------- 1---red car-----------qa 2---red car-----------ws 3---red car-----------ed 4---yellow car--------rf 5---yellow car--------tg 6---pink car----------yh 7---pink car----------uj 8---pink car----------ik...

but there IS a sequental ID field. 1,2,3,4,5,6,7,8,9

Hi i got it wrong the data is more like field 1--- field 2 ----------------- A-----------qwewq A-----------ewt A-----------rrwehgr B-----------regtre B-----------rgsdfg C-----------dfgdfsg C-----------dgsdfg C-----------dfgsdfgfsd ------------------ as in field two is non sequential :( damn

Hi, I have a table of the following. --------------------------------- field 1--- field 2 ----------------- A-----------1 A-----------2 A-----------3 B-----------2 B-----------3 C-----------3 C-----------4 C-----------5 ------------------ I want to right a quiery to pull out the 1st, 4th, and...