Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Importing Portions of an Excel File (Complicated!)
I need help creating a procedure that will first create, and then update on a regular basis, a table in Access via information in an Excel file. I already know how to link Access to Excel info, but this is going to be a bit more specific. Description of Excel File: I have a file with four...- pete1505
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
-
Multi-Field Propagation using List or Combo boxes in a Table
I have a table containing several foreign keys from other linked tables. In particular I have a list of countries and their corresponding number that has been assigned to them. I want to set a the "number" field to be a picklist in the datasheet view where the user can click the dropbox arrow...- pete1505
- Thread
- Replies: 2
- Forum: Microsoft: Access Tables and Relationships
-
Query Criteria Based on Form Data
Here's an interesting one. I have a crosstab query that uses a query, that uses another query which has a date field with a criteria that states the date must be between the dates the user enters in two text boxes in a form. Problem is, the report I run is based off the original crosstab query...- pete1505
- Thread
- Replies: 21
- Forum: Microsoft: Access Forms
-
Part of IIF Statement in Access Query Not Working
Can you all take a look at this Query and let me know why you think it's not working: SELECT TASK_ORDER.C_Name, TASK_ORDER.CO_Name, TASK_ORDER.[Cont_#], TASK_ORDER.[TO_#], DELIVERABLE.[Del_#], DELIVERABLE.[Invoiced Amount], DELIVERABLE.Rec_Date, DELIVERABLE.HQ_App_Date...- pete1505
- Thread
- Replies: 10
- Forum: Microsoft: Access Queries and JET SQL
-
SQL Code for Access Database Query
What is wrong with this Code: SELECT TASK_ORDER.C_Name, TASK_ORDER.CO_Name, TASK_ORDER.[Cont_#], TASK_ORDER.[TO_#], DELIVERABLE.[Del_#], DELIVERABLE.[Invoiced Amount], DELIVERABLE.Rec_Date, DELIVERABLE.HQ_App_Date, DELIVERABLE.Invoiced_Date, DELIVERABLE.KDF_Approval, DELIVERABLE.R_Drive_Date...
