Search results

Hello, I got an unbound OLE object on my access form that holds the excel sheet. The unbound object is disabled and locked so the user can not click in it (otherwise the menu's of Excel appear) Now.. when I paste data onto the sheet through code, sometimes the object isn't big enough to display...

When the user clicks an item in my custom toolbar, which event does he trigger? How can I capture which item he selected ?

I got an MS Access 2003 db which I think has an general option disbabled or so dnno, here's the case: When I create a query, and choose to close the query (just be clicking the "X" button at the top), Access doesn't ask me to save the query or not.. it directly displays the box to fill in the...

I got an existing querydef and a recordset. I want to set the source of the querydef to the recordset. How do I do this? It must be something simple I overlooked. Isn't there a SQL() function on the recordset obj like on the querydef obj?

For now I have 20 comboboxes on my form each bound to a field from my sourcetable. Since ya can only choose 1 value in a combobox, the users want to to choose multiple values in each box. How should I implement this? I can't use 20 listboxes because I haven't got any free space left on my form...

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

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

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

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

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

Can somebody give an excel newbie some tips how to work structured and organized because I am making a tool for my company and it's lookin' more and more like a spaghetty-bord. I am used to program in access where everything seems so organized, now I make calculation in different places of my...

I want to import data from Word docs into Access. Each word doc is created from a template. So each doc has the same layout. I searched this forum and found a way to import data with the bookmark property. This works perfectly when I add the bookmarks after the doc is created. But when I create...

I need some advice on this, here is the situation: I got 2 listboxes where only 1 can be shown. I got to ask 2 questions to the user: 2 sided? -> NO ==> Show lisbox 1 -> YES -> Specific combination? -> NO ==> Show listbox 1 | YES -> Show listbox 2 How should I implement this? I was thinking...

Hi, I am making a simple searchform for my moviecollection, I thought by selecting an item in the resultlistbox, I'd show all the relevant info of the selected movie in the ControlTipText property of the listbox. But ms access tells me my value is too long. Isn't there a simple alternative...