Search results for query: *

Having improved my usage of the Hyperlinks, I have now hit an unexpected showstopper ! Having already made entries directly into various tables, I have now created Data Access Pages to display the contents of those tables. That all appeared to be working correctly (i.e. all entries in the tables...

I am afraid this has just added to my confusion ! I have available 2 versions of MS Access, i.e. 2002 and 2003, and in both cases my toolbox for Pages provides, amongst other choices, a Hyperlink, an Image Hyperlink and a Bound Span but no BOUND Hyperlink field. I have found reference to such a...

I have an existing Access database where one table contains a field with a data type defined as Hyperlink. I have now moved that database to SQL Server (using the stndard conversion facility) which has now given that field the data type of Ntext. When I view that data, the field contents are...

The implication appears to be that you have joined 2 (or more) tables in the query. If you have, then you will need to ensure that the join properties for the appropriate links have been suitably modified, e.g. it may be necessary to establish the correct 'ALL:only' relationships.

Our environment has recently changed to XP and I am now trying to upgrade an Access system from 97 to 2002. My problem is that originally (under 97) I found that if I limited the form size in Design I would get the same size in Form view; however I now find that when I open it, under 2002, the...

Yes, I am sure I can - but this means I have to export the information and then re-import it. This is obviously somewhat more laborious and I was hoping I could just save the information directly as a table (i.e. Object Definition) as I used to do under Access 97. [In fact my previous posting on...

I have described in previous threads how I have built a 'mechanism' whereby I am able to extract details from the Object Definition created by the Documentor facility. In particular, under Access 97, I was able to store the online output as the table 'Object Definition' and then use Queries to...

GREAT ! I must admit I had thought that this would be OK for the initial input but would not work correctly (i.e. give me the 'friendly' value) when I subsequently retrieved that value back from the Oracle database. How wrong I was !

Thanks for the reply; unfortunately this is not quite the solution I require (I had a feeling my description might be misunderstood !). The MS Access front-end is only being used to create certain information which will then be utilised by Oracle SQL processing - in this particular case, certain...

Having built a new system with a variety of forms, I have been presented with a particular user request and I am unsure how best to solve it. This area of functionality involves the user supply certain information which will be turned into SQL instructions. these include the use of the terms...

Thanks for that tip - I have got the basics to work but, like yourself, cannot see how to supply any additional parameters. Does anyone else now how I might be able to automate this process ?

Being a firm believer in the use of metadata, I try to ensure that all table columns in my Access databases are provided with suitable descriptions. I have now written suitable queries to extract relevant detail from the 'Object Definition' table (created when I 'save the table' after I have...

You are correct in pointing out that I should have really raised this issue on the other forum. I have now got both alternative solutions working; interesting variations !

I am not too sure what form of coding I need to enter for the AfterUpdate event. Presumably I need to use/pass a parameter to identify which row has been selected. How ?

I have a Form with 2 pulldown lists. I wish to limit the output from the 2nd list, dependant upon the selection made from the 1st list (there is a one-to-many dependence between the 1st data item and the 2nd data item, where both items are present within the single table from which the form has...

The perfect answer !! (I had not used this feature before) This has allowed me to automate the whole process by using the 'OpenQuery' action within the macro. Many thanks.

Thanks for that tip. Using that information I have made use of the TransferDatabase action within a macro - basically it did work but unfortunately, it would appear I either create a new table from the original table or create a new version of the query itself (whereas in fact I wish to use the...

From time to time I have 'imported' a new table, based upon the contents of an existing table but using a query to modify that data (all in the one Access database). I use the Options in the Import Objects subscreen, setting 'Import Queries' to 'As Tables' - driving the whole process manually. I...

Well spotted - when I reduced the amount of code, I removed too much ! I have now resolved that difficulty and in fact have got it working with significantly more data items. I have now restored the full select and join code (see below) but have had to limit the number of data items declared in...

I have created a number of different (simple) merge instructions without problem but I now have hit a difficulty which is affecting several others. To isolate the problem I have simplified one of those but still have the same error condition (i.e. ERROR at line 7: ORA-00904...