Search Result

maff811 · Jan 30 '12, 12:12 PM

Hi there,

I have a small database in MS Access that is causing me some issues.

I have a Main Form "A" which has a number of Subforms "B", "C", etc.

Main Form A has 'autonumber' as the unique identifer for each record, whereas subforms B, C etc have their primary key as simply 'number'. These fields are linked.

I am able to show records for each subform that...

pkminer30 · Nov 8 '11, 09:50 PM

My visual basic code is:

Code:

Public Class Form1

    Dim PasswordTrials As Integer

    Private Property TextPassword As Object

    Private Property TextUsername As Object

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim Login = Me.ClientsTableAdapter1.ClientQuery(TextUsername.Text, TextPassword.Text)

...

Ron Fontanillas · Mar 3 '11, 10:08 AM

Hi All,

I'm new here and also new with Access 2007.
I have a Form named "Copy_of_Qr y" and a subform named "qrysubform ". the subform is based on a query with column headers Year, Month, PIC, etc.

I've made three combo boxes, all which are supposed to filter the query (subform), one for the Year(cmbYR), then month(cmbMonth) , then PIC(cmbPIC). I just used the parent/child linking method. What...

sammy vang · Mar 1 '11, 04:41 PM

You can consider me an amature. I can't figure this one out. Hopefully, I can explain it well enough.

Here's the structure of my page:

***myASPpage.as p***
(contains a frame inclosed in a div)
<frame id=myFrame>
|
V

***mySearch.asp ***
(contains a form with two select fields)
<form id=searchForm>
fields: model & serial
|
V...

AlarV · Jan 7 '11, 10:03 AM

Hey everyone, I created a GUI project, where I'm using a JTree. When it's created everything is ok, but in my run() method when I call it i get a nullPointerExce ption. Here is the code.

Code:

treePanel = new javax.swing.JPanel();
DefaultMutableTreeNode top =
        new DefaultMutableTreeNode("blah");
        mytree = new javax.swing.JTree(top);
javax.swing.GroupLayout treePanelLayout = new javax.swing.GroupLayout(treePanel);

...

Sri13 · Dec 2 '10, 04:23 PM

Is there a way to initialize an enum to null/empty?

Code:

public enum Color
{
  Red,
  Blue
}

How to do something:
Color c = null;
or
Color c = "";

Fspinelli · Nov 10 '10, 04:57 PM

Hi again!

I have a form (parent) that has a subform (child). I know how to make it so the parent form's feilds opens up null, but I need the subform (child) to open up null, too, when this form opens up.

From the parent form the subform populates symbols based on the parent form which has some combo boxes to choose from and one text box to enter a number into. When the end user enters or choses the data in the parent...

gnawoncents · Oct 6 '10, 09:54 PM

I have a form (FRMsurveyRepor ts) with several combo boxes (e.g. Class, ClassUnique, SurveyID, etc.) which use an SQL query based on a table (TBLSurveyRespo nses) for their record source. The available options filter based on any criteria selected in the combo boxes above them. If nothing is selected, all options should be visible.

For example, consider the following combo boxes below.

ClassUnique
SurveyID
...

Robert Vida · Jul 26 '10, 07:03 PM

Hello, my question has to do with inner joins and nulls.

The question is, how would i need to modify an inner joins search query to return all fields even if a table is null. So basically, if I have two tables that have matching values and a third table that is completely null or doesn't have those values, I still want it to return those matching values.

I also don't have any experience with this so please describe it...

katlee · Jul 13 '10, 01:47 AM

I am using Access 2007 to design a database that will allow users to search an inventory of historical photographs. Currently I have a table with fields such as Date, ID, Description, Project, Division, Unit, Facility, Feature, Subfeature, Region, Area Office, and State. I am using a query by form method that have either text boxes or combo boxes for each of the fields. I want users to be able to enter in the fields that they want to search by...

nstalkol · Jun 1 '10, 05:51 PM

Im a rookie.

I have am unbound combo box populated with values (rowsource) from a query which has 2 tables in it. Each table has its own ID, but both are included in the combo box (info3). Sometimes the combobox has ID values from Table A, but the corresponding ID value in table B is NULL. The bound column is the ID from B, because I use it to populate text boxes, by going to that record using:

strCriteria = "[ID]...

zealman · May 7 '10, 06:07 AM

Code:

import java.util.*;
import java.io.*;
import java.math.*;
import java.awt.event.*; 

class Node
{
	String ortu,isi;
	int jumanak,jumchild;
	Node child[] = new Node[5];
public Node(String parent, String a)
	{
		ortu=parent;
		isi=a;
                jumanak=jumchild;
	}
}

public class tree 
{
private Node root;

...

rmatos95 · May 4 '10, 03:08 PM

I have a table where, in many fields there are numbers from 0 to 5. I need to convert the zeros into null. I guess I need to create an append query, but I do not know which expression to use so that it will convert the zeros to null.
Thanks for the help!

jrlittle86 · Apr 8 '10, 01:14 PM

I know I'm overlooking something very simple but How can I check if the text within an XML tag is blank?

The code below works fine as long as there are values within an XML node (For example the <CPU>Intel</CPU> node below) but it throws an Exception error when the node value is blank/null whatever as in the example node <Monitor> </Monitor>.

It's ok if the node value is blank, I just want...

EARNEST · Feb 25 '10, 11:54 PM

Hello guys,
My program would allow a user to tweak its calculations engine via certain controls: radio buttons, check boxes etc. The problem is, based on such settings, appropriate events would take place that would either improve my programs performance (by disabling certain dynamic GUI updates) or slow it down (dynamic GUI control's updates).
To disable those GUI components, an event has to be assigned to null.
How can I...

Search Result

No data shows when I run a query

Need help fixing my Login Code in Visual Basic

null value shows all records in subform

Debug my javascript issue with forms and frames

Java GUI Static component, NullPointerException

How to initalize enum to null or blank?

How to make a subform's field clear on open

Query based on combo box needs to return all values if Null

How to modify an inner join search query to return all fields even if a table is null

Multiple parameter query; ignore blanks & have results match all parameters entered

Bound Combo box is Empty on selection of Null value on Exit Sub

Tree

Convert zeros to null

How to Check if XML Node is Empty/Null/Blank

Assigning a null value to an event in one class from another class