Help for a n00b trying to create a new form...

Creating and using forms
Post Reply
lollipop7081
Posts: 7
Joined: Wed May 14, 2008 8:33 pm

Help for a n00b trying to create a new form...

Post by lollipop7081 »

I am fairly new to the whole db thing, though I have used Access before, I've never used Base until now.

I need to create a form from a table. I get that I should just "Use Wizard to Create Form" but it won't let me. The option isn't available. I can't do anything with Forms or Reports. I tried using the option at the end of the Table Wizard to create a Form from the table but it just shuts down OO and when I recover the db it doesn't have a form or the table I tried to make the form from.

What am I doing wrong?

Thanks!
Last edited by lollipop7081 on Thu Jun 19, 2008 8:01 pm, edited 1 time in total.
User avatar
kabing
Volunteer
Posts: 680
Joined: Fri Nov 23, 2007 12:05 am
Location: Midwest, USA

Re: Help for a n00b trying to create a new form...

Post by kabing »

To help you, we need some more information:

-What OS are you using (Windows, LInux, Mac)
-What version of OpenOffice.org?
-What does the status bar at the bottom of your database document say. For example, does it say something like "embedded database" and "hsqldb engine" or does it say something else?

I am suspiscious that your tables don't have primary keys and this is the source of the problem, but I can't know for sure without more information.

kabing
NeoOffice 2022.7 LibreOffice 24.8.4 on (Intel) Mac OS Ventura
lollipop7081
Posts: 7
Joined: Wed May 14, 2008 8:33 pm

Re: Help for a n00b trying to create a new form...

Post by lollipop7081 »

Sorry about that...

I am on using Windows XP Pro, OO 2.4, and the status bar says "HSQL Database Engine".

I do have a primary key in the table...so any other thoughts?

Thanks!
Folbo
Posts: 4
Joined: Fri May 23, 2008 7:55 am

Re: Help for a n00b trying to create a new form...

Post by Folbo »

Hi.
No solution just the same problem :cry:

I have created a new table with a keyfield autonumber, two text fields, a date field and an image field.
This was on a new install of oo (2.40), where only Base and Draw were installed, with none of the optional extras.
I am running XP SP3.

Neither the reports nor forms are enabled in any way; both the wizard and design views are greyed out.

I do not know if there are some dependencies between the forms and the non-installed components.

I am trying to evaluate a move from MS Access to base for teaching databases at a wide range of levels, where the wizards are crucial the lower end.

Any suggestions would be gratefully received since I need to have made a decision in time for it to be included in the new build for the next academic year.

Many thanks.

Martin.
User avatar
r4zoli
Volunteer
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: Help for a n00b trying to create a new form...

Post by r4zoli »

For using Forms, Writer needs to be installed, all forms and Repots Writer document files, indserted into Base file.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
Folbo
Posts: 4
Joined: Fri May 23, 2008 7:55 am

Re: Help for a n00b trying to create a new form...

Post by Folbo »

It works :D

Many thanks.

I wondered if it was a dependency issue, but there were no warnings during installation to say that sgnificant functionality of one part of the package significantly depends on the installation of another part.

Thanks again

Martin.
Post Reply