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

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 "&"?

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

We just changed to AD and for years been syncing all of our PC clocks with our WINS server via the login script and the command net time. I am told now by the helpdesk that clock sync is handled diffrently in AD, but no one can provide me a good explanation. I ran a test of changing the clock...

I have a form that's main job is to create an evaluation. One of the tabs on the form is a summary of the evaluation. It totals the score from each tab of the evaluation. I used to have scoring done as an event procedure, but the scoring was getting tricky since I needed it to update always...

I have a Macro that I created to run a query and produce a file daily. I want to name the file YYYYMMDD, but I can't figure how how to dynamically change the file name. Ideas?

How can someone redirect a message using the Outlook Client. I know you can use it with a rule, but i need to do it on demand. Can I put messages in a folder, and have the folder sweep for the messages to redirect?

I want to have a GroupBy query but the format of the date in the table is a timestamp. How do I correctly perform a GroupBy?

Has anyone seen this error before? Anytime I use a new server my company built for me and the DBRW, I get this error.. Database Results Error Description: Class not registered Number: -2147221164 (0x80040154) Source: Provider Does anyone know what it means? I can't find anything about it.

Anytime I use a new server my company built for me and the DBRW, I get this error.. Database Results Error Description: Class not registered Number: -2147221164 (0x80040154) Source: Provider Does anyone know what it means? I can't find anything about it. Thanks!

I have a webpage that contains a ship to address. I want to copy that shipto address into the order path of a ecommerce webpage. Is there a way with javascript that I can create a button on my webpage that copies the datapoints into the page of the merchant. Pretend that I know the field names...

Does the server need MS Office installed for all features to work. For example, I get a missing class error with the DBRW, the only thing different from my other server is the lack of MS Office.