Search results

I assume you are not using the wizard bcoz you said you have a function.... You write the function to import data, right? Please post your coding first and let us see. Thank you. Victor

You can have a look into the MS Access. I try to use TOP 1 suggested by Dcrake~ I dont know why I cannot show up the min(Sum(Turnover)) with store_key when I create the new DB. However, I can show up the min(cost) when using my existing DB.... so strange....

Can you try not using the Store_Key? Let's say using the store name.

You can use the query that you mentioned in your pervious post, I assume it is query1. Query1 contain the below column Store_Key Sum(dollar_sale) ======================== 1 500 2 1,000 3 1,800 4 20 5 670 You...

Thank for your answer. That means, if I am still developing the Access, I need to run compact and repair regularly, right?

Dear All, I just wonder, in normal way, my MS Access is around 35MB. After it is crashed and created a backup in the same folder automatically, it is now around 18MB. Why? Thanks. Victor

Can you use a query and using "*05/01/2008*", then txn(s) for the date will show up.

Just checked with the Server Admin, they limit the size for the domain..... Yes, I have split it already. Users have a frontend in the server to use.

The "SHIFT" tricky is known to someone professional to MS Access. haha.... I think there is no solution that fit to you. You cannot bypass "SHIFT". If someone know, please let me know.....

YOU CAN TRY TO LIMIT THE FUNCTIONS IN TOOLS>STARTUP.. It is depended on what you want to display....

I can sure it is only 6MB. No data inside the database right now. What do you means of personal space allotments in network? I have checked the network drive, it also contain many space for storage. What happen? Who can help? Thanks a lots!!!!

Dear All, I have a MS Access put into shared server to let user to use. However, when a user tried to open to use it, it prompted user that "Not enough space on disk". I have checked the server size and local harddisk. There are also contain enough space to use. (My Access just 6MB only) Is...

Dear All, Now, I have a mandays table, which is used to store how many days you work for a project. It contains the below fields, - mandays_id - mandays_year - mandays_month - mandays_employee - mandays_project - mandays But, now I have to create a search form which is used to let the user to...

It seems that your coding cannot MoveNext.... Is it?!

As said before, some of my txn(s) are 0 divided by 0, as a result, it appear "#Error" in query. I have tried to check let see it is error or not by using IsError(), and hope it return 0 or 1. However, #Error still appears for the query. So, I think MS Access do not think this is error, 0...

I found that there is 1 txn is 0/0, and the value in the query is #Error. So, when VBA read the query![ValueRatio], it always display Overflow. May I ask, how I can bypass this #Error and move to next record? Please advise.

Dear All, I tried to run a variable to accumulate the value for the same country, but it prompts me that it is over flow. I have try to round() the value within the query or in the VBA, but fails. Please help how I can solve the problem. Below are the coding, highlighting is the error...

except link table, you can export DB1 related tables to DB2 when you open DB2.

I suggest you try to create a variable and store the value of Me.Designation.Value, then use MsgBox to print it out. Let see what is the value it is storing first.

are you using "RESIGNED" when design? Not the ID, right?!!