Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sallyGals

    How to solve ODBC connection problem?

    The problem now is it can work in my computer, but it can not run in another three computers. I could not found the problem.
  2. sallyGals

    Transfering references?? library????

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

    How to solve ODBC connection problem?

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

    How to solve this: Method "connection object"_currentproject failed.

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

    How to solve this: Method "connection object"_currentproject failed.

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

    How to solve this: Method "connection object"_currentproject failed.

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

    What this means? "You can't carry out this action at the present time"

    My system suddenly show out this message box: "You can't carry out this action at the present time" What it means?what should i do?
  8. sallyGals

    How to show the month in April instead of 04?

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

    How to show the month in April instead of 04?

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

    Transfer Spreadsheet problem

    u can try this: FileName :J:\INFORMATION\Data_Team\Database\Grad.xls Best Wishes, sallyGals
  11. sallyGals

    How to group data in Chart?

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

    How to group data in Chart?

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

    How to combine two chart in access?

    thanks. I had found way to solve it already.
  14. sallyGals

    How to combine two chart in access?

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

    what it means: Method 'connection' of object' _currentproject' failed

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

    How to show month format in 'February'?

    yeah! PHV, i had done it. It can work already. thank you so much.
  17. sallyGals

    How to show month format in 'February'?

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

    Is it possible to create query to join imported table?

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

    how to group data in month?

    that means i have to change all the year to month in these three query?
  20. sallyGals

    how to group data in month?

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

Part and Inventory Search

Back
Top