Need Urgent Help!!

[Phill]

I have created a search query within Access 2002 which looks for partial
details within a field as below:

SELECT Stock.[Stock ID], Stock.Description
FROM Stock
WHERE (((Stock.Description) Like "*" & ([Enter Partial Description]) &
"*"));

Once the results have been displayed I want to be able to click on the
required item and then the details to be added to a form for processing.

Can this be done?

If so can someone please advise me how.

Many thanks in advance.

Phill.

 

[Guest]

You post this question in the query section, so for your question you cant do
that with query. but you can create a form that has data sheet view, so it
looks like a query but it a form.
And with the extra form you can perform what you asking for.
If you need help wth the form I will be happy to help you.

 

[Phill]

Your help would be much appreciated. What do you need to know from me?

Phill

You post this question in the query section, so for your question you cant
do
that with query. but you can create a form that has data sheet view, so it
looks like a query but it a form.
And with the extra form you can perform what you asking for.
If you need help wth the form I will be happy to help you.

I have created a search query within Access 2002 which looks for partial
details within a field as below:

SELECT Stock.[Stock ID], Stock.Description
FROM Stock
WHERE (((Stock.Description) Like "*" & ([Enter Partial Description]) &
"*"));

Once the results have been displayed I want to be able to click on the
required item and then the details to be added to a form for processing.

Can this be done?

If so can someone please advise me how.

Many thanks in advance.

Phill.

 

[Guest]

I'll try to step you through it
1. create a form, base it on the query you want, display the form in a data
sheet view.
2. On the double click event of the field in this form assign the values of
the fields to the fields in the other form
Forms![MainFormName].[FieldName1]=me.Field1
etc
4. After assigning the values to the main form close the data sheet form.

Your help would be much appreciated. What do you need to know from me?

Phill

You post this question in the query section, so for your question you cant
do
that with query. but you can create a form that has data sheet view, so it
looks like a query but it a form.
And with the extra form you can perform what you asking for.
If you need help wth the form I will be happy to help you.

I have created a search query within Access 2002 which looks for partial
details within a field as below:

SELECT Stock.[Stock ID], Stock.Description
FROM Stock
WHERE (((Stock.Description) Like "*" & ([Enter Partial Description]) &
"*"));

Once the results have been displayed I want to be able to click on the
required item and then the details to be added to a form for processing.

Can this be done?

If so can someone please advise me how.

Many thanks in advance.

Phill.

 

[Phill]

On my original form [Sales Order Stock] I have created a button called
search which runs a macro and calls the new search form [Stock_Query1]. The
search form consists of 2 fields:

Stock ID and Description

I enter my search details and the results are displayed in data sheet view.

I have set the on double click in [Stock_Query1] to Forms![Sales Order
Stock].[Stock Order No]=me.[Stock ID]

When I double click I get the following message: Microsoft Access can't find
the macro 'Forms!Sales Order Stock.'

Any ideas on what I have done wrong?

I'll try to step you through it
1. create a form, base it on the query you want, display the form in a
data
sheet view.
2. On the double click event of the field in this form assign the values
of
the fields to the fields in the other form
Forms![MainFormName].[FieldName1]=me.Field1
etc
4. After assigning the values to the main form close the data sheet form.

Your help would be much appreciated. What do you need to know from me?

Phill

You post this question in the query section, so for your question you
cant
do
that with query. but you can create a form that has data sheet view, so
it
looks like a query but it a form.
And with the extra form you can perform what you asking for.
If you need help wth the form I will be happy to help you.

:

I have created a search query within Access 2002 which looks for
partial
details within a field as below:

SELECT Stock.[Stock ID], Stock.Description
FROM Stock
WHERE (((Stock.Description) Like "*" & ([Enter Partial Description]) &
"*"));

Once the results have been displayed I want to be able to click on the
required item and then the details to be added to a form for
processing.

Can this be done?

If so can someone please advise me how.

Many thanks in advance.

Phill.

 

[Guest]

in the double click event of the field, you should select code, and in the
code write the line of code.

On my original form [Sales Order Stock] I have created a button called
search which runs a macro and calls the new search form [Stock_Query1]. The
search form consists of 2 fields:

Stock ID and Description

