Recent content by klasse

Hi Katerine, I'll do what you propose. It is a solution in any case. Thanks for your answer, Klasse

Hi, I have a button on the menu (copied from the default menu) to compact the database. I would like it to run some routines or functions before it actually tries to compact the database, how could I do it? Thanks, Klasse

Many thanks to the two of you, I will try both solutions. Klasse

Hi, Is there any function with which I could get the last day of the month in the format 31/01/02 (for this month for example)? Or at least, a function to get the number of days of this month ? Thanks, Klasse

I would try including WITH recordset as follows: Set rst = db.OpenRecordset("SELECT * FROM [qryCompTestWrongAnswer]") WITH rst Set rst1 = db.OpenRecordset("tblTemp") WITH rst1     rst.MoveFirst   rst1.AddNew     rst1!Question = "1. ....."     rst1!Category...

Hi, I would do: if myrecordsetname.recordcount = 0 then exit sub yourrecordset.recordcount will give you the number of records in the recordset. Rgds, Klasse

Hi, I have two lists and three boxes with items. On the afterUpdate event of one list (list2) I have: For i = 0 To lists1.ListCount If list1.ItemData(i) = list2.Column(1) Then list1.Selected(i) = True Exit Sub End If Next i That is, I go through each row of list1, compare it to...

Hello, I have a recordset with which I get values of a table (customer address, city, country) and then I want to put it into a textbox, everything into one. I tried to do something like txtbox =!CUST_ADDRESS & CHR(13) & !CUST_CITY But this wouldn't work. It displays the address, then a...

Hi, How can I add from code, a new control in the default menu bar of Access? Thanks, Klasse

Hello, I have a form from which users will operate and open new forms. I would like to keep this one opened in a corner of the screen, on the top left corner, so I will open the other forms on the rest of the screen. How can I having the main form initially on the center, position it to the...

Hi, I am trying to design a form similar to a tree structure. Then I have My Database |_products |_provider I want to click on products and I should have My Database |_products | | | |_add new product | |_edit a product | |_view all products | |_provider Now...

Hi, Maybe this helps. Name of Popup form = Form1 Var in Form1 = var1 Name of second form = Form2 Var in Form2 = var2 In Form2, write: var2 = Forms!Form1!var1 or var2 = Forms!Form1!.var1 try both. You will need Form1 to be opened at the time when the code is executed. Later you can close...

Hi, I would do something like Dim MyRST, MyRST1 as recordset set MyRST = currentdb.openrecordset("SELECT (FIELD) FROM TABLE1 WHERE (FIELD)= " & yourvalue,dbopentable) with MyRST if MyRST.recordcount=0 then set MyRST1 = Currentdb.openrecordset("SELECT (FIELD) FROM TABLE2 WHERE...

Why don't u try? Dim trs AS DAO.Recordset instead of trs AS DAO.Recordset

Hello, Situation: I have a table that is created when the user wants to open a graph, and it is deleted when the user closes such graph. I read data (dates, eg. 30/10/01) from a txt file into an array. My array has two columns, one the dates and the other a sum of the coincidences of the month...