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!

Recent content by LebronJames

  1. LebronJames

    #error displaying in Report Footer

    I placed this in the Report Footer : =Sum(Nz([Totals])) If there is no records then the #error appears.
  2. LebronJames

    #error displaying in Report Footer

    I have the total placed in the report footer. If the there is a value then the value will appear but if there is a null value #error is displayed. Anyway to get around this?
  3. LebronJames

    display vbscript varaible in html

    Using VBSCRIPT how can I add the value of my variable (var1) to the html page?
  4. LebronJames

    Array value in a field

    I am importing an array field into a field within my access database. The field value will show like this: Vermont, New York Dallas, Texas Is there a way to say take the values before and after the comma and place them into seperate fields so it shows like this: Field1...
  5. LebronJames

    DateAdd including 1st of following month

    Thanks PHV the first day of the month no longer appears!! Thanks
  6. LebronJames

    Split values in cell D onto next line????

    My Excel spreadsheet is setup like this: Cell A Cell B Cell C Cell D John Smith Yes Alberta,Ontario,Quebec How can I code it so that I can turn that into this: Cell A Cell B Cell C Cell D John Smith Yes Alberta John Smith Yes...
  7. LebronJames

    DateAdd including 1st of following month

    It worked... how can I say give me the records for this month... How can I say give me records for the year up to today
  8. LebronJames

    DateAdd including 1st of following month

    I have a datetime field where I want take the lastfullmonth... ONLY problem is I am getting the first of the current month as well.. Here is what I am using in the criteria field: >=DateAdd("m",-1,Date()) This displays all of October but also giving me the first of Nov... WHY???????
  9. LebronJames

    Max Records - Append Query

    Problem is the unique field is blank or null... removed the blank or null value and append worked....
  10. LebronJames

    Problems with Append Query

    Problem is the unique field is blank or null... removed the blank or null value and append worked....
  11. LebronJames

    Max Records - Append Query

    Yes I have a temp table (table2) setup identical to table1. Where the data in table2 is not found in table1 append.... this works on smaller tables but if larger than 150000 it does not work. There must be someowhere the max records can be changed..
  12. LebronJames

    Problems with Append Query

    When I use an append query on a table of 1000 records, the new fields are added ok. When I use the same append query in table of 300000. Not all the records are brought over. I am using Access 2000. Is there an option in Access that allows me to change the Deafult Max records. Or can I program...
  13. LebronJames

    Max Records - Append Query

    Here is the query I am using: INSERT INTO Table1 SELECT * FROM Table2 WHERE (((Table1.field1) Not In (select Field1 from Table1)));
  14. LebronJames

    Max Records - Append Query

    When I use an append query on a table of 1000 records, the new fields are added ok. When I use the same append query in table of 300000. Not all the records are brought over. I am using Access 2000. Is there an option in Access that allows me to change the Deafult Max records. Or can I program...
  15. LebronJames

    Format dateTime field in Criteria field

    This is my query in Access: SELECT Table1.DateEntered, Table1.LName, Format(CDate(nz([Table1].[DateText])),"yyyy\/mm\/dd") AS Expr1 FROM Table1 WHERE (((Format(CDate(nz([Table1].[DateText])),"yyyy\/mm\/dd"))>=Format(#1/1/2004#,"yyyy\mm\dd"))); In design view, there is a criteria field, here I...
See more

Part and Inventory Search

Back
Top