Search results

I have a report with a Subreport. The subreport is based on a query, the query has a criteria on a field called continent which relates to a multiselect listbox located on the selection form. The listbox is populated with continents of the world e.g Europe Asia I need to be able to select...

Hiya. On my main form i have several combo boxes, all of which use Lookups Everything appears to work fine until i use access 2k s inbuilt find facility to find an occurance in a certain field. For example if i do a search in the Country field for Great britain it wont find it even...

Hiya, I should really know this but ive got a text box which is used as a notes field. I then want to have a cmd button underneath, which is used to print the text in the textbox to the printer. I dont want to use docmd pintout because this prints the whole form, and i dont want to print...

Hiya, Ive been asked to email a little database which i never created to an external client. The database works fine on my PC. The database was created in Access 2k but the client has access97 so i converted it to 97. The client gets the error 'Compile Error: can't find project or library'...

Hiya, When creating a database from scatch, im trying to open a recordset by first setting dim d as database, r as recordset, mysql as string then i set r = d.openrecordset(mysql) but it doesnt recognize the word database. (ive never set up a database from scratch before, ive always made...

hiya, I need to create a crosstab report with a Publication name as the row header and the week date as the row header with two value fields. I have two crosstab queries, (The reason why i have two is because i want two value fields, so i have 1 crosstab query for each value field i need) and...

Hiya, Ive got a crosstab querie which i want to be used by a report. Ive got a Value field which is a numeric field, but alongside this id like a text field (so that for every value id like the corresponding text). Is this possible. Because the corresponding text comes from a different table...

Hiya. I need to create a report, which i suppose would best be done using a cross tab querie. Below is my crosstab querie The following fields are to be taken from two tables The row header i want as the Publication field, e.g Tatler, Vogue. (from table 1) The column header i want as the Date...

Hiya, I have a report which holds all information regarding Advertising Campaigns, and comprises a subreport which displays all the suppliers which belong to the advertsing campaigns (One to many relationship, linked on an ID field). I have the Subreport in the details section of my report...

Hiya I have a field on my report which i use as a group by. It can have one of 6 values, and i was hoping to display the backcolor of this field a different colour depending what the narrative is. But i noticed that i can only have three conditional formats, is there a way so that i can have...

Hiya, Is it possible to Concatenate fields of a report onto one line for example. If for example a table has the following records ID Hotel 1 Burj Al Arab 2 Cobblers Cove Would it be possible to display these records on the same line in a report. e.g Hotels Burj Al Arab,Cobblers...

Hiya, Ive recently taken over development responsiblities for a company loans database, but im having difficulties making changes. This may be a silly question, but when i access the database in design mode, for some reason it doesnt give me normal menus (File,Edit,View,Insert etc.), but...

Hiya, I've posted a longer version of this msg before but i think it might of been too long winded. Is it possible to run an append query which is activated by a macro when an item in a forms datasheet is selected. I want to append the CID field from my consuables table into Consumable Id in...

Hiya Im still having difficulties querying a query depending on the value selected. Ive done a bit of experimenting. The sample program consists of a table, querie and a form. In the table i have one field with several page sizes in it e.g "5*4", "A4" etc. The query is based on the one...

I have a table which has a list of countries, and another with details of which hotels within these countries have paid money. I have grouped this table so that i have a list of countries which have paid money. I then created a query with both tables, which have a relationship based on...