Recent content by danielc

Hi, I have a form with a subform set for pivot table view. I want to go to a specific record in main form based on the selection I made on the pivot table subform. Something like on click (select) for pivot table view. It should be possible but I can't figure how. thank you for your help. Daniel

I've figured out. Here is the code: Function d() DoCmd.SetWarnings False Dim stc As Double Dim cod As String Dim codl As String Dim DATA1 As Date Dim DATA2 As Date Set db = CurrentDb Set rs = db.OpenRecordset("q4") stc = rs.Fields("TRANS") rs.MoveFirst Do Until rs.EOF DATA1 =...

Post the code that prints the labels.

Hi, I'm a newbie with VBA. I have a query sort asc by id and date ID / TRANS / DATE Z1 / 2500 / 01.07.06 Z1 / -300 / 02.07.06 Z1 / -450 / 03.07.06 Z1 / 225 / 03.07.06 Z2 / 325 / 01.07.06 Z2 / -226 / 01.07.06 Z2 / -100 / 02.07.06 ........................ I want a function to make a sum for...

hi, you can try with Weekday Weekday([date]) the rest can be solved with iif . dny

Hi, You can try: IIf([totalSum] < 300; [totalSum]*0.2; [totalSum]*0.21)

But only for 2 dates. Otherwise takes as reference only the first date. Dny

HI, Thanks a lot. It works fine. Daniel

Hi, I'm new on this forum and I'll appreciate your help. I have a table that looks like that: id transaction date a / -20 /01.01.06 a / 500 /01.01.06 a / 500 /01.01.06 a / 230 / 02.01.06 a / -160 / 02.01.06 b / -400 / 01.01.06 b / 450 /01.01.06 b /...

Hi, Anyone can tell me what cause the message "The search key was not found in any record" when I try to delete a record from my table? Appreciate your help. Dny

Hi, I have an Access Data Page located in the same dir with my database. Problem is simple: when I move or rename the directory, I can't open the page, cause the ConnectionString remain the same and if I try to open it into my db an Update Link is necessary. Any ideea to resolve this trugh...

Hi, Thanks. I receive a Error 3061 at code line Set rs = db.OpenRecordset("sel cmd", dbOpenDynaset) Dny

Hi, I'm new to this forum and I'll apreciate your help. What I want to do it's to make a string from several query records. ex: query FIELD1 FIELD2 VAL1-1 VAL2-1 VAL1-2 VAL2-2 VAL1-3 VAL2-3 I need FIELD2 as "VAL2-1, VAL2-2, VAL2-3" Thanks for your help. Dny