Wierd Opening Db Problem!

Mar 5, 2008

Hello

I have a database on a shared network drive. If you try to open the db (when another user already has the db open) from the route "my computer" then selecting the drive then selecting the db the message

"Microsoft Access can't find the database file 'M:lah blah blah'
Make sure you have entered the correct file and path name"

However, if you open the db through the access application it opens fine and there are no problems.

Has anyone come accross this before???
I have contacted our IT department who say that they cannot see why this is happening.

Thanks

View Replies


ADVERTISEMENT

Wierd Stuff..

Oct 25, 2005

Recently I've been having a problem with Access (2003) that I can't seem to get around. If I click on "NEW" to create a new query, do some editing, then go to close, it prompts me as to whether or not I want to save, which would be ok, if it would let me choose NO!!

I only get OK or Cancel options. I've NEVER had this problem before.
I have not done any updates added any addons. Is there some hidden trick here or some way to get around this cause its really annoying.

TIA,
Tim

View 3 Replies View Related

Wierd Date Between Query

Aug 16, 2005

I have a backwards date between query. I have a table with Date1 and Date2 fields. On the form I have a calender control. I want the user to click a date on the calender control and then look at the rows in the table to see if that date is between the Date1 and Date2 fields.

So the query will be (in english) get all rows that CalenderDate1 is between Date1 and Date2

Im stuck. Someone give me direction.

View 11 Replies View Related

Wierd Subform Behavior (Please Help)

Dec 29, 2005

When I open my mainform through an onClick event of a button, the form opens up with the subform on it is disabled/closed -- Just a blank white box shows in place of the subform on my mainform. Here:
http://img426.imageshack.us/img426/4672/shot29sj.th.jpg (http://img426.imageshack.us/my.php?image=shot29sj.jpg)

However, when i go through the objects window and open the mainfrom directly. I am able to enter and update data and the subform shows up and works fine. Here:
http://img420.imageshack.us/img420/5650/shot19ig.th.jpg (http://img420.imageshack.us/my.php?image=shot19ig.jpg)

This is the code attached to the onClick event on the mainMenu

Private Sub New_Project_Click()
On Error GoTo Err_New_Project_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Project Status - Full Details2"

stLinkCriteria = "[projectId]= 0"
DoCmd.OpenForm stDocName, , , stLinkCriteria
[Form_Project Status - Full Details2]![Proj ID].Enabled = False

Exit_New_Project_Click:
Exit Sub

Err_New_Project_Click:
MsgBox Err.Description
Resume Exit_New_Project_Click

End Sub

This is the record source on the mainform:
The projectInfomation table is the record source
SELECT *
FROM projectInformation;

This is the record source on the subform:
The projectStatusCommentary table is the record source

SELECT projectStatusCommentary.projStatusId, projectStatusCommentary.projectId, projectStatusCommentary.statusCommentary, projectStatusCommentary.commentaryDate
FROM projectStatusCommentary;


The link fields are:
projectInformation.projectId
projectStatusCommentary.projectId

The tables are in sybase and my application has an ODBC connection to them.
I can update any of the tables directly without issues.
I have ran the queries independently and updated tables through the query and it works fine also.

I have been pulling my hairs out on this for over 3weeks now. cos i can't seem to find what's wrong.
I am not able to attache the db cos it's very huge. But i have copied the problematic form &subform, to a new db so you may see my design, and record sources.

If you have any suggestions, ideas, or you've come across this kind of issue before, anything...please make my new Year a happy one and help :)
I would really appreciate it!
Have a happy and prosperous new year.

Yours truly,
Frustrated one

View 10 Replies View Related

Wierd Date Picker!!

Oct 12, 2006

Well this is bizzare,
I am using the microsoft date picker in my form. I have made it non editable (i.e. editable=false) when the form loads.

I am making it editable on the click of a button... Seems all so simple huh..

But my problem is that when I click the button, the date picker is displaced at the top of the form..

when I move the slide bar of the form, it again comes back to its original position..

Can anyone explain this?? and how to make it simple?

View 6 Replies View Related

Wierd Slow To Open Problem

May 22, 2007

Hi,

I have a database here that is run by users who use either Access 2002 (XP) or Access 2003.

I have noticed something which to me seems odd and dunno if any of you guys could explain why or how to resolve it?

