Hi all,
I am trying to get this spreadsheet to do something and it just aint working for me.
I have 2 sheets, one is a list of all users with details on their projects - the other is a list o...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 05/25/2006 Rating: 9.8 Views: 0
I am attempting to conditionally set a criteria field in a query depending the state of a field on a form. The SQL Is as follows:
SELECT [Employee Lookup].EmployeeID
FROM [Employee Lookup]
...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23034258.html
SETUP:
1 FORM "frmForm1"
1 Textbox called "Text1"
1 command button called "cmdUpdate"
Text1 shows values coming from a table: The value is either numeric or text.
1 table calleD "da...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10213389.html
Zones:
MS AccessDate Answered: 02/05/2002 Rating: 7.6 Views: 0
I would like to accomplish the following:
I have a table called tblMain. In that table, I have the following fields
Name GCO# Title
The data in the field name is derived from a ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21745751.html
Zones:
MS AccessDate Answered: 04/02/2006 Rating: 7.4 Views: 0
Here is my problem, I have a Query in which users will select items to ship off it with a check box field. I have another query which sums totals from Items shipped. I want to bring in the SumofQ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21789686.html
Zones:
MS AccessDate Answered: 03/27/2006 Rating: 9.8 Views: 0
I have a make table query, and I need to enter an 'engineer number' as a criteria. The trouble is I need to enter a hundred or so engineer numbers! So - can I store these 100-odd engineer numbers...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21822725.html
Zones:
MS AccessDate Answered: 05/08/2006 Rating: 9.2 Views: 0
Hi - hope you can help:
When designing a Query with Criteria Perameter, is it possible for the prompt to contain a "Drop down" list from contents of the field in the Table?
e.g.
A Table c...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21864769.html
Zones:
MS AccessDate Answered: 06/04/2006 Rating: 9.6 Views: 0
I am trying to find out how to program lookup functions using multiple qualifying criteria. For instance, I have the following data in excel in cells A1 to D3, with the answer cell being F1:
Pa...
http://www.experts-exchange.com/Programming/Misc/Q_20759839.html
Zones:
ProgrammingDate Answered: 02/10/2004 Rating: 7.4 Views: 0
Say I have a few tables in a database, like this:
tblStudent (StudentID, StudentName)
1,Alice
2,Bob
3,Charles
4,Donna
tblClass (ClassID, TeacherName, SubjectName)
1,Mr. Anderson,Chemistr...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21438166.html
Zones:
MS SQL ServerDate Answered: 05/27/2005 Rating: 9.6 Views: 0
Hi - an Access question:
In a Table called STOCK TABLE there is a field called SUPPLIER which is a Lookup Combo Box linked to a field called SupplierName in another Table called SUPPLIER TABLE ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21823821.html
Zones:
MS AccessDate Answered: 04/23/2006 Rating: 9.2 Views: 0