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

    column sorting and next/back page

    That was the ticket, thanks much
  2. jedrtd

    column sorting and next/back page

    I'm tring to use this code on a page with column header sorting and page next/back. but I get an error The value "" cannot be converted to a number The Error Occurred in D:\wwwroot\PrintStreamTest\Profit_By_Customer\NextNIncludeBackNext.cfm: line 13 11 : <cfloop...
  3. jedrtd

    sort using URL and Session not working from Page to Page

    The only problem I was having was that when you tried to use the next, or goto a page it would go back to the default setting not hold the sort setting(URL). The linking on the header is loading the same page, but with the script it load but does not change the sort order, but will not load...
  4. jedrtd

    sort using URL and Session not working from Page to Page

    I copied to my code, but when I click the link nothing is happening. I have not used script much where does it go in the code
  5. jedrtd

    sort using URL and Session not working from Page to Page

    here is the code, I have been fooling with this for days, I can do the sort but when you sort and then try to go to page 2 etc, it goes by to the default sort, This is the detail page, I have it keeping the session var from the summary page. ---> <cflock scope="session" throwontimeout="no"...
  6. jedrtd

    Run MDB with autoexec macro

    I need to run 3 access database, what we do is they are sch to run at night, they create copie of table we use for reporting on the next day. We do this because we found it is faster then accessing the the database during the day. I have 3 because 1 was to large. The problem is they are...
  7. jedrtd

    can not change data after a date

    Thank you for the help, got it working made a new field check for empty if so can edit, if not, no edit
  8. jedrtd

    can not change data after a date

    What I would like to be able to do is let who ever closes the data entry for the month to be able to change the date, maybe as part of an end of month process.
  9. jedrtd

    can not change data after a date

    I need to change it for each month
  10. jedrtd

    can not change data after a date

    I want to set the data so if the date is < 03/31/05 in a record, you can not change any data in that record, you can look at it but not change it. How would I do this
  11. jedrtd

    FindFirst, NoMatch Problem

    I have a form that is being use to update a file, I placed an unbound control on it and will use this to look for the record to update. It founds the record if it is there fine, but if nomatch I want it to ret to the seach field. I put this code in the afterupdate event of the search...
  12. jedrtd

    Pass standard query Criteria to Crosstab...

    So how did you get it to work, I'm getting the not recognize error on my crosstab
  13. jedrtd

    dlookup just wont work

    I tried this but alway got the smallest cost, shouldnt it be wt1 >= txtw and w2 <= txtw. I tried this now it is returning nothing again? Thanks
  14. jedrtd

    dlookup just wont work

    weight1, weight2 and pmrate(this is the field witht he cost in it)are the fields in the table that i'm looking up weight is the field you key into. so you key the weight then lookup >= weight1 and <= weight2 move pmrate to cost field. hope this helps
  15. jedrtd

    dlookup just wont work

    I need to use >= <= in a lookup, I'm not getting errors now but I get null. I have a weight1 and weight2 field which is the range fields, then on the form I have the weight, I need to check the weight1 and weight2 and get the cost for the weight from the table. I'm using this in the...
  16. jedrtd

    dlookup #error

    Ok, I tried it with each one separate and they worked pasted below are the 2 that worked DLookUp(&quot;[PMrate]&quot;,&quot;rategood&quot;,&quot;[Weight2] =&quot; & [Forms]![rates]![weight]) DLookUp(&quot;[PMrate]&quot;,&quot;rategood&quot;,&quot;[Weight1] =&quot; & [Forms]![rates]![weight])...
  17. jedrtd

    dlookup #error

    I took out the single quote and I dont get an error but it isnt doing anything now =DLookUp(&quot;[PMRate]&quot;,&quot;RateGood&quot;,&quot;[Weight1] >=&quot; & [Forms]![rates]![Weight] & &quot; AND [Weight2] <= &quot; & [Forms]![rates]![Weight] & &quot;&quot;)
  18. jedrtd

    dlookup #error

    pmrate is the field I im pulling the looked up value from weigth is the field on the form weight1 is the lowest weigth on the same table as pmrate weight2 is the highest weight on the same table as pmrate the weight1 and 2 fields are single/general number 4 dec. the pmrate is money
  19. jedrtd

    dlookup #error

    =DLookUp(&quot;[PMRate]&quot;,&quot;RateGood&quot;,&quot;[Weight1] >= '&quot; & [Forms]![rates]![Weight] & &quot;' AND [Weight2] <= '&quot; & [Forms]![rates]![Weight] & &quot;'&quot;) ok I I pasted it just like you had it and got a name? error, put rates in place of myformname now I get Error...
  20. jedrtd

    dlookup #error

    =DLookUp(&quot;[PMrate]&quot;,&quot;rategood&quot;,&quot;weight1> =' &quot; & Form!weight & &quot; ' And weight2< =' &quot; & Form!weight & &quot; ' &quot;) Here is the lookup, I know it is just the &quot; ' are in the wrong place thanks

Part and Inventory Search

Back
Top