open a card directly from table view

[antuk]

Hi folks, I am a simple user of access, no developer. In fact, I have one principal d/b running on my access, ad/b which I had imported from my iPad... The import went smoothly enough but I face this problem. I usually scroll the table in order to locate a patient's name, and I can't find a way to select this line and have it switched to a card view in order to update it. I need to move to card view, search from there in order to locate this person in card view. I am sure there is a way to select a line ( a record) in table view and jump from there directly into this record in card view. Please help. Thanks.

[CJ_London]

need to clarify what you have since your terminology is a bit 'not access'

This is a db imported from iPad - please clarify, do you mean a db or do you mean data?
when you say 'scroll the table' - do you mean this literally or do you mean you are scrolling a form?
when you say 'card view' - do you mean a form?

the answer to this comment

I am sure there is a way to select a line ( a record) in table view and jump from there directly into this record in card view

this can be done, but not from tables, only from forms.

It sounds like you have just imported the data, which will not import any functionality - and which you will need to build yourself.

So if we can clarify what you actually have we can probably help. you say you are a simple user of access, so a good stating point would be

1. list all your tables, queries and forms
2. provide a screenshot of your relationships

[antuk]

OK, my bad. I have imported a csv file into access and it functions as an access database perfectly (at least to my needs). It has a table with all the records on it, something like 950 records. It also has a form view for each of the records. I am looking for a solution to select one of the rows on the table, i.e., one of the records, press a key or whatever on my keyboard or the software, and have this record shift to a form view for editing. Hope now I have managed to be clearer. Thanks.

[CJ_London]

So you have a single table and a single form (your 'card' view) of that table.

It may be you don't need to do anything, or there are other options -which is right for you depends on how you are using your table to find records.

The 'do nothing' routine is simply do the following in your form, right click on any control and select one of the filter options relevant to that control.

Let me know if that meets your needs, and if not, describe what you do in the table to find a record, do you just scroll down until you find the record you want, are you only ever looking at one field (e.g. lastname) etc.

[antuk]

In my work flow, I randomly scroll the table where I can see multiple names in a glance. Then, I pick up a name that I need to update some info about it, put this name in search query in FORM view. Then I update the form as needed. I wish I could shorten this process by, say, rt. click on a line in table view, select an option to open this person in FORM view. This seems only logical to me that such an option should have been built in the software. If not, I wonder if a macro can be built to be able of doing this. However, I have no idea how to build such a macro. Hope now I am clearer on this.

[CJ_London]

This seems only logical to me that such an option should have been built in the software

there are many options, but remember Access is a development environment, not a finished product.

Probably the easiest thing for you to do is create what is called a split form, will take a few seconds to create.

1. select your table by clicking on it, do not open it
2. click on the 'Create' tab at the top
3. in the forms section, click on 'More Forms'
4. click on Split Form
5. Save the form
6. Job done

Now open the new form, clicking on any of the information in the bottom section will display the data in the top section.

If you don't want the list at the bottom but would prefer it at the top or to the left or right

1. go into the form design view
2. display properties if not already visible (click on the properties option on the design ribbon
3. in the dropdown box select 'form'
4. select the format tab
5. scroll down until you see 'Split Form Orientation'
6. Select your option
7. close and save form
8. job done.

[cbende2]

What Ajax just provided you with is the way to go for what you desire Antuk.

A split form is what your looking for.

[antuk]

Thanks Ajax. That basically solved my problem.
I would rather have a full view of the table than half of my laptop screen, and be able to switch to a form view of a specific record instantaneously, yet I suppose that this solution is as close to what I need as possible.
Many thanks again for your patience and help.

[CJ_London]

I would rather have a full view of the table than half of my laptop screen and be able to switch to a form view of a specific record instantaneously

that's where the programming comes in - it is doable but you'll need to learn a bit of programming. There is a bar you can move to adjust the split between the two views and bearing in mind you said

I randomly scroll the table where I can see multiple names in a glance.

it sounds like you would be better with the list to the left or the right. If the names aren't in the first few columns, you can click on the column header and then drag the columns to the left - then click save to save the new layout

[antuk]

Thanks again. I wonder if I can exploit your good will and ask you something else. I have designed the form nicely with colors and b/g + a nice logo. Can I copy this design and apply it on the table and split form as well? How can this be done?

[CJ_London]

Can I copy this design and apply it on the table and split form

not to the table because that is not a form. with regards the form, you'll have to try it, I don't use split forms myself because of the limitations I keep hitting with what I do. As you know, the form can be easily created again so nothing ventured, nothing gained.

1. Open both forms in design view
2. in the split form, delete all controls
3. go to your other form and copy all controls (ctrl-a to select all) then paste into the split form (ctrl-c)
4. the back colour of the detail section you will need to do separately. Open properties if not already open and go to the original form and click on the detail bar, look down the format tab for Backcolor.
5. copy this property and paste into the equivalent property of the split form
6. save the form and job done

[antuk]

I am in your debt. Thanks again.