If one of the 2002 users opens the database it opens fine first time (I use 2002 myself for development) however if a 2003 user opens it it can take 30s+ to open, but then if they close it it will re-open in just a couple of seconds like for the 2002 users.

However if a 2002 user opens it once a 2003 user has just closed it they will then take 30s or so to open it, but then again if they close and re-open it's almost instant.

Is that normal?

Incidentally office 2007 doesn't seem to suffer from this, but it's dead slow at running the database anyway so I'm not going down that route for the forseeable future!

Thanks in advance for any input!

I did try the recommended method of searching this forum using google but it didn't seem to work for me:(

View 1 Replies View Related

Wierd Sorting Situation (excluding Record)

Jun 29, 2006

I'm trying to sort a combo box alphabetically except for one value which is always at the top of the list.

The row source of the combo box is a query. record to remain at the top of the list is static- same value and ID number always. I've fiddled around with a few things, but at the end of the day, i'm just not smart enough! (or its not possible -which i doubt)..
any suggestions?
cheers.

View 2 Replies View Related

Wierd Prob: Cannot Update SQL Server Text-fields For Some Records, But Can For Others

Feb 22, 2005

Hello,

I have a very strange problem:

I have a table linked to an SQL Server table in my MS Access 2000 Application containing 5 text-fields (SQL Server Type, in Access seen as MEMO-fields) and several other fields (in total about 140 fields). Updating any field works fine except for some records. In those records I can only edit the non-text-fields in my application. When I try to edit one of the text-fields I get a error message telling me that another user has edited the record and i have to discard my changes.

The strange thing is that this problem only crops up for some records. (1 in a 100 or so) All other records work fine.

Does anyone know what happens here? And how this can be fixed?

Thanks.
Kaine

View 3 Replies View Related

Forms :: Closing Opening Form With Timer Then Opening Main Menu

Apr 7, 2014

I have a Form opening from Access Options. I would like to close this Form using the Timer. The following is the code I have used but it is not working.

Private Sub Cover_Page_Form_Load()
OpenTimer = Timer
End Sub
Private Sub Cover_Page_Form_Timer()
If (Timer - OpenTime) = 5 Then DoCmd.Close acForm, "Cover_Page_Form", acSaveYes
End Sub

Next question. If I can get this to work can I then use a DoCmd to open new Form within the code above or do I need a new process.

View 5 Replies View Related

Opening Forms Directly (instead Of Opening MS ACCESS)

Apr 20, 2006

Hi All,

Is there a way that when the user clicks on a database file, the form pops up without opening MS Access window.

Thx,

Jatz

View 1 Replies View Related

Opening Forms Directly (instead Of Opening MS ACCESS First)

Apr 20, 2006

Hi All,

Is there a way that when the user clicks on a database file, the form pops up without opening MS Access window.

Thx,

Jatz

View 6 Replies View Related

Opening An Access Program Without Opening Microsoft Access

Jun 11, 2007

I am very close to completing a DB Program.... How can I create a desktop Icon that will Launch my Program without Loading Microsoft Access along with it???

View 6 Replies View Related

When Opening Access

Apr 27, 2005

hi, when opening access how can i get a switch board or a form to automatically open up, instead of viewing the main acess windows

View 1 Replies View Related

Exclusive Opening

Jun 2, 2005

If I have one access mdb file called "DATA" that contains tables and two access applications as mdb files: "app1" and "app2". Both applications has links to tables in access mdb file "DATA". Is there a way to open access file "DATA" exclusively when I open "app1" and open it shared when I run "app2"?

View 3 Replies View Related

Opening Exclusively

Aug 11, 2005

I have small problem that I can't get access to edit my own database because the are constantly people using it. So is it possible to kick uses off my database so that I get exclusive to edit it?

Cheers

View 1 Replies View Related

Database Not Opening

Sep 27, 2005

Hello,

I have been working on a database back and forth and home and at work. Today I saved my database from home and onto my computer at work. The database is not opening here at work. It works fine at home. When I attempt to open it, it tells me Access has encountered a problem and needs to close and it closes.

I tried the Compact and Repair.. Access still shuts down on me. I made a new empted database and tried to import the tables and forms into it.. Access still shuts down on me.

It's getting frustrating because I've been trying to get this working for 3 hours now with no success.

View 5 Replies View Related

