The Basics Access 2007

How To Open/Read An Access 2007 (accdb) From Excel 2007
Hi All,

My company is moving to Office 2007. I am going through several hundred macros written in Excel 2003 to make sure they work in 2007.
I am trying to open and read an Access 2007 database (extension .accdb) from within Excel VBA.
What used to work was this:

Code:
Dim dbLocal as Database
Set dbLocal = Workspaces(0).OpenDatabase("C:MyDatabase.mdb")
When I run this under 2007 and change the Access database extension to .accdb, I get this error:

Quote:




Run TIme Error 3343
Unrecognized Database Format




I've tried adding extra References in, but no luck. Any help would be greatly appreciated.

Cheers,

Paul

---

Importing A Date Function From Excel 2007 To Access 2007
hi, I have a major project ahead of me, I am creating a Dbase full of maintenance records in Access 2007. This Dbase is supposed to be able to calendarise routine maintenance and also on-the-spot maintenance so that all our vehicles don't miss out on it. Is it necessary to link Access with Excel so that each time maintenance is performed, Excel tells Access when it needs to be done next time, or is there another way that's much simpler only using Access 2007? I'm new to Access and Visual Basic so simplest explanations are best...thanks in advance.

---

VBA For Access 2007
Hope this is the right forum. I have a lot of VB experience, but am new to VBA, especialy Access 2007.

Have managed to create my tables, and an initial form, but I need a head start as to how to write some VB code. And to have access to a toolbox to add controls to the form. Once that is known to me, the next thing is how to perform SQL statements against the host DB.

---

Access 2007 VBA
Does anyone know of a link to where I can get started with Access 2007

---

Access 2007
I have a 2007 access database that I need to share between three users simultaneously and updated accordingly. I have loaded the database on a remote server and created shortcuts on the entire three users desktop. However, when more that one user is accessing the database our software crashes… can anyone help me out with this please!

---

DAO And Access 2007
I have an older application that uses access 97 and DAO. Is there one option to use access 2007 or access 2003 using DAO ? to use ADO is necesary rebuild all application.
Thanks in advance
 
Fernando Oviedo Find a local pizza place, movie theater, and more….then map the best route!

---

Access 2007 With VB 6.5
Hello,
first off, thank you for taking the time to read this. Second, I am trying to modify the parameter of a query created through design view. I want to physically change the query parameter so that if I were to open up the design view it would have the new parameter data.
I have looked everywhere and it seems that this question comes up a lot, but I can't seem to find a viable answer that works.
Thank you again for your time,
Phreakuency

---

VB6 And Access 2007 Problem
Hey everyone.

I am having an issue. I am able to save information to an access table, however, it will not move to the next empty record, for the next save.

When I load the form, it will pull the information from the previous save. If I clear the fields and save something new, it will place the new information on top of the old. What am I doing wrong or what do recommend that I do. Here is the simple code I wrote. Using ADO.

Private Sub cmdJEntrySave_Click()

Dim boolAdding As Boolean

boolAdding = (datJournalSave.Recordset.EditMode = adEditAdd)

datJournalSave.Recordset.Update
If boolAdding Then
datJournalSave.Recordset.MoveLast
End If
End Sub

Any help would be kindly appreciated. Thanks!

---

VB6 - Access 2007 Problem
Hello all, im fairly new to vb
i doubt this problem will be a problem for any of you lol.

i have this simple stock inventory program and would like to add a combobox to a field so i can filter the datagrid.

any ideas where i been going wrong?

[edit]
the database is saved as a 2000 version

hmm

when i create a new database VB always says it cannot recognise the database format, but when i edit a DB that came with VB and stip it down to 1 table then rename it, it works fine. Any ideas?

---

Provider For Access 2007
What kind of database provider am I going to use if Im using Microsoft Access 2007 as my database.. Thanks

---

Connecting To Access 2007 Using ADO
Hello All,

I have been trying to connect to Access 2007 using ADO and found out that the reason I could not was because of the .accdb extension vs .mdb.

So after some reseach I found the correct connection string:

vb Code:
DBConn.ConnectionString = "Provider = Microsoft.Ace.12.0;Data Source=" & strPath & ";Persist Security Info=False"


