General :: MS Access White Screen - Error 1002

Aug 13, 2014

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.

View Replies


ADVERTISEMENT

Tables :: Error -1002 - Link A Table From One Database To Another

Jun 27, 2013

I simply want to link a table from one database to another but am getting an Error -1002 with the error description: "'|' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long."

I have tried just creating a basic table with one field and linking it to another database and still getting the error. It happens when I compact and repair on close.

View 5 Replies View Related

General :: MS Access - Multi Search Screen

Jul 14, 2015

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 am attaching the database.

View 2 Replies View Related

General :: Invoking On Screen Keyboard In Window 8 From Access

Apr 18, 2014

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.

View 6 Replies View Related

A Simple Login Screen / Also Access In Full Screen

Jul 27, 2006

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.

View 3 Replies View Related

Access 2003 SQL View Loses White Space Changes

May 2, 2007

Hello,

Is there a way to configure Access so SQL View saves white space changes to a query? By white space changes I mean tabs, spaces and carriage returns added to make the query more readable in SQL view.

For instance:

When I'm editing a complex query in Access, I space it out nicely like:

SELECT ((field1 * field2) + (field2 * field3)) / field4 AS [Weighted Avg]

FROM table1, table2, table3

WHERE table1.field = 'xxx'

or something similar, with spaces between fields, parenthesis, and carriage returns or tabs in between major blocks of logic to increase readability. It's simplified above but I hope you get the point.

When I save it and return to SQL View later, Access compacts the query to:

SELECT((field1*field2)+(field2*field3))/field4 AS [Weighted Avg]
FROM table1,table2,table3
WHERE table1.field='xxx'

The above example isn't so bad, but with multipe selects, joins and mathematical calculations using parenthesis, it becomes really unreadable after Access "compacts" it.

Any way to change this lovely "feature" ?

Thanks,

-Scott

View 1 Replies View Related

Reports :: Access 2007 - Report Printing Black And White On Color Printer

Jan 21, 2014

I have a lovely report that includes a small color photograph. I'm sending the report to print on my HP Color LaserJet, but it is printing in black and white.

I can't find anything in the Properties that specifies whether this prints in color or black & white.

How to print this in color?

View 5 Replies View Related

General :: How To Disable Main Screen

Jun 8, 2012

Is there anyway to diasble the window that has the circle in the left hand. When I open my database I just want the form to open. I dont want the window with the toolbars to open it jus gets in the way an is more of a hassle to deal with.

View 3 Replies View Related

General :: Display Progress Message On Screen

Jun 24, 2013

I want to display the message "Processing Record ? of ???..." on the screen while my vba code is running without interruption. Since the msgbox requires the user to click a button to continue, what is the simplest way to display this message on the screen without interrupting the program or requiring user interaction?

View 2 Replies View Related

General :: Fitting Form According To Screen Resolution

Nov 21, 2013

I created a form which fits to my screen resolution. When I open it through an another computer which has different screen resolution then my form is opening according to my 1st screen resolution.

I wanted to fit the form resolution to the desktop on which it it opening. Is it possible?

How to set the form the screen resolution on which the form is opening.

View 3 Replies View Related

General :: Can't Exit Access Now Error

Mar 8, 2013

Access 2010. I've created a database on my thumbdrive and I'm now wishing to place it on our network for multi-users. In copying/pasting the database the the network drive I'm getting the following error message when either trying to Compact and Repair and/or just simply close the darn thing.

Error message:You can't exit the Microsoft Access now.If you're running a Visual Basic module that is using OLE or DDE, you may need to interrupt the moduel.

View 7 Replies View Related

General :: Disable Home Screen For Front End Users?

Jul 23, 2014

I have a database that logs people in and out. Works great unless the user minimizes the navigation page and clicks the X on the main Access Page. I have to keep the minimize button active on my nav page.

Is it at all possible to disable the main access page for the user?
If not, is it at all possible to set a logout macro to the X button on the main page?
If not, is it at all possible to set a logout macro to activate on "Quit Access"?

View 4 Replies View Related

General :: Distributed Application - Variable Screen Sizes?

Mar 26, 2013

Is there a means of making an application grow/shrink to accommodate different screen sizes? eg. not all users of a distributed application will necessarily have the same screen size.

View 2 Replies View Related

General Error With Migration 97 To Access 2003

Sep 29, 2005

In the company whe are migrating from NT4 with Access 97 to a XP And office 2003 enviroment.

This couses some serrius Isues.

one of them richt no is a Multi usser DB. 2 systems of XP and only one of them is able to run the DB. both instalations are the same. ... the DB is tested on more XP systems. but so als it seems only one person is able to run the DB at a time..

But a few can't run the DB at al.

the Software on all systems is the Same Image so there is no diference between OS and Office.

Who already migrated from 97 to 2003 and had isues with migrating..
like these.

.. on the department whe have 15 + diferent DB's in 97. and the Main developers of these DB's ore the IT department is not going to fix this.

View 2 Replies View Related

General :: How To Get Rid Of Error When Network Access Interrupted

Jun 10, 2012

Some of my users have laptops and usually at work finish, they remove their laptops. The issue occurs when they restart their laptops again without network access and then they have some dialog boxes showing below messages:

"Your network access was interrupted and you should close MS access and restart."

