.mde File Cant Find Project Or Library
Jun 16, 2005
Please help!
Working on an Access 97 database that I have inherited, on win 2000. The database is converted into an .mde file for the users.
I need to convert my new version to an .mde file, it does convert, but then when trying to open it afterwards gives the error below. Believe it's connected with the startup form frmsplashscreen which has 'on current', 'on open' and 'on timer' events
The expression On Open you entered as the event property setting produced the following error: Cant find project or library.
I have gone back to the .mdb it was converted from and compared the startup form to that of a previous version. All the code is the same.
I have also tried commenting out the on open event, which then changes the error to
The expression On Current you entered as the event property setting produced the following error: Cant find project or library.
I don't understand why it does not work, this same form opens fine when it's an .mdb file.
This is the first time I have worked with .mde files...I've looked on the internet, can't locate the exact error but similar ones point to problems with files on my ws (references etc). Previous versions of this database as .mde files work fine though?
Just say if you want the code from the startup form.
Help! Can't see what is causing this issue.
View Replies
ADVERTISEMENT
Nov 22, 2007
Okay, I have been away from in-depth access for several months and now I am transfering my project to a new computer with Office 2000 and latest patches installed.
When I try to run a screen, I get the error "Compile Error. Can't find project or library."
I check the references against the old computer and they are all the same.
The silly thing is that it is built-in functions like "trim" causing the error.
I know this is very basic but I forget what causes it.
Thanks much for the help!
View 1 Replies
View Related
Jun 11, 2014
The Str() function is a basic, how can this function be missing? I had a problem not so long ago with not being able to change background colors via VBA 'cause, I'm almost certain, the same error message.
Somehow my Access installation is broken, or my HD is dying? Haven't noticed any other errors with my system though.
View 4 Replies
View Related
Aug 30, 2005
I try to use the function chr() and left() in Access2000. but it got "Complile error: Can't find project or library".
View 1 Replies
View Related
Feb 10, 2015
i have the following code and i have the below error:
can't find the project or library in red part
Code:
Option Compare Database
Option Explicit
Function DatumUmwandeln(Datumstring As Variant) As String
Dim Monat, Tag, Jahr As String
If Datumstring <> "" Then
Tag = Format$(Datumstring, "dd")
[code]....
View 14 Replies
View Related
Dec 3, 2012
I am using VBA for MS Access 2003. I left this project since 4 years and I know back to it as mass needs forced me to use it again.
I use trim function. it raises the compile error: can't find project or library. I know that the solution is by adding the library in the References item from the Tools menu. Thus What are the minimum libraries that I should add so that these basic problems solved. By the way: I already added the Microsoft Visual Basic for Applications Extensibility 5.3.
View 1 Replies
View Related
Nov 18, 2014
Code:
Private Sub Form_Open(Cancel As Integer)
cboDateStart.Value = Format(Now() - 7, "short date")
...
End Sub
When I run procedure the Format is highlighted and popup error message:
Compile error: Can't find project or library
View 1 Replies
View Related
Nov 4, 2014
I have a program running with VBA coding, whereby the user enter a password which then sets the field attributes to enable the user to change them.
This is working on my laptop, on the client's LAN, it also worked through REMOTE DESKTOP, but the Head Office installed new PCs and now the REMOTE DESKTOP cause a problem.
View 4 Replies
View Related
Jul 28, 2013
I am using Access 2010.
I want to set up a Library File containing code that I can call from numerous access databases.
I try to make reference to the newly created Library.accdb file in Tools - References and get the error message: Name conflicts with existing module, project or object library.
I have checked the names of all of these and there does not appear to be a conflict.
View 1 Replies
View Related
Feb 16, 2014
I had almost complete my project in Access. How i will produce the executable file of my Project.
View 1 Replies
View Related
Aug 14, 2006
http://www.access-programmers.co.uk/...ad.php?t=97787
I am attempting to add a command button on a form that will allow user to browse files, then select a MS Project file to import, then have it linked to the current record (by a hyperlink or icon of some sort) so that clicking on it will open that MS Project file.
I found the above thread and have imported the modules and the fFindOpenImportFile in order to test in my database. I have made only slight alterations to the code, as I am still a novice w/ VB, but may not have done so correctly. In the Private Sub bImport_Click, I inserted 'tbFile' where sample "C:WindowsWin.ini" had previously been, so that it will import the file already selected from the bBrowse_Click. (If there is a cleaner/better way to do this, I would appreciate any help.)
Here is an exceprt from the code:
Private Sub bImport_Click()
On Error GoTo Err_bImport_Click
Me.tbHidden.SetFocus
If IsNull(tbFile) Or tbFile = "" Then
MsgBox "Please browse and select a valid file to import.", vbCritical, "Invalid File"
Else
If Dir(tbFile) <> "" Then
CurrentDb().Execute "DELETE * FROM tImport"
'FileCopy "C:WINNTWin.ini", "C:WINNTWin.txt"
DoCmd.TransferText acImportDelim, , "tImport", "tbFile", False
MsgBox "Your file has been imported into the Database."
Else
MsgBox "Your computer does not have a C:WindowsWin.ini file so the import example will not work.", vbInformation
End If
End If
Exit_bImport_Click:
Exit Sub
Err_bImport_Click:
MsgBox Err.Number & " - " & Err.Description
Resume Exit_bImport_Click
End Sub
The imported form works great for 'Browse' or 'Open', but when I try 'Import', I get the following error:
2391- Field 'F1' doesn't exist in destination table 'tImport'
I even went back to the sample database and tested the form within the sample, using "win.ini" file and get the same error????:eek:
Of course, when I try it with an actual *.mpp file, I get this error:
31519- You cannot import this file.
...which leads me to believe that even if I fix the first error, I might be on the totally wrong path b/c it's an *.mpp file???:confused:
Any help would be greatly appreciated.
Thanks in advance for any help!
View 5 Replies
View Related
Apr 25, 2005
I have tables and forms setup but I have 3 general questions on how to finish the project.
1. Should I create a folder where all the files reside for instance, create a phone log folder, put the DB file into the folder and export XML's into the same folder?
2. How do I get the form to launch as a self-contained form without the Access application in the background?
3. How can I get this form and table to automatically update an XML spreadsheet whenever records are added?
4. How can I get the form to sort all records according to time logged? The time will be entered in manually and we need all the records to sort automatically by time in ascending order.
View 5 Replies
View Related
Jun 10, 2006
I have a TXT file in a folder (C: emp file.txt) I have the file's Title property set to 'Log file' and Author property as 'John'
How can I get these property values into my variables var1 & var2
View 12 Replies
View Related
May 31, 2005
i have created a form that has data in a field as a referance, i want to use that ref to open a page or PDF file to that referance ,
The idea is that the form is the data input for hard copy documents, i will scan the documents and store them on a hard drive i then want to open the documents as word, or PDF files from the form to the ref of the field in that form
can anyone help
View 1 Replies
View Related
May 10, 2005
(Referring to this post (http://www.access-programmers.co.uk/forums/showthread.php?t=75790) by ghudson)
Hi,
This post was very useful, it really helped me out, but I do have one question. My database will be used by multiple users and will be stored on a mapped network drive, just as the files that I want to link to. Now unfortunately not all machines are configured the same, so the same network drive can have different drive letters depending on the machine and this might cause problems. Is there a way to modify the code to get the absolute network path instead of the drive letter?
thx
Luke
View 1 Replies
View Related
Jun 29, 2006
Hi
I am looking for help related to the “You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later.” message when trying to change the design. I have done a lot of reading on this forum as well as googled the subject but have not found anything regarding my specific question. I find that there’s a whole lot of information regarding workgroup security and how to set up and troubleshoot. However, my needs are a bit more simple – I think :) We have a database that is shared among 5-6 users during a couple months out of the year. There are no log-on id’s required and everyone just opens the file and works as needed. Everything works fine; we have no problems with users changing or doing more than they are supposed to. Therefore, I don’t want to break anything by complicating matters…it works and we’re happy with it. The only annoyance is that during these couple months, someone has to make occasional changes to the database in design mode. Of course, we need everyone else out of the database so he can have exclusive access. This entails calling and/or running around asking those people to close the file and sometimes physically checking computers left unattended with the file open. So my question is: Is there any way to find out what users or workstations have the file open? This would make it so much simpler. All the users are on a Windows Server 2003 network and the files reside on a server. Perhaps this is more of a Windows question; I couldn’t think where else to post it! If anyone could point me in the right direction, I would really appreciate it.
Thanks!
View 3 Replies
View Related
Dec 4, 2006
Hi,
We migrated on DB to a shared network drive. But the users cannot open the DB. It keep give an error message that microsoft access can't find the database file. Please advise.
View 2 Replies
View Related
Dec 11, 2006
I'm having a small difficulty in using the code example ghudson posted for Browse [Find a directory or file]. First off, the code works great. Thanks a lot for posting it!
The problem I am having is when linking a folder via dBrowseDirectory. The folders I am linking are on a shared network drive and I am trying to figure out how to set the initial directory to default to the networked PC. This way the user doesn't have to navigate to the shared drive every time. All they would have to do is navigate to the particular folder to link (2 clicks instead of 10+).
The dBrowseFiles function allows to set an initial directory, however I cannot figure out how to set it for dBrowseDirectory. Is there any way to do this by altering your code for dBrowseDirectory?
Thanks in advance!
View 5 Replies
View Related
Dec 14, 2006
Hi
I am running Access 2000 with MDAC 2.8 and SQL Server 2000 database. I have linked the tables of the database in Access. The problem is that it would not allow me to insert/update/delete but only to select from the database.
Here is the code:
Dim strSQL As String
Dim con As ADODB.Connection
Dim cmd As ADODB.Command
Set con = CurrentProject.Connection
Set cmd = New ADODB.Command
Set cmd.ActiveConnection = con
strSQL = " INSERT INTO dbo.crop_demand_yearly (" & _
"geo_id, crop, area, water_value, water_use, date_from, date_to)" & _
" VALUES("
strSQL = strSQL & ((Val(Me.txt_borenid))) & "," & (Val(Me.cbo_crop)) & "," & (Me.txt_area) & "," & (Me.txt_use) & "," & (Me.txt_value) & ",'" & Format(Me.txt_datefrom, "dd/MM/yyyy") & "','" & Format(Me.txt_dateto, "dd/MM/yyyy") & "')"
cmd.CommandText = strSQL
cmd.Execute strSQL
con.Close
Set cmd = Nothing
Set con = Nothing
I dont understand what is the problem! Please help
View 1 Replies
View Related
Nov 6, 2013
I'm trying to find all the table names inside an external access file from a path.
I have a code for the user to select a file which return a patch to the file.
Then I need to find all the tables names from that file and append them to a list.
so I them can input them into a code and link the tables.
here is the code to get the file patch:
Code:
Function getFileName(path) As String
Dim f As Object
Dim varFile As Variant
Dim path
Set f = Application.FileDialog(3)
[Code] ......
View 8 Replies
View Related
Nov 5, 2013
We have a new user who is unable to get into a database. Another user in the same office had no problems.
The other user is using:
"C:Program Files (x86)Microsoft OfficeOffice14MSACCESS.EXE" /wrkgrp"ServerNameShareNameSFTPSFTPWorkgroup.mdw" "C:SFTP Database V2.1 FESFTP Database V2.1 FE.mdb
The new user was not able to access the share at all using ServerNameShareNameSFTP until he changed the path to:
"C:Program Files (x86)Microsoft OfficeOffice14MSACCESS.EXE" /wrkgrp"ServerName.ACCT05.us.companyabbreviation.comSha reNameSFTPSFTPWorkgroup.mdw" "C:SFTP Database V2.1 FESFTP Database V2.1 FE.mdb"
Now he can get into the SFTP folder, but when he uses the shortcut, he gets an error stating Microsoft Access couldn't find the file ServerName.ACCT05.us.companyabbreviation.comSha reNameSFTPSFTPWorkgroup.mdw 1" "C:SFTP Database V2.1 FESFTP Database V2.1 FE.mdb" (Note the space and 1)
I created a new shortcut, and I was able to open the db using his target line, even though I can use the shorter one. For the new user, this still generates an error.
View 4 Replies
View Related
Jun 5, 2014
Is there a function I could use to find the date listed in the "date created" property of an Access file?
View 4 Replies
View Related
Aug 14, 2014
This may not even be possible, but I am looking to create a Query that can locate records in an Access Table based on 2 columns of data that I have stored in a CSV file.
My table contains several fields, 2 of which are "Dept" and "SKU" and has over a million records.
My CSV file contains 3 fields: "Dept", "SKU" and "Total" - total being the number of times that particular Dept/SKU combination is used.
I need to be able to parse the dept/sku values from each row in the CSV to the query and locate only the records that contain the same values in the Access table.
The plan being to delete out those that are identified by the query.
View 6 Replies
View Related
Sep 5, 2013
I have some vba where I'm importing a text file and splitting it out into a table. For the most part its working just fine.
But I have a line of data that I need to pull out the string right after "Old" - Murphy and right after "New" ZMurphy
Acc# : 111111 This is test data, Person : 22222 Old Murphy New ZMurphy
I'm thinking Instr() could do this but I'm unable to get it to work.
I am using Access 2010...
View 3 Replies
View Related
May 28, 2005
I ran into this the other day and thought that I would post it here if anyone is interested.
CodeLib is an application that helps you to easily find and information gathering.
Support Notes, Code, Files, Pictures, Web, URL save. 6 in 1 Utility.
A database for all your information.
* A Personal information manager (PIM).
* A Knowledge manager (KMS).
* A Document manager (DMS).
* A Bookmark manager.
* A Pictures manager.
* A Notes manager.
* A Code manager.
* A Files manager.
* A Web manager.
* A Blog Writer.
* ... and much more
Screenshot: Here (http://codelib.threeus.com/Manual/images/Snap90.gif)
Video:Here (http://codelib.threeus.com/Demo.htm)
News source:Here (http://codelib.threeus.com/)
Download free version for Access/Firebird/MySQL/MSSQL:Here (http://codelib.threeus.com/Manual/DownOld.htm)
There is a shareware version for $39.
I have always wanted one of these and free is a very good price and if you want more functionality, there is the shareware version.
Enjoy.
View 2 Replies
View Related
Jun 13, 2005
Is it possible to download the MSDN Library from the Net from offline viewing ?
Cheers,
View 1 Replies
View Related