Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / February 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Access to db webproject Microsoft JET Database Engine 0x8000400527 Feb 2008 13:07 GMT1
85:  
set con = server.CreateObject ("adodb.connection")
86:                  con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data        
                 Source=FeedBack.MDB;Persist Security Info=False"  
Syntax27 Feb 2008 11:43 GMT1
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 Bar27 Feb 2008 06:32 GMT1
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 field27 Feb 2008 03:15 GMT5
Hi, I have a text field in the manner of:
1-90
1-95A
1-95C
DataType Mismatch error27 Feb 2008 01:58 GMT2
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
SetFocus27 Feb 2008 00:16 GMT2
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 integer26 Feb 2008 22:32 GMT1
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 one26 Feb 2008 22:25 GMT1
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 template26 Feb 2008 21:08 GMT1
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 Question26 Feb 2008 20:58 GMT10
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 GMT2
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 type26 Feb 2008 17:48 GMT4
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 Code26 Feb 2008 13:43 GMT1
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 Excel26 Feb 2008 10:03 GMT1
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 form26 Feb 2008 07:25 GMT2
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.