But now I get the error 3706 "provider cannot be found or not installed properly.

So after some more research I found that the connection uses the Ace.12.0 OLEDB vs the Jet.4.0 OLEDB.

I found a database connectivity download from MS which is suppose to contain the Ace.12.0

Am I on the right track here? is this the download that I need? has anyone else had this issue?

Thanks.

---

How To Create An DSN For MS Access 2007?
How to create an DSN for MS Access 2007 ?

--------------------------------------------------------------------------------

Hi all,

How to create a DSN programmatically for MS Access 2007 ?

i have tried the following code,but its not working.

------------------------------------------------------------------------
Function Build_SystemDSN(DSN_NAME As String, Db_Path As String)

Dim ret%, Driver$, Attributes$

Driver = "Microsoft Access Driver (*.mdb,*.accdb)" & Chr(0)
Attributes = "DSN=" & DSN_NAME & Chr(0)
Attributes = Attributes & "Uid=Admin" & Chr(0) & "pwd=" & Chr(0)
Attributes = Attributes & "DBQ=" & Db_Path & Chr(0)

ret = SQLConfigDataSource(0, ODBC_ADD_SYS_DSN, Driver, Attributes)


'ret is equal to 1 on success and 0 if there is an error
If ret <> 1 Then
MsgBox "DSN Creation Failed"
End If

End Function

--------------------------------------------------------------------------

So, pls help me to do that!

i need it urgently.


Thanks,

th.

---

Access 2007 And VB 6.0 - Report !!!
Wishing you all !!!!

* I have report in Access 2007
* I am using VB 6.0 for open that report
* By the following code i am getting "User-defined type not defined" error on

Code:
Private Sub Command1_Click()
Dim objACCESS As ACCESS.Application


* My code is


Code:
Option Explicit
Private Sub Command1_Click()
Dim objACCESS As ACCESS.Application
On Error Resume Next
Set objACCESS = CreateObject("Access.Application")
objACCESS.OpenCurrentDatabase "D: est.mdb"
objACCESS.Visible = True
'DoCmd.OpenReport "tabel2", acViewPreview
'DoCmd.Maximize

objACCESS.DoCmd.Maximize
objACCESS.DoCmd.OpenReport "PID", View:=acViewPreview
objACCESS.DoCmd.Maximize

End Sub


* Please advice on this
* Thanks in advance.

---

2007 Access Database
I have a 2007 access database that I need to share between three users simultaneously and updated accordingly. I have loaded the database on a remote exchange server and created shortcuts on the entire three users desktop. However, when more that one user is accessing the database our software crashes… can anyone help me out with this please!

---

Can't Add New Record To Access 2007
I can't add a record to MS access 2007 from VB
Please help


Code:
Sub addMonth()

Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim strSql As String
cn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:dashboarddashboard.accdb;Persist Security Info=False;"
cn.Open


strSql = "SELECT * FROM manpower"
rs.Open strSql, cn, adOpenDynamic, adLockBatchOptimistic, adCmdTableDirect
rs.AddNew
rs.Fields(0).Value = "2008"
rs.Fields(1).Value = "5"
rs.Fields(2).Value = "20"
rs.Update
rs.Close
Set rs = Nothing
cn.Close
Set cn = Nothing

MsgBox "hello"
End Sub


Thanks
Asaf

---

Visual Basic 6 And Access 2007
Hi Guys

I have a query regarding using VB6 and Access 2007.

We currently have an application written in VB6 that uses an Access 2003 database. We connect to the Access 2003 database using Jet, DAO and the data control in VB6. This works fine.

I now want to upgrade the application to connect to an Access 2007 database using the new Access accdb format. Can I still do this using VB6 and DAO?

I have tried a few tests and cannot get it to work. I am using VB6 with SP6. I have added the new ‘Microsoft Office 12.0 Access database engine Object library’ to my references in the application. When I try to set the ‘Record Source’ property of the data control I get the error message ‘Unrecognised database format…’. So what am I doing wrong?

Do I need an upgrade to the data control so that it can connect to the new accdb format? If so I haven’t found one in the downloads centre.
Am I using the right library?

