Search results

Hi All I have a query to which I need to add a charge. The query is based on table1 but the charge is only added if a yes/no field in table2 is true. This is what I have tried but it does not work. Charge: IIf([Table2]![Field1]=True,Format("25","Currency"),Format("0","Currency")) Any...

Hi All I have a macro which deletes line 2 of a csv file and converts all values in existing cells in columns K to AC to a currency format. This works well. What I need to add is code to check column D and if cell value is "OWO" then modify cells in columns K to AC in same row to 0 (zero)...

How do I change the following criteria. Charge: IIf([UnitCode]="P005",25,55) I need to apply this criteria only if it is not equal to [table] [field5] is not equal to "can" and if it is equal to can then value will be 0. Can't get my head around it. Evan

Hi all I have a database created in access 2010 on win xp. I have calendars on some forms that pop up when date field selected and it works well. My problem is that on new machine with windows 7 and access 2010 you get a debug message pops up when date field selected but is still fine on xp...

Hi All I have this in my query which seems to work but it keeps asking for input when running report based on query. The table field is yes/no. Deposit Charge: IIf([Table]![Field]=True,Format("5","Currency"),Format("0","Currency")) Any ideas why. Evan

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

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

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

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

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

Hi All I have searched the forums and can not find anything that suits my needs. What these are as follows. I need a command button on a form that will allow me to chose an .xls from a directory and add to the existing data in an access .mdb table to an access mdb file. I am using access...

Hi All Hope you had a great festive season. I have searched the web for an answer to my problem to no avail so I hope someone out there can help. My problem is that I have created a query for my register table and have set in the criteria for the reg_no field the following code. Like "*"...

Hi All My problem is this. I have a Table that I need to query. The field I need to query by is a combination of two fields in another table selected at time of data input. It contains job number and model type. I need to query it by job number only and I need user input to select the job...