Search results

Hi I was wondering if anyone could give me some advice. I'm currently setting up a data entry form. Within this dataentry form is a one to many relationship. One person can have many jobs to do. However 99% of the time they only have one job to do. As a result however I've had to create a...

Hi I was just wondering if I could ask some general advice about crosstab querys and whether I'm going about it the right way? I am currently creating a database which involves creating many crosstab queries for a client which are then viewed through reports via a searchform. Because the...

Hi I'm working on a search form which is then used for reports and I'm nearly there. It consists of a couple of combo boxes and one multiple select list box field. I can get it to work of sorts. The database is based on a menu. The user has to choose the course i.e. starter (TypeofCourseID)...

I was wondering if anyone can help. I set up a search form so that the user can select five criterias and press preview and a report with the data based on the criteria appears- it all works fine but now I have another problem. As long as the user selects all criterias (of which I have five)...

Thank you! That has helped me greatly!

Hi I have a form that I'm using as a search/filter form. The user has five combo boxes that they can use to choose their criteria and then I want them to beable to click a button and preview a report based on the criteria in the form . Have got to creating the code for the Preview button but...

Hi Wayne Just to say I've figured it out in a moment of inspiration. I've created two queries and it works! Thanks for your help! Carrie

Hi thanks for your advice. I've had a go at doing this but when I apply a filter, it doesn't seem to work! Bit confused!! Are there anymore suggestions or anything else I can do to sort this problem out????? Thanks Carrie

Hello Can anyone help. I have some data which I want to put into a report. It's best to explain in an example!!! For example 100 people were asked to rate the quality of a meal from 1-5. I want the rating 1,2,3,4 and 5 to appear on my report as labels so that even if as in the case below no...

I have just been asked to create a database based on some questionnaire results and wondered if anyone could help as I'm already stuck!!! It involves percentages. Basically I have 200 respondents who have been asked their opinion on 4 snacks- Biscuits, Cake, Icecream and Jelly. They had a...

Thanks I'll give it a try

Hi I was wondering if someone could help. I have a check box field and when I click yes for this field I would like another field to update with the following data "interviewing". Does anyone know how to do this as I'm a bit stumped. Thanks in advance

Thanks for your reply. Unfortunately that's what I tried first off! I've tried again but still to no avail! I will just have to play some more!

Hi I'm having a problem with sorting a field on my subform. Have tried setting the sort on the table, query, and orderby property and am still having no luck. It sorts ok as a form on it's own but when it is part of a subform it sorts on the master/child link field. Is there any VBA or any...

Links of child and master Thanks for the advice! I did work it out eventually last night!!! It was because my control source and name properties were the same on the subform field being linked to the main form. When I made the name property different to the control source it worked!

Hi I have a form and subform on Microsoft 97. The link is the job number. I have linked this up on the master and child links and every is fine. When I input data onto the subform the jobno automatically populates. However I've had to export this form into Microsoft 2000. Although the...