Recent content by omegaleph

Funny you say that. I'm a co-op student here, so my "retirement" from this job is three weeks away. The guy replacing me has much less access experience too. That coupled with the fact that I have lots of other stuff on my plate = no radical changes.

Thanks for all the replies. I fixed this particular problem. If I came as annoyed/argumentative, I apologize. This database is just frustrating to deal with and I'm forced to apply "bandage" solutions.

Oddly enough, if you try to enter in a idnumber like 5000.A000 via the forms (i.e. you're on the main page for this subject and go to add a record in this IQ table) it lets you. And that's what I did. I know this database design and implementation is not optimal. But, as I said, I don't have...

Umm, the table works fine for entering/changing data or reading data via forms. I can also use it via SAS easily (and do so often). The only thing I cannot do is change the structure. I know its a problem, but not as big a problem as you seem to make it. In fact, one of the reasons I would be...

As I said, I don't have the time (or expertise) to implement this as it seems like a lot of work, re-making forms etc.

Actually, each field is a score on part of an IQ test and the resulting % or Z-score. So, each entry has a different range of possible values, and even number types. And predicting a question, no the % and Z-scores are not calculate automatically but by someone scoring the test by hand and...

Yeah, I've read that article and tried the work-arounds and it didn't help. If I were to split the table, how much work would I have to do in order to make the forms work as usual? The table is also pretty normalized. Each attribute depends only on the primary key and the table is in 2NF...

Well, at the moment I don't have the time to re-design the table. I know it needs to be done, though. And I'm not sure what you mean by "smart key". There is an input mask and I just need to change it to accommodate new idnumbers. I could remove the input mask if that's better.

There are 200 fields in the table. The primary key, (the Idnumber) has an input mask of 0000&0000 and I want to change it to 0000&AAAA

I inherited a db and one of the tables is giving me problems when trying to change some of the design. Namely, I make the change and when I try to save it says "Property value too large.". I did a compact/repair. Beyond that, I can't remove any of the columns and am not sure what to do. Thanks.

I have a database (inherited) and its now working well except for one form. You can open it and enter data and save/close it. But when you open it again, there is nothing there (whereas all the other forms show the current data). The code is included below. I've done some debugging and found...

Just a thought before I try your suggestion. What if I simply copy the current table and past it into the old table, using the "append" option? In this case, it would also require matching file size. It seems to also ignore validation. The only other problem is new variables but there are very...

I'll try that. the field names and types are the only things preserved in the new tables, so that's good.

Hello all. I have a database that has up-to-date data but is missing all the structure (I won't go into why this happened...). I have a backup version that has the exact same tables but with all the structure (i.e. primary keys, validation, default values etc.) intact. Is there a way to get...

Okay, how about this then. Is there a way for me to temporarily "turn off" any restrictions when pasting a batch of data from one table to another?