Search results

Yuo can remove the record navigation buttons by opening your form in design view and goto properties of the form. Select the Record Navigation to False. About saving your data in a table - not sure I understand - thats what will happen if you add a button in design view, and choose what the...

I have a form that displays minutes. When the minutes are 9 or less it displays as, e.g. 9 instead of 09. How do I get that leading zero to display? I read in previous posts that one way was to format as text or date, but I don't want to do that bc the minutes are added up on form save/close...

Brilliant!!! :D :D :D

I want to use the Key Up event in a textbox to count the number of letters in the textbox. I cannot use SelLength as the text i not selected... It resets a label.caption next to the textbox to the number of letters in the textbox, as you're typing - or rather, it should :o

The "Left" instead of "Inner" was exactly what I needed - THANKS!! :) However, there can be several "dato" values for each "test_id" - I only want the largest one represented in the query... Now, if there are three entries in the "dato" field connected to the same "test_id", I get three...

Okay, browsed the forum, and I get that I must somehow Dim the table names in a function, but how do I call the function in a query?

Have this query: SELECT tbl_test_FA.test_id AS tbl_test_FA_test_id, tbl_test_FA.komp_omr, tbl_test_FA.emne, tbl_test_FA.underpkt, tbl_test_FA.metode, tbl_chk_FA.dato FROM tbl_test_FA INNER JOIN tbl_chk_FA ON tbl_test_FA.test_id = tbl_chk_FA.test_id; I want it to return a line for each and...

I'm new to queries as I have usually just put my criterias in the opening arguments of whatever form I was using. If I base a form on a query, and put additional openargs, what filter is applied first - the query or the openargs? Thanx :) Steff

Table: Adresseliste: adres prefix 1 one.. 2 two.. 3 three.. 4 ... Table: Tabel1: adres status 1 45 1 34 1 3 1 16 2 4 2 78 .. I use this query: SELECT Adresseliste.adres, Adresseliste.prefix, Tabel1.status FROM Adresseliste INNER JOIN Tabel1 ON Adresseliste.adres=Tabel1.adres WHERE [status] =...

Right, so I tried changing the label to a textbox, but problem persists... The OnCurrent event for what object? The textbox/label? Thanks!!! :D

I have a table and a form with continuous records (218 items). In a different table I have the status of these 218 items. In design view of the form I have added a label at the end of the record. I want to use the DMax to set the caption of that label to the status of the particular item, but...