Search results

Is it possible to make a query that returns a field as an accumulated value of the previous posts, plus whatever value is saved in the post itself? The table holds a date field and the value. I want the query to return the result sorted by date like so: Date, value, totalvalue 12/03/2005, 1...

ghudson, thanx for your help. yeah - I noticed you can't set focus to an invisible object.... No use wasting more time here - I'll go with the tbHidden approach. I should have guessed... :o Good illustration! Thanks for all your help!

Hmm... neat! But still I consider it a plan B, to insert a small hidden text box to shift the focus to - not so pretty, but it gets the job done. Of course I must remember to remove it from the tab list... Maybe that'll be my final option... Btw, did you think about the possibility that the...

To be honest, it's actually a label with underlined text that says "save".... save To give it a html feel to it... I have put the "disable text boxes" in the click event of the label. Since one of the text boxes always has focus after the edit, I can't disable them as long as the cursor is...

I have a bunch of text boxes that are only enabled after clicking an "edit" button. I want to disable them again when I click another button, "save", but I can't, since one of the objects now has focus... Where do I "throw" the focus, so I can disable the text boxes again?

Worked it out: Me.[mysubform].ObjectSource = "frmMyNewForm" Will change the source of the subform to "frmMyNewForm". However, it will only work if the object that has this event is not placed on the subform itself. Does anyone know why??? I assume it's got something to do with...

Works great! Thanx! But how do I change the source of the subform window on my tab ctrl page? Is there any way to change what form is displayed as subform on my page?

Tab control - how to add/change subforms? I have been trying to figure out how the tab control works on a form... So far, not at all... :rolleyes: How do I display another form as a subform on one of the pages on the tab control? I can't seem to find anything in the toolbox to add to the...

Is it possible to make an iif in a SQL sentence that checks if a record with two given values exist? What does the... uh.. "exist-function" look like? I know the below will probably NOT work... :rolleyes: I want to do something like Iif(EXIST([table].[field]=criteria),1,0)

These give the same result: WHERE [tbl_chk_FA].[klcv_nr] = fWin2KUserName() or [tbl_chk_FA].[klcv_nr] = "" and WHERE [tbl_chk_FA].[klcv_nr] = fWin2KUserName() or fWin2KUserName() = "" :confused: tbl_test_FA values are still left out, if there are no tbl_chk_fa entry for it...

Okay, I put in the "" beacuse I also wanted to get all the records from the table, tbl_test_Fa, even where there where no corresponding [klcv_nr] & [dato] in the table tbl_chk_FA. Now I only get the post if there's a corresponding entry in tbl_chk_FA. tbl_test_FA holds all the tests a given...

This query is almost working... :) Only it doesnt seem to care about the "WHERE"... I also get posts where [klcv_nr] is NOT fWin2KUserName() or ""... What's up?!? SELECT DISTINCTROW [tbl_chk_FA].[klcv_nr], [tbl_test_FA].[test_id], [tbl_test_FA].[komp_omr], [tbl_test_FA].[emne]...

QueryDef pointed me in the right direction - thanks :) However, when I dim db as DAO.Recordset I get that error 'not defined'... I know I have to refer to uh.. something but what/how/when/where :confused:

Okay. Do I do this in the form load event, or in a button? Can it be done like so: Let's say i have a button: When it is clicked I: define the vars create a sql based on the vars open the form in which the data should be presented -or is it usually done in another way?

Works perfectly! How do I do the same with the the table names? i.e. dim the table name in a function, and put it after SELECT.. Lets say the function is tblname()... Will "SELECT tblname().[this_field]..." work?

I have a function fWin2KUserName() that dims strUserName. Can I (and how) use that in a SQL sentence like; WHERE [klcv_nr]=strUserName???

Brilliant! Works perfectly :) Thanks

I'd put a hidden txtbox on the form - then make a button that adds a record. Put txtbox.value to calendarobj.value along with the add record code from the button in the calendar objects click-event in the VBA editor (alt+F11 is it?). @ ansentry Can't blaim them - it's friggin snowing here, and...

Where does the problem lie? Pulling data form the hidden form, or looking up the record once you have retrieved data from the hidden form? (did you remember to set focus back to the right form after gettign data from the hidden one :) )

That many tables would make your database go slow-mo :( You want a lot of records- not tables.