A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Create form using query doesn't fill fields



 
 
Thread Tools Display Modes
  #1  
Old November 5th, 2009, 04:10 PM posted to microsoft.public.access.forms
Smoki
external usenet poster
 
Posts: 54
Default Create form using query doesn't fill fields

Hi,
I have question, I want to create form using query. I made a form in which I
choose from one table field, and then the other fields on my form should be
filled in with appropriate row from table.
I already tried query, and it works. But, when I choose one paramether on my
form, and then press command button to refresh form data, nothing happend?
Why???
Maybe it's connected with Primary key? I have Primary key in my table, but I
think if I didn't do something good, in that case even query shouldn't work?!
But, my query works, only I have problem with filling form fields
  #2  
Old November 5th, 2009, 06:49 PM posted to microsoft.public.access.forms
Daryl S[_2_]
external usenet poster
 
Posts: 881
Default Create form using query doesn't fill fields

It sounds like the fields on your form are bound to a table instead of the
query. Check your datasource for the form - it should be the query.
--
Daryl S


"Smoki" wrote:

Hi,
I have question, I want to create form using query. I made a form in which I
choose from one table field, and then the other fields on my form should be
filled in with appropriate row from table.
I already tried query, and it works. But, when I choose one paramether on my
form, and then press command button to refresh form data, nothing happend?
Why???
Maybe it's connected with Primary key? I have Primary key in my table, but I
think if I didn't do something good, in that case even query shouldn't work?!
But, my query works, only I have problem with filling form fields

  #3  
Old November 5th, 2009, 07:13 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Create form using query doesn't fill fields

On Thu, 5 Nov 2009 07:10:07 -0800, Smoki
wrote:

Hi,
I have question, I want to create form using query. I made a form in which I
choose from one table field, and then the other fields on my form should be
filled in with appropriate row from table.
I already tried query, and it works. But, when I choose one paramether on my
form, and then press command button to refresh form data, nothing happend?
Why???
Maybe it's connected with Primary key? I have Primary key in my table, but I
think if I didn't do something good, in that case even query shouldn't work?!
But, my query works, only I have problem with filling form fields


Sorry, we cannot see your screen from here...

Evidently there is something wrong with the query or with the form. Could you
open the query in SQL view and post the SQL text here? What is the form's
Recordsource property (it should be the name of the query)? Did you perhaps
set the form's Data Entry property to Yes (that will let you add new records
but not display existing ones)?
--

John W. Vinson [MVP]
  #4  
Old November 6th, 2009, 10:11 AM posted to microsoft.public.access.forms
Smoki
external usenet poster
 
Posts: 54
Default Create form using query doesn't fill fields

Datasource is that query, not table. But, nothing happend, still
Any other recommendation?

Smoki

"Daryl S" wrote:

It sounds like the fields on your form are bound to a table instead of the
query. Check your datasource for the form - it should be the query.
--
Daryl S


"Smoki" wrote:

Hi,
I have question, I want to create form using query. I made a form in which I
choose from one table field, and then the other fields on my form should be
filled in with appropriate row from table.
I already tried query, and it works. But, when I choose one paramether on my
form, and then press command button to refresh form data, nothing happend?
Why???
Maybe it's connected with Primary key? I have Primary key in my table, but I
think if I didn't do something good, in that case even query shouldn't work?!
But, my query works, only I have problem with filling form fields

  #5  
Old November 6th, 2009, 11:03 AM posted to microsoft.public.access.forms
Smoki
external usenet poster
 
Posts: 54
Default Create form using query doesn't fill fields

Me again
It was my mistake, I changed command button, and it works now )))))
But, my main problem is not solve yet. Actually, I wanted with this form to
find, and then change some data in my base. It's base of network equipment,
and some equipment has been changed (location of equipment, for example). So,
I want to find specific equipment, and then to change some options about
that. But, when I change location, then on all places in base (where that
location was) it has been changed to this new one. Why?

Smoki

"Smoki" wrote:

Datasource is that query, not table. But, nothing happend, still
Any other recommendation?

Smoki

"Daryl S" wrote:

It sounds like the fields on your form are bound to a table instead of the
query. Check your datasource for the form - it should be the query.
--
Daryl S


"Smoki" wrote:

