Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: AlanJordan
  • Content: Threads
  • Order by date
  1. AlanJordan

    Subquery (Correlated) Syntax

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

    Single value binding to Access

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

    Data Reader Loop Issue

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

    Study Aid for VB6

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

    Should I be using a subreport?

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

    Data inSubreport only shows first contact

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

    Percentage of Total

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

    Locking Layers

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

    Protect CD from Duplication

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

    Print data in subforms as well as forms.

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

    Switchboard Manager out of Sync with Switchboard Items Table

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

    Error 3464 Data type mismatch in criteria expression

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

    QDI Function (Quick Date Info )

    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, _...
  14. AlanJordan

    Automate Generic Conversion of SQL

    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," & _...
  15. AlanJordan

    Keeping track of code snippets that need revision

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

    Coercion of double

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

    Pass Control

    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)...
  18. AlanJordan

    Change ZOrder of text boxes that show through tab controls

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

    Lots of interesting code may be found here

    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 +...
  20. AlanJordan

    Properly position tab control

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

Part and Inventory Search

Back
Top