Fill in a form in datasheet view 1

[CJSilver]

I have a form made up of 4 queries and 8 tables. two of the tables are blank columns made to be filled from the form.

My form is created in the datasheet format. It has 20 columns, 4 of the columns are populated with data. I want the users to be able to open the form in datasheet view (Just as if it were an excel spreadsheet) and to be able to just enter their data into any of the empty cells. From what I have been told, the only way to do this is to use code. I am not a coder.

Could someone please help me with this?

C. Johnson

http://www.SilveradoCable.com

 

[Frink]

Hallo,

Not sure what you mean by 'a form made up of 4 queries and 8 tables'. A form has a single recordsource (a query or table). Maybe the other tables/queries are in a subform or listbox/combobox or something?

You can get a form or datasheet to look a bit like a spreadsheet without using too much code, but it depends on your table structure.

If you'd like to tell us what your table structure is like and show what you'd like in your rows/columns, we can offer more specific advice.


- Frink

 

[CJSilver]

Hello Frink,

Thank you for responding. Yes you are correct, The form is made from 1 query, that query is made from many others. Here is what it looks like:

Assembler Item Due Date MO# BD B 1 2 WC
CA4684 MO-27455 2 ASSEMBLY
CA4688 MO-27458 1 ASSEMBLY
CA5273 MO-27448 3 ASSEMBLY
CA4684 MO-27455 2 1ST END

The only rows that have data already in them are Item, MO#, BD and WC. The rest of the columns would be filled in. The form is much bigger than shown here, there are really 35 columns that are numbered 1 to 35, in these columns I would like to have a drop down, the only thing that can go in those columns is either X or it's left blank.

I hope this is enough information. Thank you for your help!


C. Johnson

http://www.SilveradoCable.com

 

[Frink]

Hallo,

Still not totally sure what you actually want.

In Access you can create a 'Tabular' Auto Form based on your query. Have you done that? Is that what you want? If not, what don't you like about it? what needs to change?

- Frink

 

[CJSilver]

Hello Frink,

I used the Datasheet format, the tabular view would also work, but since I already have data in some of the cells I can't add anything in the other cells. It acts like the cell are locked, but they are not. Unless I have my tables set up incorrectly. I was told by a friend that the only way I could enter data in such a form was to use code.

C. Johnson

http://www.SilveradoCable.com

 

[Frink]

Hallo,

Oh. Does it say 'Recordset not updatable' when you try to enter values?

- Frink

 

[Betsvigi9]

This may or may not seem like a stupid question, but does your query allow new records to be added and amendments to be made? If the query allows additions, deletions and amendments, then any form based upon it, whatever format, should also do so. If your query won't allow the above, then you will have to sort out the relationships between the tables before proceeding.

 

[CJSilver]

Hello Betsvigi9

No, it certainly is not a stupid question <chuckles>. I am not an expert in Access by any means. My query was originally created just to print the form in datasheet view and not to have data entered into it. I have never used Relationships in Access. I had thought that setting up the links in the query was all that needed to be done. I see I was wrong.

C. Johnson

http://www.SilveradoCable.com

 

[CJSilver]

Let me try this again. From what I understand, the issue I have is this.

The query that I am making my form from is made up of tables from my manufacturing software, (which cannot be written too) and tables that have the columns I want to be able to write too. From what I understand, the only way I can have a form made from a view that has both updatable and non-updatable columns is with code that when run would add records to only the tables I want.

Unfortunately I am not a coder. Can someone help me accomplish this?

C. Johnson

http://www.SilveradoCable.com