Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DriesG

    Problem gotorecord in subform

    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...
  2. DriesG

    Create a "look-a-like" grid in details section

    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...
  3. DriesG

    Selections in a grid

    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...
  4. DriesG

    Selections in a grid

    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...
  5. DriesG

    Selections in a grid

    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)...
  6. DriesG

    Toolbar and rebar vbaccelerator on MDI form don't show

    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
  7. DriesG

    Toolbar and rebar vbaccelerator on MDI form don't show

    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...
  8. DriesG

    Create toolbar for form

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

    Create toolbar for form

    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...
  10. DriesG

    While opening a report: show progress bar

    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...
  11. DriesG

    DIVISION

    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
  12. DriesG

    dlookup with multiple criteria

    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...
  13. DriesG

    Customers who have not had transactions...

    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
  14. DriesG

    dlookup with multiple criteria

    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...
  15. DriesG

    Criteria for query from selections out of mutiple listbox

    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...
  16. DriesG

    Problem with linked chart to report header

    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...

Part and Inventory Search

Back
Top