Reserved Error (-1517); There Is No Message For This Error.

Mar 31, 2006

Does anybody know what this error message refers to?

"Reserved Error (-1517); there is no message for this error."

It just started happening today, and I haven't even made any changes to the database. It occurs when I hit a button I have to run a macro.

the macro does the following:
1) Shows all records
2) Requery
3) ApplyFilter.
The Where Condition for the filter is:
Right([tblContracts].[JobNum],4)=Right([Forms]![FrmContProc].[txtFindJobNum],4)

The weird thing is that it only occurs if the Form window is taller than 1/2 of my viewable area. If the Form window is 1/2 the viewable area or shorter, it works OK. This was running fine earlier today, but about 4:00 pm (03/31/06) this started happening.

If anybody knows what this error means, or how to get rid of it (I really need to use this window in full-screen) then please let me know.


-Thanks, Sean

View Replies


ADVERTISEMENT

Reserved Error (-1517)

Nov 4, 2005

A query that I have been running without error for months has suddenly failed. When I try to run it I get this error message:

Reserved error (-1517); There is no message for this error

The query is

INSERT INTO DISPUTESPortal
SELECT DISPUTES.*
FROM DISPUTES;

Like I said, this has worked for months, but just started failing the other day. Neither table's layout has changed.

Any idea what this error is, and how to get my query working again?

Thanks,
David

View 1 Replies View Related

MS Access Reserved Error (-1517)

Jan 29, 2007

WTF does this mean?

ugh

nothing on google with this error message

thanks

sportsguy

View 6 Replies View Related

"Reserved Error -1517"

Mar 5, 2006

insert words that are not for public . . . .

I have a large text file, 800 megs,
354000 records. . .

and when i run the following query . . .


