Search results for query: *

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...

Thanks, worked like a charm!

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...

I apologize but I am very green at this. Where exactly would I type this code in so that it would affect this change? Thanks, Andy

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

I'll give it a whirl. Thanks for the tip mball, I'll let you know how it goes...

Yes but I guess that I'm not sure how it exactly works and more importantly if I could perform a complicated task like finding unique orders with it.

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".

I thought that enforcing referential integrity would do it...but it didn't.

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)...