Recent content by Lee Weaver

I have a form with a querry as a subform, I only want the user to be able to edit 2 of the 4 items shown on the subform, but I can not find a way to protect data in a querry. This form is for teh mamager to approve multiple records on a single page, so the querry subform is the easiest way...

hmmm not a good sign although most of the popints that are listed as "evil" won't effect this application. I do need to restrice what can be placed in here. but i want it easily updated by an admin by just adding an entry to the "furniture" table. I guess i can vba code it. but if someone...

my problem is im trying to define this in the table definition using the lookup feature. not on a form and yes I had that mixed up.. this line isn't actually what i'm using. my table has nothing to do with furniture. jsut using that as a aid to discribe my problem

I'm attempting to use the first method. but getting the row source sql right is the problem. the table is "furniture" SELECT furniture.type FROM funiture WHERE catagory.funiture=me.block5_catagory;

cascading trouble. I am now having trouble getting the next 1 figured out. here is an example of the data in the table... Catagory,type,configuration chair,dinner table,wooden chair,dinner table,metal chair,lounge,fabric chair,lounge,leather table,diner,wooden table,dinner,glass...

AWESOME the select distinct worked like a charm

I have a table that I am using as a lookup for a set of list boxes. the list boxes will cascade from 1 to the next. the first list box i need to only show each catagory once. the table has about 150 entries. but there are only 6 diferent catagories at this time. so i need to know how to...

I figured it out. I was clicking the box not the line for the acutal relationship. got it deleted.

OK now i see it. I also see why the relationship is interfering. but I can't seem to delete the relationship. I click the offending relationship and the 'X' delete button. and the relationship goes away. i click save. but if i "show all" again it reappears. How do I get it to go away and...

I need to change a field data type but when i try it tells me that i need to delete a relationship in the relationships window. but when i open the relationships window it doesn't show any.

this is going to take some work. I am unable to do a merge in this way because I am changing field types in the new database. some of the fields are LONG text fields, and I am making them embedded word documents, so I will have to figure out how to do this via VBA. So the question now morphs...

I have a table with a field that is an ole object and has a embedded word document in it. I am trying to import archival data into the system and need to write information to that ole object word document. after the new systems goes "Live" the data will be entered into the embedded word file...

make table query I'm attempting to at this time. will post again if I have more questions. Thanks for the Information

why merge. I want them merged to make it easier for the vba for the project. the porject is rather complex and having to deal with multiple tables complicates things further. the data is archival data, that I have imported from multiple sources. after the new system goes live all the...

I have 2 tables, 1 contains a document number and several fields, and the other contains the document number and about 40 other fields. I want to merge the 2 tables so all the information is in 1 table. I have googled this but only seem to find cases where both tables contain the same...