Access Datasheet Questions and Answers

Recent IT Questions

1 - 5 of 5
<<PREVIOUS 1 NEXT>>

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 the...

View Answer   |  Nov 18 2009  4:40 PM GMT
SQL, Access Datasheet, Microsoft Access 2000
asked by CompEng

  590 pts.

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",...

View Answer   |  Oct 23 2009  12:43 AM GMT
SQL, Access Datasheet
asked by CompEng

  590 pts.

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 file is "...

View Answer   |  Sep 10 2009  3:29 PM GMT
SQL, Access Datasheet, as/400 data
asked by CompEng

  590 pts.

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...

View Answer   |  Aug 20 2009  1:44 PM GMT
Access Datasheet, iSeries Access, AS/400
asked by CompEng

  590 pts.

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.

View Answer   |  Jul 30 2009  3:44 PM GMT
VBA, Microsoft Access, Access Datasheet
asked by TJay

  75 pts.

1 - 5 of 5
<<PREVIOUS 1 NEXT>>