Search results

Thanks to everyone for there help. It was a missing reference. Even though the .dll existed on my PC and the reference was pointing to it, it still did not recognise it. I copied the .dll from another PC and it worked fine. Many Thanks Chris

I have 2 PC's one that has Access and VB6.0 installed on it and the other which just has Access. I can use the trim function on the PC with VB6 installed, but on the PC with just Access when using VBA, Trim is not recognised. I have looked at the references added for both versions and...

Solved that problem. I am working with linked tables. These are linked to my DB2 database. I was trying to trim the database field. I had to move the value into another string then trim that. Which worked. So now I have the correct path, but.... I keep getting a message now that says...

Thanks for asking, I have now resolved this issue I am using the me.command.hyperlinkaddress = "address" which works. The only problem I am having now is where the database field I am using is 8 characters long but the content of the field is actually 6 characters I am getting trailing blanks...

Hello, I want to be able to hyperlink to a MS Word doucment, but I want the path to be built up in access. I have a database field called SDRNO, the value of this will be the document name. Using access VB can how do I build this up??? Any help would be much appreciated. Thanks Chris

Thanks very much that worked pefectly. Chris

I also have an Icon which you click on to add a new record. If I set this form property to no, will that disable the add icon as well? Many thanks for your help.

How do I stop Access from accessing a new record when I forward past the last record within a form? I currently have icons set up to allow a person to move bacward and forwards through the records. I want the form to stop at the last record not move into a blank one. Help would be much...

I have created an access database comprised of link tables connecting to my DB2 database on the Iseries. This has been working fine, but recently we upgraded to Iseries Access 5.2 with service pack, which changed all the ODBC drivers. I have since deleted all the link tables and re-linked them...

I would be for ever in debt to anyone who can help me resolve this. I currently have an access database which uses link tables to our AS400 database. I have a form over the main link table which a user use to log request changes. The data will be stored on the AS400. The database file has an...

Thanks loads for your help. I have found the problem...... i feel a bit red faced. Basically I thought I had both ODBC connections configured with the same name, but one of them had an extra space after the name!!!! I could not see this until I looked at the link table design in access. I...

Hello, The configiration of the ODBC driver is the same on all machines. If however I re-link the tables on another PC, I can then access them from that PC, but can still not access them from any other PC including my own. It's like there is some sort of ownership authority onthe ODBC...

I have a database which uses linked tables. I set the linked tables up using an ODBC datasource which I configured on my pc. It is a fairly basic configuration it just allows me to link the tables to our AS400 database. The problem is, that it works fine when I run the database on my PC, but...

Thank you very much for the link. It looks like a very informative website. Thanks Chris

Thank you very much for your advice. After much mucking around on Friday afternoon, I realised that I needed to have a primary key on files I wanted updating. I was initially linking to a logical view of the file through the AS400 but was not setting a key. I now link straight to the Physical...

I have a form which has been created over a linked table. I want one of the key fields to automatically increment by 1. I cannot alter the design of the field to auto number because the table is linked. I have created a query which gets the maximum number for that field on the database...

I am currently link to my AS400 DB2 Database using a linked relationship within Access. I am unable to update any of the records though Access. It keeps saying that the recordset is not updatable. I have set my ODBC driver to read/write but this still has no effect. Can anyone...

Just one more questiom, where can I purchase a copy of the Developers Addition of MS Access? I am trying to trace it down on the web, but am not having much luck. Thanks Chris Rice

Thanks for your response, this sounds like a good path to take, and I am looking into purchasing a copy now. Many Thanks Chris Rice

I have created an access application which I need to distribute to a range of users. The application is linked to our AS400 database using link tables and therefore could pretty much stand on it's own. Not all our users have MS Access, and we would need to buy more licences for them to have it...