Search results for query: *

Hi, I have a table named tblemployee in the sql2005 database MyCompany. I am trying to create a page that have a textbox which user can enter an integer 1-3 (number of csv file)and a button when clicked, it will connect to tblemployee table, obtain the number of records of the table and divide...

Greeting, I have a gridview with checkbox that allow user to check to select and when the user is done selecting, he/she click on Submit button and will be send to a different page. below is the click event code Protected Sub Button2_Click(ByVal sender As Object, ByVal e As...

I have a listbox that display a select distinct field from SQL and I have a button when clicked, it supposed to copy the content of the listbox into a textbox, but it didnot, it seems like I have the select the value first then click copy. Is there a way to default it to automatically select the...

Hi I have a page with several radiobuttonlist, ddls, textbox a gridview that display data from SQL DB, and when I click edit button, it will send me to another page (update page) to update data. when I am done I click Complete, it will then close the update page and I am now back to begining...

Hi all, I have a page that capture the userid and assign it to session("currentuserid"). This current user can only update records in a sql Billing table that UserAllowed id field of that record match the session("currentuserid"). Now my question is how can I assign UserAllow id to a...

Hi everyone, I have a form page in ASPnet when the Submit button is clicked, a stored procedure in SQL is called and the pararmeters of data in this form (such as first and Last name and so on) will be passed and inserted into a SQL table of a UserInfo DB. Here is a segment of code in the...

Hi, I am currently learning Access DB. I created a form with a button when clicked it will open another form. My question is when it open the second form, it default it to Form view, how can I change it to default to Datasheetview? Here is a few lines of the codes attached to the command button...

Hi, I am trying to create a column that displays number reflecting the row number and because of reflecting the row number the digits in the cells are automatically changed at any time a row is inserted or deleted. For ex: Rows 1-5 are headers F_Name L_Name...

Happy Holiday season to All, I am very new to SQL server. I have a SQL 7.0 DB that has a file property set to file automatically grow by 1 percent and so is the transaction log. My question is can I change the growth to 1 MB by selecting the "in megabytes" option? will it hurt anything? Thanks...

Good Morning. I have an Excel sheet with all columns formatted (text or number or date...). It was working fine until a user did something to it and now one of my column which is shown with format: number 2 decimal places but when I enter 1.00 it will automatically default to 1 but if it's 1.05...

Greeting to All, Question 1) I am trying to implement something like this: I have in Column A as Date and Column B as Quantity. Date Qty 07/25/05 1 if a user enter a number in the Qty field and go to different cell and left the Date blank, a message should pop up and ask the...

I have a a Price Column that has data as this: Reg Price --------- 2/5.00 2/1.00 3/10.00 10/1.00 I can not do any calculation using this column. As a result I want to see if there is a way for me to split the data into 2 column as this Reg Price Unit Price...

Greetings All In Word, If I customize the toolbars, I can save a file with extension .dot and copy this file to a different machine, I will have the same toolbars setting. Can Excel be done the same? and what file would that be? The reason I want to do this is on my Excel I customized in...

Hi everyone I have 2 columns A and B (A progid, B Qty)as follow: Progid Qty Asid Hgid Bhid c grey out whid Anid c grey out Gtid and so on... I am trying to set up the Qty column with cell grey out when Progid is blank so that user can not enter data in these cells...

Hello everyone. I have a workseet that has a command button that trigger a macro. When the seet is not protected I can press the command button and the macro run fine (autofilter) but when the sheet is protected from others to modify, it give a runtime error when pressing the command button. Is...

Greeting to All, I have a Item sheet with a list of data like this Item progid StartDate EndDate ..... ------------------------------------------------------ 11223 AA 01/25/05 03/25/05 24555 AB 02/01/05 05/15/05 ...etcetera My goal is...