Why Some Can Some Can't Open Shared Db That's Open?

Jul 23, 2007

Hi,

I have noticed that on our network, certain people can open an Access db that is already open by another person, yet some cannot.
We are using the same shortcut (to the mdb file) and all have the same windows read/write permissions.

I can only think it is some setting in Access?

Can anyone help point me along the right path?

View Replies


ADVERTISEMENT

Reports :: Can Create A Date Parameter Box Open Up / When Open Report

Sep 21, 2014

I have a report based on a query that has data for many dates. At the moment I have put a specific date in the criteria of the query so that I could build the report format. So it now displays all the data for the date i have in the criteria section. I will need to run this report several times per week so the specified date (and corresponding data in the report) will need to be changed to a new date when I open the report i.e. when I open my report I want to show data in the report only for a specified date.

Can I create a date parameter box open up when I open the report? Can I create a form with a button that when I click will open the report displaying data for that date? What would be the best way?I also need to display the specified date on the report.

View 5 Replies View Related

What Have I Done? You Can't Open A Subform When It Is Also Open In Design View

Jun 1, 2006

Problem:
Visual Basic run-time error 7792: You can't open a subform when it is also open in Design view.

I have a subform with properties for SourceObject, LinkMasterFields, LinkChildFields changing according to objects and events in the master form.

The subform was bound to a query before which meant that the subform load event was happening as soon as the master form is loaded. I needed to restrict the subform loading until a certain point so I removed the SourceObject property for the masterform's subform. The subform on the master form is now Unbound.

(This is because I'm now running some code on the FormLoad event for the subform which needs to be restricted until the LinkMasterFields and LinkChild Fields properties have been assigned correctly otherwise it takes ages to load.)

Now I'm getting the above error. Obviously, i do not have the subform open anywhere in design view. No Visual Basic windows are open. I've closed the db, closed access, reopened it and clicked on nothing except the masterform. The error occurs when I raise the event in the master form which assigns the sourceobject property to the subform, i.e.

Me.sfmQryAllOV.SourceObject = "sfmQryAllOV"

Can anyone help me? I've googled this but finding no answers.

View 1 Replies View Related

Forms :: When Open A Form / Want To Open Another From At Same

Jan 14, 2015

when i open a form i want to open another frm at the same time. i have a main form with some buttons in it. when i click on a button and a form opens then i am not able to click on a button to open other forms from the main form.

View 2 Replies View Related

Forms :: Click Button To Open Dropdown To Open Record The Filters By Dropdown

Jul 28, 2014

I currently have a button that opens a report. the report pulls from a query that has parameters set to "fromdate" and "todate". instead of using dates and parameters that pop up as blank text boxes, I would like to click the button, have a form pop up with a combo box to select all of the options available (currently 23 options) and then click a button to make a report that only displays the record (1-23) selected. I do not need any time constraints because as the databases get updated with more records, there would be more than 23 options to choose from.

View 1 Replies View Related

After Open Open Another Form

Jul 26, 2005

I want to open another form automatically when an initial form opens, both are non popup) I have tried open and load events - but still the calling form appears on top of the called form.

How do I get the two forms to open form 1 and then form 2?

Also I cannot use the timer event as this is doing something else.

Thanks

View 2 Replies View Related

Closing An Open Form From Another Form That Is Open

Dec 17, 2004

Is there a way to close a form that is open from another form that has the focus. I tried using the Unload event, but I received an error message "Cant load or unload the object". I would appreciate any help!

View 1 Replies View Related

Cant Open

Sep 11, 2006

Hi Guys,

I have created a ms access database and it is located on our shared server at work.

However if someone is viewing the database, when another person double clicks the icon to open the database, nothing happens. As soon as the other person exits the database, someone else can access it.

Previously more than one person could access the database at a time, now they can't.

Any ideas?

Thanks,

View 2 Replies View Related

Open Mdb From Another Mdb

Apr 8, 2007

Just curious to know whether it is possible to open a mdb file from within the form of existing mdb file?

View 1 Replies View Related

IIf Help - Is Open?

Jan 2, 2007

Hi all,

I'm not sure if this can be done with the expression builder. I have a query that brings in a value from an open form when run. The query can be called from two seperate forms.

In my expression, I would like to check which form is open, and port the corresponding value.

In VBA -

If IsOpen(frmPSWork) Then
MyVar = Forms!frmPSWork!txtID
Else
MyVar = Forms!frmCSupdate!txtID
End If

In the expression I tried playing around with something simple along these lines without success -

IIf(IsEmpty([Forms]![frmPSWork]![txtID]),([Forms]![frmCSupdate]![txtID]),([Forms]![frmPSWork]![txtID]))

Please help!

Thanks

Rob

View 2 Replies View Related

Open URL

Jan 6, 2006

