Recent content by Channah

Not that I am aware of.

I am getting an invalid argument error while trying to export a query to a text file. The query is based on a linked table (ODBC to a 9i database). Any ideas why this would not export results? The query runs just fine.... I am perplexed! Thanks in advance, Chris

I would like to enable a form to capture the windows logon as a default value in form!test!username Any ideas?

I have a table from our billing system and the Cust. name is nasty. I need to Proper format the text for capitalization. Is there a query that can do this for me? eg... TEK TIPS FORUM should= Tek Tips Forum Any help would be appreciated. Thanks, Chris

I need it in a separate table for import into our CRM.

It can be set up how ever it needs to be. Currently it has a field for the Account Number, Customer Information (multiple fields) and Service Code. for example... AcctNumber CustName ServiceCode 12345678 Channah C 12345678 Channah T 12345678 Channah D I...

I have a table with up to 3 entries per Account Number. Each entry has a Service Code associated with an account number. The problem is that I need 1 account number with all Service Codes. How would I write a query that would return only 1 instance of Account Number and in one field, aal...

Thanks but I am still lost on this one. I rarely use excel for this type of thing. I cannot get the index number to go away. I have tried to use the Index function as above but I am going to have to claim ignorance on this one. Any further detail would be greatly appreciated. Thanks

I have the combobox adding a value to the cell. Unfottunately it is adding the list position number of the value... for example: It is displaying 1 instead of Excel. I need it to display Excel. Also it is a Form Combo Box. Thanks

I have a Combo Box in my Excel sheet that I would like to have auto-populate other cell below it. Any ideas?

I need to crack a sheet that a former employee locked down... how would I go about this?

We have recently had to let someone go. On their way out the door they have changed the passwords on several excel sheets in the office locking both the sheets, the workbook, and the VBA project. Does anyone have a painless way to get around the password protection, locked cells, etc? I could...

Is it possible to populate a report using the current data in a form? I would like to be able to generate a report based on a form that shows account details. The form is controlled from other forms that supply data and open through scripts. Any ideas on this would be greatly appreciated...

Thanks... that is the solution that I was thinking would work best. Cheers.

How do I make a Pop Up form loose focus so that I can display query results from a Cmd button? Should I just create a form for each query and make them pop up as well? I think that is the route I am going to take unless someone has a better idea. Thanks Chris