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!

  • Congratulations strongm 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: *

  • Users: cbogz
  • Order by date
  1. cbogz

    OnRequestEnd.cfm

    Hmm, is this file that you want to call the custom onRequestEnd for the only file in the directory? Remember, application.cfm will fire for every template in the directory, and the same goes for onRequestEnd (Perhaps there is a way to turn the onRequestEnd off through code, but I'm not sure...
  2. cbogz

    OnRequestEnd.cfm

    A couple of questions: Are you using an application.cfm? If not, you need to in order for it to look for an onRequestEnd.cfm file. Also, if you are using the application.cfm file, the onRequestEnd file, I think, needs to be in the same folder as the application.cfm file that you're using. In...
  3. cbogz

    Need to know all fields that have default values

    I don't have my Access/VBA books handy, but I think there is a way to do this in VBA. You'd have to cycle through the collection of tables, then through the fields of each table, and look to see if the default value property was set or not. This might be a question you'd want to post to the...
  4. cbogz

    Deleting data from a table after 'x' months

    Is there any particular reason you want to reuse the key field? It seems to make more sense to delete the entire records, or at least archive it, so that you have a record of it. Certainly, what you are asking is possible. You could have a query run each time the database opens that clears...
  5. cbogz

    Exporting file from Access to Lotus Approach

    I have read the dbf files may not support long field names (longer than 10?), so if the field names are getting truncated on export, you may be running into trouble because of it. I tested it on my system and tried to export a table I knew would create duplicate field names, and indeed, I ran...
  6. cbogz

    Days Past Due Report

    In your SQL statement, try the following as criteria for dtReceived: < DateAdd(&quot;d&quot;,-15,[Forms]![frm15days]![txtDate]) DateAdd takes 15 days off of the value you've entered into the form. If dtReceived is still less than that value, then over 15 days have passed.

Part and Inventory Search

Back
Top