Search results

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

Greetings: I believe my db is corrupted. The symptom was that I could not run a UNION query with more than 2 queries, unless I called saved queries. That worked fine. I started a new db as a test with made up tables and UNION queries with 3 or more queries worked just fine. Does my...

Greetings: I have a union query to pull witnesses to an incident from three main tables for a report. Consumers, employees, and non-staff. Two of the tables are further linked to others. All queries work alone, and any two will form a union, but I get an error message saying the object could...

I can open a subform with a button but it no longer has the master and child relationships it has when embedded. How do I retain that when using a button to open a subform? Thanks David

I am creating an incident database. There are three principal tables. General information about the incident is in the main table. The incident ID, created there, is an auto-number. The two detail tables record information about the one or more patients and employees involved in the incident...

Well, I just joined. I integrate the various applications in an organization so they can write reports using data our of multiple applications, like payroll and EMR. I use access for this because it is easy to teach employees to use it. Most young IT students learn Access in school...