User Profile

Collapse

Profile Sidebar

Collapse
monadel
monadel
Last Activity: Mar 25 '08, 06:36 AM
Joined: Sep 20 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • monadel
    replied to export into text File
    in Access
    I can export to text the data but I have to hard code the output file.
    like:
    file_name = "H:\txtFileName .txt"

    How do you set the output to a new .txt file ( just open a new one)?

    cheers
    See more | Go to post

      Leave a comment:

    • monadel
      started a topic export into text File
      in Access

      export into text File

      Hi guys,

      Does anyone can help how to export data into text file please.
      Any help will appreciate it.

      Thank you
      See more | Go to post
      • monadel
        started a topic button to export table into excel
        in Access

        button to export table into excel

        Hi,

        I am a newbie here for exporting about exporting things into excel.
        I have a form displaying information that user can add/update which is stored into a table.
        What I want is a button on the form that user can export all info into excel that table only.

        thank you
        See more | Go to post
        • monadel
          started a topic run SQL stored procedure from Excel
          in SQL Server

          run SQL stored procedure from Excel

          Hi,

          I need to run a SQL Server 2005 stored procedure by pressing a command button in excel 2003 (VisualBasic 6.3).

          Searched and tried many solutions here and in other web resources, read about opening the datasource, but I cannot find the exact solution for my problem.

          Any help would be greatly appreciated,

          Thanks
          See more | Go to post
          • monadel
            started a topic MS Access security
            in Access

            MS Access security

            Hi Guys,

            I have an access file in the network drive so people can share to open that file.
            However, how do you make an ms access file more secure? Could you help me please? I want to make only autorized/certain people can open the file and only the creator of the file can delete it.
            It would be great if only me can delete the file not others. Is there a way doing this?

            cheers
            See more | Go to post
            • monadel
              started a topic delete permission
              in Access

              delete permission

              Hi guys,

              Do you know how to create a delete permission on acces file. Therefore no one can delete the file. I want to set it from access itself not from the administrator.

              thank you
              See more | Go to post
              • monadel
                started a topic Multi Value Parameters
                in SQL Server

                Multi Value Parameters

                Hi all, I am a beginner of SQL Server 2005.

                How do you display multi-values parameters with coma in the SQL Server 2005 reporting?.

                I believe we have to create a fucntion to do this, but how do you create a function in SQL Server 2005? we only can create / alter table.

                I have an example from a book but it doesnt help me at all. it just give me an example of the code but when I tried, it did not work coz...
                See more | Go to post
                • monadel
                  started a topic insert picture from MS access into MS excel
                  in Access

                  insert picture from MS access into MS excel

                  I have a problem insering a picture into excel spread sheet from access.
                  What I am trying to do is when user press a button it will create a excel spread sheet with picture on cell A(1,1)

                  Can somebody help me with this please.

                  Thank you.
                  See more | Go to post
                  • monadel
                    started a topic Automatically resize form
                    in Visual Basic

                    Automatically resize form

                    Hi guys,

                    How do you resize a form in VB. Basically when user drag the form to minimise or maximise, it will resize all the components inside the form.

                    thanks
                    See more | Go to post
                    • monadel
                      replied to Exporting from queries in vb into excel with Header
                      in Visual Basic
                      please. how do you do to export data into excel with header?
                      See more | Go to post

                        Leave a comment:

                      • monadel
                        started a topic Tab Control Change
                        in Visual Basic

                        Tab Control Change

                        Is anyone know how to handle if someone has not submit/save or made changes on 1 form which has a multiple tabs, but then user forgot to save it and move on click on the next tab.
                        Is there a function to check on like tabOnChange?

                        Cheers
                        See more | Go to post
                        • monadel
                          replied to Exporting from queries in vb into excel with Header
                          in Visual Basic
                          anyone? please help me.
                          See more | Go to post

                            Leave a comment:

                          • monadel
                            replied to Exporting from queries in vb into excel with Header
                            in Visual Basic
                            This is my code to export into excel. So where should I add the Header??

                            Public Function ExportToFile(By Val filepath As String, ByVal rs As DAO.Recordset, ByRef columnStart As Integer) As Boolean

                            Dim xl As Excel.Applicati on
                            Dim wb As Excel.Workbook
                            Dim ws As Excel.Worksheet
                            Dim fld As DAO.Field
                            Dim x As Integer
                            Dim i As Integer
                            ...
                            See more | Go to post

                              Leave a comment:

                            • monadel
                              started a topic Exporting from queries in vb into excel with Header
                              in Visual Basic

                              Exporting from queries in vb into excel with Header

                              Hi Guys,

                              Can anyone help me with this problem please. I cant export a queries that I wrote in vb script into excel with Header according into the queries that I wrote.
                              I can export the data but without the header. I want additional header from the queries.

                              Thanks guys.
                              See more | Go to post
                              • monadel
                                started a topic exporting datarecord set from queries into Excel with header
                                in Visual Basic

                                exporting datarecord set from queries into Excel with header

                                Hey Guys,

                                Is there anyone know how to export a datarecord set from queries that I wrote in vb script into excel with a Header that I want according into the queries please?

                                Thank for your help.
                                See more | Go to post
                                • monadel
                                  replied to SQL overlapping date
                                  in SQL Server
                                  Thx I have solved the problem. I just added up some more checking for the dates in the queries and I think they work fine
                                  See more | Go to post

                                    Leave a comment:

                                  • monadel
                                    started a topic SQL overlapping date
                                    in SQL Server

                                    SQL overlapping date

                                    I have a problem with checking the overlapping date.
                                    Basically I am developing a database using MS Access (VB scripts) and SQL queries.

                                    I have 2 tables which are empTable and empLeaveTable.
                                    In a form I have put all the employee data on a label. There are another text boxes that user must put in when the an emploee wants to start leave and end leave. When user click on submit button it will check wheter the empoyee already...
                                    See more | Go to post
                                    No activity results to display
                                    Show More
                                    Working...