Hi,
I have question, I want to create form using query. I made a form in which I
choose from one table field, and then the other fields on my form should be
filled in with appropriate row from table.
I already tried query, and it works. But, when I choose one paramether on my
form, and then press command button to refresh form data, nothing happend?
Why???
Maybe it's connected with Primary key? I have Primary key in my table, but I
think if I didn't do something good, in that case even query shouldn't work?!
But, my query works, only I have problem with filling form fields

  #6  
Old November 6th, 2009, 03:54 PM posted to microsoft.public.access.forms
Daryl S[_2_]
external usenet poster
 
Posts: 881
Default Create form using query doesn't fill fields

Smoki -

Are you saying that when you change one record on the form that it updates
multiple records in the database? Please post your query (data source), and
indicate which fields you are changing on the form that are ending up in more
than one record in the database.
--
Daryl S


"Smoki" wrote:

Me again
It was my mistake, I changed command button, and it works now )))))
But, my main problem is not solve yet. Actually, I wanted with this form to
find, and then change some data in my base. It's base of network equipment,
and some equipment has been changed (location of equipment, for example). So,
I want to find specific equipment, and then to change some options about
that. But, when I change location, then on all places in base (where that
location was) it has been changed to this new one. Why?

Smoki

"Smoki" wrote:

Datasource is that query, not table. But, nothing happend, still
Any other recommendation?

Smoki

"Daryl S" wrote:

It sounds like the fields on your form are bound to a table instead of the
query. Check your datasource for the form - it should be the query.
--
Daryl S


"Smoki" wrote:

Hi,
I have question, I want to create form using query. I made a form in which I
choose from one table field, and then the other fields on my form should be
filled in with appropriate row from table.
I already tried query, and it works. But, when I choose one paramether on my
form, and then press command button to refresh form data, nothing happend?
Why???
Maybe it's connected with Primary key? I have Primary key in my table, but I
think if I didn't do something good, in that case even query shouldn't work?!
But, my query works, only I have problem with filling form fields

  #7  
Old November 6th, 2009, 04:05 PM posted to microsoft.public.access.forms
Smoki
external usenet poster
 
Posts: 54
Default Create form using query doesn't fill fields

Yes, I wanted to say that, maybe I just didn't explain that good.
But how to send to you my query?

Smoki

"Daryl S" wrote:

Smoki -

Are you saying that when you change one record on the form that it updates
multiple records in the database? Please post your query (data source), and
indicate which fields you are changing on the form that are ending up in more
than one record in the database.
--
Daryl S


"Smoki" wrote:

Me again
It was my mistake, I changed command button, and it works now )))))
But, my main problem is not solve yet. Actually, I wanted with this form to
find, and then change some data in my base. It's base of network equipment,
and some equipment has been changed (location of equipment, for example). So,
I want to find specific equipment, and then to change some options about
that. But, when I change location, then on all places in base (where that
location was) it has been changed to this new one. Why?

Smoki

"Smoki" wrote:

Datasource is that query, not table. But, nothing happend, still
Any other recommendation?

Smoki

"Daryl S" wrote:

It sounds like the fields on your form are bound to a table instead of the
query. Check your datasource for the form - it should be the query.
--
Daryl S


"Smoki" wrote:

Hi,
I have question, I want to create form using query. I made a form in which I
choose from one table field, and then the other fields on my form should be
filled in with appropriate row from table.
I already tried query, and it works. But, when I choose one paramether on my
form, and then press command button to refresh form data, nothing happend?
Why???
Maybe it's connected with Primary key? I have Primary key in my table, but I
think if I didn't do something good, in that case even query shouldn't work?!
But, my query works, only I have problem with filling form fields

  #8  
Old November 6th, 2009, 06:11 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Create form using query doesn't fill fields

On Fri, 6 Nov 2009 07:05:01 -0800, Smoki
wrote:

Yes, I wanted to say that, maybe I just didn't explain that good.
But how to send to you my query?


Open the query in design view. Select View... SQL from the menu. This will
open a big textbox with some cryptic looking text - that's the *real* query,
the query grid is just a tool to build SQL.

Copy and paste the SQL text to a message here.

It sounds like you have the field in the wrong table.
--

John W. Vinson [MVP]
  #9  
Old November 6th, 2009, 06:29 PM posted to microsoft.public.access.forms
Daryl S[_2_]
external usenet poster
 
Posts: 881
Default Create form using query doesn't fill fields

