Recent content by fitzintx

I hate the fun stuff :) All right, it looks like I'll move onto restoring the DB.

Thanks for the help! Is the corruption most likely from a user entering bad data into a table or do the Access tables just sometimes get corrupt for fun and to make life challenging :)

So I was trying to debug this and I looked at the record source for the form it's trying to open. When I try to run this query, I get the invalid argument. So I tried to open the table the query was pulling from and I also get the invalid argument, does that mean there is some bad data in this...

All, just wanted to see if anyone had any ideas about this error. All of a sudden this evening our Access Program on work network drive is getting an error when trying to open one form. It throws an Invalid Argument error - 3001. Other forms work ok but this is the only one. No changes have...

When I remove the controlsource from the textbox the code works and I don't get the error! So if I go this route then I'd have to go thru the code and add this IF statement as the Form Loads as well to set the value in the beginning, sound right? Do we know why the values changed in the...

I still get the error... Run-time error '-2147352567 (80020009)': You can't assign a value to this object

All, I'm stepping back into coding after a 5 year layoff so bare with me. I'm working on some access code that was converted from 2000 to 2010. One field is a textbox and it's control source is the following... =IIf([InternationalChk]=Yes,"Lease","County") 'InternationalChk' is the field in...

Hey Y'all! I've been at home with my kids for the last 5 years and haven't done much coding, it's amazing how difficult it is to get stuff done with new borns and toddlers! I'm starting to help out with some programming for my wife's small company and they have an Access program that's been...