Re: I thought I was making progress

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Steve,

You are probably right, I'm sure my lack of experience is the problem is
designing this project. In a nutshell;

I have a registry for Cardiac Arrest and Major Trauma Outcomes. There are
several areas for which we collect data, Patient Information, Response
Information (incident location, type), Ambulance Information ( the 4 units),
Hospital Information, and First Responder Information.

The make the data entry process easier, I wanted a single form for the data
entry.

I initially built only 2 tables due to the type of reports that were
requested, 1 for the units and 1 for everything else. Then, due to a change
in the reports requested, I had to break the unit table into 4 tables. This
was suggested here from a previous post of mine to normalize the data.

There are other tables to hold lists such as Hospitals, Paramedics, First
Responders etc. There are no reports being generated from these tables.

In total, there are 87 fields on the form, 11 for each unit (44 total).

Any advice would be appreciated.



"Steve Schapel" wrote:

Paul,

The simple answer to the question of what are you doing wrong, is trying
to use a single form to enter data into 5 tables at once.

Can you please explain the 4 Unit tables, what are the similarities and
differences between them, and what is the nature of their relationship
with the tblEpistry table? On the face of what you have told us here,
it looks like you need to take a step back, and review your tables and
data structure before working further with your forms.

--
Steve Schapel, Microsoft Access MVP


Paul B. wrote:
but I'm really going nowhere fast.

I have followed the advice of many here that offered solutions.

I now have a main table (tblEpistry) and 4 unit tables (tblUnit1 through
tlbUnit4)

The main data entry form has the qry_data_entry as the record source and the
query has all five tables in it, linked by tblEpistry.EpistryID to EpistryID
in each unit table.

When I try to open my main form, I get 'Can't go to specified record' and
when I debug it, it is hanging on my Me.EpistryNumber.Setfocus line.

I simply want to use this form to enter data into my five tables. Any ideas
what I am doing wrong?

Thanks in advance.



.

Relevant Pages

  • Re: Is there any way to find out the width of a closed report programatically?
    ... you never for one second thought that the appropriate response to ... this with the reports closed, which then would have allowed Bob (or indeed ... smart-arse or anything else. ... Don't be a fool and come at me with idiotic tripe and I won't have to ...
    (comp.databases.ms-access)
  • Re: AutonumberProblem
    ... See the last sentence of my previous response. ... Open the data entry form in Design View, select the ID field, ... instructions on how to do this, follow this link to the MS Knowledge ... How to Create a Multiuser Custom Counter." ...
    (microsoft.public.access.gettingstarted)
  • Re: Logical handling
    ... on the reasoning that disk space and memory ... statistics puposes only needs access to one possible response record as ... (The total response to a question is then just the sample size ... one-by-one check, and produces all reports directly, on one pass. ...
    (comp.lang.fortran)
  • Re: syllogism
    ... stimulus that importantly influenced a response, ... on their cognitive processes, that is, on the processes mediating the ... Accurate reports will occur when influential stimuli are ...
    (sci.logic)
  • Re: Carry Id from one Form to another
    ... >I am somewhat new to MS Access and need some help with a data entry db. ... Recipient gets one, and only one, response for the life of the system? ... >and the six other forms are a breakdown of the Response information. ...
    (microsoft.public.access.forms)