Recent content by aspfun

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

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?

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?

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

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?

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?

I tried it but did not work. Is there any code to manage it?

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

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)

In SQL server query window but my question is: Is it possible to convert it to Access query or VBA running in Access?

This problem was solved in SQL as below. How to convert it to Access vba? CREATE TABLE dbo.PatientInfo ( MEMBID CHAR(8), ADMDATE DATE, DSCHDATE DATE ); go INSERT INTO dbo.PatientInfo VALUES ('06000248','08/02/2010','08/04/2010'), ('06000248','08/10/2010','08/12/2010')...

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

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

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]?

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)