Search results for query: *

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

The record source for the form is a data table with only about 180 records. There is no reason that it should be causing a problem. Oh well... I think that I will resort to the backup copy that I have and hope that this doesn't happen again. Anyother ideas on this would still be greatly...

Thought of that... the database is not secured. Everything else in the database works great. There are no other problems or anything. It is a very simple application that is accessed by about three users. I can open every single other form and table etc. with no issue. Furthermore, when I...

This is a massive form... the original database was created by a former employee and I am in the process of trying to fix the damn thing... it is a nightmare. This is the code that "should" be behind Acccess Members... however, I can't even get into the VB of the form to view any...

I have a form that will not open in a 2000 database that I created. When I click on the command button to open the form, it states "you cancelled the previous operation". Here is the code for the cmdButton... Private Sub Command145_Click() On Error GoTo Err_Command145_Click Dim...

I am working on repairing an old MDB (Still Access 2000 though) that is in our department here at the office. It is on the server and has multiple users. I wwould like to be able to fix some of the problems that it has but the individual that created it turned off the ability to fix it when he...