Hello.
I have a Jasper Report being populated from a database. The report will be used as a stock check form so I have a rectangle on there that will be used to enter data manually when the report has been printed.
One of the fields (Reference) is set to not print repeated values but how can I get the rectangle to only print when the Reference is printed.
I have tried:[LIST][*]Boolean.valueOf ($F{Reference}. isVisible())[*]new...
Corwin Moyne
Last Activity: Nov 29 '14, 10:29 PM
Joined: Feb 18 '12
Location: Ireland
-
Jasper Report: How can I hide a field based on another
-
I did exactly this in a Java Desktop application this week. I have user details in a table on a database, ie username, password and user type. The user type is either admin or standard. When the user logs in, the application checks the username and password and if they exist it returns the user type. If the user type is admin, a hidden button is now available on the window they login to allowing them to open a another window where the admin only... -
How can I retrieve records and a total count of the records - MySQL
If I write:
SELECT * FROM table_name WHERE date BETWEEN "2014/07/01" AND "2014/07/04"
I get 4 records returned which is what I want. But I also want the total number of records which in this case is 4, but if I write:
SELECT *, count(*) AS total FROM table_name WHERE date BETWEEN "2014/07/01" AND "2014/07/04"
It displays total 4, but only one record.... -
Corwin Moyne replied to Access 2010 - VBA - How can I send email with Outlook? It just sits in outbox!in AccessHey. The following link shows how. Just replace the red writing with your own details.
http://www.blueclaw-db.com/access_email_gmail.htm...Leave a comment:
-
Corwin Moyne replied to Access 2010 - VBA - How can I send email with Outlook? It just sits in outbox!in AccessI tried that a long time ago but it didn't work. I ended up bypassing outlook altogether and sending using gmail's SMTP server. Works great.Leave a comment:
-
Thanks for the reply. I think your suggestion is good but I have no experience with jsp or tomcat. I do have experience with php and phpmyadmin. I could use that. The reason I wanted to create a desktop application is that is what I do best.Leave a comment:
-
What is the best back end to use with a Java or C# front end?
4 years ago I designed an Access database for a company I worked for. It has a back end on the company server and multiple (about 6) front ends. It is in use everyday and works well but is not without problems.
I have just completed my third year of a Computer Science degree where I learned a lot of new skills. I have been given the opportunity to redesign the system over the summer and I am trying to decide what is the best way forward?... -
How do I retrieve values from combos dynamically added to html table
I have a table with 10 rows added by looping throw a $result from a database query. When the user selects an option from one of the combos, how do I get its value. I have used Javascript but I can only get it to work with the first combo.
COMBO CODE
...Code:echo"<td><select name='status[]' id='combo' onchange='getComboValue()'>"; echo"<option value='' ". (($row['finished']) == 0 ?
-
How do I update a JProgress Bar inside a thread?
I have a thread that runs some data. I want the progress bar to update as the thread runs. But how can I get the info from the thread to set the progress bar value?
What is the correct way to achieve this? -
I found a solution myself:
I started the button listener inside a new thread that implements Runnable, that way the listener is not caught up in Swings own main thread.Leave a comment:
-
Corwin Moyne started a topic How can I output to a text area whilst JButton listener is in execution?in JavaHow can I output to a text area whilst JButton listener is in execution?
I have a GUI that runs sorting algorithm tests. I want to update the user to what is happening by updating a text area as the program runs. A start button gets the ball rolling but the text area does not update until the program finishes, although the console does.
Clearly a threading issue I hear you say, and I agree.
The problem I have, is I am trying to start a thread to update the text area, but the thread does... -
JDBC to Access connection gone wrong?
In the last couple of days I successfully created an Access backend and a Java frontend. I added to the driver using %windir%\SysWOW 64\odbcad32.exe as I use Windows 7 64 bit and it connected to the database first time. Hooary! I then went to college today and successfully connected again using another 64 bit machine. Later in the day I connected using a 32 bit machine but when I got home it would no longer connect on my home machine. Error: "[Microsoft][ODBC... -
Corwin Moyne started a topic Java - Do I need classes in my front end that match my database tables?in JavaJava - Do I need classes in my front end that match my database tables?
Hello. I am a little confused. Up to now my Java college projects have not been connected to a database. Last semester we serialized the data we wanted to keep.
I have been asked to do a class diagram for a new project that will have a database backend and a Java frontend. The project is for a cinema and will store movies etc in a database. If all the relevant info is in the database, do I need classes in the frontend that match the... -
Corwin Moyne started a topic Can I output data from a query / table / form by email as apposed to attaching?in AccessCan I output data from a query / table / form by email as apposed to attaching?
I have an Access Database that is used as an ordering system. At the minute, when the user hits the re-order button, the details required are passed to a sub which then passes these details into the body of an email and sends it. This works great but the problem is, one email equals one order. One of my users has now requested that multiple orders can be made on one click of the button. I have added a check box to the form and ideally I would like... -
Can I pass String[] values to array in another frame?
I have been given some already complete classes by my lecturer and the idea is that I build a GUI. The project is based on an Employee class.
Among other things, I would like to add a new Employee to the array of Employees already created for me by my lecturer. The problem I have is in the way my lecturer has set the project up: I run an EmployeeTester class, and after selecting an Employee to view from a combobox, a new frame opens... -
I am using Access 2010. Can I program using C# instead of VBA?
Hello. I am currently creating an Access database. I am a second year programming student where I am learning java and C#. Can I use C# instead of VBA when it comes to Access? I am pretty good with C# but know nothing about VBA and I am finding the different syntax very confusing. -
Corwin Moyne replied to Access 2010 - VBA - How can I send email with Outlook? It just sits in outbox!in AccessI don't need to send any objects. The body of the message will contain info on the fields from the originating form. I just need to keep Outlook open long enough for the message to send.Leave a comment:
-
Corwin Moyne started a topic Access 2010 - VBA - How can I send email with Outlook? It just sits in outbox!in AccessAccess 2010 - VBA - How can I send email with Outlook? It just sits in outbox!
Hi there. I'm a complete noob when it comes to VBA. I have some code that I got online to send an email using Outlook through Access 2010. The code works by displaying an Outlook message window, but the message sits in the outbox until I open Outlook. Is there anyway to keep Outlook open long enough for the message to send. The reason I am asking is because this database will be used in work and I cannot guarantee that the guys will open Outlook...Last edited by zmbd; Nov 18 '12, 10:52 AM. Reason: [Z{Please use the <CODE/> toolbar button to format posted code.}] -
Corwin Moyne started a topic Access 2010. How can I remove value from a combobox after it is selectedin AccessAccess 2010. How can I remove value from a combobox after it is selected
Hello. Lets say I have 3 tables: jobRef, colourAnilox and aniloxTable. jobRef is a parent of colourAnilox. I have a combobox on the sub form colourAnilox that gets its list from aniloxTable. Once the user makes a selection on the combobox (aniloxRef), I want to temporarily remove this from the list as I can use it only once on each jobRef. But how can this be done?
I do not know how to write VBA so I am hoping this can be acheived... -
Corwin Moyne replied to How to reference a field in a parent table in a SendEmail macro. Access 2010in AccessSorted. I set up a macro on a form instead of the table. This allowed me to add the YR Number to a sendEmailObject . Thanks.Leave a comment:
No activity results to display
Leave a comment: