Search results

  1. A

    Switchboard Manager

    Hi, I used switchboard manager to create command button and Labels on the forms. Can we manually create command button and labels on the forms, but they have related? I checked the forms Toolbar, it doesn't have command button and Label attached each other (related).
  2. A

    last character in the textbox

    Hi, I want to put the last character on the textbox. But, textbox's width is modify depend on the monitor screen size. How can I put the last character of the textbox's width?
  3. A

    Visual Studio 2005

    Can Visual Studio 2005 Professional distribute VB exe file?
  4. A

    Show the database window when closing

    Hi, When the user open the database, the database window will be hided. But, when the user close the database with one form opening, it will show the database window for a while, and then close it. How to prevent the database window to show at the moment?
  5. A

    Insert the records into ODBC linked tables

    Hi, I have a lot data to append to ODBC linked table in MS Access. I want to know that which way is faster to append the records. if I append the data into ODBC linked table, 1) create the one query (append) to insert the records into ODBC linked table 2) use the VBA code (DAO/ADO) to insert...
  6. A

    Print the field names

    Hi, I create many fieldnames in one table. I want to print all the field names and give somebody. Where I can do that?
  7. A

    modify query

    Hi, I create one database and the query and the forms for my clients in the sharing drive. Every time, the user open the form and select the field names and then execute the query depend on which fields the user select on the form, and then output to the screen. Here is the question, if there...
  8. A

    run commandbar

    Hi, I create the startupfrm. When the user open the database, the startupfrm will be automaticlly opened. This form has been setup Time Interval = 5000, and there is Timer function inside the form, every 5 seconds, I want the database to refresh the user menu depend on the user's permission if...
  9. A

    Ado

    Hi, I active application role from the SQL Server, then I open the recordset rs.open "select .............", conn, adOpenKeyset, adLockReadOnly and then Do while Not (rs.BOF or rs.EOF) conn.Execute("select [path] from [List] where [Name] = 'Tim'").Fields(0).Value ........... rs.movenext...
  10. A

    sysusers

    Hi, In SQL Server, if I active the application role, can all the public user still read the sysusers table even though the application role does not select the sysusers as read permission? Thanks.
  11. A

    Permission on View

    Hi, I create the table "Personal Information", which list all the employees information, such as id num, name, age, department....... Only me has full permission on this table. I create the View, which select fields: name, age, department columns for my co-worker to read, update, and add new...
  12. A

    Rename Standard Role

    custom role I made myself.
  13. A

    Rename Standard Role

    Hi, How can I rename the standard role? Because I want to keep the object permissions, just rename role name.
  14. A

    Data Access Pages

    Hi, Can we write ASP languages of the data access pages? Does it support? Can we use it to insert/delete/edit records? If we use it and put it in the web server, does anybody access it via the URL Address? Thanks.
  15. A

    charindex

    Hi, charindex is searching from left to right. do we have function from right to left search? Thanks.
  16. A

    Report

    Hi, I am using VB6, I use MS Access as backend, if I create reports in the MS Access, can VB6 control the MS Access report?
  17. A

    Deny the column

    Hi, I linked the SQL Server tables to MS Access. But, I want to prevent one column to read by user. I tried to create the standard role in SQL Server, and then deny one column, after that, I create the query which select the fields are read in the table only except the denied column, but the...
  18. A

    Read Only message

    Hi, I create one Excel file in the sharing drive. If multi user access this file at the same time, the user will get the Read-Only message when opening. Can I skip/remove the Read-Only message?
  19. A

    mdb VS ADP

    hi, When the database open, there is auto hidden form open, there is Timer function doing something on each second. When I run it on mdb, it wokrs fine, but when I run it in ADP, it works slowly. How can I make it efficient on ADP.
  20. A

    User

    Firstly, I make the application role active. after that, select user => it will show the application name, I want it to show the current username (window NT network username (userid).
Back
Top Bottom