Opening A Web Page

Dec 26, 2005

Hi,

I have made an application in access 2000. So what I have, 2 text fields and one button. I would like that when I click the button that access visits a site like this:

http://website.com/test.php?ID=5&NUM=23

where 5 and 23 are values from my fields in my form.

Any ideas.

regards

View 1 Replies View Related

Opening A Database?

Aug 9, 2006

Here's a little problem I have and wondered if anyone knows a way around it.

I currently have many databases that I have created for work and they are quite happy running away doing what they are meant to do on a 2000/NT setup, we will soon be switching to our parent company's network 2003/XP/Citrix which is presenting me with the following problem and we do not have any control over how this is run.

We can no longer create desktop shortcuts to the databases as current, they will place 1 database in the start menu and would like this to be used as the database menu so that all databases are launched from this.

So I am trying to launch access databases from within an access database (Access XP), here's what I have tried so far

Shell - works when I use full MS Access but does not work in Run Time versio n which is what the users will access, shows no error, it just beeps and does nothing.

SendKeys - %fo<FileName>.mdb~ - again works in full access but not in Run Time as RT does not have 'open' in the file menu.

FollowHyperlink - this actually works but I can not get this to open the new database as a full screen window, this requires the user to either run everything maximized (not ideal as some forms are designed to run side by side) or for them to resize the main forms.

Are there any other ways to open a database from within access RT version that will open the access application full screen?

View 5 Replies View Related

Opening And SaveAs

Nov 29, 2006

Hi all,

I have a file that is called vot.xls, but it is a tab delimited text file.
I would like a button on a form called import to open it up in excel and save it as a worksheet vot.xls file.

How would i go about doing this?

Please help.

Thanks in advance

View 11 Replies View Related

Opening Problem

Jan 14, 2008

Hello all!

My program was almost finished, and everything was just fine when a fatal error occurred!

I tried to open my access application and my startup page appears, when i introduce the values I need to introduce here (username and password), a microsoft screen appears, saying that the program has encountered an error and needs to be closed.

After 10 times giving me the error (not 10, but quite a lot of times), it work fine...

What's the problem?? Anyone has a solution for that?? It happened two times so far... and i'm afraid of handing this in, and having this problem...


Thanks for your help!

View 7 Replies View Related

Opening A Pdf Doc Problem

Feb 16, 2005

How can I open a particular Adobe Acrobat document from an Access database?

For example, I have a filed called "Doc1.pdf" that I want to open. How can I do this?

frankie13

View 2 Replies View Related

New Form Opening

Feb 18, 2005

Is there a way you can set where a from Opens in relation to a button or a piece of text you select.

Basically I have a main form, with some selectable options on the LHS of the screen, rather than use buttons I have text boxes programmed to open a form using the "On-Click" event, I want the new form to open right next to the text box, so it will look like a drop down menu.

Additionally the main form could be moved around the screen, is there a way of locking the 2nd form to be next to the text box ?

Additionally I know I could use a list to but I am trying to design the DB with a certain look.

Many thanks

MattP

View 1 Replies View Related

Opening Forms

Aug 16, 2005

Instead of using command buttons to open forms
I would like to open forms displayed in a list box
Is there a way of doing this, so for example the
listbox will show
CustomerForm
SupplierForm
OrdersForm
ProductsForm
When any of the above is clicked the relative
form will open.

Regards
jmeek

View 9 Replies View Related

Opening Forms

Aug 23, 2005

I have a form with a bound combo box listing names, [myname] and a multiselect list box that lists all available forms in a database [myselections]. I am really struggling with code that will enable the user to hit a command button that will then open the selected forms to show the data for the selected individual. I have found things related to selecting items in tables etc but not related to opening forms to specific entrys and I am just not experienced enough with SQL to get this working. Can anyone help or direct me to a good example?

View 1 Replies View Related

Opening Form

Oct 4, 2005

I have a combo box with 4 choices and it is limited to the list. Based on the value the user selects I want to open 1 of 4 forms. Tried using the select case but does not work?

any suggestions?

Jon

View 2 Replies View Related

Opening Form

Feb 3, 2006

Hey, just one quick thing.
Whenever i open my database i want my form to open automatically, i'm only using oe form and one table, but the only thing im going to need to use is the form.

Cheers Guys!

View 1 Replies View Related







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