Search results

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

Thanks for your reply. I am running this query through a form and using criteria: >[Forms]![Benefits]![date1], however this only provide me with leaving dates after 15/05/2006. What I need to show is all live employees where leaving date is 00/00/0000 and where leaving date greater than...

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

Its ok. forgot to amend UniqueRecords property of the query to Yes

Unfortunately I cannot post the database. I just have 2 tables and as far as I am aware there are no further relationships in table dbo_MP_Audit.

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

Thanks for your reply Where can I state my query name within this script? Thanks

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

Still receive #Error message. Thanks

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

Sorry meant .mdb

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

Thaks for your reply. Does not work in .mde either

Wondered if someone could help. I am trying to Export an access report from an .mde (File>Export) and receive an error message "Overflow". the report itself is only 17 pages long. Can anyone advice? Thanks Paul