I enter my search details and the results are displayed in data sheet view.

I have set the on double click in [Stock_Query1] to Forms![Sales Order
Stock].[Stock Order No]=me.[Stock ID]

When I double click I get the following message: Microsoft Access can't find
the macro 'Forms!Sales Order Stock.'

Any ideas on what I have done wrong?

I'll try to step you through it
1. create a form, base it on the query you want, display the form in a
data
sheet view.
2. On the double click event of the field in this form assign the values
of
the fields to the fields in the other form
Forms![MainFormName].[FieldName1]=me.Field1
etc
4. After assigning the values to the main form close the data sheet form.

Your help would be much appreciated. What do you need to know from me?

Phill

You post this question in the query section, so for your question you
cant
do
that with query. but you can create a form that has data sheet view, so
it
looks like a query but it a form.
And with the extra form you can perform what you asking for.
If you need help wth the form I will be happy to help you.

:

I have created a search query within Access 2002 which looks for
partial
details within a field as below:

SELECT Stock.[Stock ID], Stock.Description
FROM Stock
WHERE (((Stock.Description) Like "*" & ([Enter Partial Description]) &
"*"));

Once the results have been displayed I want to be able to click on the
required item and then the details to be added to a form for
processing.

Can this be done?

If so can someone please advise me how.

Many thanks in advance.

Phill.

 

[Phill]

Ofer

I have done as you suggested and selected code on double click

Private Sub Stock_ID_DblClick(Cancel As Integer)
Forms![Sales Order Stock].[Stock Order No] = Me.[Stock ID]
End Sub

I now get a Run-time error '2450':

Microsoft Access can't find the form 'Sales Order Stock' referred to in a
macro expression or Visual Basic code.

Any ideas why this is doing this? The form is valid!

in the double click event of the field, you should select code, and in the
code write the line of code.

On my original form [Sales Order Stock] I have created a button called
search which runs a macro and calls the new search form [Stock_Query1].
The
search form consists of 2 fields:

Stock ID and Description

I enter my search details and the results are displayed in data sheet
view.

I have set the on double click in [Stock_Query1] to Forms![Sales Order
Stock].[Stock Order No]=me.[Stock ID]

When I double click I get the following message: Microsoft Access can't
find
the macro 'Forms!Sales Order Stock.'

Any ideas on what I have done wrong?

I'll try to step you through it
1. create a form, base it on the query you want, display the form in a
data
sheet view.
2. On the double click event of the field in this form assign the
values
of
the fields to the fields in the other form
Forms![MainFormName].[FieldName1]=me.Field1
etc
4. After assigning the values to the main form close the data sheet
form.


:

Your help would be much appreciated. What do you need to know from
me?

Phill

You post this question in the query section, so for your question
you
cant
do
that with query. but you can create a form that has data sheet view,
so
it
looks like a query but it a form.
And with the extra form you can perform what you asking for.
If you need help wth the form I will be happy to help you.

:

I have created a search query within Access 2002 which looks for
partial
details within a field as below:

SELECT Stock.[Stock ID], Stock.Description
FROM Stock
WHERE (((Stock.Description) Like "*" & ([Enter Partial
Description]) &
"*"));

Once the results have been displayed I want to be able to click on
the
required item and then the details to be added to a form for
processing.

Can this be done?

If so can someone please advise me how.

Many thanks in advance.

Phill.

 

[Guest]

Is the form [Sales Order Stock] running?
its not enough that it exist, it need to be running, if it does then make
sure that the name is correct.

Ofer

I have done as you suggested and selected code on double click

Private Sub Stock_ID_DblClick(Cancel As Integer)
Forms![Sales Order Stock].[Stock Order No] = Me.[Stock ID]
End Sub

I now get a Run-time error '2450':

Microsoft Access can't find the form 'Sales Order Stock' referred to in a
macro expression or Visual Basic code.

Any ideas why this is doing this? The form is valid!

in the double click event of the field, you should select code, and in the
code write the line of code.

On my original form [Sales Order Stock] I have created a button called
search which runs a macro and calls the new search form [Stock_Query1].
The
search form consists of 2 fields:

Stock ID and Description

I enter my search details and the results are displayed in data sheet
view.

