Search results

Hi, Basically I am trying to link a SQl Table through code without having to go to tools and then using add linked table manager and then refresh.The above steps I am trying to code. I have this function in a module and use the command button of a form to call the function. Though I hard coded...

Thanks jetfill, your post was really helpful thanks again.

Thanks for your suggestions everybody. I'll try and let you know my results. Thanks once again.

Is there a way to tell how many times a database is open by the user. Thanks I am looking for a way to code desperately. Thanks in advance

Hi, I am looking for a method that i can hard code a program to refresh the links to their appropriate DSN the backend being the SQL server. Instead of going to the users desktops each time when a change is made to the database and then refreshing the links through tools and then add-ins and...

Thanks Jack, Thanks a lot

I have a search form, when the user types in the partial text and click OK, it opens another form with company names in a combo box, where the user can select a particular name from the combo box. My question is how to set up a message box and where to set up if the user typed partially and...

Hi, I am trying to capture the listindex and value of the combobox before any change is made so where should I really do this in which event, I am doing this to compare the values after a new selection or change is made. I have it presently in the Oncurrent event of form public originalvalue as...

Hi guys, I have a form BDInfo. I have these two fields Current Exchange and Prior Exchange. Prior Exchange is dependant on current Exchange. For eg: if current Exchange in a record = "AMEX" Then when a user changes a selection of Current Exchange in the record to "PHLX" Now Prior Exchange =...

Hi, I have a company form and a exchange form. A company belongs to one main exchange, but during the course of time it can change to become a member of other exchange. In the Exchange form, I have made it easy so that the user can select a exchange, The problem is when the company changes...

Hi, I have a company table with company ID as the primary key, And the company can belong to many exchanges, I have a look up table for exchanges with Exch ID as primary key and Exch Desc as another field. I have linked the company and look uptable by creating another table called...

Hi, I have a form based on the member information, which has a individual_Id has a field and primary key for that table. I am trying to code, so that if a ID is already present in the table, give user a message box, saying that the ID already exists, enter a new ID. And again it has to focus on...

Hi Rich Thanks for your reply. Actually I am trying to import the data from a old database into new database. Priorly in the old database in table Individual information has a field called member to show a whether the individual is member or non-member to a company, and has data in form of...

Hi, I have a table with Individual_Id and Membeship as their fields. The Membership field basically has couple of "yes" or "no"s, I want to code in such a way, so that where ever there is a "yes" in membership field, it has to replace to 1 and "no" to 2 and put the whole data in different...

Thanks Rich, Regards

Hi I have a company form, in which there is a command button which would open a form basically a list box for the user to select different sectors the company belongs. When there is a record already with company_id the command button works fine, but if a user by mistake choose to select to...

Hi, I have a table called "Member Information" which has a field called "List". The relation is a member can belong to many list types. For eg: Individual ID : 2 list_type: Agriculture;Pharmaceutical;Bio I need it split in this manner Individual ID list_type...