Search results for query: *

Hello all, I have a form with a subform(1) in single record view. In this subform(1) there is another subform(2) in datasheet view. On this subform(2) there is a button to tell the subform(2)to go to record "acfirst". When I'm for example on record 2 in subform(1) and I click the button I would...

Hello, I would like to create some kind of a grid look for the details section in a report. I want to do this by drawing some vertical and horizontal lines. This gives the nicest effect. It looks great, as long as the text boxes don't grow. When a text box grows, then the vertical lines ar too...

OK, I found the solution. Of course you should start the code as follows: For i = 1 To dataSuppliers.Recordset.RecordCount in stead of For i = 0 To dataSuppliers.Recordset.RecordCount - 1 0 is not a valid row in a grid. The first row is of course row 1 Perhaps this information is usefull for...

Perhaps I have already a part of the solution: Dim msg As String Dim i As Integer For i = 0 To dataSuppliers.Recordset.RecordCount - 1 If vbalGrid1.CellSelected(i, 3) Then msg = msg & vbalGrid1.CellText(i, 1) & "," End If Next i with the CellSelected method you can define if a cell...

Dear all, I would like to make a delete query, based on the multiple selections from a vbalgrid. I know a way to do this with a listbox: you just create an "IN-string". For example dim strIN as string dim i as integer For i = 0 To lstList1.ListCount - 1 If lstList1.Selected(i)...

Thank you LPlates The solution was to change the ".CreateReBar Me.hWnd" to ".CreatReBar Picture.hWnd" It works great. thanks again for your help. Dries

Hello, I have a rebar and toolbar from vbaccelerator on my MDI parent form. The problem is that the rebar and toolbar do not show when the form is loaded. On my child forms, there is no problem. On the child form you can place the rebar and toolbar directly on the form. On the MDI form, that is...

Hello Vladk Thank you very much for your help. I didn't know how to get the toolbar control. Thanks again, Dries

Hi, I have created a MDI form and a child form. Both have a menu, created with the menu editor. When I open the child form, the menu from the MDI form is replaced by the menu of the child form. That's ok. But is there a way to create a toolbar that is displayed at the header section or...

Hello, I have a form with a button and a progress bar. If I click the button, a report opens. As it takes a long time to format the report, I would like the progress bar to show me the % completed. Does anybody know how I should link the progress bar to the the formatting of the report? I...

Hello, Perhaps you can try this: If for example the name of your dcount field = txtDcount, then you would have to enter next string in the controle source item of the text box that has to show the value you want. = ([txtDcount]/Avg([txtDcount])) regards, Dries

Hello John, Thank you for your help, but I tried that already. It didn't work. I thought already the error had to be in the date/time criteria. But anyway, thanks to you it just came to me. I was looking at your syntax and I saw the problem. I use the European date notition as I'm living in...

Perhaps you can just write as a criteria for the transactions in your query: <(date()-180) This when you assume that a month has 30 days as an average, otherwise you will have to predefine the days in a month. regards, Dries

Hey, I have a dlookup function for an unbound textbox. Th problem is that the function doesn't return the correct value. This is my syntax: DLookUp(&quot;[Available]&quot;;&quot;tblPlanning&quot;;&quot;[Name] =&quot; & [txtName] & &quot; And [Date] =&quot; & [txtDate]) The controls...

Hello, I have a query that I want to filter with a criteria in a certain column. When I tell the qeury to get the criteria from a listbox in a form, that's no problem, as long as the listbox is not set to multiselect. If I change the listbox to multiselect, the output of the box is always 0. I...

Hello, I have a problem with a chart on a report. The report is based on a query. In this query there is a field called &quot;Product nr&quot;. This field is a group header in the report, so it groups data on each interval (every new product number). Together with each group I would like a...