Finding Holes in Numerical Sequence
I need help in identifying the missing numbers in a large query. The only problem is that some of the numbers may be alpha and numerical combined or not-they are mixed. Yet all the numbers are in the same column.  The query looks like this SELECT MSPMP100.PRDNO,MSPMP100.CLASS,MSPMP100.DESCP     FROM CARF1.MSPMP100 MSPMP100                                          Where MSPMP100.CLASS= ‘72′ MSPMP100.PRDNO is the [...]

Answer Question   |  March 31, 2012  10:58 AM
Access Datasheet, AS400 iseries, SQL, SQL Query

Linking Carrier and Products in Access 2003
I have a carrier table and a product table. The Carrier table i have CarrierID and Carrier Name. In the Product Table I have ProdID,Carrier, and Product name. What I want to accomplish on a form is when I select a carrier in a combo window and then select Product in another window , I [...]

Answer Question   |  June 24, 2010  5:17 PM
Access 2003, Access 2003 forms, Access Datasheet, Access Tables, Microsoft Access ComboBox

How can I ensure that the invoice data goes to the correct record on the subform datasheet?
I use a form to hold the details of a client. The form has a subform [datasheet] which details each visit that the client makes. To do an invoice for the visit I have a pop-up form. I would like information from that pop-up form to be transferred to the datasheet subform. How can I [...]

Answer Question   |  June 24, 2010  8:46 AM
Access Datasheet, Access forms, Microsoft Access subforms, Visual Basic Data Report

MS Access Datasheet sorting using Runtime
In Access 2000 runtime is it possible to enable some quick an easy sorting on a DataSheet view in a subform?  I am currently using a ComboBox to achive this, but it would be more intuitive for the users to just be able to click on the column heading like one would do in Windows [...]

Answer Question   |  April 2, 2010  6:23 PM
Access Datasheet, ComboBox, Microsoft Access 2003, RunTime

SQL Access Query
I am using the book SQL for Microsoft Access. and the below statement is from the book and for some reasone I am getting a sytex error on the  word “Udate”     Why would that be?  CREATE TABLE Manufacture ( ManufactureID INTEGER CONSTRAINT ManfID PRIMARY KEY, ToyID INTEGER NOT NULL, CompanyName CHAR (50) NOT NULL, [...]

Answer Question   |  February 16, 2010  11:00 AM
Access Datasheet, Access query, Microsoft Access, SQL, SQL Access, SQL Query

SQL
is it possible to have a where sql statement that is open ended. I have notice that there are time that parameter box pops up with some the Access pass-through queries that I have.  Is it possible  with SQL to be able to have a box pop up that would ask for a specific input to [...]

Answer Question   |  February 27, 2010  4:40 PM
Access 2000, Access Datasheet, Microsoft Access 2000, SQL, Windows Server 2000

How to use SQL to filter columns in a spreadsheet.
I have a query that is listed below. I need to develop a statement that would filter the month and the year as well as the Phase informaton in the access table.  __________________________________________________________________ Select INMSP300.M3OE# as “OENo”, INMSP300.M3OEC as “ComprsOE”, INMSP300.M3PRD as “PN”, INMSP300.M3CLS as “PrdLine”, INMSP100.MSAPP, INMSP100.MSPRD, [strong]INMSP100.MSRDTM as “rtd-Month”, INMSP100.MSRDTD as “rdc-Day”, INMSP100.MSRDTY as “rtc-Year”, [...]

Answer Question   |  October 23, 2009  12:43 PM
Access Datasheet, SQL

Working with SQL: Extracting Data or Text within a Query, adding new column for extracted data
I have created a passthrough query in access to draw information from an AS400 system. I have also created some tables in excel and copied and pasted them into access to link them to the AS 400 query via access. So as of now I have three files in one access passthrough query. The one [...]

Answer Question   |  September 11, 2009  3:29 PM
Access Datasheet, AS/400, as/400 data, SQL

Access & iSeries AS400 Tbl and Query Issues Error Code 5001
I am in Access and I have (A) a passthrough queries=(INMSP300) and (B) table queries=(dbo_ECC_APP.OEM),I want to join. In the dbo_ECC_APP.OEM there are number identifiers that have no associate number were in INMSP300 there are both and they are associated. So I need to have all the number in the INMSP300 showing and only those in [...]

Answer Question   |  August 20, 2009  1:44 PM
Access Datasheet, AS/400, DB2, iSeries Access

Access – Bound sub form trying to set the value of an unbound field
I have a bound sub form with a Datasheet view.. One of the fields on the form I want to be unbound, but still display the value of a field for row displayed. How do I show the value.

Answer Question   |  August 6, 2009  3:44 PM
Access Database, Access Datasheet, Microsoft Access, Microsoft Access subforms, VBA