Question about Operating Systems

1 Answer

How to print picture wiht crystal report 8.5 using ms access ?

I store link picture file name in ms access database field, Now i want to print pricture with crystal report 8.5 use picture-link stored in ms access database, picture images are stored in seperate folder, How can i get the pictures with crystral report 8.5 ?

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

I am not sure if I understand your question correctly but here goes..

if you want to click on a link within crystal report and them show the picture you can use OLE..
in the tools menu click on OLE, select "Create From File" ,
select the object type eg: MS bitmap.
Select Link
Browse to folder where the image exists. and select it
you can now select a Icon or leave as is and it will display the image name..
Clikc OK

now when you run CR if you click on that link it will open and display the image..

if you just want to add a Image to CR
in the Tools Meni select Insert, Picture browse to the folder where the image is stored and select it then click OK and it will be displayed

I hope this helps



Posted on Jan 18, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

4 Answers

How to convert 2007 excel sheet into 2003 excel sheet


if you have excel 2007 you can save the file into excel 2003 compatibility

if you have excel 2003 need download compatibility pack from this page
http://www.microsoft.com/downloads/en/details.aspx?familyid=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en
install it and success!

Feb 22, 2011 | Operating Systems

1 Answer

Different between MS EXCEL & ACCESS


Hi. MS Excel is for spreadsheet. Very useful when creating accounting documents. MS Access is for database. Very useful when collecting data.

Please visit these links to learn more about the 2 applications:
http://www.blurtit.com/q373300.html

http://office.microsoft.com/en-us/access-help/using-access-or-excel-to-manage-your-data-HA001042918.aspx

http://www.thetechfaq.com/2010/03/14/microsoftaccess-and-excel-comparison/

Sep 03, 2010 | Microsoft Windows XP Media Center Edition...

1 Answer

Quicken will not print. Program aborts after error message: Problems communicating to printer: "Dell Photo Printer 944" The specified resource name cannot be found in the image file.


Hi,

Ensure that your printer is online and all cables are securely attached.

(i) If your printer is on a network, ensure that your network allows you permission to access the printer.

(ii) If you are printing to paper, ensure that the Quicken PDF Printer is not selected.
(iii) If you have more than one printer:

(iv) Ensure that you have selected the correct printer in Quicken. (Select the QuickenFile menu, select Printer Setup, and select the item you want to print. Be sure the correct printer shown in the Printer field. For example, if you are printing a report, select File > Printer Setup > For Reports/Graphs.)

(v)Try making another printer the default printer.
Microsoft Windows Vista:
Click the Microsoft Windows Vista logo (Start button) and select Control Panel.
Under Hardware and Sound, click Printer.

Select the printer and click the Set as default command button.

Microsoft Windows XP:

Click the Microsoft Windows Start button and select Printers and Faxes.

Right-click a printer and select Set as Default Printer.

(vi) Try printing from WordPad or Notepad to be sure Windows is communicating with your printer.

Click the Microsoft Windows Start button, select All Programs or Programs, select Accessories and select WordPad or Notepad.
Enter some text. Select the File menu and select Print.

(vii) If your file does print from WordPad or Notepad, try reinstalling the printer or printer driver.
(viii) If your file does not print from WordPad or Notepad, it probably means that Windows is not communicating with the printer. Check your Windows printer settings.
Thanks for using Fixya.
Good Luck and have a nice day.

May 25, 2010 | Operating Systems

2 Answers

Task filter


Following are a handful things u have to know about VB file handling

for more details...go to http://www.5starsupport.com/info/vb.htm

File Handling (Generic)