I all, i'm newbie in access and need help, i want to create a button that opens a url inserted in a text box, like this:

__________________
__________________|tex box (with url inside) |____|button


when you click the button you open a webpage with the url inserted inside the textbox, is this possible with vba or some other way?? thanks.

View 4 Replies View Related

Open PDF

Mar 17, 2006

I am goign to try and explain my issue the best I can and hope that one of you has some advice.

I have a form full of text boxes that are populated based on a Combo Box selection.
A couple of the fields are Not Visable and house a PDF name and PDF path
What I am tryign to do is allow the user to hit a PDF button and bring up the PDF image, although there may be recrods without a PDF image. So I am trying to test for this.
I wrote a basic If THen statement that tests for the PDF image name. IF it is there then it says "Its there", if not it says it "Not there". This worked out fine, showing me that I can test for an image name.

BALLFIELD_PDF_NAME = PDf image name
BALLFIELD_PDF = PDF Image Path (location of image)

CODE:
Dim Test
Test = Me.BALLFIELD_PDF_NAME.Value

If Not Test = "" Then
MsgBox "Its there"
Else
MsgBox "Its not there"
Exit Sub
End If



I then wrote the below code to look for the image name, if there open the image, if not exit Sub.


Results:
When I open the form and all teh fields are blank adn try to open PDF from a record that I know does not have an image if get nothing (Exaclty what I want)(it exits the sub)
I then choose one that I know has an image and it opens the image (Exaclty what I want, open the image)
I then repeat on another that has an image and it opens that image. (Great)
My problem arises when I try and open one that does not have an image after opening one that does. It goes into the Else Statement (See below) but still opens the last image I opened.....
I cannot figure this out.....

Any thoughts




CODE:
Dim Test
Test = Me.BALLFIELD_PDF_NAME.Value

If Not Test = "" Then

MsgBox BALLFIELD_PDF

Command178.HyperlinkAddress = Me.BALLFIELD_PDF.Value
Else

Exit Sub
End If

View 5 Replies View Related

Open Database

Jun 1, 2005

What is the best place to have opendatabase statement ? Currently I have opendatabase in all of my forms. I dont have any modules in my application. I am new to access programming. Is module really necessary in an application?
If I can put the opendatabase statement in one place, it will be easier for me to change the database name and path, if I have to..I dont know how to do it.

Can anyone help..I hope this one should easy for many of you people.

Thanks very much.

View 10 Replies View Related

Open Any File

Jun 2, 2005

hi there,

I thought my problem would be a common one but after spending enough time on the net and all forums i couldn't find my answer... anyway... here is my problem. The database is about creating reference, the table contains multiple references, i create a folder where i'll put all the files to be attached

