Adding Images- Strange Problem
Jun 26, 2005
Hello,
I am trying to add a normal JPEG or JPG image to an Access 2003 form through the "Image" control.
The problem is that when I browse for images , it does not show any JPEG or JPG images, but only BMP and images of other 3-4 formats - The JPEG format doesn't exist there. When I try to add a JPEG through "all-files" it gives me an error message - "does not support this format".
There is not problem viewing JPEG images on WinWord or other programs.
Has anyone heard of such a problem and its solution?
Thank you
Gabi
View Replies
ADVERTISEMENT
Jun 24, 2005
Hello,
I am trying to add a normal JPEG image to an Access 2003 form through the "Image" control.
The problem is that when I browse for images , it does not show any JPEG images, but only BMP and images of other 3-4 formats - The JPEG format doesn't exist there. When I try to add a JPEG through "all-files" it gives me an error message - "does not support this format".
There is not problem viewing JPEG images on WinWord or other programs.
Has anyone heard of such a problem and its solution?
Thank you
Gabi
View 2 Replies
View Related
Aug 31, 2005
My client wants a data entry application, but he wants the previously entered data to remain on the screen since he usually only wants to change a couple of the data fields. So, I created a form (.mdb) and add the record via vba code.
I have the autonum field turned on and have set the form parameters to:
edit = no
delete = no
additions = yes
Data Entry = yes
Now, say the next autonum should be 50. When I add a record, the autonum used is 51 and as I continue adding records, the autonum increases properly. However, when I close the form (via the X or via a close button) record number 50 is created with the exact data in the last record added.
I can filter this out with a distinct query, but I really don't want this data and so far I have been unable to stop this from happening.
Does anyone have any idea as to what is really going on here?
View 1 Replies
View Related
Jul 31, 2006
Hi there,
I got myself pretty much backed into a corner here. I am trying to add images to records. For example, in my database there will be certificates scanned and put on each specific record. I have been searching high and low and found that the OLE object tool will allow me to do this. However, the only method I've found was to right click right in the table and selecting add object. I'm trying to find a more userfriendly method. I was hoping someone can point me in the right direction.
Thanks in advance!
View 3 Replies
View Related
Sep 6, 2007
Hello
First let me apologize if I am being stupid, quite new to Access. I am trying to create a database with some pictures in it; I want to design a form that changes the image with each record, (Its for work they want a database of our employees info with a photo of each employee) reading though the help file it seams I need to add a bound image control, I have tried 2 different ways and am still getting the same problem, the first way I tried was to create a text field with the address off the photos (there are .jpg’s) and then add a bound image control on the form and link it to the field. Problem is this just displays the name of the file not the picture (e.g. as you go though the records it shows Mark.jpg, Simon,jpg, Louise.jpg….) I then tried to add a OLE field and add the files that way, if I click on add from file when creating the object I get the same problem just displays the file name, If I click create new bitmap image it works and displays the picture, the problem is the data base file then becomes huge (it was 45 meg with 2 photos, I need to add about 150 in total!. Am I being totaly dumb, is there a way of getting Access to display Jpg’s and ideally have them linked to instead of embedded to keep the size of the database down.
Sorry for rambling! (oh yeh and I am using Access 2003)
Thanks in advance!
Matt
View 2 Replies
View Related
Jun 26, 2006
Hi there,
I'm trying to add an image into a table. I know I can do it manually by creating an OLE Object and so forth. I am actually trying to get the user to enter in the path of the image and add it into the record/table.
Basically this is for a database that will hold a scanned image of a certificate associated with each person entered into the database. Anyone have any suggestions?
Thanks
View 2 Replies
View Related
Oct 15, 2014
I have to add 2 company logos and a phone graphic to a report.
I can only seem to add one logo and if i try to copy and paste a graphic it just displays the file path.
View 3 Replies
View Related
Sep 9, 2005
I have a table called 'students' with the appropriate fields. There is another table named parents_prof which contains records of common professions. The tables are related through the 'ID_parents_prof' of the 'parents_prof' table to two fields on the table 'students', thus 'students.father_prof' and 'students.mother_prof'.
1st question) Is that possible? Is it possible to create a relation between the key field of one table to two different fields of another table? Is it a good practice?
I did this because I want to build a query which checks for both fields together, meaning I want Access to return a record if the appropriate profession is in either field of mother's or father's profession.
SELECT students.surname, students.name, students.father_name, students.father_prof, students.mother_name, students.mother_prof
FROM parents_prof INNER JOIN students ON (parents_prof.ID_parents_prof = students.mother_prof) OR (parents_prof.ID_parents_prof = students.father_prof)
GROUP BY students.surname, students.name, students.father_prof, students.mother_prof, parents_prof.parents_prof
HAVING (((parents_prof.parents_prof) Like "*" & [enter profession] & "*"));
Access cannot represent the above graphical, so I had to enter the
OR (parents_prof.ID_parents_prof = students.father_prof)
in the SQL formula.
2nd question) Is the above proper query, according to the rules?
View 11 Replies
View Related
Apr 27, 2005
I have done some forms and it is the first time that i had this problem:
I can input data in several records without having any problem but when i close and save the form and next time i open it ,i do not find my previous records. I checked this in the tables and find that the values that i had input were there but in my form these values had disappeared. Can anyone explai this ..
Also,
Suppose i have 2 tables with NAME set as the primary key and which is linked 1-1. When i create a form for these 2 tables and when i write JO in the name field only once the name JO should automatically be inserted in the other name field i.e i should be able to input only one data. This is not the case. What i should do is : write JO then click in the other NAME field then type something e.g RO then this will be typed auto. in the other Field. Can you also explain this
View 2 Replies
View Related
May 27, 2005
I have a form with a tab control and each tab has a subform on it. 3 of these tabs/sub forms are continuous forms that allow the user to enter details for the selected job (i.e. on tab has a subform that allows the user to enter various scheduling dates for the job).
If I say have the scheduling tab selected and then change a field in the MAIN form, then click on the new record row in my continuous subform my main form jumps to the first record. However, if I update a field in the main form, select a different tab, then click on the new record row in my subform it works fine. Also, if I click the add record button it works fine as well.
I can't seem to find anything in my code that would cause the jump. Any ideas?
Thanks,
Hammy
View 3 Replies
View Related
Oct 4, 2005
I received a very strange error this morning.
I was going to create a new query with the simple query wizard, but as soon as selected a data source I got a message saying "The expression on Got Focus you entered as the event property setting produced the following error: The text you entered isn't an item in the list."
After this I can select a datasource, but the cursor remains in hourglass mode. It almost seems like this is a run-time error, when I am merely trying to create a new query. In addition to which, I haven't set any events to run on "got focus". Anyone have any ideas on what is causing this and how it can be fixed?
Thanks,
Chris
View 3 Replies
View Related
Nov 14, 2005
Hello,
I have a strange problem which have to be solved in Access in all way, if it is possible. :-) I have to create a table similar to an Excell sheet. Row headings are name of persons, column headings are workplaces. The aim of this table is to register worked hours at each workplaces per persons. At one person in one shift more workplaces are possible. The number of persons and workplaces is changeable. Does anyone know how could I solve that to store in different records each workhours? For example if a person works 4 hours at 1. workplace and then 4 hours at 2. workplace, this would mean only one row on the form, but two records in the table.
I would be very grateful if somebody would have a good idea! Many thanks in advance!
VoiD
View 1 Replies
View Related
Dec 28, 2006
I was working on the design of a form and had just made, what I thought, were some fairly minor changes. The specifics of which I can't recall. On saving the changes and attempting to go back to the form view I got a pop up window with the following header;
Microsoft Office Access has encountered a problem and needs to close. We are sorry for the inconvenience.
I can either send and error report or choose not to :rolleyes:
The up shot of all this is everything else in the DB seems to still work fine, but I can not open the effected form in either design or form view without Access shutting down :mad:
Has anyone seen anything similar? and if so any idea what may have cause this dummy spit? and Is there any way around this without deleting the effected form and rewriting it?
View 3 Replies
View Related
Mar 9, 2007
Hi to all,
Here is my problem:
I import value from an excel sheet and write them in a table, i use Excel object reading cells row by row. All works fine but after 1900 or 2000 rows program hangs without errors if i place a stop in program when my row counter reachs 1900 and run the program step by step that works, i tried to place a sleep command each 500 rows without better result. Does somebody have any idea ?
(i use Office 2000).
I can't use transferspreadsheet because for any reason in my excel table generated i have #Number! errors in some fields and i don't know how to skip these records.
Thanks in advance for help.
VINCENT
View 8 Replies
View Related
Mar 30, 2007
Hi All
I have just noticed some strange behaviour in access. I hava and asp page which gets two dates which are then used in a sql statement to refresh a page. The end of the statement deals with a between clause like this
WHERE tbl_Movements.date_of_Movement Between #12/03/2007# AND #30/03/2007#
But when I view this in design mode it changes it to
Between #03/12/2007# And #30/03/2007#
Why does it do this and what can I do to resolve it
Thanks
View 1 Replies
View Related
Jan 31, 2005
Hello To All,
Has anyone seen the message in the attached file? I got this when I was trying to update the row source on the field after I had a problem with data in a report coming up inaccurate. I've been developing in MS Access for about 7 years now and have never seen this. Any explination for this would be greatly appreciated.
I am using MS Access 2000 on a Windows 98SE machine. :eek:
- Charles Williams
View 1 Replies
View Related
Jun 23, 2005
Hi,
I have a query that in some cases it works and in others no. I've tried :confused: everything :confused:.
The problem is very strange: attached there is the database!
Anybody have any idea?
Thanks!
P.S.: :) forgive me but I don't write well the English!
View 2 Replies
View Related
Oct 29, 2005
It may be a simple problem I don't know. I have to do an inventory control database in Access for my Systems Design paper however I am having an issue with queries.
I have a query called Item Status Check and it asks the user for the item code and goes in a table called Inventory Item to get the results. Now the problem is after I added a whole lot of new items (I had some from testing earlier) it does not bring them up in the query at all, its ignoring them basically.
Now I find this strange because other queries like suppliers etc still work fine and access any new data I put in.
I know its going to be simple but its doing my head in.
EDIT: Found more.
The ISC query has the following field
ITemID
ITemName
SupplierID
CarryCost
RetaiPrice
StockMin
StockMax
StockOnHand <--- from a stock on hand query.
Now if I delete the stockonhand it shows all the stock so thats the problem. The way I have calculated stock on hand is to simply take all the purchase orders, add them together and subtract the customer/production order numbers. I don't know why this would happen
EDIT 2
found the problem, need the solution
In the StockOnHand calculation is takes all the number of incoming stock and subtracts the outgoing stock to get its answers. If the stock isn't on one of each of the incoming/outgoing forms it doesn't show it at all.
EG
Incoming Stock:
Purchase Orders
Add Stock (from an alter stock form for discrepencies)
Outgoing Stock:
Customer and Production Orders
Remove Stock (alter stock form)
If items have not been used on 1 of each of these they don't show up in queries with StockOnHand.
Thanks in advance
View 1 Replies
View Related
Dec 20, 2005
Hello all. Have a bit of a strange one here (and fairly frustarting). I have a table which includes a field (type memo) which holds text comments.
I have a query which includes this field. For some reason, when the comments field is empty (identified thorugh opening the table), when it is returned through the query is shows two characters, namely '@v'.
Can anyone shed any light on this for me? Thanks for reading :)
View 2 Replies
View Related
Apr 30, 2006
I have a select querey
which contains the expresion
forms!frm_itemslct!text8
It should just pick up the value contained within [Text8] which is a number, and it was doing that earlier this evening. I've since changed something and instead of a number it is now showing a small square :confused: For the life of me I can't work out what it is that is causing this.
View 3 Replies
View Related
May 16, 2006
Hi,
The Problem that im getting is that when I query select a yes/no field in a table the results return TRUE and FALSE, even when the criteria states Yes.
does anyone know whats going on with it.
I know it isnt me as I have had my collegues check it over and they are all confused as well.
any help will be great!
View 4 Replies
View Related
May 6, 2005
i have a form with some control on it. Among these controls, i have 2 unbound image control, which displays linked images.
Now i am noticing that with this particular form only, if i start click the next record arrow in the navigational pane very fast to move through the records, all of a sudden the whole access database will disappear abruptly leaving .ldb file open.
Any idea why this happens ? Do you think that those 2 unbound image controls has to do with it, because if i try hitting the next record button extremely fast in other forms, it simply scrolls through the records, without the closing the database abruptly.
Thanks!
View 2 Replies
View Related
Apr 27, 2005
Many will look at this and laugh but its real.
My Access Dbs are opened in hidden state and i dont see my forms.
This must be the cause.
I tried to hide the menubars using ghudsons code,i disabled the shift key. But i dont know what has happened.
I can nolonger view them. I have tried every method out and i think the only option is to repair OS, may be it will work.
I have enabled the database which i disabled the shift key but when i hold down the shift key, it loads but the forms are totally hidden, STRANGE! ijust see the grey access background and when i click on it twice from the task bar.It pops up.
I have tried to make another database, use the autoexec macro to call a form which enables all command bars, but this works only for this database and when i press the shift key down, this database hides the toolbars and i only see the grey access background. This is happening on EVERY DB ive developed on this machine. I thought it was the access that is totally corrupted but i tried to reinstall my office and i still get the same results
This is now a NIGHTMARE to me.
When db is shifted to another machine it works fine as before.
This is REAL but can i get some suggestions from you folks before i repair my OS.
View 1 Replies
View Related
Jul 10, 2005
I am trying to use the runsql command and I am encountering a strange problem.
The following works:
DoCmd.RunSQL ("INSERT INTO financial VALUES ('" & clientNumber & "', " & txtFinancial & ", '" & firstname & "', '" & surname & "', '" & txtDate & "', '" & txtTime & "', '" & editdate & "', '" & edittime & "', Null, Null, Null, '12', 'Bob', 10)")
But when I change the Null to a textbox with a null in it, it wont work:
DoCmd.RunSQL ("INSERT INTO financial VALUES ('" & clientNumber & "', " & txtFinancial & ", '" & firstname & "', '" & surname & "', '" & txtDate & "', '" & txtTime & "', '" & editdate & "', '" & edittime & "', '" & txtacc & "', Null, Null, '12', 'Bob', 10)")
The textbox txtacc has a null value in it.
This is frustrating me beyond belief. Please help.
Thank you in advance
View 1 Replies
View Related
Dec 12, 2005
When I recently opened a Db I had been working on I received the attached Msg.
The path to the Db is C:Database ProjectsAEMSWarranties and Sales.mdb
Once OK is pressed the Db works fine.
I created a new Db and imported all objects, but no change.
Any ideas?
Dave
View 3 Replies
View Related
Jun 26, 2006
I work in an environment with 7 computers networked to the same database. Until last week the database worked fine on all computers.
One computer was wiped clean and reinstalled with XP pro sp2 with all updates, office XP with all updates and also every other programs needed etc etc...
Now the database that every one uses will open up but will crash when the date filter is used in any form/report/query... This is the only computer this happens on and the error sometimes comes back with the following number 2147418113 but is intermittent. I dont think it is anything in the VB as it works totally on every other computer and worked fine on this one until reinstall of everything...
any thoughts anyone??...or has anyone ever heard of this??
View 4 Replies
View Related
