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

As far as your autonumber sync issue is concerned, you should look into using a randomized autonumer as opposed to an incremented one. This should take care of your sync issue.

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

I'm confused. You have to be a little more specific. Which field is not bound? Do you have a field called FullName in your counselor's table? Where is the 'LastName + FirstName' value being stored? What does this mean: &quot;when I am flipping through the record the unbound field is blank...

Hmmm... Your question about why it takes longer for your form to open in design mode (now that you have split your project into a FE and BE) actually is not so bad. If you think about it, if your form is connected to a recordsource that lies in the BE, when the form is opened in design mode...

I see how you go about iterating through the array to delete each item in the array. I have no problem with that. My problem, however, is how to get those PrimaryKeys in the first place? Like I mentioned before, if I select several records from a Datasheet view, I have access to only one of...

Hey Henry, I had a similar problem myself. There are several ways of doing it, but here's how I suggest you handle it. You will need to use VBA to accomplish this, so I'm hoping you're familiar with this. 1. Go to the Form's Code section (View->Code). Under 'Option Compare Database'...

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