Inserting Pictures Making Access Crash?
Nov 14, 2006
focking pissed off. i want to add an image to a some forms, the database is all working and that. but when i put a picture in in the design view and then go to view it the whole thing crashs. i nearly lost the whole data base from putting one on the home page, thank fock i had a back up and now ionly have to redo one form as the other one wont open anymore it will just crash every time i try to open it. i have no idea whats going on, i have other images that i put on it before, but i cant put any on now. anyone every encounted this and how do i over come it!
View Replies
ADVERTISEMENT
Jan 31, 2005
I am using Access 2003 in a simple database and want to add digital pictures of each item in my database.
Before trying to enhance the database with pictures; the various fields are filled with either descriptive text or numbers. The size of the mdb database file is 464k.
I recently wanted to add a picture of each database entry. After adding a picture that is only 300k in size the mdb file increase to 18MD. Then after adding another picture also of 300k bytes my database grew to 25MB.
In the drop down menus Under Tools - Database Utilities - I ran the Compact & Repair Database. This did not reduce the size.
In the database Form I am using a Bound Object Frame to hold the picture and yes I am not linking the picture I am including it in the database. But, would only expect it to increase the database size by slightly more than the picture size.
I should also point out that the only way I have found to get the picture to be visible (not just an icon of the type of picture file) is to right click on the Bound Object Frame scroll down and choose Insert Object. Click on Create New and select Adobe Photoshop Image. This open adobe photoshop I make sure the picture properties are creating a picture of 300k.
So my question(s) is again. Why is my database increasing in size so rapidly? Is there a better to insert picture into a database?
Regards, Roy (HerlocherR@aol.com)
View 2 Replies
View Related
Dec 11, 2004
It seems to be quite simple really. Make a form for Orders and add a subform for Order items. Write some VB code to chage values on the Order form when an Order item is added or amended. Add a "Find" dropdown to the Order form to find particular Order numbers.
Run the form and add/amend orders and items. This will work OK. Move to the next or subsequent order using the "Next" button. Add/Amend again - no problem. Drop down the "Find" control, select an order and the correct order comes up on the form. Amend an item. As the code attempts to change a text box on the Order form Access crashes.
The same code (to add up the items, take off discount and add on tax) can be run after a "Find" by changing a "Discount %" text box on the Order form and this works OK. Perhaps the Order form needs to be in focus for the code to work but I cannot see why this should be so.
In fact you don't actually need the "Find" dropdown. Any code that moves to another Order record programatically will cause Access to crash when an item is added/edited subsequently.
Making it crash is simple but stopping it has cost me a couple of days of frustation. Has anybody any ideas?
Regards
Peter
View 2 Replies
View Related
Apr 19, 2007
My Access 2000 project crashed and the computer dutifully asked to report the error to Microsoft, so I let it run. I then looked at the subsequent screen and was surprised. Well - silly me, maybe I shouldn't have been.:mad:
This screen simply said that Access 2000 was in "extended support" and my "solution" was to upgrade to a newer version. This was a bit irritating since the purpose of reporting feedback is to provide an opportunity to fix program bugs. So why ask the user to provide an error report if that report will simply be ignored and only used for a sales pitch.
While Microsoft has every right to discontinue product development, I would hope that they would still try to fix bugs that cause a program to crash. I guess Microsoft's quality control department has been outsourced to the same company that Dilbert works for. Additionally, I find euphemisms, such as "extended support" for "You are out of any help options, tough luck" to be quite irritating. Why not directly admit that we are on our own.
Also I am still on a slow boil over over the last six years by the fact that help for DAO/ADO disappeared from Access 2000 help which was in Acess97 help and Microsoft never got around to making it available as an update.
Back to work now.
View 7 Replies
View Related
Aug 21, 2013
So, my database appeared to be working OK yesterday however I occasionally saw an error in my "Update Event" script on one of my combo boxes.
today, now when I try the combo box, I get a immediate crash.If im assuming its the same combo box, here is the code for that box:
Code:
Private Sub MCAcmb_AfterUpdate()
Me.Model.RowSource = "SELECT DISTINCT [tbl].Record, [tbl].Model" & _
" FROM [tbl] WHERE Record = '" & Me.Recordcmb.Value & _
"' ORDER BY Model"
[code]...
I recently added a header...just tried it again and got the error:"The expression After Update you entered as the event property setting produced the following error:Object or class does not support the set of events."however I got it to work by entering VB, adding a space, removing it and then saving and entering the form view the form worked as normal. when i close and reload, i get the error again
View 3 Replies
View Related
Mar 8, 2006
Hi
I have a DB which has been up and running with no problems for a couple of months.
A couple of users have recently had new machines installed. These are XP SP2 with Office 2000.
The Database FE is on the PC and the Backend is on the server.
When FE is first downloaded and opened it runs fine. The second time you go in the DB gets by the Splash screen but then crashes on the Title Menu. If you then recopy the FE to the machine it opens fine the first time then crashes again on the second attempt.
I have checked the references and all ok. I have full error trapping on the Splash screen and the Title Menu yet I just get the error "Access has encountered an error and needs to close..."
It runs fine on my machine which is XP SP2 with Office 2002. Has anyone any suggestions that I can check or repair this?
JC
View 8 Replies
View Related
Feb 29, 2008
I have built a database with Access 2007, and intend on sharing the database amongst two users.
I am running Vista, and the two PC's or on a peer to peer network. Both with Vista.
I have split the database, and put separate copies of the front end on each of the PC's.
The backend of the database is on the public drive on my PC.
Access opens and functions correctly on both PC's with 1 User logged in.
However, if both users are logged in, my collegues PC crashes when it tries to open forms. This does not happen on my PC.
Does anyone have any ideas on what I need to change. Thanks in advance.
View 4 Replies
View Related
Nov 2, 2005
Hi folks!
I've been experiencing a very frustrating problem recently.
One of my databases crahes randomly, and I'd like to know if some of you have tips to helps me.
The database is splited in front-end and back-end, both on the server. I know keeping the front-end on the client PC will improve performance, but due to a high number of users (about 60 to 80) and the need of doing frequent updates, installing the front-end on each machines is not an option for now.
Users are not all directly connected to the server. Those who are directly connecte4d to the server (in building A) have no problem. Those who don't (building B) have extensive lags on opening (about 30 seconds), and on about anything that calls an heavy query, most often leeding to a crash. Access display the message telling that the datbase needs to be repaired and restart.
I tryed several thing to improve my queries, like eleminating most of GROUP BY and UNIQUE clauses and avoiding the use of functions.
I have a lot of conditional formatting in the forms, but I don't think this is the problem, since it is executed on the local machine (as far as I know).
My theory is that the lags cause some call to the DB to timeout. I just dont know how to fix that. Is there an option to higher the timeout delay?
My other theory is that the problem is caused by dropped packets during the connection to the DB. I tryed downloading large files (100Mb to 250Mb) from the server several times and never had a problem. Although the connection is quite slow, the ping is very small, like below 10ms to 20ms. Is there better ways to test a network connection, if possible without installing software (limited rights on the machine)?
Would using Replicas be a solution? What are the pros and cons of it? I never used them and know very little about it. My idea would be of putting a back-end on both servers, but I guess the data would not be as live.
BTW, I am using Access 2002 (2000 file format) on an XP SP2 PC.
Thanks to all of you patient enough to read all of this! I Hope some of you have some awnsers, tips or tricks!
View 10 Replies
View Related
Oct 30, 2013
I've got a bit of a problem with linking a text box to a ComboBox. I have an employee name in a field [EmployeeName] that sits in the Header of a Form. (This is so I can show multiple records for that employee without having their name repeated at each one). I also have the name of contact [ContactName] that sits in the Detail area of the form.Both names come from their own tables that have all their contact numbers and e-mail addresses in columns I have linked the name to text boxes [ContactPhone] & [EmployeePhone] with their relevant phone numbers in within the Detail area of the form.
The ContactPhone that has the ContactName within the Details part of the form works well with no problems by putting =[ContactName].Column(1) in the Control Source
However when I put =[EmployeeName].Column(1) in the relevant Control Source (and / or EmployeeEMail in a second text box), once I have saved the form in Design view and returned to Form view, Access crashes and shuts down!If I remove the wording from the control source Access doesn't crash.
View 2 Replies
View Related
Jun 18, 2007
I have Access 2003 and have trying for some time to insert pictures. I have followed the instructions step by step as outlined in the BIBLE and nothing. I recently acquired a new computer and the problems still persists. Can anyone help.
View 8 Replies
View Related
Sep 10, 2004
I know its possible with the right code because I put animations into my VB assignment last year. I just need to know how to do those group things where several objects of the same type (like twelve picture frames) have the same name and are told apart by a number in brackets. eg. imgThewave(1).
Thanks
View 3 Replies
View Related
Nov 25, 2011
we are traders of metal scrap. we have lots of material pictures on the basis of container numbers. We want make a user form where on entering the container number the relevant picture will be shown.
View 2 Replies
View Related
Oct 11, 2005
Hello. ( First post)
I had scanned these forums, but i didn't see what I was looking for. I'm new to access, my intern ship short of threw me into it. eh' but that is not the point.
I have to build a circulation spreadsheet, and my bosses would like there to be pictures for each item. Any ideas on how I could do that? Thanks for your time.
View 1 Replies
View Related
Oct 18, 2006
Hi there
im trying to build a database that stores a large number of photos and would like some suggestions on how i can upload multiple photos (20+) at one time without uploading each one individualy, preferably through a form.
To outline the problem, each member of the team has a camera that they take to jobs, when they return i want them to be able to open a new form, enter the job number (the primary key) onto the form and then somehow drag and drop the pictures from the camera onto the form to upload them.
Is this possible through Access? is this the best way of uploading multiple photos easily? and how do i build this?
Thanks in advance
MJ
View 2 Replies
View Related
Aug 17, 2013
I am using access 2013 to make a PowerPoint presentation based on the data in a query. I know how to do that much using VBA but I am also trying to make a slide with a picture on it from a saved location.
Dim db As Database, rs As Recordset
Dim ppObj As PowerPoint.Application
Dim ppPres As PowerPoint.Presentation
On Error GoTo err_cmdOLEPowerPoint
[code]....
At the moment I am not worrying about adding the data as I know how to do this and had it working before - its just adding the picture to the slide.
View 2 Replies
View Related
Jul 2, 2012
Where I can get some better pictures for my access database. The standard ones are really not all that great. I am looking for a stock pile of pics that I can place in my files so that I can draw upon them whenever I am designing my database.
I just havent had much luck designing buttons in GIMP.
View 3 Replies
View Related
Mar 22, 2013
I am currently working on a project for work on re-creating our database for our daily audits. We enter daily information on a form which feeds to the table and in return we run the queries to get the percentages and all that good information. I was asked to be able to load a picture of to a particular record. Can I do that from the form and that link to the table and to the queries that run?
View 2 Replies
View Related
Jan 9, 2012
I have a report that links to a picture. It displayed great in earlier versions of access, but when I switched to 2007, the pictures are displayed but they look like they are posterized. They print just fine. I use an image frame, zoom size mode and centered. They are fairly substantial jpegs (2 megs), but regardless, it is the change to Access 2007 that caused the problem.
View 10 Replies
View Related
Sep 14, 2005
Hi,
My database consists of some personal data and a photo of each person.
I am trying to include these photos when I browse the database via ADP.
I have found instructions how to do so at Microsoft website (article ID: 285820)
Link for it: http://support.microsoft.com/?kbid=285820
The problem is I cannot make it !!!!!!!!
Where exactly should I paste the VBscript in the page code to execute displaying of the photos???????
I am happy to send you the head portion of my page code if anybody knows where to paste it.....
Please help,
Jimmy
View 1 Replies
View Related
Nov 27, 2013
I have a access DB for my employees with pictures. The main form displays their info and a picture as I scroll page to page. But I also have contact report that will show all info and picture. I am having difficulties linking the pictures from a seperate folder on my server.
View 4 Replies
View Related
Apr 8, 2006
I have successfully used the recommended way to display images from a folder in a form as posted on the microsoft website.
http://support.microsoft.com/kb/210100/
These instructions were for Access 2000. I noticed that there are seperate instructions for doing this using Access 2003.:
http://support.microsoft.com/kb/285820/
My questions are:
1. If multiple users access this database using different versions of Access (2000 and 2003) will it not work for some?
2. do i have to modify code if i update to 2003?
Thanks for youir feedback!
~Bruce
View 1 Replies
View Related
Jan 28, 2005
Dear All:
I am currently printing a letter from access to word using a command button. So far, so good.
However, I wish to add the person's name on the letter who I am currently viewing on the form. The name of the fields on the form is called "FULL NAME".
Here is the code I am using to print the letter from Access:
Private Sub PrintLetter_Click()
On Error GoTo Err_PrintLetter_Click
Dim oApp As Object
Set oApp = CreateObject("Word.Application")
oApp.Visible = True
Set appWord = New Word.Application
' The path/name of the Word document goes here
Set wdDoc = appWord.Documents.Open("C:documents and settingsuserdesktopEXPRESS DIPLOMA LETTER.doc")
wdDoc.PrintOut (False)
wdDoc.Close (False)
appWord.Quit
Set wdDoc = Nothing
Set appWord = Nothing
Exit_PrintLetter_Click:
Exit Sub
Err_PrintLetter_Click:
MsgBox Err.Description
Resume Exit_PrintLetter_Click
End Sub
Any help is appreciated.
Regrds,
Dee
View 6 Replies
View Related
Sep 23, 2005
Alrght I'm new to access databases so I don't want to make the mistake of assuming I know more than I do, so please help me out if you can. Thanks.
I would like to insert a DataTable that is created from reading an ASPX page's TextBoxes into an Access table or two. So here is my code for the insert.
Code: C#
PHP Code:#region Insert
public bool Insert(ref DataTable InsertData)
{
OleDbConnection myConnection = new OleDbConnection();
OleDbCommand myCommand = new OleDbCommand();
OleDbDataAdapter myAdapter = new OleDbDataAdapter();
OleDbParameter param;
DataTable dt = new DataTable();
StringBuilder SQL = new StringBuilder();
try
{
// Build SQL Statement
SQL.Append("INSERT INTO Driver (");
SQL.Append(" Driver.ID,");
SQL.Append(" Driver.ReservationID,");
SQL.Append(" Driver.PrimaryContact,");
SQL.Append(" Driver.FirstName,");
SQL.Append(" Driver.LastName,");
SQL.Append(" Driver.Address1,");
SQL.Append(" Driver.Address2,");
SQL.Append(" Driver.City,");
SQL.Append(" Driver.State,");
SQL.Append(" Driver.Postal_Code,");
SQL.Append(" Driver.Ownership,");
SQL.Append(" Driver.HomePhone,");
SQL.Append(" Driver.CellPhone,");
SQL.Append(" Driver.AutoInsurance,");
SQL.Append(" Driver.Agent,");
SQL.Append(" Driver.Policy,");
SQL.Append(" Driver.Phone,");
SQL.Append(" Driver.Birthday,");
SQL.Append(" Driver.DriverLicNum,");
SQL.Append(" Driver.DriverLicState,");
SQL.Append(" Driver.DriverLicExpDt,");
SQL.Append(" Driver.DrivingRecord,");
SQL.Append(" Driver.DrivingRecordDetails,");
SQL.Append(" Driver.DriverNumber,");
SQL.Append(" Driver.IsDriver,");
SQL.Append(" Driver.InsertDt,");
SQL.Append(" Driver.ReservationID)");
// Insert Values
SQL.Append(" VALUES(");
SQL.Append(" @ReservationID,");
SQL.Append(" @PrimaryContact,");
SQL.Append(" @FirstName,");
SQL.Append(" @LastName,");
SQL.Append(" @Address1,");
SQL.Append(" @Address2,");
SQL.Append(" @City,");
SQL.Append(" @State,");
SQL.Append(" @Postal_Code,");
SQL.Append(" @Ownership,");
SQL.Append(" @HomePhone,");
SQL.Append(" @CellPhone,");
SQL.Append(" @AutoInsurance,");
SQL.Append(" @Agent,");
SQL.Append(" @Policy,");
SQL.Append(" @Phone,");
SQL.Append(" @Birthday,");
SQL.Append(" @DriverLicNum,");
SQL.Append(" @DriverLicState,");
SQL.Append(" @DriverLicExpDt,");
SQL.Append(" @DrivingRecord,");
SQL.Append(" @DrivingRecordDetails,");
SQL.Append(" @DriverNumber,");
SQL.Append(" @IsDriver,");
SQL.Append(" @InsertDt,");
SQL.Append(" @ReservationID)");
SQL.Append(" )");
// Define Connection
myConnection.ConnectionString = _ConnectionString;
// Build Command
myCommand.Connection = myConnection;
myCommand.CommandType = CommandType.Text;
myCommand.CommandText = SQL.ToString();
// Execute
myConnection.Open();
myAdapter.SelectCommand = myCommand;
myCommand.ExecuteNonQuery();
}
catch( Exception myException )
{
// Raise Error
throw new System.Exception("Exception occurred in: " + MODULE_NAME + ".GetListByRVType(). Exception Error: " + myException.Message, myException);
}
finally
{
// Clean up
myConnection.Close();
myCommand.Dispose();
myAdapter.Dispose();
}
}
#endregion
View 1 Replies
View Related
Dec 28, 2005
I want to update an MS Access table date field with a blank date. How do I go about it? Right now, if the "dateAskFor_Funds" text field is blank, and I try to update the "AskFor_Funds_Date" field in the database, I get an error. That is why I don't do anything.
What expression should I use in the place of
intJunk = 1
in the code caption below.
Private Sub cmdUpdateApplication_Click()
Dim todaysDate
Dim intJunk As Integer
Dim rst As ADODB.Recordset
todaysDate = Date ' MyDate contains the current system date.
Set rst = New ADODB.Recordset
rst.Open "EA_Apps_List", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
…
…
…
If IsNull(Me!dateAskFor_Funds) Or Me!dateAskFor_Funds = "" Then
intJunk = 1
Else
rst!AskFor_Funds_Date = Format(Me!dateAskFor_Funds, "Short Date")
End If
…
…
…
Set rst = Nothing
End Sub
View 1 Replies
View Related
Mar 23, 2005
I am currently using access 97.
I am trying to read from an excel file that has the same format but changes data every day due to reports that I run from a different program. I just export them to this excel file called test.xls
What I want to do is import this data from the excel file and insert it into existing data in my table. I need to this every day.
Currently I cannot get the data to append. I can only insert the data once and cannot get it to append. I tried using macros, but think it would be better to use VB.
Any help you could provide would be great.
Thank You
View 1 Replies
View Related
Apr 15, 2015
I like to store SQL code as a memo field in a table. I then use a form to collect selection criteria from the user, and this is used to create a 'WHERE' clause which is then appended to the stored SQL. This has always worked, but in one recent case the SQL failed. On examination I discovered that although the SQL is correctly stored in the memo field, when Access retrieves the code it inserts a space character in the middle of one of the words, thereby of course creating an invalid SQL string. It's easy to work around it, but why this happens? A bug in Access?
View 1 Replies
View Related
