display data in form as select record in subform in data sheet view (1 Viewer)

O

ootkhopdi

Registered User.

Local time

Today, 13:26

Joined

Oct 17, 2013

Messages

181

• Nov 12, 2013

• #1

Sir
i have a main form named(EMP)
i have a subform named(SEMP)with EMPID
i have an another form Named(SDetail) with EMPID
i want to open form Sdetail with filter records for data select in subform (SEMP) ,EMPID field
Subform SEMP in as datasheet view.
pls help me so i can open sdetail for selected records only

 

M

Mihail

Registered User.

Local time

Today, 10:56

Joined

Jan 22, 2011

Messages

2,373

• Nov 12, 2013

• #2

pls help me so i can open sdetail for selected records only

Click to expand...

Records ? Not record ?

 

O

ootkhopdi

Registered User.

Local time

Today, 13:26

Joined

Oct 17, 2013

Messages

181

• Nov 12, 2013

• #3

yes i want Records for a particular EMPID

and My EMPID is in Text format..

Pls help me

 

M

Mihail

Registered User.

Local time

Today, 10:56

Joined

Jan 22, 2011

Messages

2,373

• Nov 12, 2013

• #4

I'm afraid that you have a wrong setup for your DB.
Post it here (converted in Access 2003 format)

 

O

ootkhopdi

Registered User.

Local time

Today, 13:26

Joined

Oct 17, 2013

Messages

181

• Nov 12, 2013

• #5

Mihail said:

I'm afraid that you have a wrong setup for your DB.
Post it here (converted in Access 2003 format)

Click to expand...

Sir

i m atached my complt data base but it is too large
for uploading

 

M

Mihail

Registered User.

Local time

Today, 10:56

Joined

Jan 22, 2011

Messages

2,373

• Nov 12, 2013

• #6

Do a Compact and Repair.
If still is too large, ZIP it.

 

O

ootkhopdi

Registered User.

Local time

Today, 13:26

Joined

Oct 17, 2013

Messages

181

• Nov 12, 2013

• #7

sir
i compact and repair database but it is app 3 mb in zip

 

O

ootkhopdi

Registered User.

Local time

Today, 13:26

Joined

Oct 17, 2013

Messages

181

• Nov 12, 2013

• #8

i do an option as
i create a query for selection of records as parameter id
with a command button i open form based on query

so i get my solution near by..
if u have any other solution pls tell me

 

M

Mihail

Registered User.

Local time

Today, 10:56

Joined

Jan 22, 2011

Messages

2,373

• Nov 12, 2013

• #9

This is quite impossible.
How many records have you in this DB ?
Have you a lot of forms ?

This is my mail address: alt.mihai@yahoo.com
Send me the DB (2003 or 2007 format) and I'll try to post it.
Send it to me even if you can't convert to a previous version of Access.
I'll find a way to upload it.

Inform me after you send the DB in order to check also my spam folder.

 

O

ootkhopdi

Registered User.

Local time

Today, 13:26

Joined

Oct 17, 2013

Messages

181

• Nov 12, 2013

• #10

sir
i sent mail to u with attachment

pls check and help me to make it better

 

M

Mihail

Registered User.

Local time

Today, 10:56

Joined

Jan 22, 2011

Messages

2,373

• Nov 12, 2013

• #11

This is indeed a "large" DB

If someone else wish to take a look is welcome.

I attached to this post the first part of the ziped file.
See my next post for the second part

 

Attachments

• ootkhopdi001.zip

  1.8 MB · Views: 79

M

Mihail

Registered User.

Local time

Today, 10:56

Joined

Jan 22, 2011

Messages

2,373

• Nov 12, 2013

• #12

The second part of zipped DB

 

Attachments

• ootkhopdi002.zip

  1.4 MB · Views: 77

M

Mihail

Registered User.

Local time

Today, 10:56

Joined

Jan 22, 2011

Messages

2,373

• Nov 13, 2013

• #13

Sorry for this but, what you name "DB", is a pain.

Now you have my mail address. If you wish, we can establish a live contact, in order to try together to make, from your collections, a database.

Cheers.

 

O

ootkhopdi

Registered User.

Local time

Today, 13:26

Joined

Oct 17, 2013

Messages

181

• Nov 13, 2013

• #14

Thanks Sir
pls tell me how can adjust autoheight of a sub form based on record show as datasheet

 

M

Mihail

Registered User.

Local time

Today, 10:56

Joined

Jan 22, 2011

Messages

2,373

• Nov 13, 2013

• #15

Lets try other approach.
You explain the problem you have and I (we) will try to give you a solution.
At least until you will have a better terminology.

The autoheight is a Yes/No property. It is not adjustable. It IS or it is NOT.
So, what you have ??? (... a form based on a table tbl1 and a subform based on other table tbl2. tbl1 and tbl2 are related via a field named... CommonField. The subform is/should be in datasheet view and I have THIS problem....)

As well as in math any question (problem) should have 2 parts: a) Environment description b) the question.

If the environment is a wrong one then the question has no answer.
Example: What is the sound speed ?
The usual answer is 340 m/s . Is this true ? No. The sound speed depend from the environment. It is not the same in steel, in water or in air. Even in air is not the same because the speed of sound depend from many other factors: temperature, pressure, humidity etc.

So, a much better question is:
What is the sound speed in air at 20 Celsius degrees and at the sea level (pressure=1 atm)
Now the 340 m/s is, indeed, the answer.

The same for your DB.
Anything you will try will fail soon or later because you have a wrong setup at tables level - the main environment.