Hey All,
I found an easy way to clean these out of tables and prevent them from causing errors in action queries. It's very simple, just cut and then repaste the tables that contain these entries. The corrupted records do not get copied for the same reason that they cannot be deleted.
I stumbled upon a way to clean out garbage records in tables. These include records with chinese or "box" entries which Access creates from time to time by mistake. They tend to be hard to find and get rid of because of their ghost-like qualities: They are present and problematic but...
I know how to find the on enter for boxes in form design but in datasheet design I cannot locate any on enter
I tried the code, and just the "Format()" part in the Default Value box for my day of week but that didn't work. Thanks for the help
Andy
ps I also realized that if I put it...
Hi there,
I am interested in making one field of a table depend on another field. Specifically, I have a date in one field, and would like another field to automatically contain this date's day of week. So if you type in the date, for example, "8/1/2003", the day of week field would...
Yes! crosstab is very cool. But how do I get it to total only records with a unique combination of first name, last name, and chart #?? What would follow there WHERE? And who's on first?
Thanks
AD
Hi, my skills are extremely limited so any help resolving the following issue will be invaluable. I am making a database of patient medication orders which has a table with fields "last name", "first name", "chart #" and "Order Date" among others. What I...
Hi, my skills are extremely limited so any help resolving the following issue will be invaluable. I am making a database of patient medication orders which has a table with fields "last name", "first name", "chart #" and "Order Date" among others. What I...
When I click the Wizard Button, a window titled "Choose Builder" pops up and I have to select among "Expression Builder" "Macro Builder" or "Code Builder".
Chrissie,
Thank you for the speedy reply but I am still having trouble finding any option to create a subform. I even have tried to create a new form all together w/ the wizard but the page that is supposed to pop up asking if I would like subforms does not pop up. Instead I am taken directly...
I am designing a database for a clinic's dispensary (pharmacy). There are actually various issues I need to resolve, being that I have no experience whatsoever. I'll let you know what I've done so far and list my major issues below.
TABLES:
I have 3 tables: "Basic Patient Info" (P)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.