Please help. When trying to launch MS Access 2000 I get an error: " Can't find the database you specified, or you didn't specify a database at all. Specify a valid database name in the command line, and include a path if necessary." When I try to open a valid Access file, the application simply doesn't display anything.Please help to fix the problem.
Thanks
i want that if any powerpoint application is open after closing my access app all of these powerpoint files will be closed. i found this code for excel file and i changed it for powerpoint application. but i have an error message in this pink line?
error 438: object doesn't support this property or method
Code:
Public Function test()
Dim oApp As Object
Dim workbook1 As Object
[Code].....
This seems like a very silly question but I wondered if someone could tell me how I open up another mdb file from a form?
I've tried the following
On Error GoTo Err_Command976_Click
DoCmd.Quit
Dim stAppName As String
stAppName = "S:updateUpdateMDEUtility.mdb"
Call Shell(stAppName, 1)
Exit_Command976_Click:
Exit Sub
Err_Command976_Click:
MsgBox Err.Description
Resume Exit_Command976_Click
End Sub
But I just keep getting "Invalid Call Procedure or Argument"
Many Thanks
Andy
I have a shared 2000 db and for the last few days someone has been leaving it open. In '97 you could open the .ldb file and see who it was, is there a way to find out in 2000?
Also, I have seen something on remotely removing users who leave the application open but can't find it now. Does anyone know how this is done? The data must be refeshed daily and hasn't been for the last four days due to this lock.
Hi all..
I need to open an application when user clicks a command button...From this forum I have learnt that I can use SHELL command..but when I use this command to open an application, it opens a new instance of the application everytime...Can I bring the application to the foreground if it was already open?
Thanks in advance.
Hi all,
I have an application which needs to be embeded in a form. The reason for this is that we need other details in addtion to what the application.exe can perform. When a user loads a form the application needs to start up within ACCESS form.
Can you please reagard this as high priority.
Regards
Sidtech
Hello,
I once used a program, when you click this .mdb file, it opens a main Form interface that user can run programs such as view report etc. That is, all tables, querys reports, other forms are behind the sence (user does not need to know them).
Could anyone tell me how to do this? Thank you for yoru help.
I am trying to open a MS Access Database which was made in MS Access 1997 or MS Access 2000, at the moment i am using MS Access 2010, i cannot open the database or link the tables.i do not have MS Access 2000 anymore.
View 1 Replies View RelatedThere are around 100 customers.And on application open, need to check if customer has paid invoice. If the customer has paid/not paid need to change the status accordingly. Form on open event changes status of only the first customer.Form on current changes status only if we move to the specific record. Is there an event to trigger to check the entire table records on application open?
View 9 Replies View RelatedWhen I exit my application I sometimes (about 1 in 5 times) get an error message (see attached jpg). This doesnt make any senese to me as I am closing my application NOT opening it. Is this happening because my mdb is corrupted? (I compact and repair on close)
View 3 Replies View RelatedHello,
1/ I occasionally run into this error: "The instruction at "0x77fc823" referenced memory at "0xfffffff8". The memory could not be "read".
Click on OK to terminate program."
Do you know if this error message occurr ONLY on certain computers using Access 2000? Since this error popped up on one of my co-worker but NOT on mine. I even tried to re-install Access 2000 again, but the error message still pop up when tried to open a report. Also, the last three digits of instruction number "0x77fcZZZ" change everytime. Please help!!
2/ For some reason, I was coding VBA on one of the procedure on Form_Load, then certainly Access 2k does NOT let me go in the code of any control. WHY!! I am frustrated!! I tried to go in different way, but does not work
Thank you so much.
Hello
For some reason Access will not allow me to open any mdb files. When i click on the file to open Microsoft opens the install wizard for office 2000 and asks for disc 2. If i press ok its says DATA2.msi is missing.
However if i open access through the Programs menu and then go and search for the mdb file i can open it with no problems.
My question is how to solve this problem as i have to copy give someone a copy of one of my databases and i don't want to pass on any bugs etc... ???
Help!
Hi All,
I am trying to open a DBF file in VBA, I get the an error:
Run-Time error '91':
Object variable or With block variable not set
here is my code:
'-------------------------------------------------------------'
Dim oConn As ADODB.Connection
OConn.open "Driver={Microsoft Visual FoxPro" & _ "Driver};SourceType=DBF;SourceDB=c:Mine 01;Exclus ive=No"
'-------------------------------------------------------------'
I tried the following code as well, but it gave the same error :
'-------------------------------------------------------------'
Dim oConn As ADODB.Connection
With oConn
.Provider = "Driver={Microsoft Visual FoxPro Driver}"
.ConnectionString = "SourceType=DBF;SourceDB=c:ME 01;Exclusive=No"
.Open
End With
'-------------------------------------------------------------'
Any ideas?
I need to open the DBF Files in the code using a connection string or any other method available through code.
Thanx
NoFriends
I have a path to a JPEG file in a variable. I want to click on a command button and open the JPEG file. Is there code which in effect double clicks on the path to open the file? Thank you.
View 1 Replies View RelatedHello,
I have a form named Welcome and have stored an unbound list box named lstExport which I would like to use to view and open (using the double click event) excel files that users will be saving in a specific folder on our server.
Can anybody help me with the code?
The excel files are saved in the following path:
s:sharedfiles
Thank you.
hi,
I am new to this forum and to MS Acess. i am not a software engineer or in the field of software. I had to learn as much as i could about MS Acess because of a project i worked on. I have a standalone MSacess database and one of the forms is giving me trouble when I try to enter a new record
The form is called frm_fragrances and has information about a fragrance.
the frm_fragrances has 4 fields in it and a sub form. the sub form has details about the fragrance
In a new record when I enter the 4 fields and attemt to go to the subform which has details about this fragrance I face this error.
an unexpected error haas occurred @2465: application defined or object defined error.
additional information
Active form:<frm_fragrances>
Active control:<txt_VendorName>
Previous control:<frm_fragrances>@Please call the developer for further instructions
I have looked in the FAQ and on this forum for help on error 2465 and cannot find anything to help me. I can work with forms to an extent but cannot write too much code.
I would really appreciate some help in this matter
Thank you
I have setup a small application with front/back end in local network. On client machines i have installed access runtime. Although it works fine but it suddenly quit when there is any run time error while working on client machine. Although on server machine ( where full version is running it didn't close the application ).
What i need is an option to not quit the application completely. As i am not expert in coding of try/catch statements I need a simple solution for time being .
I have based a form on a parameter query, so that when the user is prompted to enter a 'Hobby' to search on, the relevant records will be displayed on the form.
Now, I have created a command button designed to open a template letter in MS Word for a particular hobby. The problem is, I need the command to open certain file depending upon the value input in the parameter box intially. How would I go about doing this?
In a record, I want to have a text box which displays the file path to a .pdf or .doc, docx file. If you double click in the text box the file within the text box opens. If there is no file path I want a small command button to be visible next to the text box, which will launch an explorer that will locate and save the path of a chosen .pdf or .doc, docx file.
I have a field within a tblPriceList called quotefile, which I want to store the file path.
For info. This is not going to be a major multi user database, but the quote files will be stored on a vserver, not the PC the DB is being used on.
I have a database which has several records with at least 5 documents needing to be attached to each record. Using attachments or OLE would cause considerable bloat, so I opted for hyperlink fields for all the document types necessary to save with each record. However, now I am faced with an issue. It is easy enough to write code to open the files by following the hyperlinks, as well as write code to send an email, but how would I go about combining the two? I need to write a code that will attach these documents to an email, as attachments and not as hyperlinks. I know with excel documents, I could follow the hyperlink and send the document by email through excel, but I also have images converted to pdf's that need to be sent as attachments.
View 4 Replies View RelatedI am using Access 2010 with Win-7.Shared, split database with several users.Database Purpose:PM Procedure for Medical Equipment..To be able for the user to copy the file name of 1 or more technical manuals and paste into a table used for a subform on the procedure parent form.Users can then open the related files stored in a common directory that are related to the procedure when later reviewing the procedure .
Problem:File path on the common drive for our group remains static Syspro_5VOL1BIOMEDCOMMONEquipment (Service Manual).The subfolders are not static.There is an unlimited number of sub folders by vendor, model, or make.The subfolders sometimes get renamed as vendors change ownership.The file itself usually does not get renamed.New subfolders get added as needed.Everyone in our group has access to this area of the server.
Question:Is there a way in VBA that when a user opens the procedure record form and dbl-clicks the name of the file in the subform, Access can start at the parent folder and keep searching through all the subfolders until it finds the file?I cannot depend on people in my group to be able to correctly update hyperlinks so I need a way people with no Access knowledge can even use even if its a little slow.
When trying to open an Access database on the server, an error message appears - "Compile of hidden files error", followed then by a run-time error. There is no problem accessing the the server and opening the database from another PC? Does anyone have any ideas what could be causing this. Backups to CD have started failing at the same time.
View 3 Replies View RelatedI just recently helped a local business move their files to a new server, and reinstall fresh windows and office on all their machines. I have run into a problem with Access, hoping someone can help.
Sometimes (usually when someone else has the file open), if you double click on the mdb file (which is on a mapped drive) nothing happens. If you make a shortcut that doesnt help. But if you open Access, and then goto File-Open and located the MDB file that way, it opens fine.
This is annoying to the employees and they want a solution.
Anyone run into this problem?
I am designing an application in Access 2003 and it's pretty much working now.
I have a main form set to automatically open (through database startup).
sometimes, access disappears before even showing the form. The ldb file remains in the folder and access does not show up in Tasks (so it's really terminated).
I do have On_Load event code in the form, but nothing drastic and I went through and made sure that all subs have Error Handlers.
It doesn't give me any error messages, just disappears. This also happens when I try opening the main form from the open Access app, but not as often.
Usually, if I open by holding Shift, enter the form in Design view and close it, it then opens no problem.
Any ideas? I searched and googled, but to no avail.
Thanks!
it is possible to Open access application like desk application done with java or vb, or install access application as exe or similar methods. My requirements is to giving a access application to customer with data base for printing an invoice. when he running the aplication he can see access open and tables, queries forms left hand. how to hide these thing ?
View 4 Replies View RelatedWe have an extensive reporting application in Access and would like it to be available through a web application. I've went down the road of migrating this application to SQL to use SQL Reporting Services; this is a good tool but I am wondering if MS Access has an easier solution for me other than migration to SQL.
I'm looking for a solution that will make these reports available over the web for many users. Price tag is a consideration...need to know if there is any.
Please help...thanks in advance for any thoughts!!!!