Search results

  1. A

    Check if the subform is opening

    Hi, ''this is for checking if the form1 is opening If CurrentProject.AllForms("form1").IsLoaded = True Then ..................... End If how do we check if the subform is loading on the form1? currentproject.allforms![form1]![subform1].isloaded How to fix it?
  2. A

    Refresh

    <script runat="server"> Sub Page_Load if Not Page.IsPostBack then lbl1.Text="The date and time is " & now() end if End Sub Sub Submit(s As Object, e As EventArgs) lbl2.Text="Hello World!" End Sub </script><html> <body> <form runat="server"> <h3><asp:label id="lbl1" runat="server" /></h3>...
  3. A

    DropdownList

    Hi, In MS Access, I can create the dropdownlist, recordsource = select company,id from vendor columncount = 1 it only display company values. when the user select the value from the dropdownlist, we can populate id value on next textbox using dropdowlist1.column(1). Does ASP.NET do that?
  4. A

    Access Runtime

    Hi, if I don't buy office Developer software, I just download Access Runtime 2002 from the Microsoft website, and then install it on the client machines. Do I commit the company rules? Do I need to buy unlimited license for Access Runtime before installing?
  5. A

    PDF File

    Hi, I created a table which store the pdf files in SQL Server using image datatype. And then, link the table to MS Access database, can we store pdf file as binary data in the table? I tried to see this link http://support.microsoft.com/?kbid=210486 This link doesn't say that whether or not...
  6. A

    Assign Value on the Textbox

    When the report is opened, I want the textbox to be populated a word. But, it doesn't allow to do that. In VBA, can I assign a value on the textbox? Thanks.
  7. A

    ControlSource

    How about subreport? If I place subreport, then how do I represent the value of the subreport? Reports![Invoices]!Amount
  8. A

    ControlSource

    Hi, I create the report, I place the subform on the Report header, and place the regular source attached the report, I make the textbox on the Report footer, and I put =Forms![Invoices]!Amount - Sum([DiscountAmount]) on the Control Source of the textbox Forms![Invoices]!Amount doesn't work...
  9. A

    Drop Down List

    I use the combo box from the Form toolbox.
  10. A

    Drop Down List

    Hi, In the userform, it has many events on the combo box. I want to create Drop Down List on the worksheets, I know how to create the events on the combo box. But, how to create the events on the drop down list? Excel only offer Change Event, do they have any other events offer?
  11. A

    Exec & Dri

    In the Roles, when I assign the permission for each object, I don't understand what is Exec & DRI? What is it?
  12. A

    Empty String

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Put user code to initialize the page here SqlDataAdapter1.Fill(DataSet11, "Months") DropDownList1.DataSource() = DataSet11 DropDownList1.DataTextField = "Name" DropDownList1.DataValueField =...
  13. A

    myReader

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim myReader As System.Data.OleDb.OleDbDataReader OleDbConnection1.Open() myReader = OleDbCommand1.ExecuteReader() DataGrid1.DataSource = myReader...
  14. A

    ADO Connection

    No, it connects to SQL Server. We cannot use this. I just want to create the function that it is for setting up the connection to SQL Server, and then retrieve it back to main function. Because if I have 5 functions which I need to connect to SQL Server, I want to go to connection function, and...
  15. A

    ADO Connection

    Hi, I want to create the ADO function. But, I don't know how to do the reference connection back. Eg. Private Sub cmdButton1_Click() dim conn as ADODB.Connection dim rs as ADODB.Recordset if openconn(conn) = False then exit sub set rs = conn.execute("select * from table1") ...... End Sub...
  16. A

    Range

    Dim rg As Range, myRange As Range Set myRange = Sheets(1).Range("A2", "B4:B12", "C4:C12") For Each rg In myRange.Cells rg = Null Next When I set the range "B4:B12", "C4:C12", the function doesn't work. If I remove "C4:C12", then it works. What's the problem?
  17. A

    Linked Tables

    Hi, How can I prevent the user to link tables from SQL Server? In SQL Server, I give out read and insert permission on specific table in SQL Server, I create one MS Access database which linked tables, I hided the database windows, create the forms. I want the user to input/read the data via...
  18. A

    Access 2007 Runtime will be free

    It's good. So, we can use it in the company without license, right.
  19. A

    MS Access Version

    Here is a question. I go to the menu bar, Help->About MS Access It's shown Microsoft Access 2002 SP3 This is MS Access 2002 Version, right. But, at the top it is shown (Access 2000 file format) Why do I use 2000 file format in Access 2002 version?
  20. A

    Package VS Runtime

    I have MS Access 2002 version, I create one mdb file and then put it on the sharing drive, I install Access RunTime on my client machines, they can run the mdb file on the sharing drive. Another way, I used Office XP Developer Edtion to create package and then install the package on my client...
Back
Top Bottom