Closing Mdb Interfaces ..
Aug 26, 2007
Hi Friends,:)
3 small questions I need your help about ACCESS 2003 :
Note: I'm using a workgroup for users access through the network and the
.mdb located in PC as a server NO Front-end & Back-end .
1. Is there a software that can close the .mdb interfaces or forms in all
users PCs ? for design modification in case of a user left the work without closing the DB.
2. Could the users use the internet OR Intranet for fast or better access to the .mdb ?
3.In case of (Front-end & Back-end) strategy , How can I modify the forms since each user has its own ?
Kind Regards,,
View Replies
ADVERTISEMENT
Sep 13, 2005
Hi,
I'm looking for some advice on how to go about creating a web front end for an access database. I'm aware of the FrontPage Database wizard, which actually does do what I need, however for various reasons it isn't an option in this case.
Basically I'm looking for a tutorial or something along those lines that will make it easy for me to write scripts (ASP likely) so that the people that need to see the information in the databases can do so without having to open up Access and fiddle around within the actual databases.
This seems like it would be a fairly common task, so I find it hard to believe the only "easy" way to do with is with the FrontPage wizard; however, I've done about 3 days of Google searching and the best I've found so far is this forum. I'm hoping this isn't one of those questions that is asked daily here and the regs don't get angry with me...I tried searching the forums and didn't find anything.
Thanks in advance for suggestions and other input!
View 1 Replies
View Related
Jan 15, 2014
I'm looking for a form system that will interface with Access.
At present, we collect information from clients and store it in an Access 2003 database. I have designed my form as an Excel spreadsheet. I use Excel as we are missing the reference files that will enable Access to work with Word and some other programs. The Excel form is emailed to the client, who fills it in & emails it back to us.
To restrict entry of certain fields to a list of values, I use lists in the Excel Workbook, which emulate the lookup tables in Access. I am expecting to add more values to the lookup tables, which would mean that I have to constantly update the lists on the Excel spreadsheet, with the lists eventually becoming quite large.
I have written an import program in Access which imports the Excel worksheet/s into the relevant Access tables. This all works, except the entire process is very manual.
What I would like is to use an external form program that would do the following:
1. Allow me to design something that looks nicer than a spreadsheet
2. Can be updated with my lookup tables so I don't have to manually edit the lists (as in Excel)
3. Can be imported into Access (export to an xls or csv file would be ok if not into Access)
4. Is portable, self-contained & can be emailed to the client so doesn't require them to log into any of our systems, including our web site. The user can fill it out with the data being validated at the same time & then return it to us.
View 5 Replies
View Related
Jun 13, 2005
Has anyone seem the problem when you close an access database and you think it is close but if you open the task manager you will see MSACCESS.EXE still running. Why ????
Jon
View 13 Replies
View Related
Feb 26, 2006
hi.
i'm getting an error that i can't source: "you attempted to open a database that is already opened exclusively by user so and so on machine such and such. try again when the db is available."
i'm getting this when i close the db. the default open-option is shared, not exclusive. this is a single home computer. it doesn't happen all the time but (too) often. any ideas to stop this? :confused: (i've seen a few threads that are all network-related).
w
View 4 Replies
View Related
Jun 15, 2006
Current Situation:
Right now when I close a form it will save the data and close.
Problem:
When somone goes in and messes up on something and they just want to exit without saving they cant do that. The data could have been changed and one may not remember what it was!
Solution Ideas:
I am thinking that a pop up window that says "Save Changes?" Yes/No then have it save or not. Could somone give me the details on how to do this or anything else that would solve this issue. Thanks.
View 7 Replies
View Related
Mar 27, 2007
Hi there
My Access Db is working perfectly fine. But when I close it , it pops up message box saying ‘Database already exist’.
Any Clue?
Thanks
Danny
View 6 Replies
View Related
Jul 11, 2007
I wish to detect is there any opened tables, queries, forms, reports, pages(item that may potentially locked the table), and close them automatically using VBA. How to do this?
View 2 Replies
View Related
Feb 12, 2005
I want to put a button on my form which closes access i.e when i click it the access application closes and I go to desktop directly. Is there anyway I can do that.
Regards
Rahul
View 2 Replies
View Related
Feb 14, 2005
Hello,
I need to close a subform to update the controls on it (deleting and adding), and without closing the main form; without using the "visible" propriety.
Thanks
View 2 Replies
View Related
Feb 17, 2005
This is related to some advice I received some time ago <a href="http://www.access-programmers.co.uk/forums/showthread.php?t=64818">here<a>
I am runnign some code, it performs some applications, then, if a Count Field is greater than 1, a form opens as a dialog, displaying some information:
Dim A As String
A = "NewForm"
If Me.[Count] > 0 Then
DoCmd.OpenForm A, acNormal, , , , acDialog
End If
If Me.Continue = "No" Then
Exit Sub
End If
The new form opens, and you can either view it, and click continue, which will run the rest of the code, or you can click quit, which updates Me.Continue to "No", and then it exits.
The problem is, when it exits the Sub, it doesn't really stop the code, it just leaves things kind of hanging. When I try to run the code again, I get:
3321 - The database engine could not lock the table 'NewTable' becuase it is already in use by another person or process.
Another symptom - The original form where I click to start running the code, has two date fields. Normally, when this form opens, they are blank, but when I exit the sub, as above, the previous dates I entered are still sitting there.
How can I make the forms really close?
View 2 Replies
View Related
May 12, 2005
i have a continuous form, which on it i have an unbound text box which displays a calculated value. Now my form is sorted in descending order based on the value in the unbound text box.
Now, i would like that when i do some changes, i would like to re-sort the form in real-time i.e. not having to close and re-open the form. I thought of using the after update event of the unbound text box, but as far as i am concerned the after update event of a calculated "never occurs".
Is there any way, in which i can sort without having to close the form ?
Thank You
View 7 Replies
View Related
Jul 14, 2005
When a form is open you can also see on the task bar that the form is open
If the user right clicks on the form(on the task bar ) they get the following options minimize , maximise , close.
Does any one know how I can stop the user selecting Close please ?
View 6 Replies
View Related
Dec 31, 2004
Does anyone know a line of code I could write that would close all other forms, besides the form the user is working on?
I can't stand it when a new form opens up and the old one is still open. I have written individual macros to close the forms, but that is getting rather cumbersome. Any help is greatly appreciated. Thanks!
View 3 Replies
View Related
Jan 27, 2005
I want it to make it impossible to close my access application (mde file) through
the normal way (the x on top must be shut off)
greetings
Koen
View 4 Replies
View Related
Mar 3, 2005
Is there a way to close access from a form?
I know you can close the database, but is there also a way to close the entire programs with a button on a form?
Thx in advance,
Lion85heart
View 1 Replies
View Related
Oct 11, 2006
when i close the form all the fileds in the forms gets saved to the table.
i want it should pop up before closing to save it or not.
i have a button on the form to save the fields in the table.
which has code
command23_Click()
DoCmd.GoToRecord , , acNewRec
View 6 Replies
View Related
Nov 3, 2006
If you've run a query, and still got it open on the screen, does that affect re-running it? As I just noticed mine retained the previous results. So I thought it would be sensible practise, to make sure any open queries are automatically closed. So I'm trying to include some code to do this via the form which calls the queries.
But the code I've written won't work. I get the following error - Method or data member not found (Error 461). Can anyone suggest how the code needs amending to work. I think I must have the syntax wrong.
I've written....
Private Sub Form_Load()
DoCmd.CloseQuery
End Sub
I was hoping this would close whichever query was active when the form was next loaded.
Thanks.
View 5 Replies
View Related
Jul 24, 2005
When closing an access database, I get the following error message:
"There was a problem sending the command to a program"
We recently had our server changed over. Is this an access problem, or their problem?
View 1 Replies
View Related
Jan 25, 2006
I recently created a database and installed buttons to properly close the database to avoid coruption of files etc. However I could not find a way to eliminate the X button in the upper right corner of access. Today my dbase crashed, I presume because someone did not use the buttons I installed, and just closed using the X in the upper right corner of access. The database is on a network, and was not password protected at the time. It will be when it is restored, however I would still like to know if there is a way to eliminate the x button in the upper right hand corner so that users will have to use the buttons created to properly close the database.
View 4 Replies
View Related
Apr 18, 2006
Hi,
I was wondering if anyone might be able to help me out. Is there a way of programming the access database in such a way that it doen't shut the whole database if someone by accident, presses the cross sign which is right on the top right hand corner. I'd like it to ask the user if they really want to quit first. This way, all the unsaved work can be saved prior to the closing.
Is this possible?
Thank you in advance
View 2 Replies
View Related
May 19, 2006
When 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 Related
Sep 19, 2006
I have found that when closing a form and changes have been made to the fields, these changes will be saved.
I would like to know if there it is posible to only save the changes when a command button is pressed and not when if you close the form any other way.
View 3 Replies
View Related
Jan 22, 2007
Where would I access the event properties for when the entire database closes? Something like the On_Close event for a form, but for the whole database.
I want to have Access prompt to back up the database upon exit, so when someone clicks the close button, a dialog box opens and asks "Do you want to back up?" with an Yes or No option. Yes would obviously run the backup code, and No would simply exit.
View 6 Replies
View Related
Jun 13, 2007
I have a front end and back end database
I have broken the links between the 2 databases
how can I close the backend database using VB from code in the front end database?
I keep getting errors that the DB is not exclusive
View 11 Replies
View Related
Jul 25, 2007
Hi,
How can I stop user from closing the form if the mantory fields are not filled up? I try using gotocontrol but it is not working.
View 1 Replies
View Related