While VB is working on a better approach (FileSystemObject), the built-in file handling statements are still the only way to access data other than through the VB database capabilities. Your skills in this area can make or break your ability to work with various formats. The OPEN/CLOSE statements are critical to success, but the LOF, EOF, and LEN functions are used even more often! It's also a given that you'll use the DIR function regularly.
Dir - Returns a filename that matches a pattern
temp$ = Dir ("*.*")
CurDir - Returns the current directory
temp$ = CurDir
MkDir - Creates a directory
mkdir ( "newdirectoryname" )
ChDir - Changes the current directory to a new location
chdir ( "newdirectoryname" )
ChDrive - Changes the current drive
ChDirve "A"
RmDir - Removes the indicated directory
rmdir ( "directoryname" )
Freefile - Returns an unused file handle
i = freefile
Open - Opens a file for access, locking it from other applications
open "filename" for input as #1
Close - Closes a file so that other applications may access it
close #1
LOF - Returns the length of a file in bytes
i = lof ( #1 )
EOF - Returns a boolean value to indicate if the end of a file has been reached
statusvariable = eof ( #1 )
Name As - Renames a file
name "filename1" as "filename2"
Kill - Deletes a file
kill "filename"
Fileattr - Returns attribute information about a file
i = int ( tempvariable )
GetAttr - Returns attributes of a file or directory
i = GetAttr("c:\windows\temp")
SetAttr - Sets the attributes of a file
SetAttr pathname, vbHidden
Reset - Closes all disk files opened by the OPEN statement
Reset
FileDateTime - Returns data file was created or last edited
FileDateTime ( filename )
FileLen - Returns length of file in bytes
FileLen ( filename )
FileCopy - Copies a file to a new name
FileCopy sourcefile, destinationfile
Lock - Controls access to a part or all of a file opened by OPEN
Lock #1
UnLock - Restores access to a part or all of a file opended by OPEN
UnLock #1
Width # - Set the output line width used by the OPEN statement
Width #2, 80
File Handling - ASCII-specific

While VB is working on a better approach (FileSystemObject), the built-in file handling statements are still the only way to access data outside of a data base. Your skills in this area can make or break your ability to work with various formats. The OPEN/CLOSE statements are critical to success, but the LOF, EOF, and LEN functions are necessary to build useful code.
Line Input - Reads an entire line of ASCII text
line input #1, tempvariable$
Write - Puts data in a file, with separators for the data
write #1, tempvariable$
Print - Puts data in a file with no separators
print #1, tempvariable$
Spc - Used in a print statement to move a number of spaces
Print #2, var1; spc(15); var2
Tab - Used in a print statement to move to TAB locations
Print #2, var1; Tab(20); var2
File Handling - Binary-specific

VB also support features which allow you to access a file on a byte-by-byte basis. The good thing about it is that you have more control, the bad thing is that you may have to write more code. Generally, a programmer will use the option (ASCII or Binary access) according to the least code he has to write. For binary access the Get/Put are equivalent to the Line Input and Print functions used in ASCII text file access. The big difference between the two is that binary access will read (Get) an exact number of bytes of data, and the reading can start at any byte within the file.
Get - Reads data from a file
get #1, anyvariable
Put - Puts data into a file
put #1, anyvariable
Seek - Moves the current pointer to a defined location in a file
seek #1, 26
Input
input #1, anyvariable
Loc - Returns current position with an open file
i = Loc(#2)

Sep 14, 2009 | Microsoft Windows XP Professional With...

1 Answer

How to create crystal report in asp.net with vb script code


You can open the Crystal Report (should be installed with Visual Studio first) after you designed your database, then you have to connect the Crystal Report to the right database (the one which you store financial information in your case), then you can create your report easily by putting the desired variables and designs. Then you have to call for that report with a code within visual basic.

Apr 15, 2009 | Operating Systems

1 Answer

How to connect vb with ms access


se Adodc OR Even better.. ADODB. for this you need to get MDAC fromMicrosoft free download.(check under project_References- Microsoft DataActiveX objects.. the current no is 2.8. if it is not there download invb directory.

next, you can learn about creating a DSN from control panel, ODBC. onceyou learn this, connection becomes a piece of cake. get some free vbtutoriasl from WWW.

then

you need to use DAO or ADO to connect to the database. better study both but since ADO is current, i am showing that code.
under Menu Project_References, put a check mark on Microsoft ActiveXData Objects latest version (though it works for all, currently 2.8with sp pack 1 ).

at the general declarations:
dim conn as adodb.connection, rec as adodb.recordset, esql as string,esql1 as string
Private Function connect()
Set rec = New ADODB.Recordset
Set conn = New ADODB.Connection
esql = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "D:VBDesigndhana2.mdb" & ";Persist Security Info=False"
'here you put the correct path of your mdb file. and check if you have jet 4.0

conn.Open (esql), , , 0
End Function

private sub form_Load()
connect
end sub
and for adding records:
say let us say you have 3 fields. then have 3 textboxes and 1 command button on the form.

private command1_click()
esql1="select * from Yourtablename"
rec.open(esql1),conn,, adOpenDynamic, adLockOptimistic
rec.AddNew
rec.Fields(0) = text1.Text
rec.Fields(1) = Text2.text
rec.Fields(2) = text3.text
' you need to check if in your access table design you have Allowed Zero length .. set it to Yes for all text fields.
rec.update
if not rec.eof then rec.movenext
rec.close
conn.close
set conn to nothing
end sub

this will add new records to access table from VB.
' for picture store the full path of the path and the picture file nameint the text field. and in the picturebox of VB form for viewingrecords again you need ADO or ADODC and here you code:picture1.picture=Loadpicture(rec.fields(3) ' depending on where thepicture field is located. you need to make a few trials.
under Menu Project_References, put a check mark on Microsoft ActiveXData Objects latest version (though it works for all, currently 2.8with sp pack 1 ).

at the general declarations:
dim conn as adodb.connection, rec as adodb.recordset, esql as string,esql1 as string

Private Function connect()
Set rec = New ADODB.Recordset
Set conn = New ADODB.Connection
esql = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "D:VBDesigndhana2.mdb" & ";Persist Security Info=False"
'here you put the correct path of your mdb file. and check if you have jet 4.0

conn.Open (esql), , , 0
End Function

private sub form_Load()
connect
end sub

and for accessing records:

private command1_click()
esql1="select * from Yourtablename where id =" & val(text1) ' for integers

esql1="select * from Yourtablename where name=" & "'" & text1 & "'" ' for string

rec.open(esql1),conn, adOpenstatic, adLockreadonly

label1.caption =rec.Fields(0)
label2.caption= rec.Fields(1)
label3.caption= rec.Fields(2)
' you need to check if in your access table design you have Allowed Zero length .. set it to Yes for all text fields.

rec.close
conn.close
set conn to nothing
end sub


' similarly there are routines to ADD, Delete, Edit, View etc.

Feb 26, 2009 | Operating Systems

1 Answer

Final yr project


Nice project you can easy solve this problem first you want to known how to connect the java with sql or some other database. http://www.academictutorials.com/ this is the site this help you for your project. If you have any problem just contact me i will clear it.

Feb 17, 2008 | Operating Systems

1 Answer

How could i create the reports in vb.net step wise from dataset? acutually i want to prepeare the reporting for printing and also please guide me how to take the data abck on the other partation from my...


usually if you are using vb.net to make a application, it must included the crystal report component. you can use that component to create a customized reports. after you search the component but you cannot find it, maybe you need the crystal report application to create. Trying to find a crystal report application and install into your pc. you must be able to create a report after you installed this program.

Feb 16, 2008 | Operating Systems

1 Answer

Windows Explorer Details View problems.


Usually, the view is determined by the type of files within the folder. For example, when you are in the My Music folder, the Details view gives you columns like "Artist" and "Album", etc, whereas the My Documents folder has the more generic "Name", "Size", etc.

However, if you right click upon any column header (that's where it says "Name" or whatever), a menu comes up that allows you to choose which columns are displayed. And once you change a particular folder to display, THAT folder will then display those columns until you remove them. But any other folder will default to back to the standard settings unless you manually change it yourself.

Feb 01, 2008 | Microsoft Windows XP Professional for PC

1 Answer

Ms access


Microsoft access is a database application that is part of Microsoft Office. It lets you edit .MDB database files. Installing Access also installs the drivers that allow other applications which use the MS Access database format to also open their databases as well.

Not sure what your question means. If you want more information please ask me before rating the solution.

Jan 31, 2008 | Microsoft Windows XP Professional With...

Not finding what you are looking for?
Operating Systems Logo

Related Topics:

550 people viewed this question

Ask a Question

Usually answered in minutes!

Top Operating Systems Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18297 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Prashant  Sharma
Prashant Sharma

Level 3 Expert

1127 Answers

Are you an Operating System Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...