Search results for query: *

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

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

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

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

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

I have a database that I use for the management of several users for a public access TV station. I would like to be able to use photos of the users that we take when they sign up on a report that will create a user "badge" for each user. I have setup my form with a CmdClick that will...

I would like to have a textbox or label on a form that I am working with that will always display the system time. I am wanting this to be updated using the timer event in the form properties and I will have the interval for the timer set to 60000 milliseconds so that the update will occur each...

Has anyone had any issues where Access shutsdown on the execution of a Command Button or on a print report command from the file menu? If so what is this all about? I have had this problem a few times, and I can't determine a definate pattern. If I check the system log files, I find a physical...

I have a text field that contains an ID number consisting of 12 digits. I need to break this field into two fields, the first containing the begining 7 characters, and the second, the remaining 5. If you could shoot me a quick clue on this I would really appreciate it. It is killing me. Thanks