Search results

Hello, I'd like to retrieve the number of records of a make_table query before executing the query. Kinda like manually opening the query in design mode and changing the view to dataview then just look at the total numbers of records. Anyone?

Hi, I want to iterate the collection "ItemsSelected" from listbox backwards, I want to do this because I want to delete the selected items. Like ya all know it gives problems while deleting the selected items if you iterate from start to end anyone?

Hello, I got a procedure (P) on my main form (A) which opens a form (B), on which the user fills in some textfields. When the user clicks "OK", I validate these fields in a procedure (O) on form (B) and then I wanna return a value to the procedure (P) on my main form (A) and execute the rest of...

omg i feel so ingnorant... thanx a million. I overlooked this property somehow

Hello, I just have a simple question: I want to open a excel file, select a sheet and activate it (give focus). The code beneath works but my excapp is hidden, can someone help me to show the app? Public Function p_OpenExcelFile(ByVal file As String, ByVal sheet As String) As Byte...

Already tried that, it does nothing. Originally it was a txtbox that I used as statusbar, here I got the same problem: it only showed the last text I set to the value property of the txtbox. So I think the problem are not the objects

I wrote some procedures which handles each a seperate unit. When a procedure finishes, I want to write an entry to listbox 'lbLogbook' so the users sees what's happening. But the entries in the listbox only appears when all the procedures are finished. When I go into break-mode and go...

But the pagebreak should appear dynamic. In fact the 2 last sections ('Product footer' & 'Customer footer') should be grouped with the 'Detail' section so the 2 footers appear on a new page only if they're grouped with (for example) 5 'Detail'-records.

Hello, I got a problem with grouping my data together: The footers of certain sections start at new a page. How can I group all my data together so that no footers will start at a new page? These are the sections I want to group (I don't want to group them on the same page but I just don't...

Hi, I got an excel workbook, containing a chart sheet and a data sheet. I want to save the excel workbook in my access db. When the users clicks a button to view the chart, I would open the excel workbook. I first thought to save the excel file as an OLE object in my table, but I read I got to...

Hello, I got a excel graph as an OLE object on my form, it's a column type graph. How can I show the datalabel (with the seriename and value) when I hover over a column (like in Excel)? thanx Johny

Nice to hear I could help someone out :) Does somebody know how I can get the x and y coordinate of the points on the series on a graph. Since the 'GetChartElement' function only works one way (knowing the x and y values you can look if there's a point on the graph) but now I want gather all...

I found it!! The unit of measure of the x and y values are in "twips" and the function works with pixels as unit. Googled and found a function to convert from twips to pixels at the MS site: http://support.microsoft.com/?kbid=210590 It works like a charm!

Don't know exactly what you mean. I already tried to set some breakpoints in the Ch_MouseDown event but the code nevers gets executed even when I click on the chart. Just did another example: dropped an "unbound object frame" on the form and pasted some dummy code in the mouse_down event of...

Found some code on the internet that could help me ' ** Class module named Class1 ** Public WithEvents Ch As Chart Dim IDNum As Long Dim a As Long Dim b As Long Private Sub Ch_MouseDown(ByVal Button As Long, ByVal Shift As Long, ByVal x As Long, ByVal y As Long) Dim Txt As String...

Hello, I got an Excel.Chart.8-class object on my form which uses a scatter-type graph to display the data. This works perfectly. Now what I want is a new feature, dunno if it can even be done: I want the user to make a selection of points in the graph with the mouse. Then, when the user clicks...

I want to import the data on the bookmarks into my Access table. The program works fine with Word 2003 but with word 97 installed, it complaines that the macro can't be launched because the document is protected. How do I solve this without unprotecting the sheet. I already tried to change the...

I was lookin' for a good book on VB.NET 2005 too a while ago. Somebody advised me to be a WROX-book. I did some months ago. And for me this book was more then enough. Very well explained and just what I needed. I had vb program experience and learned about oo programming in school, so I didn't...

I want to import the data on the bookmarks into my Access table. The program works fine with Word 2003 but with word 97 installed, it complaines that the macro can't be launched because the document is protected. How do I solve this without unprotecting the sheet. I already tried to change the...

Wow, this is great stuff. Exactly what I needed. Thanx alot for the tips shades!