Search results for query: *

Hi My package runs fine, exporting 4 SQL views and 1 Access 97 query into 5 tabs in a destination Excel file. However when I run at again the new data is simply appended onto the end of the existing data. I need to make it so that every time the package runs the Excel sheet only has the...

Hi This is driving me crazy - I have a DataBound combobox populated as follows: cmbWeather.DataSource = MyDataObject.PopulateWeather 'databind to datatable cmbWeather.ValueMember = "ID" cmbWeather.DisplayMember = "Value" Using the value of the combobox I populate the ID value into SQL Server...

I'm trying to event handle the columnchanging event in a table bound to a datagrid. One of the columns in the grid is a comboboxcolumn I got from the web - it displays fine, the valuemember and displaymember are set but when I leave the comboboxcolumn after selecting a column the value left in...

Simple question but driving me a little insane... How do I set a combobox to a given value in the "ValueMember" field? ie integer value stored in a database, the combobox would display the relevant "DisplayMember" value. I've looked at the findstringexact method but that searches the...

I have a datagrid bound to a datatable but on entering a new row all the columns display (null). I have a dataadapter with select and insert commands to display and insert relevant data. Is there a way to avoid this? On a more general note is it considered best practice to insert data in this...

Please please could someone help me open the common dialog box (to either open or save a file) - but instead of the file being opened or saved I wish to return the file path selected to a text box control on an evb form... I know I have to use GetOpenFilePath and OPENFILEPATH in some way but...

Hi all I am trying to write a custom toolbar button in Outlook (or something similar) that will export calendar entries for a given time period into a SQL server table. I originally wanted to do this from a web environment but this was proving problematic due to user permission issues. Cheers...

Thanks xlbo That's exactly what I wanted. I think everyone else was under the impression I was looking for a set string, rather than trying to return the string from within the brackets. MWR

Hi all I would appreciate some help in returning the location within a string of both ( and ), which ultimately will help me write a procedure around the Mid function to return the value between the brackets. So basically I need the position within a string of the first instance of a certain...

Solved Amended Skips code having stolen code recorded in a Macro.... Dim r As Integer Dim mycapture As String r = 1 On Error Resume Next For Each Sht In ActiveSheet.Shapes With Sht.Select mycapture = Selection.Characters.Text...

There is some confusion here I think in the definition of text box!! The sheet I've inherited has lots of text boxes drawn from the drawing toolbar, as opposed to from the control toolbox as with combo boxes etc. The main issue with this is I can't reference the boxes to obtain the text - even...

Thanks for that but still no joy. I'm using Excel 2000, and have searched through object browser for DrawingObject but no joy. Do you have different classes to me? Also what do I need to decare Sht as? Finally there are lines and ovals on the sheet too but I should be able to error handle...

On a sheet.....

I want to grab the text from numerous text boxes within excel and insert it into sequential cells. My first issue is that I can't reference any of the text boxes as I don't know their name property - when I right click on the object there is no properties menu as with combo boxes etc. Any...

Hi all I'm gettting a Write Conflict error from Access when closing a form. Basically I wrote a function which populates a Yes/No field when any field in the record is updated, using the code: Public Function ModifyCC() Dim MySQL As String Dim MyDB As Database Set MyDB = CurrentDb...

Thanks for that but the 4 queries come from different tables that I would like to put into the same speadsheet in 4 different tabs. A union query would just put all the data into 1 set of results.

I'm trying to output the contents of 4 queries into one spreadsheet. At the moment I have to do this 4 times into 4 different sheets, which is impractical. I would like like the spreadsheet to have 4 worksheets/tabs, 1 for each query. The code I'm using is: DoCmd.OutputTo acOutputQuery, qry1...

I'm a bit of a newbie with regards to excel vba, what I want to do is to run a piece of code when a certain cell is clicked(thats it!) , but I can't for the life of me figure it out!!! Sorry, I must be having a bad day.... Matt

Cheers Phil I reckon you could be right - the problem user has a version of sqlsvr32.dll dated 08/04/98 but another user has the same file dated 2001. I tried to copy the newer file directly into the winnt\system32 folder but this did'nt work (can't connect to SQL server at all) - I'm wondering...

I am administering an access front end database with SQL Server 7.0 handling the data. I have a problem user who is connecting to same data in the same way as everyone else and has the exact same front end as everyone else too but when they try to enter more than 256 characters into a 5000...