1 Reply by tjohnson0473

(8 replies, posted in General)

Hello MVD,

I know this is not my place to post this but like you, I have wondered if this project would be abandoned. I come back to the site to see if a new release is posted, and every morning I am more disappointed to see that there is none. So I have searched the internet for a substitute program and came across "Longtion Sofware". I took my project that I have been working on for the last 2 years in MVD and reduplicated it within months. From what I have seen so far this software platform is awesome. I purchased  RAD Builder. Here is a link and a quick description. Oh, did I mention that if you need assistance with any part of the software or need a special function or how to do something within the software, you send customer service an email and you get a really quick response.

Longtion Software  - http://www.longtion.com

RadBuilder is a complete rapid application development (RAD) tool to create interactive multimedia applications, database applications, and Web applications for Windows - without programming. You don’t have to be a programmer, but with RadBuilder you’ll feel like one. Even though it is very easy to learn and use, it has everything you need to develop professional software applications with a completely visual drag and drop environment.


But I am still hoping that Dimetry will return and when he does the new release will be awesome, or the site will just disappear like did.

Take care all...

Go to forum: General

2 Reply by tjohnson0473

(10 replies, posted in Script)

As usual, you are awesome... Thanks, Derek

Go to forum: Script

3 Topic by tjohnson0473

(10 replies, posted in Script)

Hello All –  I am hoping all of you pros out there have answers to some questions. I know the answer is looking me square in the face but I can't see it.

1.    I have noticed when I load my project that there is usually one button on the form that is highlighted. How do you keep that from happening?

2.     My second question is if you have a form that has a PageControl element with multiple tabs and your want to load the form to a specific tab how
        would you write the code? I like to use this element instead of creating multiple forms.

Go to forum: Script

4 Reply by tjohnson0473

(5 replies, posted in SQL queries)

That works perfectly.. Thanks Derek

Go to forum: SQL queries

5 Topic by tjohnson0473

(5 replies, posted in SQL queries)

Hello All,

I have attached a sample project where I am having an issue with the calculation field. As you can see Form 1 will show the balance due for all clients collectively, but when you complete a search by name or date the balance does not change. Is there a way to show the balance for each client individually? This way when I create my report I can show the client his payment history and balance.

Go to forum: SQL queries

6 Reply by tjohnson0473

(2 replies, posted in General)

Perfect

Thank you

Go to forum: General

7 Topic by tjohnson0473

(2 replies, posted in General)

Hello All,

I would like to add a setup wizard function to my project. I have attached a sample that I am having trouble with the script. The wizard has a function that if the client does not want to show the wizard start function then they can check the box. Then if the client would like to show the wizard again they can uncheck the box. I am having trouble getting all of the components to work. Is there someone that can help out? Thanks

Go to forum: General

8 Topic by tjohnson0473

(0 replies, posted in Script)

Hello all,

I have a project that requires a fee to be charged to each customer once a week. Is there a script that I can use to achieve this? It would be handy to have a checkbox next to the customer's name that could be used to exclude anyone customer when posting the charge.

Go to forum: Script

9 Reply by tjohnson0473

(9 replies, posted in General)

Is there a way to adapt "CalendarWithReminders Revised2" to the new styles? I have added it to my project but the main calendar background is white and you cant see the data in column 1. I would like it to be as dark as the task list, but still, show the colors when a task is set. Currently, I am using the style AuquaGraphite. I have attached a screenshot.

Thanks for any help you can give.

Go to forum: General

10 Reply by tjohnson0473

(15 replies, posted in Reports)

Thanks, Derek

That makes a lot of sense now that you mentioned it.

I appreciate all of your help.

Go to forum: Reports

11 Reply by tjohnson0473

(15 replies, posted in Reports)

Hi Derek,

I have added a sample project for you to look at. I built the sample on the delete table project you did for me because I am also having an issue with the project trying to run the script for the registration keys that is on the inclosed notepad file. Since there is 2 procedure for OnShow for fmDashboard it gives an error. I have tried to rewrite the script to make it work with no luck. Can you please take a look at it. This is another major function of my project since I need it to expire so a new key can be used to reactivate it.

I set the report to use the "Report" function instead of the script to show that the information on the table grid will not pull. I also tried the search script by name and is still will not work. I am thinking it has something to do with the relationships between the tables.

