Recent content by tinker

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...

Thanks for your reply Although it is bound to the ID field, because it has a lookup set up bringing back a narritive i assumed it would find i narritive value aswell, looks like i was wrong In that case is there any other way of searching for a narritive in the combo boxes which are number...

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...

Hello, I was thinking that, but the record would have to be saved before the notes contents would appear on the report( beacuse the report would point to the table or a query based on a table). No doubt our users would be complaining that to print you have to save it first. Hope ive made...

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...

Thanks for your help rich but it doesnt seem to show me what i needed. Can anyone please tell me where i can download solution.mdb because im hoping this might have some good examples.

Can anybody help me in finding the download for qrysample or even solution.mdb. (I thought solution might of come with office 2000 but its not there). Thanks

Could you post the link for it please, as i cant find the page. Ive looked for this in the past but have not been able to find it. Thanks

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...

Thanks for your help but its still not giving me the desired results. What ive done, Ive included AD ID as a row header, this is a unique ID. The problem ive got now is that every record is now on a different line Please Ignore the dots .......Jan...Feb...Mar...Apr...etc Vogue..10...

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...