I have set the on double click in [Stock_Query1] to Forms![Sales Order
Stock].[Stock Order No]=me.[Stock ID]

When I double click I get the following message: Microsoft Access can't
find
the macro 'Forms!Sales Order Stock.'

Any ideas on what I have done wrong?

I'll try to step you through it
1. create a form, base it on the query you want, display the form in a
data
sheet view.
2. On the double click event of the field in this form assign the
values
of
the fields to the fields in the other form
Forms![MainFormName].[FieldName1]=me.Field1
etc
4. After assigning the values to the main form close the data sheet
form.


:

Your help would be much appreciated. What do you need to know from
me?

Phill

You post this question in the query section, so for your question
you
cant
do
that with query. but you can create a form that has data sheet view,
so
it
looks like a query but it a form.
And with the extra form you can perform what you asking for.
If you need help wth the form I will be happy to help you.

:

I have created a search query within Access 2002 which looks for
partial
details within a field as below:

SELECT Stock.[Stock ID], Stock.Description
FROM Stock
WHERE (((Stock.Description) Like "*" & ([Enter Partial
Description]) &
"*"));

Once the results have been displayed I want to be able to click on
the
required item and then the details to be added to a form for
processing.

Can this be done?

If so can someone please advise me how.

Many thanks in advance.

Phill.

 

[Phill]

It is a form within a form. So I dont think it is actually open. How can I
solve this?

Is the form [Sales Order Stock] running?
its not enough that it exist, it need to be running, if it does then make
sure that the name is correct.

Ofer

I have done as you suggested and selected code on double click

Private Sub Stock_ID_DblClick(Cancel As Integer)
Forms![Sales Order Stock].[Stock Order No] = Me.[Stock ID]
End Sub

I now get a Run-time error '2450':

Microsoft Access can't find the form 'Sales Order Stock' referred to in a
macro expression or Visual Basic code.

Any ideas why this is doing this? The form is valid!

in the double click event of the field, you should select code, and in
the
code write the line of code.


:

On my original form [Sales Order Stock] I have created a button called
search which runs a macro and calls the new search form
[Stock_Query1].
The
search form consists of 2 fields:

Stock ID and Description

I enter my search details and the results are displayed in data sheet
view.

I have set the on double click in [Stock_Query1] to Forms![Sales Order
Stock].[Stock Order No]=me.[Stock ID]

When I double click I get the following message: Microsoft Access
can't
find
the macro 'Forms!Sales Order Stock.'

Any ideas on what I have done wrong?

I'll try to step you through it
1. create a form, base it on the query you want, display the form
in a
data
sheet view.
2. On the double click event of the field in this form assign the
values
of
the fields to the fields in the other form
Forms![MainFormName].[FieldName1]=me.Field1
etc
4. After assigning the values to the main form close the data sheet
form.


:

Your help would be much appreciated. What do you need to know from
me?

Phill

You post this question in the query section, so for your question
you
cant
do
that with query. but you can create a form that has data sheet
view,
so
it
looks like a query but it a form.
And with the extra form you can perform what you asking for.
If you need help wth the form I will be happy to help you.

:

I have created a search query within Access 2002 which looks for
partial
details within a field as below:

SELECT Stock.[Stock ID], Stock.Description
FROM Stock
WHERE (((Stock.Description) Like "*" & ([Enter Partial
Description]) &
"*"));

Once the results have been displayed I want to be able to click
on
the
required item and then the details to be added to a form for
processing.

Can this be done?

If so can someone please advise me how.

Many thanks in advance.

Phill.

 

[Guest]

So it SUBFORM
forms![MainFormName]![SubFormName].form![FieldName]=...

It is a form within a form. So I dont think it is actually open. How can I
solve this?

Is the form [Sales Order Stock] running?
its not enough that it exist, it need to be running, if it does then make
sure that the name is correct.

Ofer

I have done as you suggested and selected code on double click

Private Sub Stock_ID_DblClick(Cancel As Integer)
Forms![Sales Order Stock].[Stock Order No] = Me.[Stock ID]
End Sub

I now get a Run-time error '2450':

Microsoft Access can't find the form 'Sales Order Stock' referred to in a
macro expression or Visual Basic code.

