Search results for query: *

Hi all, Try this out for me please.... I have 2 databases. The first, db1, only contains a form with a command button and some code under it (The code is below). The second, db2, has one table. This table is kinda weird however in that it is related to itself. This table stores part and...

I have 2 databases that have five data tables that are related to each other. The relationships look something like this.... Database 1 (db1) Database 2 (db2) Tbl2 Tbl2 / | \ / | Tbl1-+-Tbl3--Tbl5...

You guys rock! Thanks!

Everything I've read so far implies that once a table is created, the properties of its fields can only be read, not written. Does this mean I will have to recreate the table, it's relationships, and all of its data JUST to turn off the "Autoincrement" property? That's seems like a...

Hello all, It is possible to change an autonumber fields datatype to a number (long integer) via the access gui under table design. My question is how would I do the same thing via vba code, preferably with ADO, to a dbase that is not open. I was thinking of something like this..... First...

Ok. I've created a much simpler example to test my problem. I created two tables... Tables Table1 - ID (Autonumber); Text1 (Text) ID Text1 1 dcba 2 cbad 3 badc 4 abcd Table2 - ID (Autonumber); FKID (Number); Text2 (Text) ID FKID Text2 1 4 selected abcd 2...

It would be nice if I could filter on the key, but the first column is suppressed (ie. it's width is zero) and the key is in no way related to the displayed value (it is an autogenerated field). So it boils down to my end user is right clicking the combo box and selecting "Filter...

Hello all, Forgive the cross post, but I orignally posted this in "Access Other Topics" when it is far more suited for this forum. I have a form with a combo box. The combo box looks up entries from a table that is not the recordsource for the form. It grabs two pieces of criteria...

After a bit of digging I've enlightened myself on the "bound column". So my question could be stated as, "Can I filter a combo box using an un-bound column?"

Hello all, I have a form with a combo box. The combo box looks up two values (ID, Item) from another table. The first column width is set to zero so the user cannot see the ID of the item they are selecting. When attempting to filter (right click combo box, select filter for:, enter item) I...

Thanks for all replies. The problem was a lack of MDAC 2.7. Or installing MDAC 2.7 fixed an problems my boss was experiencing. Thanks again!

I had him check for breakpoints and watches and none existed in the module. I did find out there is a difference in our references. My version references the Access 10.0 Object library while his references the Access 9.0 Object Library. Could this be the source of my woes? If so, is it...

Hello all, I've developed a little access application for my boss in Access 2002. He is operating in Access 2000. I have the default file format set to 2000 in my version of 2002. And the dbase works great for me in 2002. My problem is when I send him a copy of the dbase to look over, the...