Smoki -

Choose the SQL View while in query design, and copy/paste the code here.

--
Daryl S


"Smoki" wrote:

Yes, I wanted to say that, maybe I just didn't explain that good.
But how to send to you my query?

Smoki

"Daryl S" wrote:

Smoki -

Are you saying that when you change one record on the form that it updates
multiple records in the database? Please post your query (data source), and
indicate which fields you are changing on the form that are ending up in more
than one record in the database.
--
Daryl S


"Smoki" wrote:

Me again
It was my mistake, I changed command button, and it works now )))))
But, my main problem is not solve yet. Actually, I wanted with this form to
find, and then change some data in my base. It's base of network equipment,
and some equipment has been changed (location of equipment, for example). So,
I want to find specific equipment, and then to change some options about
that. But, when I change location, then on all places in base (where that
location was) it has been changed to this new one. Why?

Smoki

"Smoki" wrote:

Datasource is that query, not table. But, nothing happend, still
Any other recommendation?

Smoki

"Daryl S" wrote:

It sounds like the fields on your form are bound to a table instead of the
query. Check your datasource for the form - it should be the query.
--
Daryl S


"Smoki" wrote:

Hi,
I have question, I want to create form using query. I made a form in which I
choose from one table field, and then the other fields on my form should be
filled in with appropriate row from table.
I already tried query, and it works. But, when I choose one paramether on my
form, and then press command button to refresh form data, nothing happend?
Why???
Maybe it's connected with Primary key? I have Primary key in my table, but I
think if I didn't do something good, in that case even query shouldn't work?!
But, my query works, only I have problem with filling form fields

  #10  
Old November 8th, 2009, 09:47 PM posted to microsoft.public.access.forms
Smoki
external usenet poster
 
Posts: 54
Default Create form using query doesn't fill fields

SELECT POPIS.Tip_opreme, DKP.Lokacija, POPIS.Soba, POPIS.Opis,
POPIS.Verzija_IOS, POPIS.U_upotrebi, POPIS.Serijski_broj, [razliciti tipovi
opreme].Tip_opreme
FROM [razliciti tipovi opreme] INNER JOIN (DKP INNER JOIN POPIS ON
DKP.DKP_ID = POPIS.Lokacija) ON [razliciti tipovi opreme].Tip_opreme =
POPIS.Tip_opreme
WHERE (((POPIS.Tip_opreme)=[Forms]![Pretraga po tipu opreme]![Tip_opreme]))
ORDER BY DKP.Lokacija;

If this can help anyhow
But I will explain what I want, actually! I want to find in my base
equipment with specific serial number, and then to change location of that
equipment. Do you have any idea for this?

Smoki

"Daryl S" wrote:

Smoki -

Choose the SQL View while in query design, and copy/paste the code here.

--
Daryl S


"Smoki" wrote:

Yes, I wanted to say that, maybe I just didn't explain that good.
But how to send to you my query?

Smoki

"Daryl S" wrote:

Smoki -

Are you saying that when you change one record on the form that it updates
multiple records in the database? Please post your query (data source), and
indicate which fields you are changing on the form that are ending up in more
than one record in the database.
--
Daryl S


"Smoki" wrote:

Me again
It was my mistake, I changed command button, and it works now )))))
But, my main problem is not solve yet. Actually, I wanted with this form to
find, and then change some data in my base. It's base of network equipment,
and some equipment has been changed (location of equipment, for example). So,
I want to find specific equipment, and then to change some options about
that. But, when I change location, then on all places in base (where that
location was) it has been changed to this new one. Why?

Smoki

"Smoki" wrote:

Datasource is that query, not table. But, nothing happend, still
Any other recommendation?

Smoki

"Daryl S" wrote:

It sounds like the fields on your form are bound to a table instead of the
query. Check your datasource for the form - it should be the query.
--
Daryl S


"Smoki" wrote:

Hi,
I have question, I want to create form using query. I made a form in which I
choose from one table field, and then the other fields on my form should be
filled in with appropriate row from table.
I already tried query, and it works. But, when I choose one paramether on my
form, and then press command button to refresh form data, nothing happend?
Why???
Maybe it's connected with Primary key? I have Primary key in my table, but I
think if I didn't do something good, in that case even query shouldn't work?!
But, my query works, only I have problem with filling form fields

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:05 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.