The access form froze and they could do other things but Access remained frozen. They logged off and when they went back in Access opened but none of the form buttons or links were working.
The database is not split because it is used only by one station at a time.
Has this happened to anyone and does anyone know the cause?
Five people were trying to fix it when I walked into work (5 people who no nothing about Access other than using that one database) and I couldn't get a straight answer.
Ok, so I've converted the database to 2003, split the database, compacted and repaired, but when I go to make an mde of the fe, the system "hangs" I even let it run overnight with no results. There's no error messages, nothing.... it looks like it creates a temporary database called "db1" but it never completes the conversion. Any ideas? Am I missing something simple? I have a feeling I am.
I have tried to make a login screen, I have also searched for information and tried some of the examples but, I just can't get one to work. Is there someone or somewhere where I can get information on how to build one step by step in simple easy instructions....(access 2003).
Also, how do you get access to open all the windows, tables, queries etc in full screen mode. I have expaneded them and shut it down and then reopened it but they still want to open out of full screen mode.
Thanks, everyone has been a great help in creating my first Access program.
My issue is that one of my queries can be run, opened in SQL view, but not opened in design view. When I attempt to view in design view, Access freezes and I am forced to close the program. My database is split, FE on my local, BE on another computer on my LAN.
Below is the SQL, I tried to just copy and paste this code into a new query and I encountered the same issue.
if a relevant user opened the db. All well and good, except they then wanted to be able to see the Access link in the taskbar (which SW_HIDE doesn't do) - so I changed it to SW_MINIMISE and they were happy again until..They then realised (and it was a surprise to me as well) that the right click context menus used to filter and sort continuous or datasheet forms were no longer available to these users - nor was the context menu for datasheet columns to freeze or hide columns - see attached.
I've experimented with a number of options and these context menus are available if ShowWindowAsync is not called or if called with SW_HIDE, but not for SW_MINIMISED, SW_SHOWMINIMISED, SW_SHOWMINNOACTIVE, SW_SHOWNOACTIVE.
Why the shortcut menus are not available when the Access window is minimised? The requirement being that the context menus are available to all users the Access link appears on the task bar for all users the access window is hidden for some users.I should say that due to hiding/minimising the access window all forms are popup and modal.
I created a small database with a user login form, along with a password reset form. Running it in my sandbox as an accdr file, the password value resets just fine, but on my test machine with the Access 2010 runtime installed, the password reset form doesn't reset the password. I will try to describe the state of things as of this point.
1. The LoginF presents with a combo box for the user to choose their name, and a text box to enter their password. The code below is on the After Update of the password text box.
Code: Private Sub txtPassword_AfterUpdate() 'Check if user has been chosen If IsNull(Me.cboUser) Then MsgBox "Please Select User Initials", vbInformation, "Warning"
[Code] ....
2. The password reset form has two text boxes for the new password and to re-enter the same, as well as a command button with this code.
Code: Private Sub cmdResetPassword_Click() If Me.Password = Me.PasswordTest And Len(Me.Password) & "" > 0 Then DoCmd.RunCommand acCmdSaveRecord DoCmd.Close DoCmd.OpenForm "LoginF"
[Code] ....
As I say, this works as an accdr file, but not in the actual runtime environment.
Hi, When I click on a command button to print a report and there is no data, after the message there is no data cancelling report the tool bar freezes and I can't get into design view. I can't figure out what's causing this. Any help appreciated. Thanks
I have many forms in my database, three of which completely freeze the database if I edit the slightest thing on them. These forms are all the same, and are unique to any other type of form in my database.
An example of one of the forms is the following:
The form is an "Edit Record" form which allows the user to edit a record directly from a form without going into the table. It is only possible to bring up the edit form by going to the main navigation form that consists of various buttons which a user would press, in this case the user would press the "Edit Record" button. This brings up a unique search form that allows a user to search for a record to edit. The user types their search parameter into the form and once the "search" button is pressed it will bring up the record with all the details in a different form.
Note - The search form is linked to the table where the edit record form is linked to a query.
My problem is this:
I have three buttons on the form; Exit, Cancel & Finish Editing.
All I wanted to do was to ammend the code of the buttons so that "Finish Editing" wouldn't close the form onced pressed and that "Cancel" would simply undo the actions of the user instead of undo and then close the form.
I know exactly how to do the ammendments. But, once completed if you return to the main navigation and click on the "edit" button the search form appears and allows you to type in the search parameters, but once the "Search" button is clicked the search form closes and you are returned to the main navigation where you are unable to click anything in access or even close the programme.
I have VBA code that makes use of the Microsoft Office 14.0 Object Library, but if I have this selected whenever I try to do anything in the Form Design view it is constantly freezing. It will literally say not responding" for a minute or so then I will have control again.
Hello, I am developing one softwater in ms access for small scale engineering industry. I have created switchboad wich comes at the center of the ms access gray screen. I wanted to change this gray screen of ms access and replace with my own. How to do this? can I change this screen? Early reply on this is appreciated.
I would like to ask here for advice on MS Access 2000 application. When a user logs in, he should be able to use the Access 'Query' screen in read-only mode. In other words, he should be able to generate queries by selecting tables and columns, or using the wizard, but the results of those queries may never have any influence on the data in the database. So: SELECT queries only. Users should be allowed to execute those queries, but are not allowed to access the tables, forms, or any other items directly. Is there a way to achieve this?
I am trying to build a Multi Search Screen and just do not know how to achieve this. what I want the application to do is:
1) I Created a main form for data entry called 'Orderfrm' 2) The Orderfrm Field EmpNo - I created a Search Button. 3) Users to enter the Employee No or Surname or FirstName (multisearch) and hit the search button to search for the relevant employee. 4) I would like then to open a 'SearchFrm' with the details of the employee. 5) If it is more than one employee - the system to list them all 6) users will select the correct employee details and finally the system to autofill the details in 'OrderFrm'
I have a modal, pop-up Form, that I'm using as a dialog box. But, when it opens, I want it positioned on screen in a certain place, but I'm struggling to work out how to do this. What properties do I need to alter/set, to achieve this?
I have a module that pulls the user name in the firstname.lastname format. This is the module (module name is fosUserName):
Code:
Public Function GetUser() As String Dim WNet As Object Set WNet = CreateObject("WScript.Network") GetUser = WNet.UserName End Function
I what to add a a text box on the welcome screen that says something along the lines of Welcome firstname (from the firstname.lastname that the code above pulls) what would you like to do? I need some code that will get me all the characters left of the period that separates the firstname from the lastname.
ContextObject .FileName = strPrefix & .StockNumber If .Dirty Then .Dirty = False End If ' .Refresh End With
Stepping through with the debugger, the ".Dirty=False" statement is executed, but the screen does not refresh. If I comment out the "If .Dirty ..." block and comment in the ".Refresh", then the screen does refresh with the new value - but of course that needlessly refreshes all the other records on the form.
I'm looking to take a screen dump of the current Access window, and save it to disk, as part of the error handling for my application. Does anybody have any suggested starting points? I've been Googling around for a while, but haven't really turned up anything concrete.
This (http://support.microsoft.com/?kbid=240653) was as close as I really got (sending the print screen keystroke), however I still need a way to save this data to the disk.
Is there anyway to bring up the on screen keypad or on screen keyboard from Access when running Windows 8 on the desktop? It would really be useful if someone was on a tablet wanting to input data in a text box if could automatically invoke the onscreen keyboard. By default when running applications on the desktop in Windows 8, one has to manually bring it up. I would like to include a touch option so every time wanted to enter data, they would not have to manually touch display keyboard option. A number pad like in excel for iPad would be even better. If text field would bring up keyboard, if number field, it would bring up number pad.
Our client has about 10 end users on Terminal Serve, and they occasionally get white screen error. The event log show following error message
"The program MSAccess.exe version 14.0.7104.5000 stopped interacting with Windows and was closed. To see if more information about the problem is available, check the problem history in the Problem Reports and Solutions control panel. Process ID: 51cc Start Time: 01cfb681b4d13efe Termination Time: 0" Event ID 1002.
Server has MS Access 2010 (SP2) runtime installed. The error happens randomly, and happen on a particular form. When user has updated form details, click EXIT button, the white screen occur.
I have a MS Access database which has a web browser control incorporated within . I also have a get screen capture program for "excel" which works magnificent. I would like to incorporate these 2 functions into The Access . I would like to use my web browser control located in the access example to zoom into the picture of a house . Then capture that image and save it into access in the best usable format possible ...
I have a screen with multiple records from a database. At the top of the screen I have a button that lets the user change the mode between read only and edit modes. The current mode is displayed near the button. When the user decides to update a record or records he goes into the edit mode and starts changing the records. The user may change any number of records on the screen. When editing is finished he presses a button called save and close gets feedback and leaves the screen. Now in this process how do I keep track of the records that are changed on the screen . Plus he can hit the page down key and go to the next page and make changes there also. Is it possible to stop the hitting of the page down key. What indicators can I use to spot the records changed?
