Search results for 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?

Can you create a password for the backend only?

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

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

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

How do I remove this page1 on my screen?

I have code that finds the correct string in my find button, but how do i code to search for the next occurance. For e.g. I can not believe that you can If I hit the find button it will highlight the first occurence of can, but if I hit the find next it will hightlight the next occurence...

I'm using VB.Net 2003, but SelLength is not an option on my intellisense, but SelectionLength is an option. What is the difference?

I am programming a simple word processor. How do you highlight the text after the word search? Here is my code: Dim Target As String Dim FoundPos As Single Private Sub btnFind_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnFind.Click FoundPos...

I am trying to write code for when a user begins entering text in a multiline textbox and the textbox loses focus a message bos will prompt the user asking if they want to save or discard the text they recently entered. I thought there was an event KeyPress and Leave, but when I code the...

Does anyone have any good resources regarding coding CollapsiblePanels in VB?

I am new to VB.net, but I do know the basic. I have a program where the front-end is in VB and the backend an Access database. I made the necessary change, but when I try to compile the program I get the following error: Type 'CollapsiblePanel.CollapseGroupBox' is not defined. sub 'Dispose'...

I am new to VB.net, and the programmer before me coded an application with collapsible panes. I need to make changes to a form, but when I try to compile I receive build errors. The executable file runs fine. Can anyone tell me why this doesn't compile, but when I run the application it...

I'm using Access 2000. If there is a SSN in the ORDERS table that is not in the CUSTOMER table I want to build a query that would return those values. Can this be done?

Can you take the AVG of a Date column

I HAVE A ORDERS TABLE WITH SSN, DATE, CANCELED My code is SELECT DISTINCT tblOrders.SSN FROM tblOrders GROUP BY tblOrders.SSN, tblOrders.Date, tblOrders.Canceled HAVING (((tblOrders.Date) Between [Forms]![frmReportDialog]![StartDate] And [Forms]![frmReportDialog]![EndDate]) AND...

I have a combo box, that if a user types in SSN then it goes to that record, here is the code Private Sub cmbSSN_AfterUpdate() ' Find the record that matches the control. Dim rs As DAO.Recordset Set rs = Me.RecordsetClone rs.FindFirst "[SSN] = '" & Me![cmbSSN] & "'" If Not...

I have the following code: Private Sub QuickFind_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[SortName] = '" & Me![QuickFind] & "'" If Not rs.EOF Then Me.Bookmark = rs.Bookmark Me!QuickFind.Value = ""...

I have a tabcontrol with 2 pages, BillTo and ShipTo On each page there is a CheckAddress Button that looks at the address and assigns 4 digit post code and county. Problem is when I click the button nothing happens, but if I go to other page and back, then it works. What is going on?