Recent content by paulS30berks

I have written some code that will output to a spreadsheet in a given location: how can I rework this code so that the excel output displays on screen rather than saving to a specified location: Code Written: Private Sub outputToExcel_Click() DoCmd.TransferSpreadsheet acExport...

I wondered if someone could help. One of my users is able to open ms access but cannot run reports due to An "OpenRecordSet macro" missing Is this something I can add back in or a reinstallation of MS Access onto the Users Pc? Many thanks Paul

I wondered if someone could help. I am using the Val () Function to convert a text field to number within a query which still gives me a text output. P.S I do not have permissions to change within table as using Access as a front end to SQL via link Tables.

I have run two columns: Period20060: IIf([period]<>0,[valuehome]) Period2006: IIf([period]=0,[valuehome]) and receive restults for period=0 but not for <>0. Can anyone help?

Sorry maybe silly question, how can I write this within a select query: Select Year, Iif([period]=0,"0","1-4") as NewPeriod, sum([valuehome]) from yourtable group by Year,Iif([period]=0,"0","1-4")

I have written the following expressions within my query: period 1-4: Sum(IIf([Forms]![fixed asset register]![period]>"0",[valuehome])) and period 0: Sum(IIf([period]="0",[valuehome])) but the query is too complex to run.

I wondered if someone could help. I have 3 columns of data within a table and from a select query am trying to seperate certain groups. Table 1 yr period valuehome 2006 0 100 2006 0 10 2006 1 1000 2006 1 800 2006 2 60 2006...

I am looking at writing a statement such as: Expr1: Sum(IIf([period]<=[forms]![fixed asset register]![period] And Not ([period])=0,[value])) but no results show

Many thanks for your reply, much appreciated. I do need to seperate period 0 from the other months. i.e period 0 - value period 1-5 - value Thanks

I wondered if someone could help I am querying a table using a select query. The data I am pulling from the table is in format: Period Year Value 0 2006 1000 1 2006 100000 2 2006 500 3 2006 5000 4 2006 50000 5 2006 200000 In my query, I wish to seperate: Period 0 + value from...

thanks for your reply. Each Employee has a different threshold (there are 8 thresholds per employee) and there are some 11000 employees. I have tried to place contents into a spreadsheet draw up a pivot table and then placing into a table - just seems alittle long winded.

I have written the code below, which should work, however I am receiving an Error: Run Time Error '13' Type mistmatch on line: Set cn = Application.CurrentProject.Connection. Can anyone help? Option Compare Database Option Explicit Private Sub cmdRun_Click() Dim NICode As String Dim rs As...

Thanks for your reply, however I am trying to look at another way of querying the data rather than breaking down into seperate tables.

I have an employee with an NI Code of A NI Contribution thresholds are in the format: A1a A1b A1c A1d 1000 100 10.00 50.00 However there are many NI Codes and many columns of thresholds for each Code. I am trying to write a query to say: If NI Code = x then give me...

An #Error is shown for all records