May I know how you solve it? Because for my system it also can run in other computer, but there have 2 computer can not run it and i also checking the library and refernce, but it is ok .
Thanks in advance.
i had modify my connection string to ODBC DSN. But error ocur when i run it, it shows that "object doesn't support this property ot method." When i debug, it points to the .provider = "MSDASQL"
Below is what i had change in the module:
change:
Set cnConn = Application.CurrentProject.Connection...
yup.
it shows this error:
Run-time error'-2147220999(800401f9)'
Method'open'of object'_connection 'failed
Is it missing component or was corrupted?
i had install MDAC 2.8 .
I check references already, but it didnt missing any component.Since it shows the same error, so i think of other way to connect to the current project. i had change the connection string to ODBC. My source name is StockLevelingSystem.
the coding is this:
Set cnConn = New ADODB.Connection...
Now i installed a system( which is use microsoft access 2000 to develop) in another user's pc, but the problem is the pc is using microsoft access 2003.Then this error message occur: Method "connection object"_currentproject failed.
I had replace the latest MDAC file into that pc, but it still...
my problem is not only for month april, that is example ...
i want it always up-to-date, now is april, so it will show april.When reach to next month, it will change to May...
i had create a table and i add month field in the table.
Now i want the form to show the month in word, eg, April.
But when i set the control source to Month, it will show 04...
Besides, I had try this: =Format([Month],'mmm')
but it show jan , it suppose to be April.
then i also try this...
i had solve this problem already. By the way, i have another problem now. I have 30 product in Y axis, I want to categorize 1O product then put a mark there in the axis there, so it will make user easy to count the total of the product.How to make it?
thanks for helping.
i had create chart in the system, the chart fields are target, current stock, stock minimum, and stock maximum.Now i want to show the chart which is group by target, means the highest target will display first then follow by the lowest target...
But i have no idea to do it, can anyone tell me...
i need to create a stack column chart with line chart....
the stack column chart is to show the stock target and current stock. The line chart is to show the stkMax and stkMin..
but i only can select the line column chart, so how to make it meet waht i want?
thanks so much..
regards,
SallyGals
i have develop a system by using my pc, then i need to install this system in the server.But i face problem when i put in the server. In the beginning, the function that i done can not work, after i add in the EYEDOG.OCX file, it can work already. But now i face another problem.
i had use a...
I had create a msgbox which ask user to insert record for that month. But what i want is to show the month in "February", but it just can show 2.
MsgBox ("Please insert records for month " & Month(Now))
result: Please insert record for month 2
i want this to show out:
Please insert record for...
I had imported table from another system, may i know that is it possible for me to create query to join imported table and the current system table?
i had try it, but it was not allow..
Now i had group my data in year, my report will only show all the data in year.
But if i want to group data in month to make all data show in that month only, how to modifyt my sql statement?
Example: now the database consits of MARCH data, when it reach APRIL, it will no data to show in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.