INSERT INTO ACEimport ( CustomerID, ContractID, ContractModifier, ContractLine, ServiceProgram, Invoice, InvoiceLine, InvoiceDate, TransactionType, EffDate, EndDate, Duration, UOM, AcctRule, BillCycle, BAMA, EOPBillFlag, Product, CValue, InvoiceTotal, RevenueTotal, GLDate, InvoiceLineTot, ContractLineTot )
SELECT Xrevenueoracle.CustomerID, Xrevenueoracle.ContractID, Xrevenueoracle.ContractModifier, Xrevenueoracle.ContractLine, Xrevenueoracle.ServiceProgram, Xrevenueoracle.Invoice, Xrevenueoracle.InvoiceLine, Xrevenueoracle.InvoiceDate, Xrevenueoracle.TransactionType, Xrevenueoracle.EffDate, Xrevenueoracle.EndDate, Xrevenueoracle.Duration, Xrevenueoracle.UOM, Xrevenueoracle.AcctRule, Xrevenueoracle.BillCycle, Xrevenueoracle.BAMA, Xrevenueoracle.EOPBillFlag, Xrevenueoracle.Product, IIf(IsNull([ContractValue]),0,[ContractValue]/100) AS CValue, IIf(IsNull([InvoiceAmt]),0,[InvoiceAmt]/100) AS InvoiceTotal, IIf(IsNull([RevenueAmt]),0,[RevenueAmt]/100) AS RevenueTotal, Xrevenueoracle.GLDate, IIf(IsNull([InvoiceLineAmt]),0,[InvoiceLineAmt]/100) AS InvoiceLineTot, IIf(IsNull([ContractLineAmt]),0,[ContractLineAmt]/100) AS ContractLineTot
FROM Xrevenueoracle
WHERE (((Xrevenueoracle.GLDate)>#1/28/2006# And (Xrevenueoracle.GLDate)<#3/5/2006#));


I get the reserved -1517 error, i have compacted and repaired the destination file, and i have scrolled through with a query and can't find it. . .

Before inserting the Null, i used to get another error of Numeric Overflow. . . and i was hoping that the null error handling would get rid of it. . . but no such luck. ..

any suggestions oh wiser ones?

thanks

sportsguy

View 1 Replies View Related

Tables :: Generating Monthly Report - Reserved Error 1524

Mar 12, 2013

i have a table on my database from which i generate a monthly report by running a query. when i run the query (date from to date to) i have no problem. it shows me all the relevant records. when i want to generate a report, i input the start date and the closing date for the report. it then gives me an error (reserved error (-1524); there is no message for this error.) i have gone into the table and basically isolated all the corrupted entries. there are 359

what i need to know is how to repair these entries without losing the information. im new to access and this is a simple(kinda) database which i set up to keep track of what the staff in my department are doing on a daily basis.

im running access 2007.

View 7 Replies View Related

Error Message With No Error Number

Feb 1, 2006

Hello All,

I have been developing my database all one seems to be well exept for an error message which is attched.

If anybody can help me trap this error or offer some advice i would be greatfull.

Alastair

View 6 Replies View Related

Error Message - Error No:6;

Jan 21, 2008

Hi. The following message appears when an append query is run in one of my databases "Error No:6; Description: Overflow". I've never seen it before, can't find it in Help - nor anywhere else on the net. All assistance greatly appreciated!

View 2 Replies View Related

Error Message

Sep 28, 2005

While going to the design mode of a form, I regularely get the following message :

Microsoft Access can't run the macro or callback function 'fDesign'.

In my Dbase there is no macro with that name.
Can anyone tell me what this messages means and how to get rid of this thing.

Running Win XP, Access 2003 Sp1

View 2 Replies View Related

Error Message

Jan 23, 2006

I have attached a screen print of an error message I recieved on my access database. I finally got it to come up, but only after a few pop up boxes with this error message.

I do know the shared drive it is housed on went on the fritz. So I copied it and pasted it to my desk top. Grrr...I thought this message was due to the flipping shared drive. But now, I recieved it on my desk top too.

Anywho...can someone look at it and tell me what it means.

Thanks alot.

PS, i know my desktop has to much stuff, so don't go there. ;)

View 2 Replies View Related

Error Message

Apr 3, 2006

Hi can anyone help i keep clicking on a qry and it comes up with this message "Syntax error (missing operator) in query expression 'tblSTSLimits.Max Short'. but Max Short is correct can anyone help

View 1 Replies View Related

Error Message

Aug 9, 2006

Hi all,
I face a problem while openning a form.
It gave me this error message:

The expression On Load you entered as the event property setting produced the foolowing error:
User-defined type not defined.

What to do?

Sorry for bothering you.

Thanks & Regards

Mark K.

View 3 Replies View Related

Error Message

Aug 23, 2006

I get an error message when I open access 2003 database "database contains a missing or broken reference to the cacview.ocx version 1.0

All help so far says to go to tools>references.
My tools in the help menu does not have references
anysuggestions

View 1 Replies View Related

ERROR Message! Please Help

Oct 9, 2006

I have a table that keeps crashing. The only error message I get is "Invalid Argument". Each time, a single record will turn into "#Error". Each field says this in the row. When this happens, Access won't let me delete just that row,

Any ideas how to delete them?

View 2 Replies View Related

Error Message

Jul 11, 2005

I am getting the following message:

"you tried to execute a query that does not include the specified expression qryMaxDays.Days Between 0 and 50 as part of an aggregate function."

I have other queries just like this and they run with no problem. any ideas? :confused:

SELECT Count(qryMaxDays.Days) AS [Number Of], qryMaxDays.Days
FROM qryMaxDays
GROUP BY qryMaxDays.Days
HAVING (((qryMaxDays.Days) Between 0 And 50));

View 1 Replies View Related

Message Error

Mar 6, 2006

I am trying to Right Join two queries which are basically from the same exact table, but when I do that I get the following error.

ODBC--called failed.

[Microsoft][ODBC SQL Server Driver][SQL Server] The column prefix 'MS1' does not match with a table name or alias name used in the query. (#107).

The following is a copy of my SQL

SELECT PqryExpiredPolicy.Policy_Number, PqryExpiredPolicy.Orig_Exp_Date, PqryExpiredPolicy.Insured_Key, PqryNewPolicy.Policy_Number, PqryExpiredPolicy.Name
FROM PqryNewPolicy RIGHT JOIN PqryExpiredPolicy ON PqryNewPolicy.Insured_Key = PqryExpiredPolicy.Insured_Key;


I have looked for this MS1 and cannot find it. Any ideas where I should be looking or what this means?

View 3 Replies View Related

Error Message

Jul 21, 2005

I get the following error message when I open a form, but I cant see anything wrong:

Run Time Error '2447':

There is an invalid use of the . (dot) or ! operator or invalid parenttheses.

This is the code that causes the problem:

Private Sub Form_Activate()
If Me.SumOfTotalGVS > 16 Then
MsgBox "You have exceded the total amount of GVS on the CATT site"
Let Me.SumOfTotalGVS.BackColor = 255
Me.SumOfTotalGVS.ForeColor = 65535
Else
Let Me.SumOfTotalGVS.BackColor = 16777215
Me.SumOfTotalGVS.ForeColor = 0
End If
End Sub

View 13 Replies View Related

Error Message

Feb 27, 2006

Can anyone tell me what is wrong with this line of code please. Im trying to count the number of records on another form that is open. This is an On_Click command from another form.

Me.lblCount.Caption = "You have " & Forms![Armour_Selection].RecordCount & " Armoured Squadron(s)"

View 1 Replies View Related

Error Message!

Aug 11, 2006

Hello all,
I have an access application. I imported a form to it with all related tables and queries and modules from another application. Unfortunetaly, it didn't work.
It gives me this error message when openning the form:
The expression On Load you entered as the event property setting
produced the following error:
User-defined type not defined.

Sorry for bothering you.
Thanks & Regards

Mark K.

View 7 Replies View Related

Error Message

Nov 28, 2006

Hi folks,

i have a form that allows me to save mobile phone details.

The problem with this form is that if its incomplete and i click 'x' it shows me the validation message followed by an error message (which is attached with this thread).....

why is that? is there anyway i can exit the form (incomplete) without the valdation message or error message occuring???

View 14 Replies View Related

Help With Error Message Please

Sep 7, 2004

Function Age(varBirthDate As Variant) As Integer
Dim varAge As Variant




varAge = DateDiff("yyyy", varBirthDate, Now)
If Date < DateSerial(Year(Now), Month(varBirthDate), _
Day(varBirthDate)) Then
varAge = varAge - 1
End If
Age = CInt(varAge)
End Function




I get # error in the field. Help?

View 2 Replies View Related

Error Message!!!!!!!

Sep 24, 2004

I get this error when I try to run a query. I have attached a screeen print of the problem. Every thing else works just fine it is the same query I copied it and just change one of the fields. the other query orks fine.

View 1 Replies View Related

Error Message...Help...

Oct 17, 2007

Can anyone help me wit tis error message,
When i try to add in new things, it appear...

Server object error 'ASP 0177 : 8007000e'
Server.CreateObject Failed
/admin/cd_add_action.asp, line 11

Ran out of memory

View 1 Replies View Related

Duplicate Error Message Help

Jul 6, 2005

hi,

the below scrip was taken from another forum member.

i have put this in the Forms / error VBA

but i still a little lost

i have set 3 fields to be indexed not to allow duplicate information (Forename, Surename, DOB)

i was then advised to error trap so it would highlight that i have enterd a duplicate record on typing in the DOB (As that as third feild to be entered)

so i then used the below script, however this doesnt highlight that it is a duplicate it just doesnt let me go on to the next record, the only time the error message is highlighted is when i go into design mode.

anyideas on where to go from here.


Private Sub Form_Error(DataErr As Integer, Response As Integer)
If DataErr = 3022 Then
Response = acDataErrContinue
MsgBox "Tis MerID alredy exist!"
Exit Sub
End If
If DataErr = 2169 Then
Response = acDataErrContinue
MsgBox "Tis record will not be saved!"
Exit Sub
End If

End Sub

View 3 Replies View Related

Getting Interesting Error Message

Oct 25, 2005

I have an Access project that when it starts, lets you pick a folder and a file to open as input (done with VBA code), and that works beautifully. My project then processes the opened file and that works fine also. However, when I run the project a second time, pick another file (with the same format), my project then dies on me. If I get completely out of my project and thenre-enter it, it runs fine. I've enclosed a screenshot of the error I'm getting.

Any help is greatly appreciated. And yes, I did a search on this and several other forums as well as on Microsoft's site and could not find anything related to the error I'm getting.

View 2 Replies View Related

Error Message Access

May 4, 2006

I receive a message as follows
ODBC call failed
[IBM][iSeries Access ODBC Driver] SQL data type argument out of range (#30030)
what to do ??

View 1 Replies View Related

Combo Box Error Message

Jun 7, 2006

Can anyone tell me whats wrong with this line of code?

DoCmd.OpenReport "rptOverview", acViewPreview, , "WHERE [CarID] = " & Me.cboCar.Value

I'm getting a missing operator error (3075)

..its supposed to open a report based on what record the user selected from a combo box

thanks

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved