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

  1. navigator703

    Min Date with a twist

    Hey Folks- I have a query here where I am looking for the first time a property has gone active. The twist is that I only want properties where they have gone active in last 18 months [July 2006]. I am have been looking for a while in other posts for another topic like mine, but nothing is...
  2. navigator703

    The ability to paste records is gone?

    Good Afternoon- I am working with a couple of tables that I need to paste data into. When I actually try to paste the data into the table, the normal empty row at the bottom of the table is gone. This limits my ability to paste records into the table from my excel spreadsheet. This feature...
  3. navigator703

    Select statement and column listing

    I have been searching the normal sites [will remain nameless], but I should have tried here first. Ugh how we realize the best answer is the first answer. I have run the normal search, but haven't found anything near to my question in the forums. Anyway, for general knowledge purposes how...
  4. navigator703

    Simple Update with a Sum statement

    Good Afternoon I have a simple update statement with a sum that should happen in access. I used the design view to come up with this SQL statement. But I am using Access to update the table. The following is the code: UPDATE dbo_T_OCCPT INNER JOIN [TBL_Phase II Master - v2 JANITOR] ON...
  5. navigator703

    Sub-selects with a having clause

    Happy New Year, I am working on a subselect query with a having statement at the end. The having statement will eliminate all differences that are not zero. I only want to see where the differences are not zero. This will hopefull reduce the amount of results. SELECT P.PRPTY_ID...
  6. navigator703

    Find tenants with middle of the month rents

    Good afternoon all- In this SQL code, we are looking for tenants with split month rents. We are working on trying to fix this rent problem to where it matches for the end of the month like normal rents do, but in the meanwhile, we need a list in order to fix them in the future. Right now this...
  7. navigator703

    DAO::Open a Connection Problem

    I am still quite new to VB and databases. Well a buddy of mine is having problems with his DAO connection to an Access database. Since I have no clue about DAO, I have turned here. I have also looked at connectionstrings.com, but I didn't find anything with DAO connections. Any suggestions...
  8. navigator703

    VB Forms & 1 Access Table Search w/ 1 recordset return

    Good Morning- I am new to VB and VB Forms. I am still in the learning phase. I have searched these forums, connectionstrings.com, even ask.com. I'm getting a little confused with all the information. I will make this quick and simple: 1) I have one access table 2) I am using a VB form to...

Part and Inventory Search

Back
Top