Beginners - Example Database - Base Tutorial

[Fraoch]

Really dumb newbie question, and it just concerns formatting, but...

Pasting a series of fields in a frame is driving me nuts!

It seems to have a random effect. Sometimes my pasted fields disappear, sometimes they appear in a different portion of the page (but move with the frame), sometimes they appear but are disconnected from the frame.

I've managed to get two of the frames in using a different procedure each time but the last frame, the one with Department ID, is really fighting me.

It seems to be connected to two things:

- the frame anchor. If this is set to "as character" like it is by default it sticks to the left of the page and pasting fields in it never seems to work. Unfortunately the pasted fields seem to have an anchor of their own too, sometimes not the same as the frame, which is why I get the fields attached to the frame and moving around with it but not in it.

- design mode. It keeps coming on without me doing anything. I'm not sure what makes the pasting work because it's flipping back and forth so much.

Any tips? Thanks.

[DrewJensen]

I had a lot of trouble with that also, but as I have updated to the later releases it seems to have lessened...or perhaps I am just learning to work differently.

Anyway, I just installed 2.0.3 and will take a few minutes to really look at this.

Otherwise all I can say is that you are right about the anchoring being the issue.

After I work with this new release I will put up what I see happening..OK

[Fraoch]

Thanks Drew.

Also thanks for all the work it took to put together the tutorial! Much appreciated.

[iceman84]

I need HELP!!!

Does anyone know how to create check buttons,
I need help creating a few check buttons.

I am unable to assign the check boxes value, it only returns "1" or "0".

Can anyone help???

Thanks in advance...

[DiGro]

Which value ?

It is either ON ("1") or OFF ("0")
_________________
DiGro

[iceman84]

Yes! yes!!.

Something like that only 2 values "1" and "0" only.

Can I assign any other values besides these 2 values or is there an alternative way to this problem.

[DrewJensen]

As far as I have been able to determine you can not change the default behavior of the checkbox, assigning 0 or 1 - directly. I blekive this is a bug and will open an issue.

As a work around for the moment you have two options. One requring some Basic code and one requiring the use of two radio buttons. The radio buttons refernce values property does work - go ahead and try it. But you will need two of them, sine you can;t toggle a radio button.

The other option would be to assign a macro to the 'When Item Status Chenge' event of the check box.

[iceman84]

Dear DrewJensen;

Would you happen to know/have of any samples codes regarding the 'When Item Status Chenge' ??

I need some sample codes for reference...

Thanks in advance.

[Blaise]

I have a problem with adjusting the tabstop order in my form. Following this tutorial (which is impressive by the way) when I clicik on the Form Navigator Button Base brings up a different view of the lables and text boxes in a tree without the buttons. It does not let me move the boxes around.
Any suggestions as to what I am doing wrong?

-----------
2nd question. (Being new to databases my apologies if the answer is somewhere obvious - please just point me to it.)

I have a table with a list of people (fields LastName and FirstName) and an automatically generated Primary Key. I want to create a second table with the Names and Addresses for these people so I can use it for mailing list purposes. is there a way I can link a new table so that when I create records it will pull in the names. I think I should probably be creating a table linked to the fist without the names but with their addresses and a common field so that I can run a query which will be the names from one table and the addresses from the otherbut I don't see how to link them. Any suggestions?

-----

thanks in advance

Blaise

[DrewJensen]

Blaise

Will try to answer these in other message threads.

[kptan]

dear drew, i dont really understand the part about inserting the photo and note form. seems like u kinda jump a distance all of a sudden.

well im having this problem when i create both forms, and setting the master and slave, it shows employees notes and department, where is my mistake? and i dont really understand from the part after deleting the relationship for photo. can u elaborate more..... thanx.

[Sandy Dunning]

Following tutorial, but can't figure out how to add a list box control to a form.

I need the steps for doing this, so the List box Wizard will open, (the tutorial tells me to add a list box, but I don't know how- everything I've tried won't pull up the wizard up, as the tutorial implies)

Any response is greatly appreciated!
(I am at the "List Box" section of the tutorial)
SandyD

[jwf]

Sandy, To get a listbox added:
1) Open your form in 'edit' mode
2) goto the top navigator bar and select VIEW >> TOOLBARS >> FORM CONTROLS
This will add a "Form Control" toolbar to your window. On this toolbar is the Listbox control,,, click it, then place your cursor where you want the control and press and hold the left mouse button while moving your mouse to the desired size.

You should have what you need to continue.

[platon]

Hi for some reason I don´t seem to be able to find the sequel to this wonderful tutorial - Message 1 in this thread. I paged through this rather long thread but found nothing. Have I overlooked it?

[acknak]

I also found this tutorial/example/thread very helpful.

I also ran into problems with the Notes/Photo section, although I did eventually get the notes to work.

It would be great to see the presentation updated to smooth over some of the glitches, flesh out the last part (the subforms) and include the report.

Anyway, one thing I need help with: as I said, I fiddled around and finally got the Notes subform to work, however there are some lingering bad behaviors and I'm not sure whether it's my fault, or a Base bug. If someone could take a look at my database (here: Employees.odb) and tell me if you also see these problems when entering data in the Notes subform:
1) I set the "Navigation Bar" property to "Parent Form", but if I make an entry in the subform, then click "Next Record", the entry is lost. I have to specifically click the "Save Record" button to update the data store. For fields in the main form, editing then moving off the record is sufficient to save the changes.
2) Sometimes, after I type some text in the Notes text box, I have to move the mouse around or click in a different field before the Save Record button (the little floppy disk icon) activates for the subform.

Ok, I see now that these are related. Once the Save Record button activates, moving to the next record will save the changes to the Notes field.

Does anyone else see this (I've tried 2.0.2/2.0.4 on Fedora Linux)? Is there something I need to change in the form?