Access File Cant Be Opened
Mar 9, 2008
I have Access 2000 at home, and 2003 at work.
I can still open my file at work, but the same file at home cant be opened. It keeps giving "microsoft access has encountered an error" etc.. send error report..
Any suggesstions?
Thanks!
View Replies
ADVERTISEMENT
Jul 9, 2013
I have a database with three users, only one of whom has editing privileges. As such, I didn't see the need to setup a front end and back end (nor did I know how at the time). Anyway, that's not the issue. The database is saved on a networked computer that all users can access. Unfortunately, when accessing the database in the shared network folder, only the first user can access it. Other users will double click the file and virtually nothing happens.
However, users can instead open Access first, and open the file through the program fine. Why this would be the case and how I can have multiple users open the file from the shared folder?
View 4 Replies
View Related
Jan 8, 2014
How can copy table from another mdb file in current opened mdb file? If copy table is exist in current file table will be replaced.
View 7 Replies
View Related
Jan 14, 2014
I have the following code. In the Else part of the code, after the wb.Activate line, what code can I place here that will assign wb.Name to the objExcelApp object ao that when the line .Visible = False kicks in, it will make the already opened MS Excel file invisible.
Code:
Dim strExcelFile As String
Dim wb As Workbook
Set objExcelApp = GetObject(, "Excel.Application")
If objExcelApp Is Nothing Then
Set objExcelApp = CreateObject("Excel.Application")
objExcelApp.Workbooks.Open FileName:=strExcelFile
[code]...
View 2 Replies
View Related
Oct 1, 2013
I have a access form that has a text box that holds a search term. The search term is used as a variable in a query. The query results populate a list box. Selecting a result in the list box populates the rest of the form where the record can be edited. All of that works great...sort of. When first opening the form you cannot view any records. The search function works fine and the list box populates but selecting a record does not populate the rest of the form. Attempt to navigate (next, first, etc.) and you get a "You can't go to the specified record" dialog. There is a simple fix for this. Open the form as normal. Then switch to design mode. Do absolutely nothing. Switch back to form mode. All is well.
View 1 Replies
View Related
Jul 9, 2015
I have been at this for almost 3 weeks now and I'm having great difficulties trying to get this right and working. First let me explain what I am doing and what I am trying to do.
Firstly, I am making a Maintenance database using MS access software, what I have are tables, forms and no queries or report existing so far. The forms and tables all work correctly.
After the form (Job request) has been completed I need to save/export into PDF so I am able to hyperlink it against its existing asset card elsewhere.
now what I have done is Created button, on event "on click" I have tried to go to macro builder
ExportWithFormatting
Objet Type: Form
Object Name: FrmMachineFault/GenMaint
Output format: PDF
Output file:
Auto Start: No
Template File:
Encoding:
Output Quality: Print
when I click this button it opens to save to and it works perfectly but I have to manually type the file name when it gets to the Save to section.
What I want it to do is define the name by the existing fields in the open form. Example Closed date, Effected area, Asset and title.
What I am hoping for is something like this.
10/07/15_Foundry_Furnace_LPG_Leak
(Closed date)_(Effected Area)_(Asset)_(Tittle)
Is this possible?
View 14 Replies
View Related
Apr 26, 2006
Hi
I want to see Which tabel was opened, who and when opened it.
And if possible I want to see what is changed.
I want to see as I mentioned above as a "log file"
Thank you
Sedat ONAT
View 3 Replies
View Related
Dec 21, 2014
IN Access 2007 when a Continuous form is opened there is no records shown.
Only after hitting the page down records are shown.
View 1 Replies
View Related
Mar 11, 2014
I often create contract using mail merge. I have an access file that I want to use as data source for word file. But it does not automatically.
Please download the attached file !
If there are 1 customer and 1 property, I do not need to do anything. Conversely, if there are many customers and many properties, I take time to manipulate.
Firstly, I open the word file. I have to copy and paste paragraphs that I want. Highlight of the original paragraphs is blue.
Secondly, I click 'Insert Word Field' -> select 'Next Record'.
In short, I wish to use VBA in access file to automatically perform the steps that I have outlined.
View 3 Replies
View Related
Jul 11, 2007
I have a button in the form of the current access file. What I want to do is when the user click on the button,
triggered the vba to backup current access file. But since the file is currently open, is this possible? If yes, may I know how to do it with vba?
I have tried two methods but failed:
1) Use copytofile method, but I get permission denied due to file open;
2) Use dbengine.compactdatabase method, but it also has problem if the file is open.
View 3 Replies
View Related
Nov 15, 2013
I'm experimenting with MS Access, and I've successfully split an MDB someone created into two files. I can access the database from 2 computers at once using the front end file connecting to a file server which hosts the _be.mdb file.
Could the _be.mdb file theoretically be on a NAS without any computer attached, or is there some runtime or full version of Access that needs to run on the machine with the back end file?
View 2 Replies
View Related
Dec 7, 2006
i have develop an application in Ms Access, now i want to have setup file for that, how a setup file can be created.
View 3 Replies
View Related
Jul 18, 2007
Hi,
I want to make some changes in .MDB file and i do not have it. I have only .MDE file.. Could you please let me know how i can convert .MDE file into >MDB file so can change tabelsa nad reports...
Many Thanks
Nitesha
View 1 Replies
View Related
Nov 27, 2005
Hi,
In the Forms of the MS Access,
Can we add the flash file, or swf, other animation file on the form?
Thanks.
View 1 Replies
View Related
Dec 30, 2011
i want to convert accdb file to an exe file that not display any design view in other words i want the user watch only the forms and handle with the application as a program.
View 2 Replies
View Related
Aug 13, 2014
I have a shared database and at times the database name changes to db1 when somebody is working on it. It doesn't happen all the time or with specific user.
For example if my database name is Incentive.mdb it will automatically change to db1.mdb when its opened and saved.
View 2 Replies
View Related
Nov 4, 2005
I have a subform inside a Form.
When I'm trying to upadate the subfrom from an event triggered by a control in Form I get the error message that subform is not opened.Why is that?
I've tried commands MoveTo or Select (subform) before update command in order to force update command to understand that subform is opened but without any result.
I guess is a common problem but I can't find the solution. :(
View 1 Replies
View Related
Nov 8, 2005
I have a Main Form that utilizes tabs to control several other forms by opening, closing and making them visible/invisible. One of the forms needs to be closed when its tab on the Main form is unselected. The problem is that once the form is closed, when it opens up again it opens right infront of my Main form's tab control so I need to move it down an inch to get to the tab control.
I've positioned this form where I want it and saved it numerous times. But once I select the tab, it opens up right ontop of the Main form's tab control again. I have the AutoResize set to No and the Auto Center also set to No.
Any ideas how I can get this form to stay put?
Any help is most appreciated. Thanks.
View 2 Replies
View Related
Jan 2, 2006
hopefully someone will know what to do...
i have a form that has a bunch of check boxes and labels that are hidden to start with,and become visible when a confirmation button is pressed. Wen i set this up in the design view i.e making their visible status = false, everything runs accordingly - however when the next person comes to update their details the form will not format properly. i think the reason has something to do with the check boxes having different visibilty statuses after the initial confirmation i therefore used code on the form open event
If Check2.Visible = True Then
check.Visible = False
End If
however this tends to fail at the first checkbox, however if i then press run on the VBA screen everything else seems to then run fine and so only the first checkbox is left visible...
can anybody help....
thanks in advance i hope i have made myself clear..
View 2 Replies
View Related
Jan 18, 2006
Hi
Is there a way I can make a form open to maximum size to fill the work area without click the forms Max button
dave
View 1 Replies
View Related
Oct 16, 2004
I have a VB6 project that connects to a Access database. I get a run time error when I try to copy the database as a backup - "You attempted to open a database that is already opened exclusively..."
I need to be able to copy this database while it is still open. How do I work around this?
Thanks Steven
View 2 Replies
View Related
Apr 21, 2007
I am having a db whose back end is in a shared computer and front end (all queries, forms & reports etc) are on local users machines. On opening db first form openes is user id for login.
Now I need to do more on that, 1st step is - how to check who has the db running on pc. Then to refresh his form and send him some message (popup).
Can somebody take me through?
View 2 Replies
View Related
Apr 9, 2008
How can i have multiple people entering data into a database, also there is an excel file that imports the info every few min, if i have that open i cannot enter data into the database. theres going to about 4-5 users plus the excel file.
View 1 Replies
View Related
Sep 2, 2005
Hey there, when a user opens my database, I want the form to enter records to automatically open. Can someone plz help with that... thx
View 3 Replies
View Related
May 17, 2006
Hi all, I have a main form which contains buttons to control all other window. I'd like to prevent user to work on two forms at the same time. Can anyone advise me how to disable the main window while the second window is opened?
thanks
View 3 Replies
View Related
Feb 11, 2014
I have the code for sending an email but I only want to send a single email when there are records in a query and only when the database is first opened.
I hadn't considered this in my design so what structural requirements would it require if any?
View 5 Replies
View Related