When this view is run, all of the discrepancies written the previous month are displayed. I've got the last day of the previous month, but I can't get the first day. Any help would be appreciated.
A criteria example: Between 10/1/2006 and 10/31/2006
So far I have:
Between 10/1/2006 and...
I have a select box that is populated using 2 queries, each from different tables. They both pass pkey for value. Based on which table's value is selected, determines another setting when an update takes place. I may have a pkey value of 8 for a department and a pkey value of 8 for an...
I am using Access 2003 SP1. Table1 has a description field. Table2 is a lookup table that has airport codes. I want to loop through Table1's description field looking for any reference to each airport code. Can I do this with an Access query?
There are only 2 of us that work with ColdFusion and I am the only one working with this code. I thought that I had heard that there was an auto-correct setting somewhere. I thought maybe this was enabled and that is why this was happening. Does this sound familar to anyone?
The problem is that I am saving the code after an edit. The change is reflected when I refresh the page. It is when I go back and open the code itself that it has reverted back to its original revision. Example: I am trying to fix these line of code
<!---
FROM:
<A...
I already have SourceSafe installed and have used it with ColdFusion for 6 years. This is something that has started happening since I have installed ColdFusion MX. There is a Code Rewriting setting under Files/Preferences, but none of the boxes are checked.
I am using ColdFusion MX. I edit code and save. Refresh page everything is fine. The next time I go back in to the same code, the changeds I made have reverted back to the original version. If I make an edit unrelated to the first edit and save, I lose the first edit. I am using SourceSafe...
I am creating the package manually. I know how to adjust the size if I am exporting to a text or csv file, but I can't see how to do it if I am exporting to Excel. I may give up and just export to csv.
I am using DTS to export data from SQL to Excel. I have a large text field that is being truncated at 255 characters. When I look at the Destination field size for the package, I see that the Data Type for all the fields is VarChar and the size is 255. How can I change this so the text is not...
I understand that there is suppose to be a Sounds Library under Windows - Other Panels - Common Libraries. My installation of Flash does not have a Sounds Library. Do I need to reinstall?
I have upgraded to Office 2003 from Office 2000. I have an Outlook form, which is a vacation request used company wide. The user opens the form, fills in vacation info then clicks send. The e-mail then sits in the Outbox. Normally, this would have been sent to the user's supervisor. Is...
My Network Support Group has installed Office 2003 on several computers for test purposes. Unfortunately, the development group was not one of the test computers. I have a secured database that will not run as is in Access 2003.
I am getting ready to look at Access 2003. We are currently using Access 2000. In previous upgrades I have had to do a considerable amount of work to convert my secured database to the latest version. Can someone point me in a direction for good information about Access 2003, specifically...
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.