Search results for query: *

I am creating a text file that stores a list of file names so that I know what files have been processed. I have figured out how to write a file to the .txt file, but have run into two problems. 1) each time i write the file name it just overwrites the previously inserted name and 2) how can i...

I have an excel file with a few textbox's on it. They text boxes have autowrap and vertical scrollbars. When I do a print preview the textbox only shows a few lines of text. Is there a way to show all the text in the textbox when doing a print? The autoresize property just covers up the rest...

I am trying to create a search for a grantee, currently i am just passing it in as a parameter, but the drawback is that it has to be an exact match. How can I use the LIKE in my WHERE clause so that it looks for the words in the database? SELECT ApplicationID, GrantCountID, GranteeName...

How would I check to see if the selected cell is under a certain cell called "personnel" and above a cell called "contractual"? They are all in the same column "B". thanks in advance, Chris

I'm trying to check to make sure the text box has a number in the format of: #####-##, or five digits a dash and then two digits. How would i do this. Thanks in advance, Chris

I have a file viewer control which came with the VbPowerPack. I'm trying to get the drag and drop functionality going for files, but everytime I drop it in, it just shows up as the full file string and not an image. Has anyone had experience with this? Do I need to do somekind of refresh...

SELECT dbo.AUDIT_LOG.AuditID, dbo.AUDIT_LOG.AuditType, dbo.AUDIT_LOG.TableName, dbo.AUDIT_LOG.UniqueFields, dbo.AUDIT_LOG.UniqueId, dbo.AUDIT_LOG.FieldName, dbo.AUDIT_LOG.OldValue, dbo.AUDIT_LOG.NewValue, dbo.AUDIT_LOG.AuditDate, dbo.AUDIT_LOG.AuditDate_NoTime...

I currently have a web application that generates reports as excel files and then emails them out. All of the excel files get put into a temp folder on my server. How would I create an app that will sense when the directory has been changed and then delete all of the files in that folder...

I have looked on the web for articles talking about user controls, but I have not found any that go into an in-depth discussion about functionality. What are other advantages to using web user controls other than reusability in pages? Thanks in advance for input, Chris

I have been racking my brains for hours over this. totalNewHours = myTable.Compute("SUM(Time)", "FundSourceIni = AH") This code is suppose to take the sum of all the rows in "Time" while adding up only rows with "AH" in the FundSourceIni column. I keep getting "column AH does not exist...

I have a new user registration page, but whenever a new user clicks it from the login page, it just redirects to the login page. How do I exclude it from being part of the authentication process? I am using visual studio 2002, building a solution project. Thanks in advance for help, Chris

For the life of me, I cannot figure out why my code is not updating the data from the datagrid. It will go into edit mode, I can cancel and I can delete, but it will not update. it is always the small things in life. Well I don't know what to do except paste my code here and hope that one of...

I am programmatically adding a datagrid to my page on a selected index change event. It is working just fine, but it put the datagrid at the far bottom of the screen. Is there a way to add a place holder and specify where to add the datagrid? Thanks in advance, Chris

Ok, here is the deal. I have a page that has three thing. First, a popup calendar, 2) a datagrid and 3) a dropdown box with a few options in it. Right now when the page loads it pulls the data from sql for that day. As you change the date the page reloads with that data. So here is my...

I have a page with two dropdown boxes and a datagrid. The first dropdown box has content already binded to it. Now, based on the selection of dropdown box 1, I want the second box to load some content based on the id of the selection from 1. And then I would like a list of items to appear in...

How do I run sql query analyzer? I'm trying to install some .sql files to create a database, but I cannot figure out how to open or use the query analyzer. Thanks in advance. Chris

I'm working on creating my user registration page and I am almost finished except that i'm stuck on how to check the sql server whether or not the user name and password are already being used, and then some logic to process this. I tried creating a custom validator function to do run a select...

Here is my code and what is does: 1) opens up word files 2) copies bookmarked fields 3) opens up access database 4) copies the data to the table Now, i need some help with the error trapping. When the code runs and finds a word doc that does not contain bookmarks, it gives me a error 5941...

How would I go about opening an access table from word and then inputing data into that table with data stored in a variable? Thanks in advance, Chris

I am trying to loop through a folder of word files to extract some data from them and then close it and move on. The problem is that it just keeps looping through the files over and over again. If I do not know how many files are in the folder how can I make it stop after going through the...