Will VB6 talk to an Access 2007 database or do I have to use a 2003 database in the old format or upgrade to VB.Net?

Thanks for your help
John Adams

---

Connect MS Access 2007 Database To VB6
Dear All,

I tried to connect to Access 2007 database with Microsoft ActiveX Data Object 2.8 in VB6. But error 'unrecognized database format'.

How to connect?

Thanks in advance
Raj

---

Creating Managed Add-ins For Access 2007
What I wish to accomplish: For a reunion, I want interested people to sign up via website form giving their year, etc. I want this information to be inputted into an access file so i don't have to input that information myself.

Level of expertise:Beginner. i'm not even sure of Access

What've done so far:I googled topics in search for tutorial s and came up with this tutorial: tutorial link for creating managed addins

Problems I'm having: cannot find option for other project types node or extensibility or shared addin in. the following are the instructions i get stuck at :
9.In the New Project dialog box, in the list of project types, expand the Other Project Types node.
10.In the list of project types, select Extensibility.
11.In the Templates pane, select Shared Add-in, as shown in Figure 2. Type a name and a location for your add-in, and then click OK to create the add-in.

Any help is appreciated even telling me another way to do it. I'd try the web service toolkit but the tutorials provided for that are over my head. Thanks,lq

---

Mscomm Cotrol For Ms Access 2007
Is there any equivelant code/control for using mscomm control in Access 2007. User wants serial port communication from Access database. Thanks

---

Access 2007 Export To CSV - Not There - Plz Confirm
Hi,

We have our organization running on Access 2000, we are about to switch to Access 2007, but I can't believe that Microsoft would remove the Export to a CSV file.

I have a php program that we use to upload changes to our online data base, it reads a CSV.

Can someone confirm that there isn't some secret setting somewhere?

If it's not there I guess I will have to right a .net app to do it, not like I haven't done that before, just a pain.

Thanks

Rich

---

Access 2007 Navigation Pane
Does anyone know how to close and hide this navigation pane in Access 2007 using code.
I definately do not want users having access to this DB window (pane).

but i cant seemt o solve it.



gumuk

---

Access 2007: Tools Options
Can someone please tell me how to expose the multi-tabbed dialog box that I used to see under Tools, Options? I need to see if there any hidden objects. Thanks!

Right-click on left hand navigation pane, navigation options, check show hidden objects.

------------------------------------------------------------------------------------------------
Put your PC to good work at vbCity at world community grid and join Team vbCity.
2,669,763 3,325,308 points and ranked 1,195 1,149 as of March 8 May 23, 2008!
------------------------------------------------------------------------------------------------

Edited by - Geof on 4/28/2008 6:47:38 AM

---

Basics - Access 2003
Okay, I am brain dead

I need to create a proceedure to re-link an Access Database to dbf files on opening of the database and for the life of my I can not remember how to do it in code.

Please someone give me a kick.

---

VB6/Access Database Basics
I am absolutely new to VB so I have some basic questions. First of all, I have a Access2003 back end database and I want to create a program in VB6 to manipulate the data within it.

Do I have to open up a connection to a table in the backend database every time I open a form in the VB project to display the data? In my Access program I link the tables to the front end when I start the program. Do I have to link with the VB project as well then just populate the forms with data via queries or SQL?

Any help or shoves in the right direction is greatly appreciated. Thanks.

---

Access 2007 - Chart Updating Issue
Hi,

Is there a vba function that causes a chart in Access 2007 to update or refresh? I am seeing new data within the table (XBar1), this is the same table that is selected under the chart's properties for "Row Source". I have "Automatic" selected under the chart's "Update Options" property. The only way to get the chart to update to this table is to close the form and re-open it, I'd like this same functionality but at the end of my vba macro, what am I doing wrong?

I'd appreciate anyones input, since I've searched the web and this forum with no luck.

Thanks.

---

Export Data From Excel Into Access 2007 ??
What's up Crew?

I'm having trouble opening my access data base 2007 with my excel vba macro. I'm trying to open it and write into it. I get the Run-time error '3343'
"Unrecognized database format"

Greatly appricate the help!

Here is my code:

