Re: Allen Browne - Help with duplicating Form & Subform!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Allen,

I just wanted to clarify that there needs to be a unique pattern within each
request, but there can be many patterns, so I used a 1:M relation between
tblRequest and tblPattern.

--
~Erica~


"Allen Browne" wrote:

Immediately before the Execute line, temporarily add this line:
Debug.Print strSql

When it fails, open the Immediate Window.
Copy what you see there, and paste it into a new query.
Try running the query.
See if you can pin down what's wrong.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Eka1618" <Eka1618@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C0C9B4A4-FC30-404D-A476-B25F79651FD4@xxxxxxxxxxxxxxxx
Hi Allen,

You Said : Appending to the RecordsetClone of the form does not move it to
a
new record.

So getting the value by using the current event will not work then (if
that
is what you mean). This is what I originally thought and so I do not
understand what you mean by getting the values from somewhere else. Do you
mean by creating a query and using that recordset, or using the table?

I have done another test and I think that perhaps I am wrong about what is
going on durring the code. I used the following:

If Me.frmPattern.Form.RecordsetClone.RecordCount > 0 Then
strSql = "INSERT INTO tblPattern( PAT_NO, PAT_SIZE, QUANTITY ) " & _
"SELECT PAT_NO, PAT_SIZE, QUANTITY FROM tblPattern WHERE REQUEST_NO = " &
Me.REQUEST_NO & ";"
DBEngine(0)(0).Execute strSql, dbFailOnError
End If

It told me that a PK cannot be null. As a test I ran this as a seperate
query and used the request number of 133 and I do have 1 record that
matches.

I am wondering if it is not the PAT_NO and PAT_SIZE at all and if it is
the
REQUEST_NO. It would make more sense to me to say insert pattern number,
size
and quantity where the request number = the request that I am duplicating.
However, I think I need the code to give me that new Request Number value
so
that I can append that as well.

I think the code should read more like this:

If Me.frmPattern.Form.RecordsetClone.RecordCount > 0 Then
strSql = "INSERT INTO tblPattern( PAT_NO, PAT_SIZE, QUANTITY, REQUEST_NO )
"
& _
"SELECT PAT_NO, PAT_SIZE, QUANTITY, (NEW REQUEST NUMBER) FROM tblPattern
WHERE REQUEST_NO = " & Me.REQUEST_NO & ";"
DBEngine(0)(0).Execute strSql, dbFailOnError
End If

This sort of makes more sense, but I do not think it could work at the
same
time. tblPattern is looking for REQUEST_NO, PAT_NO and PAT_SIZE since they
are a composite PK and I do not think it is getting that new REQUEST_NO
value.

I think this better explains whats going on, please let me know what you
think when you get a chance, Thank You!

--
~Erica~


"Allen Browne" wrote:

Not sure I followed.

Appending to the RecordsetClone of the form does not move it to a new
record.

The subform could be at a new record if there are no related records
there,
or if it happens to be at the new record.
"Eka1618" <Eka1618@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9038C847-363C-49CE-B229-BE3875B161B9@xxxxxxxxxxxxxxxx
Hi Allen,

Since you last response I have not been able to work on this issue
again
until today.

One important thing I forgot to mention the other day is that the
records
that are being duplicated are exsisting records from an earlier time.

When the parent for opens, I prompt the user to find the request they
want
to duplicate. If there are patterns associated with the request, then
the
records that appear in frmPattern were already saved, so it does not
seem
possible for frmPattern to be at a new record (with the example I have
been
using). I have frmPattern Data Entry Property set to No.

However, it is possible for it to be at a new record, but in the
example
that I have been trying to test this with, the pattern information has
already been saved. This is why I am confused as to why it says it is
NULL.

I am going to try using form_current event on frmPattern to set PAT_NO
and
PAT_SIZE to variables accessible in the parent form. I just wanted to
mention
the fact the the records that I am trying in my example are exsisting
records
at the time the duplicate button is clicked.


.

Relevant Pages

  • Re: Allen Browne - Help with duplicating Form & Subform!
    ... DBEngine.Execute strSql, dbFailOnError ... query and used the request number of 133 and I do have 1 record that matches. ... > records that appear in frmPattern were already saved, ... > at the time the duplicate button is clicked. ...
    (microsoft.public.access.formscoding)
  • Re: Allen Browne - Help with duplicating Form & Subform!
    ... query and used the request number of 133 and I do have 1 record that matches. ... Appending to the RecordsetClone of the form does not move it to a new ... records that appear in frmPattern were already saved, ... at the time the duplicate button is clicked. ...
    (microsoft.public.access.formscoding)
  • Re: passing $_POST variables to classes
    ... if $_POST variables are sent to some page and are needed by the ... What are your views on implementing such a 'pattern'. ... controller decide what kind of request it gets, ... kind of response do I want' i just part of the request offcourse. ...
    (comp.lang.php)
  • Re: passing $_POST variables to classes
    ... This will then call upon the function view in the class inbox: ... if $_POST variables are sent to some page and are needed by the called ... What are your views on implementing such a 'pattern'. ... If however, you're writing an app that might get it's instructions another way, it might be handy to let a controller decide what kind of request it gets, and create a request object accordingly. ...
    (comp.lang.php)
  • Re: New attack or old Vulnerability Scanner?
    ... recall seeing a request for shell.exe lately. ... People have been seeing that string since at ... pattern in terms of order and actual GET requests that you did with the ... IBM Managed Security Services ...
    (Incidents)