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
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.
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. ;)
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
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,
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?
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.
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.
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???
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 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.
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
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.
I am in the UK and the company i work for moved to Budapest and so did my access database and is now on their server. Today a user in Budapest has come with a problem (see attachment). I really don't understand what has happened here...all the user is doing is clicking on a button, which has a hyperlink to another form, no printing involved at all. One of their colleagues in Budapest can run the report with no problems, do you think the problem is most likely to do with their computer settings...thanks for any responses.
Maintained a journal of daily happenings, on a Zip drive. Been doing if for 6+ years, thru various Access versions. Have bounced it back and forth between the zip drive and hard drive so am never more than two days apart. Today the zip drive comes up with: "The Microsoft Jet Database Engine stopped the process because you and another user are attempting to change the same data at the same time." I can't reparir (tried it). can't compact (tried it) All suggestions gradly accepted.
I am a beginner when it comes to access. The project that I am working on is tracking Travel claims. The claims are submitted ever month for 4 years so I have created 48 tables for each month and tried to link them via the SSN. The member can also submit other claims during this period, ie supplementals (for reimbursements that were missed in the monthly) and Concurrent duty claims (for the member going to additional sites then where they are assign).
I have a
MBR tbl - that holds all the MBR's info (SSN, name, unit, city, state, POC, POC email and Remarks)
(48) Partial tbl - linked by the SSN.
(5) Suppplemental tbl - Linked by the SSN ( I need more of these but I started with 5)
(5) Concurrent tbl - linked by the SSN ( I will need more of these)
These are all one-one relationship.
How can I get this to work. I can upload a blank copy of this database.
I get the following error message when trying to enter data into the form i created:
"You cannot add or change a record because a related record is required in table 'Two'."
I have five tables, four of which are one-to-one relationships. The main table ("One") of these four has a one-to-many relationship with table "Five". Something like this:
On the form are boxes for data from every table and a subform for the data from table five. Once i have entered data into every field for each of the tables, i try to click on the subform and get the above error. (All relationships have referential integrity). I've attached a file.
If you could find the problem and suggest a solution that would be great. Thanks.