I wanna a create a link to a file... the thing are :
- i want to open any kind of file (or at least i specify in a table what kind of file to open (jpg, pdf, etc...)
- The name of the file is different for ever record...
Anyway i think it will be more clear with the code :


Private Sub File_Name_Label_DblClick(Cancel As Integer)
Dim rst As New ADODB.Recordset
Dim file As String
Dim fold As String
Dim i As Integer

'Open Table Folder
rst.ActiveConnection = CurrentProject.Connection
rst.CursorType = adOpenStatic
rst.LockType = adLockPessimistic
rst.Open "SELECT * FROM Folders;"

fold = rst("Certificats")
rst.Close

rst.Open "SELECT * FROM FileType ORDER BY FileType.FileType DESC;"

'Find File

file = DocNo + rst("filetype")
If file <> "" Then GoTo OK
rst.MoveNext
OK:
'Open File
Application.FollowHyperlink file, , True
Bye:

'Close Table
rst.Close
Set rst = Nothing
End Sub

But there is an error (runtime error 490), any help would be appreciated

Thanks again ..

View 1 Replies View Related

Open Application

Sep 21, 2005

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

View 1 Replies View Related

Open With Windows/XP

Dec 5, 2005

Hey all I was wondering if there was anyway to open my program when windows opens, I have the XP sytem but I was also wondering if there would be a difference with windows 98... SO What i would like to accomplish is to open my access program without clicking on it when my windows, is loaded, can I open it when it loads automaticly. Does it matter that there are different users on my system or not. Thanks

View 1 Replies View Related

Database Will Not Open

Feb 21, 2006

Hi,

I've run across a couple issues with our database. The most immediate issue is that I have been unable to open the database on any networked (or non-networked) computer. Me and a assistant typically enter data into this database from two seperate computers. She works on a wireless networked computer with the file on my computers hard drive. I work directly with the file. My computer is wired to the router. (in case that information helps)

We keep getting errors about "cannot access remote computer" and such, they seem to occur when she's entering data and I have the database open, then close Access. It will often give her the error and not allow her to save the record.

But just today she entered something, I closed my database window, then reopened it and I could not get in. All network computers rebooted, and still cannot get into the file. I can enter the password and then it goes to just a blank area (like when your first open access with no database). Older backup versions of the database still work, so it doesn't seem like an Access error. I also noticed that the little "LockFile"s are not being created (I ever faked one just to try it out and it deleted it after i entered the database password)

I can't repair, or convert or anything, it just asks for the password, I give it...and then nothing.

I'm very lost. Thanks for any help.

View 5 Replies View Related

Open Form In Another DB

Mar 22, 2006

how can I open form that in another file.

I have 2 access files (*.mdb) opened, I want when I click on one I open form in the secend file.

how can I do it?

thanks!

View 1 Replies View Related

Can I Open Up One Database From Another?

Mar 29, 2006

I have one database and I want the ability to click on a button and open up another database. Can I do that?

View 1 Replies View Related

Can't Open Database!!

Apr 8, 2006

I can't open my database...
It was open yesterday and after a power failure computer turned off...
2day I can't open it...
Messege box says something like ---database was open--- not properly closed--- etc. etc. and can't perform auto repair...

I tried to import the objects in other database but can't do that as well...


Is there any way to repair the database???

Thanx and regards,,

MPB

View 4 Replies View Related

Access Won't Open

Apr 18, 2006

My access database is on one central desktop. When I go to the office, my laptop "connects" with this central desktop and uses the database. Also, my partner's laptop connects with this central desktop as well.

For some reason, when I connect to the central desktop's database via my laptop at the office, my partner can't connect to it. When he doubleclick's the .mdb file, nothing happens, no error message, nothing. Properties don't even come up when right-clicking the icon.

However, when my partner is connected with the central desktop's access database, I can still connect to it.

We both used to be able to connect to the central desktop with no problems.

Not sure what is the problem now. I've tried changing the security levels of the macros on my laptop, as well as the access database, but no luck. Does anybody know what could be causing this?

Thanks for your help. :confused:

View 8 Replies View Related

Cannot Open .mdb File

Jan 25, 2007

Greetings,

I have a database I have been developing for some time that I can no longer access. I am running windows XP and Access 2003, I am the only user and it is stored on my local system. I was tweaking some VBA code in a few of the forms and closed the file which triggered the auto compact/repair. Everything appeared normal until I tried to open it again later. Now I cannot open the file, I do not get an error message or anything. When I click on the file Access opens and stops, never actually opens the database. If I try to open the file inside Access nothing happens. I have tried importing the objects into a new DB and still nothing happens inside Access. The real wierd part to me is that outside of Access everything is accessible. I can import tables from inside Excel with no trouble, I can put a button into a blank database that opens the other database through DAO and I can see all my tables, forms, data, etc. My problem is that I do not need the data, it is just test data at this point, I need to recover the VBA code from the Forms and I do not know how to do that without being able to open the database in Access.

Here is what I have tried so far (on copies of original DB):
-Compact and Repair inside Access: Nothing happens just like trying to do anything else with it inside Access
-Opened DB holding shift: Same Problem
-Copied file to two other Windows XP/Access 2003 systems: Same problem
-Used Jet Compact: The database file compacts successfully, still cannot open in Access
-Opened Access with /decompile: Same problem, Access opens, DB does not
-Created new DB and tried to import objects: Cannot open the old DB or see its objects
-Imported data from inside Excel: No problems, all tables/queries are available and all data appears correct
-Accessed file from new DB using DAO code: Everything appears normal, I can export the modules to text fine, but I have lots of code in forms that I cannot export
-Opened other databases in Access on same machine: No problems

I've done quite a bit of searching on this and have not found the same problem listed anywhere else. I do have daily backups so I'm not completely lost, but I made quite a few changes before it died that make it worthwhile for me to try and recover the file.

Any suggestions of other things to try? Is there any way to extract the VBA code inside a form from an .mdb file outside of Access?

Thanks for any ideas!

View 2 Replies View Related

Open Access DB From .bat

Feb 12, 2007

Is it possible to open an access data base using a .bat command? I have a .bat file that combines multiple files and archives the individual files. I'd like to auitomatically start up the access data base from within that .bat file. Or, is there an easy way to import multiple files?

View 2 Replies View Related

Open Certain Table

Apr 8, 2007

Hi.I'm new to Access. I'd like to know how can I choose which table/form will open when I open the MS Access file from my desktop? And can I change it in the future? I have Office 2007.Regards,Kirret

View 2 Replies View Related

Open .mdb From A Html?

Apr 19, 2007

I have a local intranet where I have a link in a web page to .mdb file. For some reason it does not consisitenly open the database when clicked? Any ideas? Links to Excel work fine.

thanks!

View 6 Replies View Related

Open Excel

May 3, 2007

can anyone tell me how to open an excel spreadsheet from access 2003. I used to be able to do this in access 97 but I can't find a way to open or link a spreadsheet

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved