Fillable form for to allow user to select from 650 entries

English
#1

I am completely new to Writer. I came here because it looks like Word cannot do what I need it to do. I have a list of 650 record albums in an Access database. I can export them to an Excel sheet if that’s better. I need to create a fillable form that is a table with 650 rows. Each row will have 3 columns. Column 1 will be a data entry control for the user to enter a number from 1 to 10. Columns 2 & 3 are the title of the album and the artist and both are read only. Here’s an image of what the first few rows would look like:

Blank form

The user would then enter a number next to the ones they want something like this?

Filled-in form

Can someone get me started with this? I have the Writer Guide (7.1), which I start reading, but I am afraid it’s going to take me a long time to get up to speed.

Is there someplace I can post a request for individual consulting help (paid)? I checked the Professional Support page, but I didn’t see any way to post a general request. I would have to contact each one individually. I tried a few, but many of the links were broken.

Thanks

#2

Do NOT export to spreadsheet. It works just like Access when you connect it to a foreign database engine.

If using Windows:
menu:File>New>Database…
[X] Connect to existing database
Type: Access
Save datatbase document.
Your data are still in the Access database. Base is connected to that database. Nothing is stored in the Base document. Now you can use your database data in the context of this office suite. I recomend that you keep on using Access for editing your data. Base is not a good replacement for Access.

#3

I don’t understand your comment. My question is about how to create a fillable form from the data in the Access database.

Are you saying that Base can connect to an Access database? That doesn’t solve my problem unless Base can create the fillable form? Can it? If so, how do I do that?

I just tried what I think you suggested. I opened Base and asked it to connect to an Access database. I navigated to the folder containing my Access database. Base could not see it. It is looking for files with filetype .mdb or .mde. Mine is .accdb. I have office 365. Does Base not support the latest version of Access?

I opene3d the Access database and saved it as an Access 2003 database (.mdb). Now Base can see it, but it asks me a lot of questions about registering the database, etc. Is there a tutorial on how to do this? I do not want to affect the Access database in any what whatsoever.

But all of this is moot unless Base can create a fillable form. Can it? That’s the only question that really matters.

#4

Base is the bridge between many types of databases and office documents. Connect Base to your database and you have all the data in availlable in Writer and Calc. Hit Ctrl+Shift+F4 and drag your query or table from the data source window into Writer or Calc.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.