Any ideas why this is doing this? The form is valid!

in the double click event of the field, you should select code, and in
the
code write the line of code.


:

On my original form [Sales Order Stock] I have created a button called
search which runs a macro and calls the new search form
[Stock_Query1].
The
search form consists of 2 fields:

Stock ID and Description

I enter my search details and the results are displayed in data sheet
view.

I have set the on double click in [Stock_Query1] to Forms![Sales Order
Stock].[Stock Order No]=me.[Stock ID]

When I double click I get the following message: Microsoft Access
can't
find
the macro 'Forms!Sales Order Stock.'

Any ideas on what I have done wrong?

I'll try to step you through it
1. create a form, base it on the query you want, display the form
in a
data
sheet view.
2. On the double click event of the field in this form assign the
values
of
the fields to the fields in the other form
Forms![MainFormName].[FieldName1]=me.Field1
etc
4. After assigning the values to the main form close the data sheet
form.


:

Your help would be much appreciated. What do you need to know from
me?

Phill

You post this question in the query section, so for your question
you
cant
do
that with query. but you can create a form that has data sheet
view,
so
it
looks like a query but it a form.
And with the extra form you can perform what you asking for.
If you need help wth the form I will be happy to help you.

:

I have created a search query within Access 2002 which looks for
partial
details within a field as below:

SELECT Stock.[Stock ID], Stock.Description
FROM Stock
WHERE (((Stock.Description) Like "*" & ([Enter Partial
Description]) &
"*"));

Once the results have been displayed I want to be able to click
on
the
required item and then the details to be added to a form for
processing.

Can this be done?

If so can someone please advise me how.

Many thanks in advance.

Phill.

 

[Phill]

I have tried adding the sub form to the code and I am still getting a error
message. My problem is that I didn't make the database and I think there is
more going on within the form than meets the eye. I need to resolve this by
tomorrow lunch time.

So it SUBFORM
forms![MainFormName]![SubFormName].form![FieldName]=...

It is a form within a form. So I dont think it is actually open. How
can I
solve this?

Is the form [Sales Order Stock] running?
its not enough that it exist, it need to be running, if it does then
make
sure that the name is correct.

:

Ofer

I have done as you suggested and selected code on double click

Private Sub Stock_ID_DblClick(Cancel As Integer)
Forms![Sales Order Stock].[Stock Order No] = Me.[Stock ID]
End Sub

I now get a Run-time error '2450':

Microsoft Access can't find the form 'Sales Order Stock' referred to
in a
macro expression or Visual Basic code.

Any ideas why this is doing this? The form is valid!

in the double click event of the field, you should select code, and
in
the
code write the line of code.


:

On my original form [Sales Order Stock] I have created a button
called
search which runs a macro and calls the new search form
[Stock_Query1].
The
search form consists of 2 fields:

Stock ID and Description

I enter my search details and the results are displayed in data
sheet
view.

I have set the on double click in [Stock_Query1] to Forms![Sales
Order
Stock].[Stock Order No]=me.[Stock ID]

When I double click I get the following message: Microsoft Access
can't
find
the macro 'Forms!Sales Order Stock.'

Any ideas on what I have done wrong?

I'll try to step you through it
1. create a form, base it on the query you want, display the
form
in a
data
sheet view.
2. On the double click event of the field in this form assign the
values
of
the fields to the fields in the other form
Forms![MainFormName].[FieldName1]=me.Field1
etc
4. After assigning the values to the main form close the data
sheet
form.


:

Your help would be much appreciated. What do you need to know
from
me?

Phill

You post this question in the query section, so for your
question
you
cant
do
that with query. but you can create a form that has data sheet
view,
so
it
looks like a query but it a form.
And with the extra form you can perform what you asking for.
If you need help wth the form I will be happy to help you.

:

I have created a search query within Access 2002 which looks
for
partial
details within a field as below:

SELECT Stock.[Stock ID], Stock.Description
FROM Stock
WHERE (((Stock.Description) Like "*" & ([Enter Partial
Description]) &
"*"));

Once the results have been displayed I want to be able to
click
on
the
required item and then the details to be added to a form for
processing.

Can this be done?

If so can someone please advise me how.

Many thanks in advance.

Phill.