Search results for query: *

I have the following XML schema: <xs:schema id=&quot;NewDataSet&quot;> <xs:element name=&quot;NewDataSet&quot; msdata:IsDataSet=&quot;true&quot;> <xs:complexType> <xs:choice maxOccurs=&quot;unbounded&quot;> <xs:element name=&quot;tblCostData&quot;> <xs:complexType>...

Every time I have Enterprise Manager auto-generate a Script for one of the databases, it always places an 'N' in front of some the object names: Eg.: Here's a sample piece. exec sp_dboption N'Northwind', N'auto update statistics', N'true' GO if exists (select * from dbo.sysobjects where id =...

1)What’s the benefit to retrieving records from two or more tables by using JOIN statements as opposed to just listing the tables, and then providing the search keys in the WHERE clause? I.e.: SELECT E.Name, A.Address FROM Employees AS E INNER JOIN Adresses AS A ON (E.EmployeeID =...

Hello, I'm using the image list control in conjunction with the tree view control in an Access 2000 DB. The problem is that the images i've included in the image list control (of type .ico) are being displayed with their colors distorted. For example, one icon is purple, but shows up gray in...

I have a text box that is meant for only numerical data. The problem was, how to enforce this. Well, I accomplished this by using its keypress event, and allowing only certain keys to be processed in the text box. However, I found that if I copy textual information from another location, and...

How can I obtain from Accesss whether the current record on a form is locked or not? BackGround: I designed a form that allows a user to edit the data in a particular table, with the form's RecordLocks property set to 'Edited Record'. The database that contains this form will be placed within...

I recently had a database returned to me from one of my users where, upon opening it, it gave me the message: &quot;Urecognized database format &quot;[Path of database]&quot; I tried using the &quot;/compact&quot; switch to compact and repair the DB, but it gave me the same result. Any ideas...

Just wanted to know, has anybody ever had any problems linking to an Excel file through Access 2000? The reason I ask is that I can't seem to get that to work. I run through all the steps of linking, however, once I hit ok in the dialogue box, nothing happens. No error, no nothing. I can...

Using Microsoft Access 97, I would like to create a custom delete button that will delete a set of records that was selected by the user. To do this, the user would open a form, in Datasheet view, use the record selector along the left side to choose the records they want deleted (by...