I can't thank you enough for your help with this. my client starts beta testing the project in a week so I am really excited to get this portion completed.

Go to forum: Reports

12 Reply by tjohnson0473

(15 replies, posted in Reports)

Is there anyone that can help with my latest post? I have tried many different scripts but no luck. Once I try to search by ComboBox the information will not display on the report. I have tried using the Report function instead of Report SQL but the information still will not display. Has anyone else come across this before?

Go to forum: Reports

13 Reply by tjohnson0473

(2 replies, posted in SQL queries)

This is awesome Derek... Thanks

Go to forum: SQL queries

14 Topic by tjohnson0473

(2 replies, posted in SQL queries)

Hello all,

I am looking for a command procedure that I can add to my project.

I need to add a new menu item in "Options Menu" to say (Clear Database)

With this option, the user can clear all the data from specified tables with a warning dialog box of  "Are you sure you want to clear the data?" Yes to clear and no to return to Form1.

Has anyone written a procedure like this?

Go to forum: SQL queries

15 Reply by tjohnson0473

(15 replies, posted in Reports)

Thanks Derek for the example. Does any know how to modify the search my comboBox? I found an example in the forum but I cant seem to get the data to pull through to the report.

SELECT                                   
  payments.date,
  payments.payment,
  contacts.bowler_name_ID,
  payments.membership,
  payments.secratary_fees,
  bowling_weeks.week_num
FROM
  payments
LEFT OUTER JOIN
  contacts on contacts.id = payments.id_contacts
LEFT OUTER JOIN
  bowling_weeks on bowling_weeks.id = payments.id_bowling_weeks
 
WHERE ("bowler_name_ID" LIKE '%{Edit_Search_Value}%')
        AND (  "contacts on contacts.id = payments.id_contacts" = '{ComboBox_Seacrh_ComboBox1}')
               
        ORDER BY "bowler_name_ID" ASC

Go to forum: Reports

16 Reply by tjohnson0473

(15 replies, posted in Reports)

Thank you Derek,

I would rather use the report function, but for some strange reason it will not display any of the relationship data between tables or it will only display the first record only. Unless I am doing something wrong which could be the case. Do you have any idea why this would be?

Go to forum: Reports

17 Reply by tjohnson0473

(15 replies, posted in Reports)

Thank you for your assistance.

Is it possible for someone to write me a sample query from the table examples that are attached to make the Union between the tables? I can use the report function to create the report, but it only displays one record at a time. If I use the Report SQL and write a simple query, I can get all records to display minus the ones that have a relationship with another table.

Go to forum: Reports

18 Reply by tjohnson0473

(15 replies, posted in Reports)

Hi Derek,

What you see in the pdf is all the query that I have written so far. The project that this is connected to is very large and I would rather not attach to the forum. I am sure there is a simple solution to my problem. I just can't see it. Here is more information on my project details.

table names:             column name:

contacts                    bowler_name_id
award_type               award
bowling_weeks         week_num 

I just tried this and I am now getting a syntax error by ","

SELECT

award_recap.date,
award_recap.game1,
award_recap.game2,
award_recap.game3,
award_recap.total,
award_recap.high_game,
award_recap.high_scratch,
bowler_name_ID FROM contacts where contacts.id = bowler_name_ID,
awards FROM award_type WHERE award_type.id = awards,
week_num  FROM bowling_weeks WHERE bowling_weeks.id = week_num

FROM award_recap

Go to forum: Reports

19 Topic by tjohnson0473

(15 replies, posted in Reports)

Hello All,

I am stuck.

I am trying to write a simple query for Report SQL but I can't seem to get the relationship data between tables to pull through.

Can anyone help me write this simple query? I have attached what I have so far.

Thanks

Go to forum: Reports

20 Reply by tjohnson0473

(4 replies, posted in General)

Thank you Derek. That is what I needed.

Go to forum: General

21 Reply by tjohnson0473

(4 replies, posted in General)

Sorry I am still new to all of this. But I would like the window state to default to open at the bottom of the parent window or the ability to set the location just like you would a panel.

Go to forum: General

22 Topic by tjohnson0473

(4 replies, posted in General)

Hello all -

Is there a way to set a child window to open in a specific location within a parent window?

Go to forum: General