Search results for query: *

I have a text file that contains record information that i would like to display within a listbox on a form. I've written code to parse out the data within the file. In order to display the parsed data within the listbox I thought I should construct an ADODB.Recordset with the appropriate...

I am having problems getting proper focus on controls in forms that I open via a selection from a treeview. When the frontend of my access database opens I default to opening a main menu form containing a treeview whose nodes are created from a table in the database. The node info includes an...

I have an Access form in which, based upon some info provided by the user, I compose an email that contains selected attachments, displaying the email to the user as an outlook message. At this point the user may send the email or not. What I want to know is if they have (or have not) sent the...

I've been tearing hair out over this one the past few days. I have created a report that uses an SQL Pass-Through Query to a MySQL backend database as its recordsource. If I run the query as it is (simply double-click on it), it returns the records from MySQL as expected in a datasheet view...

I have a Value List type listbox (lstdeliverables) that contains three columns. The third column contains a "Quantity" value. I would like to allow the user to select any number of the rows in the listbox and update its quantity value for the row using a value from a textbox (txtNewQuantity)...

I have a form (FindForm) that I use to retrieve a record in a MySQL database and then open a second unbound form (MainForm) displaying numerous fields from the record. In the following code I am able to open the form successfully and things seem to work ok but the user may choose to return to...

I am experiencing an error 458 "Variable uses an automation type not supported in Visual Basic" when opening a form. In the Form_Activate sub I call another sub setHOSfields() that enables/disables some check boxes on the form based upon the value of a related checkbox. This is where the error...

I am attempting to add a quick query tool to an unbound form (Form1). By pressing a command button on Form1 the user would open a smaller form (Form2) containing two textboxes and a command button. After providing data for a query and pressing the command button on Form2 a query would be run...

I have created a MySQL stored procedure to insert new records into a table that has a number of fields that accept NULL values. On my Frontend Access database I have a form for inputting the values for the new record. I am encountering problems passing NULL values to the MySQL SP. The NULL's...

I am using an MS Access 2002 as a Frontend to a MYSQL 5.0.18 database server backend. I am attempting to set up unbound forms using a dsn-less ADO connection. I have been able to bind the textbox and combobox controls to the fields within my form however I am having difficulties binding...

I apologize if this question is redundant but my searching has not provided any answers. I'm unsure of what to use as search criteria? I have added an event method to a checkbox control to change the value of control's locked property based upon the value of the checkbox as below. Private Sub...

I've been looking unsuccessfully for an answer to a problem I'm having in binding a controlsource to a combobox in an unbound form. My problem is that when I set up an unbound form to view records from my MySQL database table, I bind the controls of the form to the fields in the table of the db...

I am working with unbound forms in an access 2002 frontend connecting to a mysql database server. I have been able to set the recordset of the unbound form in the form_open sub and reset the recordset as required for filtering/search operations but the access delete option is causing me...

I'm developing a access db frontend to connect to a mysql database server. The access users may not have the same version of access or the same version of windows. When creating ADO recordsets, connections, and command objects is it necessary to use late binding techniques when declaring the...

I've been asked to extend an existing Access database to include many more tables containing many more records (some tables contain over 1 million records). In order to handle these table sizes I've decided to move the tables into a MySQL database and utilize access as a frontend database. As...

Hi All. I am working in Access 2003, using an Access 2000 frontend database to connect to a MySQL 5.0.18 backend database via MySql ODBC 3.51 Driver. I have some error handling in place that I have written to handle VBA errors. Usually I turn this off while I am debugging the code so I can...

I'm wondering how Access FrontEnd Users' username and passwords may be sent within a connection string when performing a query on MySQL tables. Maybe I'm just missing how Access and MySQl communicate here? If I set up security permissions on the Access front end forms/reports and...

I have a main form with a number of subforms linked by a common main table id. Each of the subforms displays its associated table data in datasheet view. One of the subforms is missing the "new record" line (has the * at the front of it) while the other subforms do have it. I've checked...

I don't expect a complete answer to my problem but am hoping to find a good site(s) that desribes the effects of the OS, Database client and database version on the functionality on the database interface provided to the user. The more help anyone can provide will be most appreciated though! I...

I believe I have an issue with Users requiring exlusive access to the Access 2000 database in order to render a dynamic report. I have created a base report that has a number of unbound fields including the report record source. From a form the user selects start and end dates that get fed into...