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...
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...
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...
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...
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...
In your SQL statement, try the following as criteria for dtReceived:
< DateAdd("d",-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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.