Search results

I had a file in MSACCESS 2003 that works fine, makes graphs smoothly. When I change to version 2016 of MSACCESS I cannot change scales without getting the PC hanged out. How can I avoid this inconvenient?

arnelgp: Thanks a lot for your help! Your messages allowed me to solve my problem, though I could not make the If command work

Uncle Gizmo: I find your comments absolutely unhelpful and rather insulting. I had the impulse of getting off the Forum forever. Is that what you want?

Thanks, arnelgp! In fact, my data don´t have a space, it´like P0101/P0102. But I don´t know what am I doing wrong, ´cause I cannot make it work: I´m attaching a very small database, with just a Table and a Form with the procedure. Perhaps you could tell me what error I´m making. Thanks for that...

Tank ypu, both, arnelgp and Isaac. I´ll tried all the ways you told me, but I guess I need more help, since my knowledge of Vbasic or ACCESS is not very strong. Here is the thing: I have a person filling data on a form, in a control named "partan". I need to split the text he enters whenever he...

Thanks a lot, arnelgp. I will try this and let you know how it turns out

I need to separate text data like P0101 / P0102 onto 2 records P0101 and P0102. How can I do that? Is there any function in my ACCESS 2010 that may allow me to do that. Thanks a lot for your help

I have an application in ACCESS 2003 that runs a macro that needs to be iterated more than 20 times in some occasions. In those cases appears a sign that states that a macro cannot be called by itself more than 20 times. Is there any simple way to override this obstacle, since I don't know VBasic?

Thank you, Arnelgp. I´ll try it and let you know how it worked

I work with ACCESS 2003. I save all my files in ACCESS 2000 format. I´m working with several people using ACCESS 2010, and find it awfully annoying to try to synchronize data among the different users. It always sends a message of "Too many Locks per File". I increased the Locks per file with a...

Thanks a lot, Lorein0688: I´ll try your advice very soon, and I´ll let you know how it worked.

I´m using ACCES 2003 and ACCESS 2010 in different PCs, with Replicated Tables located in a single file (in order to share them between different files of a single Application). I realize that the file with the Tables grow very much, as far as 800 Mb, when I make the Tables replicable. It´s there...

I´m using ACCESS 2003, as well as ACCESS 2010. In both of them, I´m sometimes getting an Error Message stating "Error 2950: Query is not updatable", a message that repeats itself for between 5 to 30 times in a row. It´s very annoying. I have to close the form that I´m working with, re-open it...

I´m trying to export it as txt file with Export Command, as an fixed column width file. I´m attaching an image so that you can see the data as well as the specification of the exportation

Yeah, some of the ENTRADAS have about 20 or 30 characters

Thank you, vbaInet for your prompt answer. The field name is ENTRADA, and the data are taken and selected from a Table named RESULTADOS. The field is text, and there´s only one other field that is text, which is CódECR. All other fields are numbers, but none of them are calculated in this...

I´m having trouble exporting a query from ACCESS 2010 to a .txt file. I have a field in the middle of the query, and I cannot get the data of this field unless I put it in the end of the query (as the last field). I think I must be doing something wrong, but I don´t known what may that be. Any...

Thanks a lot, JC London. I´ve done it, and it worked fine. I had to increase the MaxLocsPerFile up to 40000 to make it work fast enough. Can you tell me were can I read about this feature? I would like to learn what was the problem and how I fixed (with your help, of course). Thanks again

Thanks a lot, CJ London: I´m going to try it and I´ll tell you later how it went.

I have an Application with several users that share tables located in a Design Master file at a server. The tables are shared in several computers with a Replica of the Design Master in each computer. When we try to synchronize any Replica with the Master Design, it gives back an error message...