Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mimitan
  • Order by date
  1. mimitan

    How can I write te records of SQL table into mutiple csv file?

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

    Can not store value of a row that is checked?

    I am sorry. I found out what my problem was. Thanks
  3. mimitan

    Can not store value of a row that is checked?

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

    ListBox selectedvalue

    The value I need (which a paragraph of text)is in the SQL table and I do not know how to assign it to a text box from SQL. So what I did is create a SQL datasource and have a listbox to grap that value (text string) then copy it to the text box.
  5. mimitan

    ListBox selectedvalue

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

    Refresh Gridview

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

    How can I reference when my Gridview has no data?

    Thank tperri for your help. I tried it, it worked but then I realize that Rows.Count does not change right away. What I mean is: I have a drop down list, when I select a name for example, the gridview will display information on the name selected, and when there is no info then it will display...
  8. mimitan

    How can I assign an userid stored in a SQL table as Session Var?

    Thanks Jason for your help. Sorry I did not understand well your 2nd step. You mean to pass currentuserid as parameter to sql, right? But what do you mean by if record count comes back 0 return the user to "grid" page. Please can you give me a quick example, I am very new to sql and aspnet...
  9. mimitan

    How can I assign an userid stored in a SQL table as Session Var?

    Sorry for the confusion. Let me try again. I have a sql db table named Billing as this: Account# Address UserAllow --------- -------- ----------- 9873546 XYZ domain\johns 7585747 RST domain\maryf Now let say john open the page Update.aspx...
  10. mimitan

    How can I assign an userid stored in a SQL table as Session Var?

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

    Insert Data in SQL2005 table using ASPnet

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

    Button to open an Access form in Datasheetview?

    Yes, That was exactly what I was looking for. Thanks PH
  13. mimitan

    Button to open an Access form in Datasheetview?

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

    How can I create a column in Excel that acts as autonumber?

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

    Database file properties change

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

    Excel Format is not working

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

    How can I require user to fill cell1 also if he/she fille cell2?

    Hi Skip, I think I got this working and this is what I have: Private Sub Worksheet_Change(ByVal Target As Range) If (Target.Column = 2) Then If (Target.Value > 0) Then If (Cells((Target.Row), 1) = "") Then MsgBox "Input Date" End If End...
  18. mimitan

    How can I require user to fill cell1 also if he/she fille cell2?

    I am sorry. I tried but was not successful. I have so little knowledge on VBA, and was unable to get the syntax correctly. Could you please show me more detail. Thanks!
  19. mimitan

    How can I require user to fill cell1 also if he/she fille cell2?

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

    Excel_Split data of a Cell into two

    Thanks Phil & Skip! That what I needed to do

Part and Inventory Search

Back
Top