Search results for query: *

The valid relationships aren't missing, additional relationships and an additional table is created by the system. I've deleted them several times and each time they return. Of course it does not return when I delete the tables, but I need the tables. Thanks any way! Anyone else have any ideas?

No, I haven't. I have a main table which I will call tblMain for purposes of explanation. tblMain contains several foreign keys which are the primary keys in linked tables. When I open the relationship window, tbl Main is duplicated with a link to itself and to two of the linked tables. There...

The main table of my database is duplicated automatically in the relationship window, why?

Please cancel request. The following worked: If Application.Intersect(target, Range("J3:J65536")) Is Nothing Then Exit Sub If target.Value <> "A" Then If target.Value <> "P" Then If Left(target, 1) <> "<" Then If Left(target, 1) <> ">" Then...

I tried........... If code(target) = 65 Then Exit Sub If code(target) = 80 Then Exit Sub If code(Left(target,1)= 92 AND(ISNUMBER(right(target,4))) .........which also gives me an error. The CODE function gives me an error saying "sub or function not defined", but "visual basic...

It appears that you are giving me the validation formulas for several fields which I wish was my problem. I need the validation to apply to one column. In other words, for every field in column B the user can only enter an "A", or "P", or a "greater than" or "less than" sign and a number. I...

hopefully someone out there can help me once again.... I would like to limit the entries into an excel field to : 1. "A" 2. "P" 3. "<" & any number formatted ##.## 4. ">" & any number formatted ##.## 5. any number example: B1 can be "A" B2 can be "P" B3 can be "< 25.36"...

Worked great! I am new to Excel and didn't have a clue, Thank you very much.

It allows me to select from the list or put in a number but also allows me to enter non-numeric characters. How do I allow only the items from the list or numeric characters only?

I'm sorry,I tried it again and it worked. I must have missed something the first time. Thanks ever so much!

I've tried that and just receive an error message. "=mylist" is not accepted. Any other suggestions?

In an Excel spreadsheet I wish to have each field in a column display as a drop down list that accepts either two items or any number. In other words the list will be "choice a", "choice b", or IsNum() where the user can enter any number. So far I have not been able to accomplish this. Can...

What causes a main table to duplicate itself in the relationship window?

Roy you are a gem! It worked perfectly, Thanks so much! Charlene

Thanks for the input guys, I'm still working on it. I've made a few changes, now getting a different error. I'll continue to play with it. It's a brand new day and the computer hasn't won yet! stDocName = "frmReportCriteria" strPTList = "" Set ctl =...

The following code generates error 3075, syntax error, missing operation. Can anyone see what is wrong with this? Why won't it work and why am I getting error? Thanks ever so much in advance for any assistance! stDocName = "frmReportCriteria" strPTList = ""...