Empty form based on query
- Thread starter Pavczech
- Start date
pr2-eugin
Super Moderator
- Local time
- Today, 14:33
- Joined
- Nov 30, 2011
- Messages
- 8,494
Re: Empty Form
When you say,
When you say,
What exactly do you mean?? Can you show some screen caps or explain a bit more??
- Local time
- Today, 06:33
- Joined
- Aug 30, 2003
- Messages
- 36,272
Re: Empty Form
If the data entry property is yes, the user can only add new records. They won't see records entered prior to opening the form. The exception might be if you have code that forces the form open in another mode.
If the data entry property is yes, the user can only add new records. They won't see records entered prior to opening the form. The exception might be if you have code that forces the form open in another mode.
Re: Empty Form
I have checked and designed new query and new form but it was still showing the previous records. There is no code to open the form either. Than I have deleted all old records and made new form which in design mode looks ok but than in form view is header bit the form detail looks like it shrenked and there are no fields. I am just starting on access so could do with any help ( like data entry property ). Thanks
I have checked and designed new query and new form but it was still showing the previous records. There is no code to open the form either. Than I have deleted all old records and made new form which in design mode looks ok but than in form view is header bit the form detail looks like it shrenked and there are no fields. I am just starting on access so could do with any help ( like data entry property ). Thanks
Hello
I have posted thread yesterday called empty form.
So i have checked few thinks. Let clarify some details:
Tables are linked to sharepoint.
Form is bound to query.
The qery is bound to two tables.
Now if i do relations to ID on both tables and create form it works but showes all the previous records and you can scroll through them.
I need relations to unique code which is generated from the form.
If i do that or if i dont do relations at all the form looks good but in form the datail part disappear. It is because the records from both tables if i take records from the socond table of the detail appear.
Can i have clear form based on query on two tables where the relations is done on "uniquecode" .
Thanks
I have posted thread yesterday called empty form.
So i have checked few thinks. Let clarify some details:
Tables are linked to sharepoint.
Form is bound to query.
The qery is bound to two tables.
Now if i do relations to ID on both tables and create form it works but showes all the previous records and you can scroll through them.
I need relations to unique code which is generated from the form.
If i do that or if i dont do relations at all the form looks good but in form the datail part disappear. It is because the records from both tables if i take records from the socond table of the detail appear.
Can i have clear form based on query on two tables where the relations is done on "uniquecode" .
Thanks
- Local time
- Today, 09:33
- Joined
- Jan 23, 2006
- Messages
- 15,573
Re: Empty form based on qeury
Show the query sql.
Show some sample data to show us what isn't right.
Mock up something to show us what you really want the result to be.
Until we understand, we're only guessing.
Show the query sql.
Show some sample data to show us what isn't right.
Mock up something to show us what you really want the result to be.
Until we understand, we're only guessing.
boblarson
Smeghead
- Local time
- Today, 06:33
- Joined
- Jan 12, 2001
- Messages
- 32,059
Please don't post the same question twice. I've merged your two threads back into one.
boblarson
Smeghead
- Local time
- Today, 06:33
- Joined
- Jan 12, 2001
- Messages
- 32,059
Well, the first thing I see is that you have a non updateable query as the form's record source. That can't be used to add/edit/delete records.
See here for more about what makes a query non-updateable:
http://allenbrowne.com/ser-61.html
And second, you have an ID field in the tables but you are using Unique No as the link? What is that all about? The ID (PK) from the parent table should be the FK in the child table.
See here for more about what makes a query non-updateable:
http://allenbrowne.com/ser-61.html
And second, you have an ID field in the tables but you are using Unique No as the link? What is that all about? The ID (PK) from the parent table should be the FK in the child table.
I have made it work on the sample. works fine "ID" link on "table1" to "Unique No" on "table2".
The problem I am facing now is it doesn't work on my real one which is linked to sharepoint.
It could be because the field is not idexed, but sharepoint won't let me use another indexed field than "ID" which will not match. I have tried to link "ID" and "ID" which works but because it is autonumber the numbers don't match, so therefore the realations doesn't work.
Does this make sence?
Could you help in any way?
Thanks
The problem I am facing now is it doesn't work on my real one which is linked to sharepoint.
It could be because the field is not idexed, but sharepoint won't let me use another indexed field than "ID" which will not match. I have tried to link "ID" and "ID" which works but because it is autonumber the numbers don't match, so therefore the realations doesn't work.
Does this make sence?
Could you help in any way?
Thanks
