Search results

Hi Spikepl, got one step ahead, only one, still a long way to go - its terrible. I got to the address thanks o the IE9 F12 developper tool, which shows the hidden code. Now I can put the number at the right place. MHTL is '<input name="subviewCorpoPagina:pesquisarProcessoForm:j_id57"...

Hi Spikepl, the problem right now is not a delay, but to find the address where to put the register number. I am not a AJAX specialist, last time I used HTML was years ago, sinds then things changed a lot. But it looks to me that the place I need to put the nbr is not in the source code. I...

Thank you Spikepl for answering. In the mean time I got somewhat more insight in how to get/put data from/to an internet page. This is fine for a static page; my problem is that the site I am interested in uses AJAX, i.e. the source code changes according to answers given. To be a little bit...

Hi all, I have been looking for a solution, still without success, for something very useful, but also quite a big challenge. On the internet there are a lot of sites which display a follow up for processes, products bought etc. like e.g. the post office. I want to supply my processes, running...

Thanks mdlueck for replying. Yes I did; to be sure, I killed the link and re-linked the table, however Access made the same arrangement. When I add new functions to our system, I normally create and check things out in an Access-BE, before creating tables in our SQL Servers. In Access there...

In my Access(2007) Frontend linked to a SQL Server Backend (2005) application, the SQL Table [SE_MesMatEng] has besides the PK [IdMesMat], a unique indexed column [NumMat]. CONSTRAINT [PK_SE_MatMaq] PRIMARY KEY NONCLUSTERED ( [IdMatMaq] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF...

I would do this dumb test. In the SQL Server: 1. Rename one of the problem tables 2. Create a new table with the former name. 3. Copy all data from the original table to the new table See if you can access the new table through ACCESS.

Hi FoFa, I didn´t got right your former return, I understood you were using a ODBC-less connection, but you wrote a DSN-less connection. A lack on attention, probably wishfull thinking (may be because some time ago, someone was criticizing ODBC links to SQL saying .adp can do without ODBC.)...

Thank you for answering FoFa. It is always nice to meet someone who has the same problem, especially when he has a solution! As nobody seems to have a solution for the ODBC problem I face, I would like to try your ODBC-less solution, it might be a way out or even a better way to do things...

I don’t know if I got your doubts, but sharing data in a Database environment like ACCESS, normally means breaking the App in two: one central database called Back End (BE), where all data used by all users is stored, and a man machine user interface, called Front End (FE), placed in each user...

Our FE/BE Access (mdb)/SQL Server application is doing very well in a corporative environment for months. However last week, when we needed to introduce an upgrade to the system, adding new functions, the swapping of the FE links between the SQL Servers (2000) for testing, homologation and...

Re: Please help. Error when inputing more than 255 characters into a "memo" field As I mentioned before, delete the field in the form and create a new one. I only had this problem once and it was easely solved this way.

have also a look at http://www.mvps.org/access/forms/frm0034.htm

As one never should input data twice, I am not sure that I understood your question. If you need to share data between applications you just link the tables. A frontend can access several backend’s at the same time, as a matter of fact it doesn't matter where the data comes from. (If you use...

Thanks for replying HiTechCoach The problem with single tables is that they often don’t show all the info you need to edit the table data, each time you use a pointer the info is in another table. Depending on the design of the relationships, it is not always possible to construct an updatable...

With normalized tables one always runs into non-updatable queries that don’t let you put the data in the tables. To get around this, the table that needs to be updated is used as form source and sub-forms display the needed additional info of the tables that otherwise would lead to a blocking...

Hi Dfenton, If it is not too much work to look it up, I think a lot of people could be interested in seeing this MS statement.

Tim, I don’t believe this, it works! fantastic, I was preparing myself to copy, delete, add columns. Thank you very much.

Hi Pat, Hi George, Thank you for replying. Tabledefs collection: as far as I know there are no commands to change things, only to delete, add (new created) objects. DDL: is almost the same, a very limited command set: Create, Alter and Drop. e.g. ‘you cannot create "AutoNumber Replication,"...

Hi folks, One can manually change the Type of a Table Column from Autonumber to Number (long int). Is it possible to do this with VBA code? Thanks for any hints.