Search found 351 matches

by BRobinsonS
Sun Nov 05, 2017 4:15 pm
Forum: NeoBookDBPro
Topic: Protecting field from accidental change
Replies: 7
Views: 10060

Re: Protecting field from accidental change

Thanks I will work on the idea.
by BRobinsonS
Sun Nov 05, 2017 2:02 pm
Forum: NeoBookDBPro
Topic: Protecting field from accidental change
Replies: 7
Views: 10060

Re: Protecting field from accidental change

Might need some help with this one.
I understand about the subroutine.

How do I focus on the MemNum field in the subroutine to see if it is being changed (i.e. by accident) ?
I would then prompt "Sure you want to change this field? "
by BRobinsonS
Sat Oct 28, 2017 11:45 am
Forum: NeoBookDBPro
Topic: Protecting field from accidental change
Replies: 7
Views: 10060

Re: Protecting field from accidental change

Still a mystery to me. MemNum Field on form is Disabled so change would not be made by accident. Only MemNum field is a text field disabled with other MemNum values displayed by Simple Text (not editable). There is a Change MemNum used to change a MemNum from Temporary Number to Permanent Number. No...
by BRobinsonS
Sat Oct 14, 2017 11:49 am
Forum: NeoBookDBPro
Topic: Grid in Rectangle in Custom Window
Replies: 1
Views: 5629

Re: Grid in Rectangle in Custom Window

Found it under Grid Properties.
Been a while since I have been thinking programming.
:oops: :!:
by BRobinsonS
Sat Oct 14, 2017 11:09 am
Forum: NeoBookDBPro
Topic: Grid in Rectangle in Custom Window
Replies: 1
Views: 5629

Grid in Rectangle in Custom Window

In my app I have a table showing in a rectangle object in a Custom Window. I have an ADD button which will allow the user to add information (e.g. office held and dates from/to) to the table as well as extra information automatically. e.g. Member Number (using current member screen) I don't want the...
by BRobinsonS
Tue Jun 27, 2017 10:37 am
Forum: NeoBookDBPro
Topic: Fighting with Report Designer
Replies: 2
Views: 6745

Re: Fighting with Report Designer

Dave,
I used the same settings.
My mistake was trying to satisfy a user testing my software.
So I just used Maintain Aspect Ratio with a certain size of box/field and Report Designer

Thanks for answering.
by BRobinsonS
Sat Jun 17, 2017 11:21 am
Forum: NeoBookDBPro
Topic: Sql to increase column size
Replies: 5
Views: 7778

Re: Sql to increase column size

Thank you.
It works.
by BRobinsonS
Sat Jun 17, 2017 9:28 am
Forum: NeoBookDBPro
Topic: Fighting with Report Designer
Replies: 2
Views: 6745

Fighting with Report Designer

In Report Designer for an Envelope printing program, no matter what settings I use for the Logo graphic from a database field the logo wants to autosize on the envelope. Tried Maintain Aspect Ratio on and off. Tried Center image on and off. Tried both off and both on with same results. Can the size ...
by BRobinsonS
Sat Jun 17, 2017 9:10 am
Forum: NeoBookDBPro
Topic: Sql to increase column size
Replies: 5
Views: 7778

Re: Sql to increase column size

I am using the AccessDB of DBPro.
by BRobinsonS
Sat Jun 17, 2017 7:28 am
Forum: NeoBookDBPro
Topic: Sql to increase column size
Replies: 5
Views: 7778

Sql to increase column size

I have a field in a couple tables of ProvState String(2) .
I have a request from Australia that a user needs at least String(3).
I would like to alter the field/column size to String(5) for existing databases using SQL in the code.

What would be the correct syntax using Neobook and DBPro?
by BRobinsonS
Tue Jun 13, 2017 4:43 pm
Forum: General NeoBook Discussions
Topic: Shortcuts
Replies: 5
Views: 3383

Re: Shortcuts

Why not use Innosetup ? http://www.jrsoftware.org/isdl.php
Lots of options to set shortcuts etc.
by BRobinsonS
Mon May 01, 2017 9:05 am
Forum: NeoBookDBPro
Topic: Using variable in text to print
Replies: 2
Views: 5983

Re: Using variable in text to print

Thanks for the tip.
I'll work on that.
by BRobinsonS
Mon May 01, 2017 6:20 am
Forum: NeoBookDBPro
Topic: Using variable in text to print
Replies: 2
Views: 5983

Using variable in text to print

I have an app to create and edit different custom letters. The text is stored in a DBPro table and printed using Report Designer. The header is the same but text varies. The text is plain text but I want to use variable(s) in the text to personalize the text. Is there a way to do this Report Designer?
by BRobinsonS
Wed Apr 05, 2017 2:05 pm
Forum: General NeoBook Discussions
Topic: Backup routine to USB when Drive letter changes
Replies: 4
Views: 2465

Re: Backup routine to USB when Drive letter changes

Gaev, Thank you for the simple solution i.e. testing for Root folders. I will try to use the idea in my backup routine. I did notice your test for d:\ came up 'true'. My test needed a disc in the d:\ to result in true. I was pleased that the FolderExists function didn't cause any error messages to h...
by BRobinsonS
Mon Apr 03, 2017 12:39 pm
Forum: General NeoBook Discussions
Topic: Backup routine to USB when Drive letter changes
Replies: 4
Views: 2465

Backup routine to USB when Drive letter changes

I created a backup routine for my projects (in each program). It has been working fine except for one situation. One of the options is to backup to a USB drive and the path is kept in the database. I do have a Button to update the path. The problem comes in when the path is saved as e:\backup but th...