Sub ExcelToAccess()
' exports data from the active worksheet to a table in an Access database
'Microsoft DAO x.xx Object Library

Dim db As Database, rs As Recordset, r As Long
Dim tName, dbPath

dbPath = ThisWorkbook.Path & "Test2007.accdb"


' open the database

''''Error happens at this point''''''''''''''''''''''''''
Set db = OpenDatabase(dbPath)
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''''''''


tName = Range("A1").Value
'Set rs = db.OpenRecordset("E01", dbOpenTable)
Set rs = db.OpenRecordset(tName, dbOpenTable)
' get all records in a table
r = 2 ' the start row in the worksheet
eRow = Range("C65536").End(xlUp).Row
For r = 2 To eRow
'Do While Len(Range("A" & r).Formula) > 0
' repeat until first empty cell in column A
With rs
.AddNew ' create a new record
' add values to each field in the record
.Fields("Test ID") = Range("B" & r).Value
.Fields("Module ID") = Range("C" & r).Value
.Fields("Module Config") = Range("D" & r).Value
.Fields("MNotes") = Range("E" & r).Value
.Fields("Date Received") = Range("F" & r).Value
.Fields("From") = Range("G" & r).Value

.Fields("Import Date") = Range("H" & r).Value
.Fields("Export Date") = Range("I" & r).Value
.Fields("CH") = Range("J" & r).Value
.Fields("Spire1 Date") = Range("K" & r).Value
.Fields("HiPot-D Date") = Range("L" & r).Value
.Fields("V1") = Range("M" & r).Value
.Fields("I1") = Range("N" & r).Value

.Fields("V2") = Range("O" & r).Value
.Fields("I2") = Range("P" & r).Value
.Fields("V3") = Range("Q" & r).Value
.Fields("I3") = Range("R" & r).Value
.Fields("Spire2 Date") = Range("S" & r).Value
.Fields("HiPot-W Date") = Range("T" & r).Value
.Fields("V4") = Range("U" & r).Value
.Fields("I4") = Range("V" & r).Value
.Fields("Spire3 Date") = Range("W" & r).Value
.Fields("PTNotes") = Range("X" & r).Value
.Fields("EnV Test") = Range("Y" & r).Value
.Fields("Location") = Range("Z" & r).Value
.Fields("Position") = Range("AA" & r).Value
.Fields("InOut") = Range("AB" & r).Value
.Fields("Date On") = Range("AC" & r).Value
.Fields("Time On") = Range("AD" & r).Value
.Fields("Date Off") = Range("AE" & r).Value
.Fields("Time Off") = Range("AF" & r).Value
.Fields("CyclHrs") = Range("AG" & r).Value
.Fields("Sched CyclHrs") = Range("AH" & r).Value
.Fields("Sched Date") = Range("AI" & r).Value
.Fields("ETNotes") = Range("AJ" & r).Value
.Fields("Excluded") = Range("AK" & r).Value


' add more fields if necessary...
.Update ' stores the new record
End With
r = r + 1 ' next row
If r = 65536 Then
'Exit Do
Exit For

End If
Next
'Loop
rs.Close
Set rs = Nothing
db.Close
Set db = Nothing
End Sub

---

VB6 Is Unable To Find Access 2007 Database Using ADO
I'm using VB6 with an ADO connection string to open an Access 2007 database.

The database was upgraded from an Access 2000 DB to an Access 2007 DB with the new file extension of aacdb.

The original code to open the Access 2000 database was as follows:

sCNString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:ClientsDatabases9999-999-99 CRCCoreDB.MDB;Persist Security Info=False;"

gcnDB.Open sCNString

This worked fine with the Access 2000 DB.

When I changed the connection string for the Access 2007 database it reads as follows:

sCNString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:Databases9999-999-99 CRCCoreDB.aacdb;Persist Security Info=False;"

gcnDB.Open sCNString

The code won't open a connection to the new Access 2007 database. It returns the run-time error: 'Could not find file 'C:Databases9999-999-99 CRCCoreDB.aacdb'

Can anyone help me with this problem?

---

VB6 To Display Access 2007 Richtext Field
I need to display Access 2007 richtext formatted field on VB 6 form. When I try to do it in richtextbox it displaus html codes. Please suggest a solution.

---

Simple Access 2007 (VB CODE) Problem..
Can anybody help me with a simple problem in MSAccess2007?

I have a very simple database where I want to multiply an employee's hours by his hourly wage.

I have a form with a field that performs the operation based on the fields entered right before it, which looks like this:

(for example...)

(field)HourlyWage = $20
(field)HoursWorked = 40
(field)LaborCost = [HourlyWage]*[HoursWorked]


The issue I am having is that when I open the table, the result (which works as above - the calculation is automatic and is updated within the form) is NOT updated in the table.

Is there a bit of code I need to use like "AfterUpdate" to update the new calculated result in the table?

Any and all suggestions are very helpful

Thank you kindly,
Michael

---

Access 2007 Form Load Question
Just upgraded to Office 2007. In Access, we've created a simple form for the user to input some data, and this data is written to a table behind the scenes.

We want to, simply, open the form and have it open as a NEW, FRESH, unpopulated, clear form! Right now it keeps opening with the first record in the table.

We tried "Unload Me" in the Form_Open procedure but get en error saying "can't load or unload this object".

What are we doing wrong? Thanks much.

---

Very Strange VBA Form Behavior In Access 2007
As posted elsewhere with no response!

I have a subform that works perfectly well in Access 2000 and 2003 but displays no results in Access 2007.

If I query on a Number field I get no results e.g.

sSQL = "SELECT * FROM table WHERE NumberFieldA = 1234"

.....Form.RecordSource = sSQL

I get results in Access 2000 and 2003 but nothing in 2007

The query returns results in 2007 when run in the SQL window just not to the sub from.

If I change the query to a string field in the where clause i do get results in 2007 e.g.

sSQL = "SELECT * FROM table WHERE StringFieldA = 'abcd'"

.....Form.RecordSource = sSQL

Now for the wierd part I have found a fix that makes no sence and was found by mistake.

If I break the query that has the WHERE clause e.g.

sSQL = "SELECT * FROM table WHERE NumberFieldA = 1234 dsfas"

.....Form.RecordSource = sSQL

Run it throwing an error then fix the query it works and returns results!!!

I have tested this several times going back to my original file the only way I can fix it for 2007 is to break the query then fix the query!

This isn't an acceptable solution for me and I really want to know what is going on as I suspect this might not be the only problem during changeover to 2007!!

---

Access 2007 Modal Forms Problem
Help me with this one please. I have a modal form in Access 2007. It is not a pop-up and the border style is set to 'Thin.' The form only allows 'edits'...no adds, no deletes, no data entry. Despite this, when the form is called from VBA code it goes ahead and allows new records to be added. I have had to add code as a work around to prevent the problems this is causing me. When the form is called it is called with the window mode being set to 'dialog.' Any suggestions as to why this form is allowing new records when that property is turned off?

---

Free Developers Extension For Access 2007
In addition to several other freebies Microsoft has been offering (Express versions of VB.NET, SQL Server 2005, Vitual PC, etc.) they are now offering for MS Access 2007 the Developers Edition for free.

With the Developers Edition you can create a runtime version of your Access 2007 programm, package and ship it to customers without having to worry about the runtime license for the runtime files which get shipped with it.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/adoproperties.asp

Previously, you needed to purchase this separately.

Even though I do not need MS Access, I just thought some of you may find it interesting.

What I find most interesting and welcomed, is the twist in the MS thought. It is one way to capture an audience's attention ... and keep it.

---

Create Excel 2003 Workbook From Access 2007
Hi All,
Can't find help on this anywhere at all.
I'm using late binding 'Set oExcel = CreateObject("Excel.Application")' to create an excel workbook, but it needs to be in version 11 (2003) not 12 (2007) for the recipients to view.
Anyone have ideas on how to do this programmatically?
Cheers
Brian

---

How Can I Automatically Add An Autonumber Field To A Table In Access 2007?
How can I add an Autonumber field to a table in Access 2007?
And if I can do this with code, where do I put the code & access it?

---

SQL Server/Access 2007 Date Field Is Slooooow! Why?
I am working with a client to migrate an Access 2000 app to Access 2007. I went through the conversion process and everything runs great except anything having to do with date/time fields. The Access app is odbc-linked to a back-end SQL Server 2000 DB. Whenever a date field is clicked, the app appears to "hang" for about thirty seconds! This is driving me nuts! There is no event properties tied to the field. In fact, I can look at the table view and click on a date without even going through a form and it does the same thing. What the heck is it doing? How can I fix this? Any ideas?

---

Compact On Close, Access 2007, Multiple Database.mdb
Greetings, all.

I've just discovered that Access 2007 creates multiple copies of Database[n].mdb while doing 'Compact on close'.

Our application (designed in XP) uses backend MDB and frontend MDE, both has 'Compact on close' on.
When I open one of them in 2007, then close it, Database.mdb appears in the same folder.

How do I fix it? (Tried turning the feature off, then turn it back on - didn't work).

Thanks.

-----------------------------------------------------------------
Making mistakes is one of the ways of improvement.
GL and HF

---

Anticipating Access 2003 To 2007 Conversion Issues
I have offered to help test/convert some Access apps from an Office 2003 to a 2007 environment.

Are there any issues that I should anticipate?

------------------------------------------------------------------------------------------------
Put your PC to good work at vbCity at world community grid and join Team vbCity.
2,669,763 3,325,308 points and ranked 1,195 1,149 as of March 8 May 23, 2008!
------------------------------------------------------------------------------------------------

---

ACCESS Database And VB6.0 - I Need The Bare Basics! Looking For A Tutor...
At this time, I think I am getting in way over my head. Once upon a time I understood VB well enough and had written some rather complex programs. It has been quite some time since I have done so and as a result I have forgotten so much. Having said that, even when I was using databases, I was using them in the form of text files. I really want to step up to Access databases today. Once the basics are understood, it seem as though Access will be far nicer to use than text. Again, having said that, I am at a total loss. I have read through many threads here regarding Access databases and VB and have crawled through web page after web page looking for the basics. Everything I read seems to assume that the reader already has a working knowledge of either VB or Access. What I really need are the basics to get the ball rolling.

My project revolves around a card game known as "Magic : The Gathering". If you are not familiar with the game that's ok. All you need to know is that there are litterally thousands of different cards avaliable to play with and a player can use any combination of them to build a deck (40-65 cards in a deck). Furthermore, certain cards are designed to work well or compliment other cards. This pair or group of cards would be known as a "combo".

What I want to do is use the form that I have designed to quickly and simply search an ACCESS database based for criteria that the users enters via combo boxes. There are 7 different comboboxes, each containing a different and generic piece of information about the cards that the user can select his/her criteria from. Each card in the database will have a .jpg which corrosponds to it. When a match or matches are found, I would like the Card Name(s) of the matches to be listed into a new Combo box where the user can then scroll through the list. At this time if the user selects a Card Name from the list, I want that card's .jpg to be displayed in a picturebox. Before all of this takes place, however, I need the drop down lists of the 7 original combo boxes to be generated based on the information contained withing the database.

This is phase one of my project but there is so much more that I want to incorporate into it down the road. For now, my goal is to accomplish the above mentioned. This will not be an overnight task for myself - understood! I realize that this may seem very elementary to many (or most) of you, however, as I mentioned above I have never used Access before and it has been many many years since I have dabbled with VB.

I am using VB 6.0 in which I have designed a form from which to work off of, I have created a very incomplete Access database (MasterDatabase.mdb). What I believe I need to get me started is a few answers to some very basic questions. They are as follows :

1. I assume that an object must be added to the project before a connection from the VB project can be made to the Access database. Believing that the above statement is true and assuming that there is more than one way to create such a connection, what would be the more popular object used to complete the task? I have read that the Microsoft ADO Data Control 6.0 (OLEDB) is a prefered method. True?

2. Assuming the Microsoft ADO Data Control 6.0 (OLEDB) is the way I am going to go, how do I setup my connection string?

3. I have utilized Access to create my database. Unless there is something other than simply creating columns and filling the rows with data I believe that I have a working Access database. Do I have to do anything VB specific to the database before VB can make a connection to it? I read something about Tables and what not. I'm not sure what a Table is?

P.S. I realize this is not a code shop and that I can not ask for anyone to create my code for me. In the end, that isn't truely what I want anyway. I do want to learn this - not have it handed to me on a silver plater. Having said that, I do tend to learn best from BASIC examples. Examples which contain other code that is irrelevant to my situation tends to confuse me further (thats what got me here in the first place). What I do require from those who are willing to help is a little patience as it may come slow at first but eventually things will speed up. I also require my teacher(s) to have an indepth understanding of my situation and the ability to aid me while sticking to the basics. Lets scratch the surface to see if we're standing on the bedrock before we try to dig a hole. Furthermore, I truely appreciate any and all assistance into this matter.

P.S.S. To clarify what is it I am actually attempting to do, I have provided my project here as an attachment. As it is currently nothing more than a basic form void of any code and the database from which I wish to work, it is provided here simply as a means of visual description of what I would like to accomplish in phase one of my project.

Cheers! Wish me luck...

---

Invalid SQL Statement; Expected 'Select'... Databinding VB 6 With Access 2007
Code:
Private Sub cmbStartMatch_Click()
adoStartMatch.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source= " & App.Path & "Scorecard2.mdb"
adoStartMatch.CommandType = adCmdUnknown
adoStartMatch.RecordSource = "Match" & "PlayerApperance"

Set dgrStartMatch.DataSource = adoStartMatch
adoStartMatch.Refresh

With adoStartMatch.Recordset
.AddNew
!AwayClub = txtAwayTeam
!HomeClub = txtHomeTeam
!MatchType = cmbMatchType
!MatchDate = txtMatchDate
.Update
.Requery

End With
End Sub

---

Warning! Vista Updates Impact On Access 2007 Table Linking
I have been working with Microsoft since the last batch of Vista updates were installed on my computer last week. I became suspicious that something was caused by the updates because shortly after they were installed 'table linking' in Access 2007 would only work under certain conditions. I do not wish at this point to enumerate the conditions. Microsoft admitted to me on the phone that those updates had in fact caused my table linking problem and they have a fix for it.
I also have Microsoft working on another problem that I suspect was caused by the same set of updates. When I open 'any' database of any Microsoft generation, the database opens, minimizes and an error message pops up stating that Microsoft could not locate the file and that I should make sure I typed the name of the file correctly. The odd thing is the database is actually opened and minimized. Microsoft has been working on this one for 4 days now with no solution recommended to me.

---

ADO Save Database BASICS Save Recordset Basics
OK all lets see if it was the nature of my other thread or if its just me that cant get an answer in this forum.

This should be an easy one for anyone of you who uses ADO.  I access an Access database with ADODB. I establish a connection, and specify a table name in the connection string. No ADODB specific command object is used.
I can make changes to the recordset on my form but any attempts to save ( Updatebatch ) or rs.save "path-N-filename.mdb" either leave a 1KB access database for new creations or result in the error of file already exists.

Can someone provide the BASICS for saving a recordset and dataase to avoid this error. Lets say I create a NEW recordset & somehow get my stream into it from my other thread in this forum.  How do I correctly attach this NEW recordset to a database I just created in ADOX, (catalog object) and save it to disk without the error that the file exists already.
Please someone this is not for production its just to strengthen my understanding (or lack thereof) in saving recordsets.
I am trying to avoid SQL in this little test I.E. the ADODB command object also. But if it's needed please educate ME !!!
If anyone cares all this is just to continue my efforts in the stream object of ADODB & parsing via XML format.. per my previous thread "STREAMS"
But I'll take what ever I can get.

 Thank You So much for your time. I do appreciate any and all responses.
Christianvbprogrammer@yahoo.com

---

Routing In 2007
I know that the feature was removed from the menus but the MSDN says the method is still available.
http://msdn.microsoft.com/en-us/library/bb177975.aspx

So I route something and then I have a button for when the next person opens it that is just:


Code:
awname = ActiveWorkbook.Name
Workbooks(awnamee).Route
I have also tried ActiveWorkbook.Route and ThisWorkbook.Route

Now this works fine in 2003 but in 2007 the method fails with a 1004 error I believe.

Any suggestions?

---

Office XP Vs 2007
SCENARIO
Some years (2004) ago I developed some macros (forms, modules, etc) to automate some proceses using Word 2002, Excel 2002 & Access 2002. The programs used to run in a PC with Office XP, now the there is a new PC with OFFICE 2007 instead.

THE PROBLEM
Seconds after the macro starts running it stops with the msg
"Code excecution has been terminated" I click on debug and run the macro with F8 and no error is found

THE QUESTION
Why would the macro stop if no error is ecountered (and no one has press Ctrl+Break as the so useful help indicates is the cause of the problem)?

---

New Excel 2007
I have a VB app that reads MS Excel files and imports selected fields into an access database.

Some of my clients have upgraded to the new Excel 2007. What do I need to do within VB to ensure that the 2007 files can be read and processed?

TIA for your assistance.

jDadWilson

---

Outlook 2007
I have been sending emails daily, from my production system, using a VB6 app with a package called HTML Mailer Plus. Suddenly, mu customers are telling me that they are not receiving their daily email. The only change that I can see is that I upgraded from Outlook 2003 to Outlook 2007. I am assuming that HTML Mailer does not work with Outlook 2007, even though I get no error mesages.

My project does reference MS Office 12, where before it was version 11.

So, I guess now is the time to break away from 3rd party code. I am going to try this code:

Dim olapp As Object
Dim oitem As Object


Set olapp = CreateObject("Outlook.Application")
Set oitem = olapp.CreateItem(0)
oitem.Subject = "Daily Activity Report"
oitem.To = "fred@flintstone.com; "
oitem.Body = "Attached is the Daily Activity Report"
oitem.AttachFile ("Z:DADFaxesFax49.txt")
oitem.Send
olapp.Close
Set olapp = Nothing
'==========================

Do you see any reason why this will not work with Outlook 2007?


===edit

This is the old code

Dim objMailer As New FlexiMailer

objMailer.ConnectToServer ("smtp.hbci.com")
objMailer.From = "brendaanderson@technigraph.net"
objMailer.Subject = "Daily Activity Report"
objMailer.Body = "Attached is the Daily Activity Report"
objMailer.AttachFile ("Z:DADFaxesFax2.txt")
objMailer.AddMultipleRecipients fmTo, "fred@flintstone.com"
objMailer.SendMessage
objMailer.Disconnect
Set objMailer = Nothing


== more edit

it does not oitem.From and oitem.Attachfile. I get 'object doesn't support this method' errors. Argh...

---

Wha-a-a-a-t Is The Office 2007...
...object procedure--using VBA--for grabbing a chart that Excel has dumped onto the sheet after creating it and, after activating that ChartObject:

1. expanding the base chart object in the horizontal and vertical dimensions?

2. moving the chart object to another part of the same sheet?

(The whole object model has changed, and MS doesn't seem to have at the least even documented how the resizing and same-sheet moving is done. The capacity for that may not even be preserved from pre-2007.)

(By the way, the Office 2007 UI is a catastrophe.)

Thanks in advance.

---

Excel 2007
I am fairly new to VB and the person who first created the program used it through the same database but used Excel 2003. I am using the same database but except have Excel 2007. Are there any major codeing issues that arise from using 2007 rather than 2003?

Any help will be great!!

---

Excel 2007
Hi,

I encountered a problem and I was hoping I can get some help. I am using a complicated program that was
build using VB.NET 2002 version and Excel 2003. Now I installed Excel 2007 and I get
"Can not create ActiveX component" - related to the following line

XlApp = CType(CreateObject("Excel._ExcelApplication"), Excel._ExcelApplication)

I have no idea what to do, I am not even sure if the syntax is correct (although is not complaining)

I changed some of the references but still is not working. One thing caught my attention:
In the original code, before I made the modifications, I had a reference called, simply, "Office" (among others).
Now I have all the others (the new versions I hope) but no "Office". I am not a master in VB anyway, so I am lost.
Can anyone please help?

Thanks,
Andrei



Edited by - andrei_popa17 on 11/26/2007 5:29:26 PM

---