Search results for query: *

I have this query, which works: SELECT [Station Number] AS Station_Number, [Station Name] AS Station_Name, [Station City] FROM Stations I want to add the count of the number of records in another table to the query. This SQL works for that purpose: SELECT COUNT(ComplaintNumber) AS [No Of...

I'm new to ASP.Net 2.0. In fact, this is my first ASP.net application. I've created an Access .mdb file and I've set up a connection. I can use a data reader to write out the data. Thank you CA8MSM. Now, I'm trying to create a series of text boxes and bind them to the Access database. I...

Hello, I do not understand why the following code places me into a endless loop. I've read a number of posts on the subject, and have tried different approaches. Here are the declarations: Partial Class _Default Inherits System.Web.UI.Page Dim strResultsHolder As String Dim...

Hello, I have a job interview this Thursday. I'm particularly interested in this job because it involves VB6 and will also provide a platform for learning .Net. The hiring manager has said, "Be ready to answer technical questions regarding VB6 programming, including use of ADO, XML, control...

I have a data entry form Companies, with a subform Contacts. In the subform I have a place for each contact name. I also have a field MayCallBack, into which a date is entered. I am able to generate a report with this SQL: SELECT Contacts.LastName, Contacts.FirstName, Contacts.Phone...

I have a database with the tables Companies and Contacts (1 to many relationship between these.) I have a report that I built that provides all of the information needed, but ONLY for the first contact. I've tried creating a subreport and linking the two by CompanyID. I still get only one...

I have a report that uses groups to create subtotals of each group. At the end of the report, I have a grand total. I want to calculate the percentage of each subtotal of the grand total. I tried the following code, which fails because Access will not allow me to set the focus and it will not...

Hello, Can anyone tell me how to lock a layer in it's position? I have a large graphic. On top of this graphic, I want to place several layers. The layers look fine as long as someone opens up their web brower to the exact same size. In reading Chapter 6 of Ten Ton Dreameaver, I am...

Is there a good way to protect a CD from duplication? I have a CD that has much html content. It is not compiled, and can easily be duplicated. (Note: A similar question was posed under the title Protecting Code. FNeily responded, but I did not see the response. I had included my phone...

I have a form with six subforms. If I use the Docmd.PrintOut command, then the form prints, but the subforms are blank. What's the best way to print the data on the form and subforms? Thanks, Alan

I find that my Switchboard Manager no longer reflects the items in the Switchboard Items table. I am able to make changes to the switchboard by editing the table directly. Can anyone suggest a way of getting the manager back in sync with the Switchboard Items table? Alan

Can anyone tell me why this code is suddenly producing a 3464 error? "Data type mismatch in criteria experession." I have changed the data, so that might be causing the problem. Do you think it is trying to coerce a vbnullstring into a double and having trouble. If so, what should I do to...

How many times have you stopped what you were doing to find out what day of the week (or weeknumber) that a particular date is associated? I finally got tired of it, and wrote this function. I hope you enjoy it. Function QDI(DateToReturn As Date, Optional strFormatDesired As String, _...

Does anyone know of a way to develop a query in Access, and then change the SQL of the query so that it includes variables. The result would be a SQL statement like this: qdfText = "SELECT KKLogin2Justifications.KKLoginID, KKLogin2Justifications.DateAdj, KKLogin2Justifications.Reason," & _...

This technique is so simple that I hesitate to share it with people, but I use it everyday. Perhaps you'll find it useful. When I am copying-and-pasting code, I start put a '@ before the block of code and an '@@ after the block of code. Example: Sub ShowEmployeeNumber() 'Show employee...

Can anyone explain to me why the code that specifically creates a variable for each of the items properly adds data, but the commented out code does not? I think it has to do with coercion of the data type, but I would expect that converting the contents of each of text boxes to a double would...

As I increase the number of text boxes that I have on a form, it becomes obvious to me that code like this for each text box is inefficient. With Me("txtNonSchHours" & i) .Value = "" .Format = "Fixed" .DecimalPlaces = 2 End With With Me("txtCode" & i)...

I sometimes place a tab control on top of many other controls and place a combo box and password box on the control, along with instructions to log into that page. After a successful login, the tab control is made invisible, exposing the controls underneath it. However, there are times when...

Lots of interesting code may be found here: Alan http://www.lebans.com/toc.htm # Files * Forms o Select A Row Page + DownloadFiles/SetGetScrollbars.zip + DownloadFiles/SelectARow.zip o Magnify +...

I have a page that is filled with controls. I want to prevent a user from using them until they select their name from a combo box and enter a password. I decided to place a tab control over the controls and make the tab control invisible when a user takes the above actions. This works...