Search results for query: *

I'm sorry, I have a table with several columns of boolean datatype, true/false. I need a query that will display the column name when it's value is true. column1 column2 column3 true false false I would like to have column 1 showing as a result of the query.

Is there a SQL query that allows you to query a table and return the column name if the value of the column is true?

Remou & dhookom You are so AWESOME!!! It is working perfectly. Thanks for all your help.

I'll try this and see what happens

Yes, all the tables are in the be and the links are only in the fe. The fe is on another server, I thought it would be easy for each user to access on the other server rather than have a copy locally. Is this correct?

So I should create the password before I split the database? When you say use it before, what do you mean?

I linked the tables from the fe to the be, but two users are still unable to open the database simultaneously

I created the database and then made a backup copy. I have been experimenting with thd backup copy. The fe tables are imported from the origiinal database. Should i have imported in the backend and linked the front end to those tables?

Can you create a password for the backend only?

Yes, each user has the ability to read write update on both servers. But when one has the database open, and another tires to open nothing happens. No error messages, nothing.

I checked when I open there is a ldb file, but when another user clicks nothing happens. The tables aren't linked, but I imported. Would this make a difference?

Remou, Long time no hear from. The be is on a server that everyone has access to.

I have a database that is split fe/be. the front end is on one server while the be is on another server. When a user opens the fe, no one else is able to access the database. Open in share mode is selected, there is no row-level locking and I have given each user full control permissions and...

Public Sub New(ByVal tmpDS As RAMs) MyBase.New() 'This call is required by the Windows Form Designer. InitializeComponent() 'Add any initialization after the InitializeComponent() call RaMs1.Merge(tmpDS) clsRAMType = New RAMType...

Sorry, I've been debugging for 5.5 hours a little brain drained. Public Sub New(ByVal tmpDS As RAMs) MyBase.New() 'This call is required by the Windows Form Designer. InitializeComponent() 'Add any initialization after the InitializeComponent() call...

I recently had to delete a reference and add it back to my project. Before this the project ran perfectly, but now the collapsible pain will not load on one form and on the other it won't compile saying that my object reference is not set. Any ideas as to how to fix this and what exactly...

Is there a checkbox datatype for excel? I exported the table from access to excel, i need the field to show as a textbox in excel

I exported a table into worksheet. I had a column with a datatype of checkbox, but when I exported it converted to true/false. In excel 2003 can you have a column of checkboxes

I'm using Word 2003. When I insert Document 2 into Document 1, not all of my page is showing.

I have a Word document, lets call it MyOriginal and I want to add several Word documents to MyOriginal. When I try to insert the margins are all off. Is there a way to add Word documents to MyOriginal and keep their same look?