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

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

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

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

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

Hi Sorry to be vague in the subject - quite difficult to word this one! I have 2 tables in my db, & I need a piece of code to search in the field Subject in tblImportMessages for a unique value (NewEmployeeID) that has been embedded earlier , then to turn a yes/no field to yes in the...

Hi I've got my Access DB sending out mail with voting buttons through vba, but need to store the responses in a table. Has anyone done this, indeed is it possible? I would appreciate any advice anyone may have. Thanks Matt

Hi I know how to send an automated mail on event, but need to include 'Voting Buttons' (included in the options menu in Outlook when composing new messages). Is this possible - has anyone done this before? TIA Matt

Using the code: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "tblTrade", "C:\internal.xls", True I wish to export all data from tblTrade in Access 97 to Excel 2000, but I am geting the following error: Table 'tblTrade' already exists. (Error 3010) Any...