Search results for query: *

Hi All, I am getting this error message "Run time error 3709" ----Requested operation requires an OLE DB session Object which is not supported by the current provider." The code stops at the execution of the query which will write the record to the table. any inputs will be appreciated...

Hi All: I am working on a way to display results of a search. The user enters the search criteria in the form named form1. Depending upon the entry made often dictated by the location of the wild card charcter a set of different SQL statements are executed. I was wondering as to how do I...

Hi All: I am attempting to implement a search application. Depending upon the number of records pulled up by the SQL query I would like to create corresponding number of text boxes on a new form. Please advise me as to how do I achieve this? Thanks Info

Hi All: I am in the process of developing a very simple search application. However, I have run into a few road blocks. Firstly, I was wondering as to how to include wild card characters to search for records. I know I can achieve that by using the LIKE criteria of SQL. Secondly, more...

Hi All: I am working on an Access form. The form has multiple text boxes. At the bottom of the from is a add button that transfers the data onto a underlying table. I want the contents of each of the text boxes to be appended to the underlying table as a separate record at the click of the add...

Hello: I am trying to format a text box. Incase the time is bigger than a certain window (7:00 AM-5:00 PM), I want it to be indicated in some different color. How do I accomplish this using the conditional formatting made available in Access2k? Suggestions and ideas are solicited. Regards, Info

Hi: I am working on a database to enter customer data. In my previous thread I had asked for information about ways to transfer information from one form to another. I did manage to figure it out. I was wondering as to whether there is a way by which I can have multiple instances of the same...

Hi: I am working on a form where the user needs to enter some preliminary customer information(like customer_ID and customer_name). After the information has been stored, as the user selects the Id, another form pops up that serves as an interface to enter more detailed information about the...

Hi All: I had created a linked table. I have deleted the table to which the original table was linked. I was wondering as to whether there is a way to retrieve the data . The error message that pops up says that the table does not exist. Inputs are greatly appreciated. Regards, Info

Hi: I am working on a score card development project. I need to have some way to have an indicator pictorially when the measured metric is withing a certain range. Does MS Access have the capability to handle such a thing on a dynamic basis or are there other platforms that can handle such an...

Hi All: I am trying to create reports from access tables. These reports are tied with queries that pull data from the tables and spool it to another table. Everytime a report is run it seeks permission that it will append the data to the table and whether it is OK. I want to hide/get rid of this...

Hi All: I have having issues with changing values ina recordset and assigning it to a text box. The error message that comes up "object required". basically the Recordset pulls up an ID as a number but before i display it on a form I want to it be more meaningful such that the number can be...

Hi All: I was wondering as to whether there was a method by which on clicking the database the switchboard would pop up without having to go through the menu list that houses tables, queries, forms, reports, macros and all that. Ideas are solicited. Regards, Info

Hi All: I am getting a data mismatch error when I execute a Update statement through the Command Execute functionality in VBA. Is there a link between the field data type in the table and the string that is being inserted into the table. Advice is kindly solicited. Regards, Info

Hi All: I have been working with access and I am trying to import fields onto a form from table depending upon a search criteria. I do not hve a lot of expereince with VBA. I am getting the error "object required". Please tell me as to why I am getting this error. Regards, Info

Hello: I am writing VBA code to populate the controls on a form including list boxes, text boxes through the execution of code. However, I am running into a few issues. I have a search page and once the user enters the ID, a form needs to be loaded that immediately opens the underlying...

Hi All: I have developed a database application on Access 2002 and it works fine on 2002. However, when I open the same database on Access 2003 there is an error. The error goes asfolows: Your Microsof Access Database or Project contains a missing or broken referecne to the file 'MSOWC.DLL'...

Hi: I am working on a data enrty from. The form includes text boxes and command buttons. After entering the data when the user clicks the "add records" command button the records are added to the underlying table. This is achived through the the execution of the "command" statement. I was...

Hi All: I have been working on a project to track customer behavior. Once the data is entered into a form it is supposed to be tranferred onto a adtabase through the click of a button. I have developed the code to a good extent. The code does get compiled but gives a run time error and I have...