Search results for query: *

Thanks alot Mike. I wiil try this a soon as I get home tonight. Thanks! Thomas

I am reading an Excel worksheet into an ACCESS database. I have return values that show up at the end of a lot of the fields. Some of the cells imported have the same values except a few have return codes on the end. This is hurting my sort routines. The fields that have return codes will...

What if you have a field like the following list name1 name2 name3@ name4 name5% name6% etc... Where @ and % represent unprintable characters you want to strip. How can you modify the following code to strip only unprintable characters? value = "NAME1" value = Left(value...

Thanks again! :-)

I want to thank you for your help. I am happy with the results.

Hi, I have a problem. I imported an Excel spreadsheet into Access. In column A, I have a field that is displaying special charaters for some cells and not for others. These characters are throwing my duplicate search off. Because of these characters, elements that are duplicate appear to be...

Thanks for your help. I will give it a try.

I have an application written in Access. I what to give the user the ability to put the DB on any drive. How can I write an application that will allow the user to tell it where the DB is located? I what to have a message that says "Unable to Locate DB, Enter the correct DB path or click...

Yes it does. I will try this and follow up with yu all. Again thank you for your help.

I am new at this. Thank you for your replies. I thought since they are both MS products that you can pass reports from ACCESS to print and save as a WORD document. Thanks for the help.

How do you send a report created in ACCESS to WORD to print as a document? Then I want to save it as a WORD Document.

Hi there, The record on the subform must have a record key link to the primary key on the main form. If there is no link you get that message. You can not add a record on the subform without a record link being present with the main form.

I have created an application that I split in two, source and database. I don't want to control where the user places the database. Is there sample code out there that I can use to ask the user where their database is located and link to it?

Hi gang, I would like to piggy back on this one. I am having a problem with the INSERT function of SQL. I have an ACCESS database that uses auto number for the record key. When I first used the INSERT, my error was that the record key was not updatable. Then I took the record key out and now...

Thank you for you all's help. This issue is resolved. Being new at this, I could not have done this in a timely manner with out all the help. Thank you'll again. :-)

I am still getting the same message. Is there a problem in the way I am accessing the recordset? I have an ADODC on the form and the fields are bound. I am using data connection2 for creating the forms through a wizard. I am using an ACCESS 2000 database. Because the wizard would not create a...

Ok. I am trying to develop a tier three application. Where the application is divided into three parts, user enterface, business rules, and the database access. I am trying to do a search of the database with a record key. When I execute the debugger, I can see how the record key is flowing...

Yes I am. I am using the following: stringConnection = "provider=microsoft.jet.oledb.4.0; " ___ & "data source=c:\rcas\VB6System\rcas_VB6DB.mdb"

I am able to read the database. I just can not update or add to the database. Nor can I do a search. But I can retrieve the first record. IF I do a search, I get that message I stated before. If I try to update, the slRecordAffected is always zero when it should be at least one. The SQL...

I am still getting &quot;<recordset>.EOF =<THE OPERATION REQUESTED BY THE APPLICATION IS NOT ALLOWE...&quot; on the &quot;IF <recordset>.EOF = true Then.... Is there something I am suppose to do in setting up the application that will resolve this issue?