Search results

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

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

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

I wondered if someone could point me in the right direction. I am pulling dates from a table in the format: 7092000 11092000 How can I reformat to: 07/09/2000 11/09/2000 Thanks Paul

I wondered if someone could help. i am running a report from Access and have set up a label within the detail line to include a sequence no. to the results. I have included the code: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) xx = xx + 0 LblSeqNo.Caption = CStr(xx)...

I wondered if someone could help. My query is set to show all Live employees with certain benefits by a particular date. So I enter date: 15/05/2006 and all employees with benefits are shown. Some Employees have a set leaving date, how can I set the criteria: If an Employee has a Leaving...

I am running a report from a form that is to produce an excel output: Private Sub cmdTransferToExcel_Click() On Error GoTo Err_CmdTransferToExcel_Click Refresh DoCmd.Hourglass True DoCmd.OutputTo acOutputQuery, "Temps_Margin_Output", acFormatXLS, [Forms]![Revenue_Output]![output], False...

I am running Access as a front end to SQL and maintain all reports and forms from a .mdb. I then release an .mde to a different location for end users to use. Each time I release an .mde and a user attempts to run a report an "ODBC call failed" error appears. So I have to re-link tables on...

I have a SQL server 2000 db and using MS access 2003 as a front end. Report maintenance is handled within a seperate directory. We then release the .mde's to a directory from where Users have access. Reports all work fine until we release an .mde. Some users experience an ODBC Connection...

I have a table that contains 2 columns: 1 = Deduction Reference Code 2 = The Value associated with each Code. for example Deduction Reference Value 999997 10000 666 6000 Code 999997 duplicates the value within code 666 so I...

Can anyone help? i have set up the delete query: DELETE dbo_MP_Audit.*, dbo_CAD_SINV_HEADER.SIN_CANCELLED_YNF FROM dbo_MP_Audit INNER JOIN dbo_CAD_SINV_HEADER ON (dbo_MP_Audit.Usr = dbo_CAD_SINV_HEADER.USR_CODE) AND (dbo_MP_Audit.Sin_DocNum = dbo_CAD_SINV_HEADER.SIN_NUMBER) AND...

I have set up a delete query and wish to run this through VBA. Can anyone point me in the right direction on how I can instruct my query to run through VBA code. Thanks Paul

The date format from one of my access tables is as follows: 11051977 9101978 and I need to amend to following formats within my select query: 11/05/1977 09/10/1978 I have tried using formula: Date of Birth: DateValue(Mid([DOB],7,2) & "/" & Mid([DOB],5,2) & "/" & Mid([DOB],1,4)) that...

I am using the formula: Normal Pay: Sum(IIf([PAYCODE]="STD" Or [PAYCODE]="PAY_R" Or [PAYCODE]="RATE*",[AMT],0)) . as an expression and need my query just to pick up one row with a total sum of these values, however I am still receiving 2 or 3 lines of seperate values. Can anyone help? Thanks...

I have imported a link table into access. The Year field I wish to search on is Text. I have entered a wildcard before the year i.e *2003 within the criteria, but still cannot read the number. Can anyone suggest anything? Thanks Paul

I am running a report that is built up of several backend queries. I have identified the query that is causing the ODBC Failed message to appear, but cannot identify what is causing the problem. I have tried to recreate the queries starting form the base query (which works fine). Cannot...