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

Dear Maquis, This is cool, but would there be any way to sort the report by choosing "*" to show all records in a report for a client, task status, or employee? Is there any way to select * within one combo box and have it sort by that particular combo box, such as employee? Here is...

Dear Maquis, That would be VERY cool, but the user has multiple combo boxes. For example, he would like to sort by employee in one occurrence, client in another, and status in another. What I am wrestling with is how to create three different reports using three different combo boxes. I...

When I use this syntax for the cboclient: If [cboClient] > &quot;&quot; Or [cboClient] <> &quot;*&quot; Then If mWhereClauseUsed = -1 Then mWhereClause = mWhereClause + &quot; AND &quot; End If mWhereClauseUsed = -1 mWhereClause = mWhereClause +...

Dear Joe, But I am pretty sure that I still need this syntax to be able to select one client within the combo box to run a report specifically for that client: 'mWhereClauseUsed = -1 'mWhereClause = mWhereClause + &quot;([C_LinkCode]=&quot; + [cboClient] + &quot;)&quot; Where...

Dear Joe, Here is the syntax for the print button that runs the reports: Private Sub btnPrintToPrinter_Click() On Error GoTo Err_btnPrintToPrinter_Click Dim mRptName As String Dim mWhereClause As String, mWhereClauseUsed As Integer Dim mRptDest As Integer Dim mRptPrints As Integer...

Thank-you Joe! What if I have multiple combo boxes? How do I clear them after the report has been run? Thank-you for all of your help! Sincerely, ~Mattine

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?

Dear Maquis, What would be the syntax for that? Sincerely, ~Mattine

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!

Dear Joe, Thank-you for the help, I will try this out! Sincerely, ~Mattine

Dear Joe, I would like to be able to click a Command Button, labeled Print, that resolves on an option group. Within my option group, I have radio buttons such as; Date, Customer, Status, and Employee. When I click on the Employee Radio Button and then click on print, I would like it to call...

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?

I am receiving a Data Type mismatch when I use this code, any ideas?

How would I create a pop-up form and call it in the open event?

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.

Yes, I would like records as I add them to show up in a subform.

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?