Search results

  1. A

    Change font

    How to change font in database objects list view windows? (not datasheet, table/query windows)
  2. A

    Export to Excel question in server

    I created a auto export a query to Excel and want to move this project into a server. Since the server did not have Excel installed therefore always got an error. How to fix this problem?
  3. A

    Does Access have the same functions like ROW_NUMBER() and PARTITION?

    There is ROW_NUMBER() and PARTITION in SQL server 2008. I can write code like ROW_NUMBER() OVER(PARTITION BY ID ORDER BY COLOR) Does Access have the same functions like ROW_NUMBER() and PARTITION? Or, using code or query doing the same job?
  4. A

    Check empty folder

    I use code to check folder as below. If the folder not exists, then create it. If dir(myfolder) = "" then mkdir(myfolder) end if How to add code to check empty folder, like below? If dir(myfolder) = "" then mkdir(myfolder) else if empty(myfolder) then //there is no empty function in access...
  5. A

    Reset autonumber column

    There is a autonumber column in one table Order. Everyday I need delete records in Order and then append records into it. Doing so, autonumber keeps on increasing. Is there any way to reset Autonumber from 0 after deleting records?
  6. A

    VBA to setup forms properties

    There are 20 forms in my app mdb file. I need to set form property for each form in design view, such as popup=no, autocenter=yes. How to use vba to do it?
  7. A

    How to center form

    I use Access 2010. How to open a form and make it at center of screen every time?
  8. A

    Connecting to SQL

    My Access app is using ODBC to connect to SQL server. Network guy want me do not use ODBC. He said that ODBC will cause network traffic. Is it true? Is there another way to connect to SQL server other than ODBC? (like ado.net in visual studio)
  9. A

    How to calculate day in different row

    I need help to code days. As the sample data below, days between [ADMDATE] and [DSCHDATE] need to be count as this way (at different rows): MEMBID---ADMDATE--DSCHDATE--RESULT 06000248 08/02/2010 08/04/2010 06000248 08/10/2010 08/12/2010 (08/10/2010 - 08/04/2010=6) 06000248 08/20/2010...
  10. A

    Email sender

    I want to code to send an email from Access app in which the email sender not my email address but something like "DBAdmin@xxx.com". I search in Google but all I found is using my outlook object and display sender as my email address. Is there a way to send an email without display my real...
  11. A

    Make table change column name

    There is a table tA in which there is a column [AAA-07]. I use a make table query to make a table tB from tA but column name [AAA-07] was changed to [AAA-7] which lost "0". How to make name of column as the same as tA, that is [AAA-07]?
  12. A

    Calculate number of moths between two days

    How to code to calculate number of moths between two days? For example, BeginingDt=09/01/2007, EndingDt=05/20/2009 should be list as below: 2007:4 2008:12 2009:5 (If date of month >=15 will count as whole month, if <15 will be ignored)
  13. A

    How to code to link all SQL server tables via odbc?

    There are about 500 tables in SQL server. How to code to link all SQL server tables via odbc?
  14. A

    Display varbinary in Access form

    My app store image data in a SQL table as varbinary type. How to use Access 2003 to link this table via odbc and display image in Access form?
  15. A

    DSN problem

    I used dsn file as below to link a SQL server. Everytime need to input password, why? How to void it? [ODBC] DRIVER=SQL Server UID=sa PWD=holiday DATABASE=Order WSID=ASPFUN APP=Microsoft Data Access Components SERVER=111.222.333.444
  16. A

    How to code to connect to SQL server?

    How to code to connect to SQL server using odbc, SQL authentication mode? There are about 500 tables in it.
  17. A

    ODBC dsn file

    I use dsn file as below from Access to link to SQL server via ODBC. From Access, I use this file but list all tables including system tables. How to restrict system objecs? [ODBC] DRIVER=SQL Server UID=aspfun Trusted_Connection=Yes DATABASE=credent WSID=aspfun_ws APP=Microsoft Data Access...
  18. A

    Use code to link tables

    I splited program and database as two mdb file, app.mdb and data.mdb. All tables are stored in the data.mdb file. How to use code to link all tables in the data.mdb whe app.mdb open every time?
  19. A

    How to update sequential number?

    I have a table like below. How to add sequential number that will reset to 1 whenever the name changes? Name Date SeqNum ------------------------------ AAA 1/10/2007 AAA 1/12/2007 AAA 1/15/2007 BBB 2/10/2007 BBB 2/13/2007 CCC 3/1/2007...
  20. A

    After linking, only -1 or 0, not null

    I used Access to link to a table in SQL server. After linking, a bit data type in SQL server became "yes/no" column in Access but only list "-1" or "0", missing "null". How to list "null" in Access linked table?
Back
Top Bottom