I am not an XML person, but anyone know how I can take an XML file and filter it by the parameters passed to me in the URL? I would then post back to the filtered XML to a web page.
exmaple
www.mysite.com/category=X&subcategory=Y.
I would then look for the matching nodes in the XML and...
I am trying to hook my SQL DB to a report engine that says it supports SQL 92. I dont really know what that means, except that it cant handle this part of my SQL statement.
Can someone tell me how I can accomplish the same thing as this using sql 92 standards? Basically I need to get all the...
I really hate dealing with dates and times in queries. And again, I find myself pulling my hair our.
I need to find all completedates for yesterday, so i want from 12 Midnight to 12 Midnight. How can I do that? Here is what I am using, but its wrong. How do I normalize to
2008-06-24...
I need a one time fix so that I can have a query to look at the timestamp in a table that is UTC and adjust it for EST (-5). I am somewhat perplexed and know this should be VERY easy, but I am confused. Help Please!
Correct, non of the records in that field will be NULL. What I am attempting to do is have a form with multiple drop downs. If one drop down is not selected, but others are, I don't want to prevent the query from working, but to assume that there is no criteria for that field. I don't think that...
If I use a query that depends on the value of the dropdown, what if no value is selected in the drop down, what value gets pased? i assummed Null ans wrote my where clause like this:
IIf([Forms]![ReportingMenu]![SupervisorReport]=Null,"Is Not Null",[Forms]![ReportingMenu]![SupervisorReport])...
I am try to pass the value of a drop down on an unbound form to a query. Is there something more to is.
Forms!MyForm!MyField
Do you need to do something more?
I been working on rebuilding the table, and it seems better now. I am now trying to default a field to the logged in user's name.....any ideas there :)
Taking out the control source didn't seem to do much. This was odd. When I made the Default value yes, it defaulted to No. When I made it No, it defaulted to N/A. When I made it N/A, it added "" and didn't pick up any default.
Yes, I do have a control source that stores column 2 (Bound Column=2).
No error, just the the box is not defaulted. I have another application where the object hsa the same setup, and it defaults to yes. I compared everything, an there is no difference.
I have a form that is an application form, I want to default some falues of the form (I dont want to do this at the table level), I should know this, but how do I default hte drop down? Which control do I need to touch? Each Drop Down has a yes, no, and NA choice, but it writes a value to the...
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.