Search results

Hi Boyd Have been fiddling with the code from your batch print db and no matter what i try i just can't get it to work completly. Firstly when running the form i can't gry out the last selection which makes a new record in table if accidently selected. Secondly when previewing selected records...

Giving it a try now but looks OK Thanks Boyd

Worked a treat. Thanks All

Hi All I need to show in a query costs of cleaning. If [field] is L5 or L8 then it is 5 if [field] is P5 then it is 25 all other values are 55. Evan

Dear Boyd I am using access 2010 for creation of database but operators will be using access 2007 for reporting and data entry. Evan

Hi All I have a form to run a report via a query with criteria. I have a combo box on the form to select the criteria to run the individual report. What I need is another button to publish as pdf all the reports individualy from the list in the combo box. Eg; List in combo box 1 2 3 4 5...

Hi All How do I show the value of a Table field in an access report header depending on value of field in the query that links to the report. Basicaly If the value of field a in the report is equal to poo4 then I need the report header to show the corresponding value of poo4 from another...

Hi All I have posted this query before (last year) but was forced to abandon it due to a death in the family. Now that I am back on track I need some help. I found this code on the forum which works to a degree. If I run the code it adds the records to the database fine. but if run again...

Happy Holidays All Todays problem is as follows: Table 1 field 1 has data like A1 or A2 or A3 etc. Table 2 will have 3 field A1 Left Up A2 Left Down A3 Right Up What I need is if the query runs and the value from Table 1 = A2 then I need the query to display...

I have moved this thread from tables as advised. My problem is that I use the attached code to import an xls into my table. The xls has a number of fields (field1, field2, field3 etc)which are set as a general number ie: 12345. When imported into my table where the fields are formatted for...

This is the code I use I found it on this site and it works well enough for now. Is there any way to add this divide by to this code. Thanks Evan Option Compare Database 'This code was originally written by Ken Getz. 'It is not to be altered or distributed, 'except as part of an...

Hi All My latest problem requires some assistance. I import an excel spreadsheet into an access table with a command button. My problem is the xls comes from an outside source and contains a number field which is actualy currency but shown as a number ie: 34500 to represent £345.00. When i...

Hi All Firstly let me thank you all for your assistance over the years and wish you all a Merry Christmas. I found this code on this site and added it to a button which works well. When first run it imported all the fields and created a large table. As I didn't all the fields sent to me I...

Thanks to all for our assistance. Both scenarios worked fine. Evan

Paul You were right about the misspelled field name but when corrected I still get an error in the field when running the query. Here is a sample of my db.

Paul Thanks for the quick response but it didn't work. Whichever way I tried it I would get a text box asking for user input of how many children in party which I don't want. Then no matter whethrer I left blank or entered a number I would get an error in the query when run. Any other...

Hi All I have a query which I need to concactenate three fields with a following text string. The expression I use is as follows: Guests: [Adults in Party] & " Adult + " & [Child in Party] & " Children +" & [Infants in Party] & " Infant" How do I get this to show only fields that have data in...

When data is input to form via xls import fielda in table 1 has value eg:IL001. In table 2 Fielda has values simillar to this and I want it to auto populate fieldb and fieldc in table 1 with values from corresponding values in table 2. Eg: Table 1 Fielda Fieldb Fieldc IL001...

Hi All I have another problem and I don't even know where to start searching for a solution. Is it possible to have fields populated from data in another table when a certain table has a particular entry. The example is as follows. When fielda table 1 = abc this is the same as field a in...

Thanks to all for your help. I found a bit of code that works on the links on this page. I might need some help later but it seems to work fine at present. Evan