Search results for query: *

How do I combine two excel spreadsheets into one Access table? In one Excel spreadsheet, I have customer name, number, and address. In the other, the same information, but I need the serial number, make, and model to match up to the customer information on the first Excel Sheet.

How would I parse one column of data that contains a city, state, and zip. There are multiple cities listed within the column of different lengths.

I have one combo box: cboEmployee that I am using to create a report. I am using this select statement: SELECT DISTINCTROW tblTasks.EmployeeAssigned FROM tblTasks UNION SELECT "*" from tblTasks ORDER BY tbltasks.EmployeeAssigned; Does anyone know why, in runtime, the combo box...

How would I create a combo box, a customer combo box for example, that resolves on the customer chosen then runs or the report. Also, how can a create an ALL option in that combo box that would show the full report?

I have a combo box that contains an employee id, is there any way that when I choose one employee id that all the tasks assigned to them will show up and only the tasks assigned to them? This is for a database that contains employee tasks. Thank-you for your help!

How do I validate an option group on a form through a command button? (Print, button for example) Do I have to have multiple reports or multiple queries?

How do I view a table within a form? I would like to be able to view the entire contents of a table within a form that is created from a totally different table.

How do I insert a subform that will automatically accumulate entries in it as the user types in the information and clicks add, for example?

How do I print a specific order number, for example, in a report?

I put this code into a module in Access. This calculates a time variance. i.e.The difference between a start time and an end time. How could I create a new module either using this code and altering it to show an average amount of time? Option Explicit Function GetElapsedTime(interval) Dim...