Recent content by dscudder

When I look at the field list in the design view of the forms, the linked tables still appear associated with the fields even though I deleted the link and changed the data type. I fear that deleting the links ad changing the data types is not enough to resolve the issue.

Thanks: Something unexpected has happened. I first went to the relationships page and deleted all the relationships to look up tables. Then I went into the table design view and changed the data types to text. I also changed the data type for all Y/N fields to long integer. Finally, I...

Greetings: I have used Access since A97, when I left dBase, but I never noticed the lookup wizard as a data type before. I have been reading a lot about various wizards lately (never used them much) and when lookup wizard caught my attention I tried it. Usually, I have done queries on the...

Greetings: It is as easy to add a bound combo box to a form as it is to link a lookup table to a field in table design. I am not sure This is about "helping" novices. As one responder indicated, it seems more likely MS is trying to sell Sharepoint and with that to drive changes in SQL itself...

Greetings: The point, and a playful one to be sure, is that the calendar contains inherent measurement error, because it is of ancient origin, rooted in society and not science. The faithful representation of calendar age reproduces that error. That was the misinformation; calendar age is not...

Thanks. It boggles the mind that MS would include that. I just stumbled on to it. I am old school and usually do not look that far down the list of data types. I am busily taking them out of my tables.

Greetings: Thanks for your kind response. I appreciate it. I will try to resend the original db that I added to. I renamed it Age2.mdb. It has the same three expressions I have included over the last few days. I think I have the right db attached. i am using two computers here at once...

Greetings: Hmm. Not sure how that happened: it was there when I previewed. Here it is again. It is a *.doc file as an attachment. Thanks for your note.

Greetings: Somehow my comments are not always being received in the congenial and even playful manner in which they were conveyed. There is a serious element here to be sure, but let us not take ourselves too seriously. My point has been that human, societal customs of speech and making up...

Thanks. That is very helpful. Of course, business as usual. My db will reside on SQL server. I understand you to say never put the link to a look up or response box table in the table design. I infer that the recommended approach is to go into the relationships view and set the link...

Greetings: Recently I discovered a data type in Access 2007 I never noticed before. It is labeled "Lookup wizard." Exploring, I realized i could link a field to a lookup table in the table design view. How clever, I thought. There are two options: one is just to type in the values you want...

Greetings: I just realized that I had a typo in the formula for the calculation of the number of days in a year I posted earlier, for which I apologize. The correct formula has a plus sign not a minus sign for the adjustment due to the 4 year and the 400 year leap year rules: ((400*365) +...

Greetings: I have seen so much misinformation on the internet about age calculations. Let's start with the leap year issue. Microsoft date/time fields know precisely when leap years occur in the Gregorian calendar we use. If you try to enter Feb 29 in any year except a valid leap year...

Greetings: I am trying to mimic a preexisting form in a report. The preexisting form has some Y/N check boxes. Data must be pulled from 3 primary tables to complete this section of the report. (Intuitively obvious in a hand completed form: not so in programming.) Witnesses to an incident...

Very helpful. More later.