Search results

Sorry about my linked tables, Namliam. I realized that 4 or 5 hours ago. So I tried to copy them into another Table and make them local, but when I tried to do so, I received the same error message. It was evident then, that JC_London post was right, there were some corrupted data in the Table...

So far I have no solution for the problem. So I try to make a Table of the Query that was bothering me. And I had the same problem, with the same error. So I built 2 little ACCESS files with only 2 Tables and one Query: The files are "NO PROBLEM A 2000.mdb" and "PROBLEM A 2007.accdb". The...

Here goes the SQL version of the query. I´m sorry it´s in Spanish, but all the spanish words are just names of Tables or former Queries. I´ve also tried to make a fresh A 2007 file, but it does throw the same error when importing this query: SELECT [RESULTADOS CALCULADOS].CódECR, [RESULTADOS...

I already tried to compact and repair my file unsuccessfully. I couldn´t find how to repair my file in ACCESS 2007, y just checked the option for compacting the file each time I close it, and then close it and open it a couple of times with no good results on the query that is not working. I...

Thanks a lot Namliam. I´ll try it and get back to you.

Sure, Bob. Sorry I didn´t realize the language factor. The error message says: Reserved error (-1524) No message for this error. When I press the Help button it says: Reserved error <Elements> There´s no message for this error (3000) Unexpected error. The specified code identifies the...

I have an application made in ACCESS 2003 that runs nicely in any computer with ACCESS 2003. When I want to run my application in ACCESS 2007 it doesn´t work (an important query doesn´t work) :( The error message that I receive every time I try to run the query doesn´t explain much (it can be...

Hi, Chris. I´m sorry it took me so long to answer. I was away from Internet for a while because I had trouble with my provider. And I was too lazy to go to a cyber-cofee shop to conect. But I could copy your instruction, I used it, and it worked just fine. I finished my application and there is...

Your spanish is getting good!!! :) But I´m still getting the error message :(. When I radically change the data source, th error message appears again. I´m attaching a new version of the file to see if you can fix it (I´m sure you can). Well, thank you again, Chris. Hope to hear from you soon...

Hi, Chris. Thank you very much. The program runs nicely, though it took me a while to figure out how to make it work. Thanks a lot for your help and patience. Hope to see you or hear from you in the future. Juan Carlos

Thanks, Chris. I need those numbers to vary, so I included them in the query which feeds data to the main form. The controls can be seen in the Form in Design View, but they won´t show up in Form View, because I put them the same background and text color than the form background. I don´t know...

Hi, Chris. Sorry, it took me a while to answer because I had trouble getting into the forum. I uploaded a copy of the new chart, which works fine, as you can see. Now the problem is that I need 2 lines, one horizontal and one vertical, in different places varying from one dataset to another. I...

Hi, Chris! Thanks again for your prompt answer. I must recognize that you´re right, as usual. I took away both "dummy" series and the graph starts running just like a cheetah!!! I made those inconsistent Series to draw the lines. The series "FVi de Ft" gives me the vertical line. The other...

I´m getting the error message more and more, and some points in the chart don´t have the Label they´re supposed to have. The error message I´m getting, translated to my english would be: Error 1004 in Time of execution. The property Points of Class Series cannot be obtained. When I push the...

Hi, there Chris Thanks again for your quick answer. While I was writing the post I figured out that the problems with the lines with the line arouse because they didn´t belong to the graph. So I included in the graph creating 2 "dummy" sets of data with line drawing between the points. If you...

Hi, again. In some of my charts (made in ACCESS 2003 in my notebook with Windows Vista Home Basic) I have lines, one horizontal and one vertical that were added by drawing (they don´t belong to the graph itself). So they have to be moved around according to the set of data that feeds the form. I...

Hi, there. I´m making charts in ACCESS 2003 in my notebook with Windows Vista Home Basic. The charts are based on queries, and I just cannot see the chart until I make a Click over the Chart Area with the mouse. I must say that I can view my charts just fine in another computer with Windows XP...

Thank you, so much ChrisO!!!!!!!!! Works wonderful!!!!!! It does send an error message sometimes when I change the data source. But it doesn´t always send the error message, and besides, it works fine when you call the form a second time . I was trying to send you the error message anyway, but I...

Thank you, GalaxiomAtHome. I´ll try it

I would like to know if there´s any way to get a Runtime for my applications built on ACCESS 2003. I need to know how to work with the Runtime also, if there´s any. Thanks a lot!!!