Search results for query: *

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 have a workbook with many sheets, each sheet is a person name. Is there a way I can have a formula on my summary page enumerate the sheet names?

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

Ereka! I see the error of my ways DateAdd("h",-5,[Case_Open_DT])

Still can't get it. I really just want to recalculate the date by 5 houts in the past. I am just stuck with how to do it.

Understood, but the data is static in the table. I ideally I want a field in my query that says EST_TimeStamp:[CaseAdd]-5

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!

Can you use the confirmation feature when you form is in ASP?

With a frontpage form that sends an email, does anyone know if you can place two fields in there? Perhaps seperated by a "&"?

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?

Is there a way to query all the PCs in my location and find the time they are reporting or the time offset from the DC?

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 put in the Row SourceL "Yes";1;"No";-1;"N/A";0 For Default Value I tried Yes and "Yes" as well as 1, -1, 0

I tried #1 above multiple times, but it never works. Any tips on how the default property works?

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