Recent content by JasGun

Hi, I have a table example below and I need a query to format it in a different way, but, I am struggling at the moment. Current Table: Pol Hdr1 Hdr2 A Type Av A Date 26/06/2003 A Ccy GBP B Type NM B Date 01/07/2003 B Ccy USD...

Terry, Any chance you could Email me that zip file as I'm stuck on the same problem? Thanks Jason Email: jason.Gunter@Capita.co.uk

Hi, I wonder if anyone can help. I have a unbound form, with an Unbound combo box giving me a list of numbers. I also have 3 sub forms based on queries, in the criteria is the combo box value. Each time the combo box is change I requery the sub forms and the data changes which is fine. But...

Sorry if I didn't make myself clear. What I need to automate is select the first value in the combo box then print a copy of the results then select the next value in the combo box and then print that one so on and so on......

Hi, I wonder if anyone can help. I have a combo box on a form which is based on one field. Each time the user changes the combo box value the financial information below it changes.This works fine. But, What I now need now, is, instead of going through each combo value and pressing print on...

I have imported a text file from a in-house Database. One of the fields has various speech marks before after and in between the string e.g. "Help Me" """Help Me""" ""Help" Me" I could write a write a proceedure to get rid of any...

In my department at work we are using Access 97. When we create a database for a different department some of the functions don't work on the machine e.g. Right(), Left(), date(), Now(). Does anyone know why the work on our machines, but, not theres? If you know how to resolve these I would be...

I have a table with 4 fields. The first field contains text and the other 3 contain amounts. I also have a form that is base on on the table above. In the form I have a combo box relating to the text field. And 3 text boxes relating to the amount fields. What I would like is when I select the...

I tried the way AccessSQLUser suggested and it works fine. I also tried adding 'All' in my table, having a text box which wasn't visible. and as its Control source was '=iif([combo]="All","*",[combo])', then in my query in the criteria was 'Forms!Form![HiddenTextbox],I...

I have a combo box that is unbound. Its rowsource is based on a query that is based on a field in a table. I want to add 'All' as an option in the combo box. Can anyone help?

I have a report that has a grouped header. If all the data doesn't fit on one page on the next page I would like a label to show "(Continued)" at the top of the page, until, the next grouped header and so on. Can anyone help?

I have a form as a main menu with several command buttons. When a button is pressed I want the current database to close and to open another database. I'm not sure of the best way to do this, can anyone help?