Search results

Hi I've created a listbox and am using the following code stWhat1 = "": stCriteria1 = "," For Each vItm1 In Me!LstArchive.ItemsSelected stWhat1 = stWhat1 & Me![LstArchive].Column(0, vItm1) stWhat1 = stWhat1 & stCriteria1 Next vItm1 Me!txtCriteria1 =...

Hi I've been looking on the forum to try and find my answer but am struggling to find anything! I have a combo box which I am validating by using IsNull. This works fine untill someone fills the combo box and then decides to delete it leaving the combo box empty again. My IsNull then does...

Hello I have just created a database which is now in use. However there is one issue that keeps arising. I have set up a startup form and from this the user chooses an area of the database they wish to go to. For example if they wish to setup a job they go to the form Setup Job. Once...

Hi I've got a database application where I have disabled my menus/toolbars using code from the forum. It works fine. However when anyone else goes into a separate database/new database they find they have also lost all their menus/toolbars in these databases. Is there anyway to get round...

Hello I was wondering if anyone could enlighten me a bit. I experienced a corruption in my database today. Fortunately I managed to sort it out but decided to look on the forum for any clues to why it happened. I came across the Jetcomp.exec compact utility. My problem is that I need to...

Hello I wonder if anyone could help. I have converted my jobno field from a number field to a text field. Unfortunately while doing this process any jobs that have a zero at the front have had the 0 wiped out! i.e Jobno 00679 is now 679. Is there any code I can use to put back in the...

Hello I was wondering if anyone could give me any tips on compacting databases. I've just completed my database and I plan to split it and put the backend on the server and the front end on everyones computer on their c drive. Originally I thought all I'd have to do is compact the backend as...

Hi I'm currently setting up a form which has a main form and two subforms. At first I could get it all to work and scyncronise fine. I then decided to help make data entry easier by breaking down the two subforms into tabbed controls. i.e. The first subform is split into three forms...

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

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

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

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

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

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