Search results for query: *

Hi I recently posted another message relating to subforms in my library catalogue. This problem is that I have an interface to the catalogue to enable searching for information in several fields. The main form has a subform linking to a table titled Subject Keyword. When I catalogue an item...

I created a library catalogue using Access and the main form to enter details includes a subform to assign subject keywords for each item catalogued e.g. a book. The subform is connected to table containing the Subject Keywords. There is no limit to the number of subject keywords I can assign...

Dear Team I have inherited a poorly designed database and one of the problems is that a field has been set up as Indexed - Yes (No Duplicates) when (Yes Duplicates) should have been selected. This table only has an ID field and one other text field which is the primary key and is the one I...

When exporting a report into Excel all the text in one of the memo fields is incomplete. Has anyone else experienced this problem and found the solution? cheers

The query is in the right order but the data is being exported in a different order.

Thanks but the problem persists.

This is another posting along the similar lines of #1. After exporting data from an Access report into Excel not all the data from one field is being exported. It's field called 'background' and the contents varies upon the individual it is describing. Does anyone have any idea why its...

I am exporting a report to excel but the first column in the access report is transposed to the seventh column in excel. Is there a properties field that I need to adjust for the report to be exported correctly into excel? thanks for your help in advance.

Hi I'm building my second db. I've got 2 subforms in my data-entry form. The first one is fine. The second one is based on a table with 5 fields. I would like one field to be displayed (Publication reports numbered 1-46) and after selection the remaining associated fields appear and then the...

Hi Lilliabeth There is no problem if I run the query. Its just in the report. I tried grouping on the report and that hasn't worked. But there is a new development with the report. The second named person with the same surname appears with only their records but the first person with the...

I have a report where there are two people with the same lastname but different firstname and the report relating to those two is presented under the first person only. Obviously there is either a problem with the query or table. Should firstname and lastname be linked somehow? And is it too...

Hi LittleSmudge I have the answer now. I thought the changes on the BE should be reflected in the FE, but they aren't. So your advice was correct. My database was split after the tables were constructed, and I wasn't aware that the tables in the front-end shouldn't necessarily reflect the...

Hi LittleSmudge It's still not working. This time I started from scratch. With the FE closed, I opened the BE and added the new hypertext field to the table. I then checked that the relationships revealed the new field in the appropriate table. Check check. I then closed the BE and opened...

Hi LittleSmudge Ok I've added the new field and then had to give the table a new name, and then updated the table links because yes my db is split. I believe I have to now re-establish the relationships but as its sometime since I created this db and its my first real on, I can't seem to get...

Hi This will be a very straightforward question for someone. I have an established database and need to add a new field (hyperlink) to my main table. I've just tried and the new field isn't appearing. I intend to add this field to my main table and reports. I realise that I will need to...

Thank you - knew it was going to be straightforward stealth

This should be an easy question - I would like to add a new field to my main form. The new field will contain hyperlinked documents from the web and/or the local network. Could a modification affect my database and queries, reports, tables etc? Should I create two fields, one for weblinks...

Hello I have a menu (form) with three command buttons titled Author, Title and Subject Keyword. When I click on one of those buttons it opens a text box with the cursor in it. After the user types in their search query, they must then use the mouse to click on the command button titled Search...

Thank you. I will leave it as it is. cheers Stealth

Thanks Lightning However not all the contents in that field would be hyperlinked. I only include a URL or local server address if the document is available electronically. I thought that I could select the URL and hyperlink it.