Archived NeoSoft Support Forum

Is there a way to trap the delete key?
In my database program if someone hits Delete on purpose or in error I don't want a record deleted.
I would hope I can have the Message "Are you sure you want to delete this record?" and allow a chance to cancel the operation.

Good to hear! I was concerned about my future programming efforts. Without Neobook, I was not sure what would happen.

It just a hobby with some business in the mix. I have developed an Accounting Program, Invoicing Program, Inventory Program, Membership Program and others for my use and others.

Since I built SQL execution possibilities into the app, I was able use ALTER TABLE YourTableNameHere ALTER COLUMN YourColumnnameHere VARCHAR(50) successfully. Wasn't just for myself. Now I can tell my customers how to change the length if required. My idea was to use SQL if I could figure out how. N...

I have an application which allowed 35 characters for email address. Of course, someone has to come up with an email longer than 35 characters. Is there an elegant way to extend the length to 50 characters? I have an idea but before I do that is there a way to determine the length first? That is, if...

I have my code working now.
Once I used LEFT JOIN is worked.
I now have the code and report working to my satisfaction.

Thanks for help.

Just noticed your reply. Thank you. I assume the J after FROM JrDetails is in error as well as G after JOIN GL G. :o I have tried to adapt the code but I am getting 'can't perform this operation on closed set'. dbpExecSQL "TryDb" "SELECT JrDetails.AccountNo, GL.AcctDescription, GL.Acc...

Sorry I guess I wasn't clear. I would like the query to do a 'look up' for the AccountName according to the AccountNo from the GL Table. Maybe it's a join I need. I programmed it originally to add the AccountName to the JrDetails table which corresponded to the AccountNo. The problem occurred when I...

This SQL depends on the AccountName to be part of the JrDetails table. Using Insert, what I want is to get the AccountName from a GL (General Ledger table) using the common AccountNo to be part of the result without duplicating the AccountName in the JrDetails table. dbpExecSQL "NBAccounting&qu...

Hoping to have one button to use for Edit Off (default) or Edit On?

Is there a way to test if a grid is in readonly=true status?
I have the default as readonly=true but want to use a button to change to readonly=false when I want to make changes.
I want to toggle back to readonly=true after editing.
Suggestions?

I have a contact database in which I have an email field.
I have a button to click to send an email but this wants me to use the default email app on my computer.
Since I use gmail to send and receive email, how to I invoke gmail when I click this button to send email to a particular contact ?

I adjusted the return address with/without logo to more than 1" from left side on #10 envelopes.

Strangely enough the envelope prints properly on Epson printer at an office but not on Brother MFC-J470DW at home.

Thank you for your reply.

I would hate to see Neobook and other apps die. I used to Program with Delphi as a hobby/business but it became too expensive to update. Neobook and add-ons satisfied my programming needs at an affordable cost. I have written several apps such as Accounting, Invoicing, Inventory control, membership ...

Original Flyers http://www.computersoftwaresystems.com/Neosoftware/NeobookPro.jpg http://www.computersoftwaresystems.com/Neosoftware/Neopaint.jpg http://www.computersoftwaresystems.com/Neosoftware/QuikMenuIII.jpg http://www.computersoftwaresystems.com/Neosoftware/Neoshow.jpg It's been a while from D...

I have 2 apps from which I print envelopes. I have a Brother MFC-J470DW inkjet printer (for colour) and a Brother HL-5140 Laser Printer. One app is a specific envelope printing app with option to print with a logo or not. The other app is a membership app to print envelopes to members which includes...