When OK is pressed, some other messages like " Object invalid or not set" appears and by pressing many time OK, it does not reset. Last option is to use "Ctrl+Alt+Del".

View 5 Replies View Related

General :: Error When Splitting Access Database

Feb 15, 2013

I have created a db for a nonprofit counseling org. I had created the first half, mostly administrative tasks, called Phase1, and put the BE on a network drive and the FE on multiple users. Now in developing the clinical portion, Phase2, I linked to four of the tables in Phase1 BE file.

Now I tried to split Phase2 the same way as Phase1 and got an error "Subscript out of Range". I think because of already having some external links in it. I checked for the file and Access actually created the BE file for the new phase2, all of the tables are in it minus the four I was linking to. But, access didn't create a FE file. The original still has all of the objects, tables and forms etc. My question is; can I link to the tables in the new BE file even though those tables still exist in the original file?

View 4 Replies View Related

General :: Upsizing Access Database To SQL Server Error

Nov 4, 2013

I am trying to upsize the access database to sql server ,i have an odbc connection and when I try to move the tables,all the data is moving except one table "tblproductinfo" . I have attached the table data and error.

View 1 Replies View Related

General :: Enter Parameter Value Error On Access 2010

Jul 20, 2012

I continue to get this "Enter Parameter Value" on my access and I can't figure out how to fix it. I have access 2010..

"Field1. Filename"

View 1 Replies View Related

General :: Access Update SQL Run Time Error 3075

Aug 16, 2012

What's wrong with my zSQL string? I am working on it for 2 days and got no where. I want to put a IF statement

(=IF('Report - key'!$B$7="ALL","ALL",'2012 data'!B2))

to a ACCESS Text field using SQL Update. Here is my code:

Dim zSQL As String
Dim zmsg As String
Dim DQ As String

DQ = """"

zSQL = "UPDATE Supplier_Meeting_Planning SET [ID3] = ' " & "=IF(" & "'" & "Report - key" & "'" & "!$B$7=" & DQ & "ALL" & DQ & "," & DQ & "ALL" & DQ & "," & "'" & "2012 data" & "'" & "!B2)"
Debug.Print zSQL
DoCmd.RunSQL zSQL

It is very painful to put ' and " in the string.

View 7 Replies View Related

General :: Error Using Access 2010 Contacts Database Template

Jun 13, 2014

I used the Contacts Database Template to import a comma delimited txt file of contacts data. The template included a number of tables, queries, forms & reports which I did not require. I deleted them leaving only a Table entitled 'Addressbk'. I added an Entry Form using the standard access tools and this works fine with the table. However, on running the access database I get the following error message; 'The form named "Main" is mis-spelled or refers to a form that doesn't exist. My only form is labelled 'Entry Form', so it would appear that one of the forms I deleted must have been named 'Main'. If one ignores the error message the database & entry form function perfectly.

View 3 Replies View Related

General :: Application Always Quit In Access Runtime On Every Run-time Error

Mar 24, 2014

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 .

View 5 Replies View Related

General :: Access 2013 / Error - Not Enough Memory To Update The Display

Dec 16, 2014

I am regularly getting the error "There is not enough free memory to update your display, close unneeded programs and try again"

Access 2013 on a windows 7 machine with 4 processors and 24GB total RAM.

Today I have 14 GB free memory (unbelievable! my first laptop had 136 MB total memory!) when I got this error (Access using 38MB) which makes me believe its not a system memory issue but to do with how much (or quickly) memory is allocated to Access.

View 5 Replies View Related

General :: Change Splash Screen For Database Using Method Of Creating Alternative Bitmap

Oct 17, 2014

I've changed my splash screen for a database using the method of creating an alternative bitmap.Is there a time setting for this or an alternative?

View 6 Replies View Related

White Background JPG

Jul 30, 2007

I am trying to put a jpg of a logo onto the top of a form and no matter what I do, it is imported with a white background! I have put it on a transparent canvas in Adobe photoshop, which usually works when I import it into word and other programs, but not access. I have tried looking at the properties of the image in access, but it says that the background is transparent. Help!

View 1 Replies View Related

General :: Error 3343 - Unrecognized Database Format (Access 2007)

Aug 19, 2015

I have a standard shared Access DB application (i.e. central BE on the network, multiple users running their own copy of the FE on their local machine) Has been in production for a while, no major issues.

New user has been added in recent weeks. My error logger has picked up an error he hit earlier today - doesn't appear to have been fatal (he hasn't come to me with a problem, suggesting he just "OK"d the error prompt and continued on - I need to confirm this with him though...)

Error was 3343 "Unrecognized database format 'C:TempMyDBMyDB.accde'."

Can see it was tripped on a particular form which queries certain data into a subform (so he was obviously able to open the FE and connect to the BE fine; it was several steps down the road where the error has occurred).

View 2 Replies View Related

General :: Run Time Error 3011 When Exporting Access Report To Excel

Dec 18, 2012

I using excel 2010 and access 2010. I have VBA script runtime error 3011 when running script. It has problem finding access report. First I was passing in as variable with the name. Then I used a script to pull in the report name from access and it is still failing with same error.

Code is shown below.

Private Sub Command29_Click()
Dim reportname As String
Dim theFilePath As String, FilePath As String, tempStr As String
' reportname = Me.My_DBTableName

[Code] ....

View 3 Replies View Related







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