Generate a new line on a continious form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Leslie - 22 Jul 2007 22:24 GMT

I'm using Access 2003 and have done some programming. What I need to do is
that based on if the file name field and the current revision field for
XXXXXXXX is not null to generate a new line for XXXXXXXX with the revision
field blank. How can / do I do that. I was thinking that an if clause
stating something similar to If filename.value = XXXXXXXX and
currentrevision.value =>0 then a new line should be created on the
continuious form for XXXXXXXX with the filename value filled in. How can I
so this?

Reply to this Message

John W. Vinson - 23 Jul 2007 01:05 GMT

>I'm using Access 2003 and have done some programming. What I need to do is
>that based on if the file name field and the current revision field for
[quoted text clipped - 4 lines]
>continuious form for XXXXXXXX with the filename value filled in. How can I
>so this?

Well... first thing to realize is you aren't creating "a new record on a
form". Records aren't stored in forms; they're stored in tables.

I suspect that you will want to run an Append query to create a new record in
the table, and then requery the form to display the newly created record.
You're assuming we have far more knowledge than we do about your table
structure or the nature of your form though!

John W. Vinson [MVP]

Reply to this Message

Leslie - 23 Jul 2007 15:04 GMT

First NO I am not assuming anything about what you know about my database
and/or tables. The form is used to generate new records in the table and
what I want to do is to automatically begin a new record based in if the an
old record exists based on the revision field so if the revision field has
something in it then a new record should be started.

Thanks,

> >I'm using Access 2003 and have done some programming. What I need to do is
> >that based on if the file name field and the current revision field for
[quoted text clipped - 14 lines]
>
> John W. Vinson [MVP]

Reply to this Message

John W. Vinson - 23 Jul 2007 18:32 GMT

>The form is used to generate new records in the table and
>what I want to do is to automatically begin a new record based in if the an
>old record exists based on the revision field so if the revision field has
>something in it then a new record should be started.

At what point do you want to create the new record? While the user is entering
a record? I'm not visualizing the process!

When you open the form, you can move to a new record. That record is blank,
with no data in any fields (except for those fields with a Default Value
property).

At what point should Access percieve that "the revision field has something in
it"?

John W. Vinson [MVP]

Reply to this Message

Leslie - 23 Jul 2007 18:42 GMT

I would like it to happen when the form is opened it should generate the new
information. What I have is a continuious form used to list drawings that
need to be moved. but in this case our Software Engineers have created and
released a new revision of the software to be released and to simplify things
for them we want to generated a new form for their software release that
encompuses several part numbers that require being moved and I would like to
generate this "FMF" for them automatically.

> >The form is used to generate new records in the table and
> >what I want to do is to automatically begin a new record based in if the an
[quoted text clipped - 12 lines]
>
> John W. Vinson [MVP]

Reply to this Message

John W. Vinson - 23 Jul 2007 20:16 GMT

>I would like it to happen when the form is opened it should generate the new
>information. What I have is a continuious form used to list drawings that
[quoted text clipped - 3 lines]
>encompuses several part numbers that require being moved and I would like to
>generate this "FMF" for them automatically.

Engineer Janet sits down at her computer and opens the database.

She opens the form. It's blank, no data has been entered.

Elsewhere in the table there are 368 records with different values of
software.

WHICH ONE of those 368 should "generate a new form"? How is Access supposed to
know WHAT data needs to be put into the new record? Where is that information
coming FROM?

I'm still not visualizing the process.

John W. Vinson [MVP]

Reply to this Message

Leslie - 23 Jul 2007 21:04 GMT

Okay, let me try again I am sorry I'm not explainning this clearly enough it
is as difficult to explain as to try to do.

Engineer Janet has completed the software upgrade and is now releasing the
software. 3 different versions are released software 4.00, 104.00 and
204.00. the are part numbers 12345678 for version 4.00 and 23456789 for
version 104.00, and 34567891 for version 204.00, also there is part number
45678912 for a label for verison 204.00. so when Engineer Janet puts opens
the form I think would be the easiest if she put in maybe the software
version of xx4.00 the form would generate a list of part numbers the part
numbers listed above that do not contain xx4.00 or any deriviate there of.
That is what I'm trying to do. I want to make generating the file move form
as easy as possible for the engineer because there are alwyas some part
number that is forgotten.

Thank you in advance.

> >I would like it to happen when the form is opened it should generate the new
> >information. What I have is a continuious form used to list drawings that
[quoted text clipped - 18 lines]
>
> John W. Vinson [MVP]

Reply to this Message

John W. Vinson - 23 Jul 2007 22:14 GMT

>Okay, let me try again I am sorry I'm not explainning this clearly enough it
>is as difficult to explain as to try to do.
[quoted text clipped - 10 lines]
>as easy as possible for the engineer because there are alwyas some part
>number that is forgotten.

It *sounds* like you want a Subform on the form listing the part numbers *for
the specific software that has been entered on the form* - not de novo for a
completely blank, no information yet entered form. It's the latter that you
seemed to be asking for.

If you could explain the sentence " generate a list of part numbers the part
numbers listed above that do not contain xx4.00 or any deriviate there of" it
might help. None of the part numbers that you list "contain xx4.00" - they're
strings of numbers with no decimal.

Perhaps I should have asked some time ago: What Tables do you have? What is
the Primary Key of each table? How are the tables related? Please explain as
to someone who has no idea what kind of work you're doing, what information
you are handling, or anything about your tables; just as and example you use
the term "label" which has a specific meaning in Access (a Label control on a
form) but I'm sure that's not the sense in which you're using it!

John W. Vinson [MVP]

Reply to this Message