SELECT [tbl_AccountsInCurrentOutline].[CurrentAccounts]
FROM tbl_AccountsInCurrentOutline
WHERE
tbl_AccountsInCurrentOutline.CurrentAccounts NOT in (Select * from tbl_CoAAccounts.CoaAccounts)
AND
tbl_AccountsInCurrentOutline.CurrentAccounts NOT in (Select * from tbl_AccountsWithData)
;
All the tables used in the query are fine and all the field names are fine yet I get the error:
"Could not find file 'C:Documents and SettingsmjineshMyDocuments bl_CoAAccounts.mdb"
Why is Access think that the table tbl_CoAAccounts (used in the query) is an mdb file? If I remove the first condition form the WHERE clause..the query works...I guess itwould be something really silly but its just not clicking !!
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
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.
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.
I have an intermittent error occurring on an Access 2k form giving the error message "cant find the macro '.'" although there are no macros on the form. After much trawling around I believe this may be due to a space being mis-keyed into one of the event properties of one of the form’s controls but I have looked at each to no avail. My question is therefore two fold:
1. If this is due to a space being keyed how do I, in code, step through each control and it's events looking for it?, or, 2. If it's not a space what else could it be.
The form opens and works Ok most of the time, the db compacts and repairs and compiles to an MDE and the error appears to not be linked to any one control or event but seems to be triggered more often than not if move from the tab order through use of the mouse.
Ideally I don’t want to redo the form or copy the database objects into a new db as there are too many.
Any help gratefully received.
NB This query was originally posted to the vba section without much success apart from a rebuild suggestion gratefully received from WayneRyan. I thought this was a vba error but may be a macro issue, a form error or could be a general problem so apologies if this is not the correct forum, if incorrectly placed Moderators please feel free to move it
I've recently created a new Access 2010 Database which I'm developing an interface for in VBA. I've created a new Userform in the Visual Studio (this required me to add the Userform button). I'm finding that when I insert the Multipage object which I need to use on the form I can no longer run the Userform. When I attempt to run, I get the error 'Path/File Access Error' followed by 'Run time error 75 - Could not find the specified object'.
It's definitely linked to the Multipage which I've inserted from the toolbox (standard object) as the form runs fine when it is not there and with other objects (have tested all other toolbox items). There is currently no code in written in the project, no tables or queries set up in the database therefore nothing is running when the form loads.
I've successfully used Multipages in a number of other VBA interfaces both in Access and Excel so not sure why they are causing a problem here. I've also just created a userform in exactly the same way in a new Excel sheet and it runs fine with the multipage.
When I am working in the tutorial which is shown in the below link:
[URL]
when I copy from Clarksville.xlsx the employees names and try to paste into a new Access database*. It says:
Text is Too Long to be Edited
I am unsure what to do next to deal with this error. The internet says to increase the size of the cell where the text is being pasted. I am not sure how to do that.
I've vba in Report onformat the vba code does some data copying to External Excel file (premade by vba).Now on first run, i got success.But on opening the excel file, it showed blank space + Error"File already opened"
No White Spreadsheet is shown with data to see into file, i created new excel file in windows, and inserted the vba created/exported file as an Obj.Now Obj is showing correct and full data with spreadsheet as normal view.
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
(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?
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.
All I am trying to do is import a Report from one MS Access db into another.
When I do this I get the following error: "Path/File access error :"VB4.tmp" Press okay and then I get this . . . "Name conflicts with existing module, project, or object librabry. Press okay and then I get this . . . "No Current Record"
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!
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?
I have a form with a form header section that contains a combo box and a text box. The form also has a detail section that has a tab control that contains the rest of the data entry boxes. I put a Find Record button in the detail section of my form. When I try to Find Record using the combobox or textbox values in the form header, I get an error saying it cant search the tab control, use the Gotocontrol action before the Find Record Action, change current field action from yes to no, or change the focus to a searchable control. If I search items in the detail section I do not get errors. The code created by the Find Record button is below. I'm not sure how to get it to set focus to the appropriate box in the form header section if that is the field I am searching on.
Private Sub cmdFind_Click() On Error GoTo Err_cmdFind_Click
I have the code below which is giving me grief as I have copied it from a previous usage and it worked fine. I have tried it in a beforeupdate and now as a seperate button on the form and it gives me the same error message; I have tried to put a save command in to save the record without any luck
the code is
If DCount("[Batch]", "tbl_Data_Wine_Batch", "[Batch]=" & Me.Batch) > 0 Then Cancel = True End If
The error message is Run time error 2001 you cancelled the previous operation.
The problem comes up in the dcount expression.
Any help would be great as it is an important part of the project and we can move on once we have overcome this
Trying to parse first two sections of a five section string. Now getting a SYNTAX COMMA ERROR. Th Left((([ArborID],InStr([ArborID],"-")+1,(InStr(InStr ([Arbor ID],"-")+1,[ArborID],"-")-InStr([ArborID],"-"))-1)),10)
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.
I have been working on a simple data base for some time now (beginner level) and am still trying to improve it. I would like to do something but before that I would like to have your opinion to know if it is even possible?I have a query QryMainReport:
Start Date/Time End Date/Time Employee
At the moment this is what the format of my report looks like (I removed other unnecessary fields):
StartTime----------EndTime---------------Employee 12/06/2014 01:00--12/06/2014 03:00------John Smith 12/06/2014 04:00--12/06/2014 06:00------Jane Doe 13/06/2014 02:00--13/06/2014 05:00------John Smith 13/06/2014 08:00--13/06/2014 08:00------Jane Doe
I would like to do as a report. (Dates would always be from Sunday to Saturday). I am not sure it is possible to do that. I suppose first it would mean:I would have to do a query to separate the times from the dates?I would have to find a way for Access to find the unique dates and unique names?Does it mean I have to use cross tab queries?