Hi,
1.
I want to show all the records where a specific data is not populated. Currently in the database, for a specific field some cells are empty.
I am wondering, how to build the query which will show the records where the cells are empty for a specific field?
2.
Also, say, [TableA] is linked to [TableB] via junction table[JtableAB]. How do I show which records in [Table] A are not linked...
18 results in 0.0023 seconds.
-
How to show and count empty cells for a field / table?
-
Auto Increment ID field of Linked table when entering on Form
I have a linked table called "dbo_proble ms". I have a form that uses "dbo_proble ms" as its data source. The linked table "dbo_proble ms" has a field called "ID" which is a Number. This field requires a value and when I enter a new record I want the ID field to use the last record ID + 1. So for example if the last record ID that was entered was "17586", then if a new record was entered the ID... -
Change hidden field value when dropdown list changes
Hi,
The problem is I have a list that i want to send to other file(php) but I want to send two corresponding variables. I was wondering if this is easy with the hidden field.
...Code:<select id='myselect'> <option value='1'>A</option> <option value='2'>B</option> <option value='3'>C</option> <option value='4'>D</option> </select> -
using (char*) in switch statment
Hello everybody.
I am new in C programming language and have an (if satament) and need to transfer it into switch statment.
My problem is that I have a field named (node_kind) of char* type and I compare it's content in the if statment using (strcmp) but I don't know how to do that in the switch statment.
Would you plz tell me how ?
Here is a short quote of my program
...Code:if (strcmp(node->node_kind, "VAR_TOKEN_e")
-
How do I move to the previous field in a recordset?
I am pretty inexperienced with VBA recordsets, and hope there is a simple fix to my problem. I have a recordset (rstQuestions) and am using a For Each...Next operation to go through the fields (fldQuestions) and pull data from relevant ones. I'm running into a problem though when I try to navigate to the previous field (not record).
Here's what I'm trying to do... I need to find the relevant field in a recordset (done; no problems),... -
Expression Help
I have a query set up with a list of records with check box fields, Text boxes and one text field with numbers.
I used this expression to get the sum total of [Text box with numbers] per total records by counting [Text Box A]
=Sum([Text Box with numbers])/Count([Text Box A])
80/21=3.81
Now I want the total of [Text box with numbers] per records with [Check Box A] checked.... -
y do i get this error? Unknown column 'imagePath' in 'field list'
This acually happends to all fields, i have made sure that i have connected to the right database name, if i post my query (SELECT id, imagePath, titleOfTutorial , descriptionOfTu torial, tutorialBy FROM dogs ORDER BY id desc LIMIT 6) into mysql on phpMyAdmin it works fine and shows the data, but dosen't work on my web page, i dont understand whats happenin' here, i have google it but no luck,
This is my code...
[code=php]... -
a macro to create a drop-down field
Hi
1-Is there a way to have to make a drop-down field and and populate it using a macro?
2-Is there any way to edit drop-down field code ( I mean { FORMDROPDOWN } not through dialogue box. -
Access Report Displays Number from Drop-down vs. Text
I am producing a report in access. I have a field in a table that is a "Look-up Column". When I add the column to a report it prints out the line-item number vs. the text. For example if I have 3 items in the lookup:
1 Entry 1
2 Entry 2
3 Entry 3
The number 3 prints out vs. "Entry 3". How do I get the content of the column to print vs. the positional number?
Thx -
Check field in subform
I have a form with subforms on it (subforms are designed on tabcontrol and each has separate page)
After user enter information on form and tries to hit "Save" button i would like the access first to check if value in a subform field is not empty.
It is tblTakeOrder form. When user fills information on form with order id, client name and required date and try to save it - access needs to check SubForm "Order... -
How to add a field not in field list to an access report
I am pretty new to editing things in vba access. I have a report that didn't have a field that I needed in the field list, I modified the recordsource query, it is a sql pass through query:
SELECT dbo.SalesOrderD elivery.SOD_Rec ordID,dbo.Sales OrderDelivery.S OD_UserDef1,dbo .SalesOrderDeli very.SOD_UserDe f2, dbo.SalesOrder. SOM_SalesOrderI D, dbo.SalesOrderl ine.SOI_Packsli pDesc,dbo.Sales Order.SOM_Speci alInst, dbo.SalesOrderL ine.SOI_SOLineN br, dbo.SalesOrderD elivery.SOD_Req uiredDate,... -
mysql query
here is...Code:$result = mysql_query("SELECT * FROM product, members WHERE members_username='amino'") // <= put table field here or die(mysql_error()); while($row = mysql_fetch_array($result)) { echo $row['product_title'] . " " . $row['product_description'] . " " . $row['product_price']; echo "<br />"; } mysql_free_result($result); -
Field List Returned as Data
I have a table with a large number of fields associated. I'd like to run a query to return the names of all these fields as data, so I can use this later in other data manipulation queries.
I'm very rusty on SQL Server, so I expect a nudge in the right direction would be enough to get me going. -
Insert text in flash
Good evening i got a question, hope that someone can answer it. Yes i have all ready used the search function and nothing showed up.
If you load a flash website in a webrowser inside your application, is it then possible to enter text in a flash form field. I have looked everywhere but i couldn't found a solution. Well hoping that someone here will be able to provide a solution. -
The specified field could refer to more than one table in your from clause
i have a database that keeps giving me the error The specified field [Tester_Info.TNR CC_Reg_Date] could refer to more than one table in your from clause. I have tried everything and can't figure it out. I have a command that runs macro and a query that creates generates the data in the form here is some of my code PLEASE HELP.
Macro:
...Code:Case 2 stLinkCriteria = "([CalExpires]>Now()) And ([Tester_Info.TNRCC_Reg_Date]>Now())"
