Recent content by AlanJordan

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

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

Thank you. Alan

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

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

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

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

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

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

Hi Lilliabeth, Thanks for your interest. Three. Alan

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

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.

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

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

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