Search results

Does anybody know how to add an option that says 'none' or 'no selection' or something to a list of combo options. I use a query by form to produce a report. But I may close that report and it goes back to the form. If I want to re-run a new query I have to close the form and re-opne it so the...

where = where & " AND (([Noise]>=50) OR ([HAVS]>=50) OR ([Skin]>=50) OR ([Respiratory]>=50) OR ([Biological]>=50)) " Cracked it! Messed about with it and copied the SQL code from a query in design mode. Seems to work, just needed more brackets.

I have managed to get my QBF form to work with one fixed parameter. here is an section of the code: where = Null where = where & " AND [Noise]>=50 " '[HAVS]>=50 OR [Skin]>=50 OR [Respiratory]>=50 OR [Biological]>=50 " If Not IsNull(Me.[cboCategory]) Then where = where & " AND...

I'll try and make this concise. I have a QBF with code from this web site and sample DBs. It works well and uses the DAO object library. Up to now I have been winging it with code basically. I want to create a new QBF with addition pre-set search parameters in addition to facility to be able...

Hello, I have a QBF routine that I have been using to produce tailored reports form my DB. I want to create a new query using QBF to allow the users to select different parts of the business but also using some static rules to return the data. I am returning list of employees based on some...

I have a table linked to another table in a one to many relationship. I am trying to get a query to work out some statistics by group the many records on the right table. I can use the group by function and the built in functions such as min, max etc. However, I need to do slightly more...

But in the table the information is displayed correctly i.e. the text value based on the lookup from the other table. Why can't the form display the same? It works when displaying the information for that field on each record, but not for this unbound combo. Anyway around this, all I want to...

ok, so it wasn't a simple option I was missing. Thanks for that.

Tried changing that and if it displays both column they both show the same thing - the ID value and not the text value. Is this because the column I am using as the look up for the combo from the main table looks up the value from a separate table of choices?

This should be a simple one but I still can't manage it. I have a table on which my records are organised in alphabetical order by one field. On my form which uses this table as the record set the records are all over the place and it is a nightmare finding the record I want. I don't...

Hello, I have a form and I have added a combo box to quickly find records. I used the wizard to set this up as I did not know the code. Anyway this works, but it displays the wrong value - it displays the ID number and not the text value from the table. The record source is a table not a...

Hello, I have a combo which I have set to activate successive combos when a selection is made in it. Unfortunately if you delet what is in it i.e. to make it empty it does not deactivate the other combos. I presume this is a peculiarity with combos as once you have clicked in it it is active...

Hello, I have two tables main tables in a one to many relationship. Main table is 'tool info', primary key is tool serial. Each tool can have many records assigned it containing 'test data' in a seperate table. I have set up a QBF to allow me to produce a report based on parameters such as...

Thanks, but what code do I use to check the value. I'm trying a few permuatations here and obviously missing something simple. Thanks for your help.

Hello, Dopes anybody know how to activate/deactivate fields for data entry on a form based on another field. I have a check box whcih when checked I would like to activate two other fields and when unchecked to grey them out. Can I do this?

Hello, I would like to create a routine which will import details from a number of columns in a defined Excel worksheet into my access table. I would like it to add new details and update exisiting details based on name. I know I have to use some extensive VBA programming only my skills are...

I have a number of categories on which I assign a relative risk - at the moment H, M and L. Previously I had these set as a value selection combo and they were as 'text'. More recently I have changed this now to a lookup and put the risk rating into a separate table. As a consequence the field...

Hello, I have a fairly small DB tracking employee details and job profiles. Every so often I need to run a manual update of employee details to add new employees in and amend current employees details such as names, job title etc. I currently do this manually, which is still a nightmare. How...

Worked perfectly, thanks very much for your help once again.

Yes, I currently select my criteria using a series of combo boxes on a form. I had overlooked the fact that I might need to actually identify what criteria the report referred to once printed out. Your replies sound good. I'll give this a go today. Thanks very much for your help.