| Thread | Last Post | Replies |
|
| Access to db webproject Microsoft JET Database Engine 0x80004005 | 27 Feb 2008 13:07 GMT | 1 |
85: set con = server.CreateObject ("adodb.connection") 86: con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=FeedBack.MDB;Persist Security Info=False"
|
| Syntax | 27 Feb 2008 11:43 GMT | 1 |
Hi everyone, I'm trying to build a VB code in order to append a WHERE clause in a query but I'm just a newbie and I need your help. Here below the SQL that I want to create: WHERE (((T_CC_comune.[Data
|
| Show a Status Bar | 27 Feb 2008 06:32 GMT | 1 |
I was hoping someone could explain how to show a status bar which allows the user to see that a program is currently running. I have developed a code and when it is running the hour glass doesn;t show therefore I would like to build a status bar to show the user that the system
|
| parse text field | 27 Feb 2008 03:15 GMT | 5 |
Hi, I have a text field in the manner of: 1-90 1-95A 1-95C
|
| DataType Mismatch error | 27 Feb 2008 01:58 GMT | 2 |
I'm missing something really simple but I don't see. When I run the code below I am getting a data mismatch error on the last execute statements. Function WorkListBuild() 'Route Variables
|
| SetFocus | 27 Feb 2008 00:16 GMT | 2 |
I set a condition on a textbox so that on "when exit", it will see if another textbox value is zero, and if the value is not zero, see if the textbox is null, otherwise, set the cursor back to the textbox. The if then statements do work as the msgbox is triggered to notify the ...
|
| converting Yes/No fields to integer | 26 Feb 2008 22:32 GMT | 1 |
I have a hopefully easy question. I have several databases with yes/ no fields scattered throughout the tables. What I wanted to do was to convert them to text fields and format them as comboboxes and set the value list to {0,-1,Null} so I can differentiate between "no
|
| how to insert record into table one by one | 26 Feb 2008 22:25 GMT | 1 |
Let me explain with an example I am having a table in ms access table : salary_details name ssn join_date yearly_salary
|
| Send email from Access using Outlook template | 26 Feb 2008 21:08 GMT | 1 |
Trying to send email using SendObject but I have yet to find code that allows Outlook to open with a outlook template. Any help/suggestions would be much appreciated.
|
| Another Golf Handicap Question | 26 Feb 2008 20:58 GMT | 10 |
I'm trying to loop through a golf "scorecard" to find if a duplicate entry was made for an entry in the handicap field. Handicap is a measure of the difficulty of a hole, 1 being the hardest, 18 the easiest. Anyway, I can load all the values into an array. I want to find if ...
|
| Updating original recordset from reordered SQL version? | 26 Feb 2008 18:13 GMT | 2 |
I need to perform a series of updates on an Access tables, after reordering the records by a descending field each time. I'm having trouble getting my head around figuring out how to update the original recordset from the reordered version. Could someone point me in the right ...
|
| error 13 mismatch type | 26 Feb 2008 17:48 GMT | 4 |
when I run this code in Access vba97 there is no error; However when i run the exact same cose in ACCESS2000 I get the run-time error of Mismach type (error-13); does any one have an Idea as to what is wrong? Private Sub Form_Current()
|
| Search Code | 26 Feb 2008 13:43 GMT | 1 |
I'm trying to optimise a VBA code for search records. I'm using a tipical Do .... Loop WHILE NOT rs.EOF with a test if the current record matches the criteria i want and, if so i Exit Do. This isn't efficient beacuse the table could have more than 1 million records.
|
| OLE Object Export To Excel | 26 Feb 2008 10:03 GMT | 1 |
I've created a table and stored serveral Excel Files in my database, is it possible to export them into a given folder by using VBA? Thank you for your kind assistance in advance. Best Regards
|
| How to highlight individual records on a continuous form | 26 Feb 2008 07:25 GMT | 2 |
I have a continuous form which generates a list of records containing blank fields that still need to be completed by the user. The user Double Clicks the Product Id on the continuous form and the record Product Id is copied to the Product Details (editing form) and the record is
|