Comments (9)
What libraries are you referencing?
That looks like the reference for VBA; if it is then it won't affect the project. The VBA library is present by default.
from msaccess-vcs-integration.
I've added the error number to the message box title. if you could download the master, run the import again and tell me what the error number is then I'll look into this.
from msaccess-vcs-integration.
The error number is -2147319779, i have only the default refrences that is already specified in the demo.accdb
from msaccess-vcs-integration.
Well, the error number is meaningless.
For each of the following lines, copy it into the immediate window in the VBA editor and hit return:
Debug.Print application.References("VBA").Guid
Debug.Print application.References("VBA").FullPath
Debug.Print application.References("VBA").Major
Debug.Print application.References("VBA").Minor
and then post the output here.
from msaccess-vcs-integration.
Your suspicion that is was VBA is correct.
Debug.Print application.References("VBA").Guid
{000204EF-0000-0000-C000-000000000046}
Debug.Print application.References("VBA").FullPath
C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA7.1\VBE7.DLL
Debug.Print application.References("VBA").Major
4
Debug.Print application.References("VBA").Minor
2
from msaccess-vcs-integration.
I found an easy solution by using the "BuiltIn" property:
For Each ref In Application.References
If ref.GUID > "" Then ' references of types mdb,accdb,mde etc don't have a GUID
ElseIf Not ref.BuiltIn Then
line = ref.FullPath
outfile.WriteLine line
End If
Next
Using this in the EXPORTReferences eliminates the bug
from msaccess-vcs-integration.
Its seems that I did not test this correctly or that this gives odd results, but when I tested it this mornig this suddely failed to do the trick. So chalk this up as a dead end.
from msaccess-vcs-integration.
The correct code is as follows:
Public Function ExportReferences(obj_path As String)
Dim FSO, outfile
Dim line As String
Dim ref As Reference
Set FSO = CreateObject("Scripting.FileSystemObject")
Set outfile = FSO.CreateTextFile(obj_path & "references.csv", True)
For Each ref In Application.References
If ref.GUID > "" Then ' references of types mdb,accdb,mde etc don't have a GUID
If Not ref.BuiltIn Then
line = ref.GUID & "," & CStr(ref.Major) & "," & CStr(ref.Minor)
outfile.WriteLine line
End If
Else
line = ref.FullPath
outfile.WriteLine line
End If
Next
outfile.Close
End Function
from msaccess-vcs-integration.
fixed in bde584e
already pushed to master.
thanks for the code @Ronaldvr
from msaccess-vcs-integration.
Related Issues (20)
- The install instructions are not working HOT 1
- ExportAllSource fails if table content export configured and pfs directory doesn't already exist HOT 1
- ExportAllSource Error 32584: No object with the given name and type exists in the current database. HOT 1
- using "source" as folder name causes issues when trying to compare multiple dbs in same folder
- Request the msaccess-vcs-integration team be able to manage repo security HOT 2
- Window position is noise? HOT 2
- Discussion/Design: Change of paths & export of tables
- New Release/Tag HOT 4
- Code Analysis Refactoring: rubberduckvba analysis
- Merge Hangie Develop Branch HOT 1
- load-VCS hangs indefinitely HOT 2
- RecSrcDt = Begin noise? HOT 2
- Escaping/unescaping of table data - backslashes HOT 5
- Export queries with .sql extension HOT 2
- Run-time error 76 during export HOT 3
- Export table only export 1 table HOT 1
- ExportAllSource performance VCS_SanitizeTextFiles HOT 19
- ExportAllSource makes all files in ANSI encoding
- Support for Pass-Through queries HOT 4
- Attachment types are exported as jetType="text"
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from msaccess-vcs-integration.