Recent content by coolcarls

Thanks a million Carl

Primay key is "idItem" This may start to make sense soon! :)

What do you mean "all the index"? I renamed the tblItem to tblItem1 and then made a new blank table called tblItem, then copied every row above the error and pasted it into the new table, the all of the rows below the error and pasted them in the new table. The had issues creating...

Sorry PHV, I forgot to address one of your questions. How would I find the primary key?

PHV, I have tried your sugestion to some extent. The problem is that I can't seem to creat the same relationships. The original relationships have that check box checked that says "enforce referential integrity" and also the type of relationship says "one-to-many", if I check the box another...

PHV, thanks for the answer, it even sounds like it may work. But I have no idea how to make a query or do any of the other things you suggested. Any way to speel it out for the layman?

It won't let me paste, the same error message comes up because I'm trying to mess with that same row. I was wondering if there is some sort of macro that could be written to delete record set #2158 from tblItem prior to opening the table? I could place it in the application and run it from the...

I we hadn't backed up in months. :(

Good Afternoon: I have a problem with our database software that has stopped us from working for the last week. I know nothing abobout Access either. So here goes... We have 3 parts to our software. 1. is the application that controls our data 2. is the actual database (the data) and 3. is...

Thanks Blue. My brain is in shutdown mode until someone taps me on the shoulder, so you're way ahead of me! Thank you again for your participation. Carl

Ken, Thanks! It works perfectly. byundt, I went with your last formula which is also flawless. I can't thank you enough, I learn so so much here. Have a beer on me! Cheers, Carl

Anyone have a better way around this mess? If I put a "=IF(ISNA" in the formula I get "too many arguments" =INDEX(Sheet1!$A$1:$B$21, MATCH(H23,Sheet1!$A$1:$A$21,), MATCH("Price",Sheet1!$A$1:$B$1,)) Thanks in advance Carl

John, Yes, you are correct. This works very well. thanks for translating my inarticulate description of my needs. Thank you too Blue.

Sheet1 cell a1 has a data from a list on sheet2 column A. I need sheet1 a2 to look at sheet1 A1 then match that with the list on sheet2 column a and place the data that is in the cell to the right of the matched data (column B) I know ther's an offset and match, but it's over my head. Here's the...

Perfect, Thanks skip. Once I have the data entered, I can use the validation filter from sheet1 for my list which would be sheet2 column a and use a vlookup or hlookup???????