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 derfloh 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: *

  1. AlanJordan

    Subquery (Correlated) Syntax

    Excellent. :-D Thank you. I never thought of using the IsNull([No of Complaints],0) function. In fact, I didn't know it existed. It reminds me of the IIF function in VB and Access. BTW, Could you tell me when it would be appropriate to use a WHERE clause for a subquery? Here is the final...
  2. 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...
  3. AlanJordan

    Single value binding to Access

    Thank you. Alan
  4. 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...
  5. AlanJordan

    Data Reader Loop Issue

    Yes. That worked. Do you think my main problem was that I was not using the right syntax, as shown below: MyDataReader.Item("ProductName")) Or, do you think it was because I declared the connection in the Partial Class, as opposed to in the subroutine? Thanks, Alan
  6. 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...
  7. AlanJordan

    Study Aid for VB6

    Bob, Thanks for your insights. I'll review the Microsoft documentation later, but it's been my experience from long ago that this documentation left something to be desired. I'm looking for a way to quickly test my knowledge and pinpoint areas of weakness (which unfortunately are probably...
  8. 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...
  9. AlanJordan

    Should I be using a subreport?

    Correction: There are three entries in the Contacts table that are populated with a WillCallBackDate. When I do a manual check to find the entry in the Companies table, there are not there. That is, of course, why the query returns no results. It turns out that this database links...
  10. AlanJordan

    Should I be using a subreport?

    Hi Lilliabeth, Thanks for your interest. Three. Alan
  11. 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...
  12. AlanJordan

    Data inSubreport only shows first contact

    They are reports. My mistake. Thank you. Yes, when took out the reference to contacts in the main report's SQL that seemed to do the trick. Thank you.
  13. AlanJordan

    Data inSubreport only shows first contact

    Thank you for your response. Here is the SQL for the record source for Companies, the parent form. SELECT Contacts.DateUpdated, Contacts.DateUpdated, Companies.CompanyID, Companies.Company, Companies.Category, Companies.Address, Companies.City, Companies.State, Companies.Zip, Companies.Phone...
  14. 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...
  15. AlanJordan

    Access Report Coding

    Hi Michael, I had a thought, and though your issue seems to be fixed, I thought that I'd mention it: There are times when Access gets confused if you accept the default naming conventions for controls. As long as you don't write any VBA code, there is not much of a problem, but if you do any...
  16. AlanJordan

    Percentage of Total

    Okay. I'll leave it in for a while, then I'll delete it. Thanks again. Alan
  17. AlanJordan

    Percentage of Total

    It's funny. How I read UNusual for "usual" even though you underlined it. My apologies. Do you feel I should remove the database from the link? Thanks for all of your help. Alan
  18. AlanJordan

    Access Report Coding

    Try this. I'm not sure what you mean by "I'm having trouble with the IsNull command." Also, I'm not sure if you like the logic that I inserted. Perhaps this suggestion will help. Dim strValue1 Dim strValue2 strValue1 = Me.Text71 strValue2 = Me.Text71a If not IsNull(me.Text71) then If...
  19. AlanJordan

    Percentage of Total

    I cannot find the directions for uploading a database. How do I do this?
  20. AlanJordan

    Navigation buttons show "can't go to specified record"

    Hi, There may be more than one way, but this is how I do it: 1. Highlight your subreport or subform control. 2.Open the Properties box. Click on the "Data" tab. 3. Change the settings in the Link Child Fields and Link Master Fields properties. Regards, Alan

Part and Inventory Search

Back
Top