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 Chriss Miller 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. traingamer

    help with function

    What if you use Dim dbs As DAO.Database, tdf As DAO.TableDef, i As Integer rather than Dim dbs As Database, tdf As TableDef, i As Integer ? Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard
  2. traingamer

    Group by month and year

    Then you are probably sorting and grouping in the report, itself. Have a look at that. Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard
  3. traingamer

    concatenate records in a query help

    Do you have a user-defined function concatenate? Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard
  4. traingamer

    Monumental Mistake

    Prosperity - really? Holy smoke. Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard
  5. traingamer

    Ultimate vs. Penultimate

    Your ultimate destination is the last destination. Penultimate is the one before last, and antepenultimate is the one before that! I've actually used antepenultimate in a speech (of course, I had to explain it). Greg People demand freedom of speech as a compensation for the freedom of thought...
  6. traingamer

    Table Export Creating Blank Rows

    Sounds like it was just text wrapping rather than actual blank lines, then. Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard
  7. traingamer

    How do I make the DLookup function update fields with new selection

    MajP beat me to it. The DLookups seem like overkill. Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard
  8. traingamer

    "Never" use tables for page layout?

    It's tough (ok, virtually impossible) to use floats if you cannot specify a width. If, however, you know the maximum width of the items in the select box, you can simply specify a width that will accomodate that. Barring that, you may (or may not) want to experiment with overflow. Greg People...
  9. traingamer

    prioritize duplicates

    I don't understand the question. Is Co a priority field that is separate from the address field? Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard
  10. traingamer

    Field Attributes

    As I understand it, dbdescending only applies to indexes, while dbfixedfield applies to fields. Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard
  11. traingamer

    Calcualtion Field

    The NZ(1stparm, 2ndparm) function evaluates the expression (or variable or field/column) in the first position. If the expression evaluates to a null or zero, it returns the value in the second position. Thus NZ([building Price1],0) evaluates [building Price1] - if it is null or zero, it uses...
  12. traingamer

    Why would an MDB suddenly become read-only

    More info needed. e.g. Is it on a shared drive? Can he copy it? If so, is the copy also read-only? Is it at the root level of his C: drive? Is it Thursday? Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard
  13. traingamer

    Multiple Table Joins Syntax Problems

    IS ici.TYPE text or numeric? ici.TYPE = '2' If numeric, remove the single quotes. Or, more likely, you simply need to move that criteria from the LEFT JOIN to the WHERE clause: LEFT JOIN domdata.pub.icinterchange AS ici ON ( i.conum = ici.conum )...
  14. traingamer

    Block exceptions

    How about something like (replace field names and table names as appropriate): Select ymt.* from [yourmaintable] ymt where ymt.Jobnum Not IN (Select distinct ejn.Jobnum from [yourexceptiontable] ejb) That assumes that your users only have table access from a form or a query that you provide...
  15. traingamer

    Need Access 2003 to edit SQL tables that have BigInt

    Try unlinking and relinking the tables. (If that doesn't solve it, go kick some developer butt.) Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard
  16. traingamer

    Need Access 2003 to edit SQL tables that have BigInt

    I don't have any issues with BigInt columns in 2003 - Access treats it as a text field. (And allows me to update it). If it's not the id field, just don't use it in your queries and updates. Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom...
  17. traingamer

    Query not working as expected

    If that's your actual code, you've turned some of it into a comment with an apostrophe: ' build sql for query sqlReport = " t_dmz_people.mpac = " & [sqlEmp] & "" ' AND ((T_DMZ_EQUIPMENT.START_DATE) Between #" & [sqlBegDate] & "# And #" & [sqlEndDate] & "# AND ((T_DMZ_EQUIPMENT.EARN_CODE)=0)"...
  18. traingamer

    .css footer stick to the bottom of the page.

    We can't see your html, but this doesn't look valid: .push 1. .footer, .push { 2. clear: both; 3. } It probably should just be: .footer, .push { clear: both; } Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard
  19. traingamer

    Combining fields

    It seems sort of redundant to repeat the data in a third field, when you can simply build the path later by simply combining the two fields. e.g. txtImageName & "\" & fileName Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard
  20. traingamer

    combo box relationships

    Look in the FAQ section of this forum: faq702-4289 Greg People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

Part and Inventory Search

Back
Top