hi,
i work with ms. access 2003
i want to display image from a folder to the report.
i have read thread in http://bytes.com/topic/access/answer...access-reports
but that's for access 2000
i want to set my image picture property, but there is no picture property when i type "image.p " -> no picture property.
so how can i display my image in the...
dbdb
Last Activity: Mar 31 '11, 01:34 AM
Joined: Feb 12 '09
Location: Jakarta - Indonesia
-
display image in access report
-
mmm finnaly....
sorry guys, sometimes we never realize a small miss perception we get.
yes i found the recordsource.
yesterday i always getting confused to find where is the record source in the report properties.
but then today, i realize that the recourdsource is place in the chart properties.
OMG...
sorry for this litlle mistake.
then i can view my chart based on the data that... -
mm so do i confused when i found no record source on it.
here is the story.
first, i run the report wizard then i choosed to build a chart based on a query.
then the wizard done, and my chart shown on the monitor.
then i want to view the report only the data that i want, but i don't want to use any criteria expression on my query, i want to apply filter on my report chart.Leave a comment:
-
my chart is on the report.
i build it using chart wizrd in the report.
there are no code.Leave a comment:
-
Apply filter on Chart
Hi,
i create a chart in ms access based on my query, then i want my chart when is it open is only show value based on my criteria.
i'll try to used it in the properties apply filter using the expression, it didn't work. the chart still viewing all data.
and i used the event "on open" and used "applyfilte r" command
then it shown an error.
"that the report isn't... -
the error msg is like this :
...Code:Exception Details: System.IndexOutOfRangeException: no Source Error: Line 49: <tr> Line 50: <td width=30%><b><font face=Tahoma size=2>Letter No </font></b></td> Line 51: <td><font face=Tahoma size=2><%#Container.DataItem("no")%></td></tr> Line 52:Leave a comment:
-
here is the code.
...Code:Sub Page_Load (Source As Object, E as EventArgs) Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("surat.mdb") & ";" Dim MySQL As String = "SELECT no, nosurat, tglsurat, kategori, tujuan, perihal, deskripsi FROM surat" Dim MyConn as New OleDBConnection (strConn) Dim Cmd as New OleDBCommandLeave a comment:
-
i don't know it could be run well or not. why don't you try just like i did.
i add the braket among the date field. like this :
wish it could be help.Code:insert into Intranet.classifieds_adverts (Title, [Expiry_date], Description, Added_by, Email_address) values (@Title, @Expiry_date, @Description, @Added_by, @Email_address)
coz my problem solve by that.Leave a comment:
-
Get number data from ms access
hi guys,
i tried to get some data from my access db. i used repeater to get the data, but i got a problem when i tried to get the data with number type in ms access.
it shown an error.
is there another way to get the data ?
thank you. -
thank you guys, i already found the way to run my query,
here is the code, hope it could inspired somebody who just learn Asp.Net like me.
...Code:Dim no As Integer Dim nosurat, kategori, tujuan, hal, deskripsi As String Dim tgl As Date Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("surat.mdb") & ";"Leave a comment:
-
well thank you for the advice.
i have a few data with different data type. i tried to stored the data into parameters. but still it didn't work.
...Code:Sub OnBtnSendClicked(ByVal s As Object, ByVal e As EventArgs) Dim no As Integer Dim nosurat, kategori, tujuan, hal, deskripsi As String Dim tgl As Date Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Leave a comment:
-
error insert into
hi guys,
i just new in asp.net world.
i have an error for my first web test.
here my code :
...Code:sub OnBtnSendClicked (s As Object, e As EventArgs) Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("surat.mdb") & ";" Dim MySQL As String = "INSERT INTO surat (No, NoSurat, TglSurat, kategori, Tujuan, -
Yes, I think so.
Thank you guys...Leave a comment:
-
Thank you, I've already found that file, and deleted it, and the database is back to usual. Was this okay to do ? So far so good with no problems; I can even use my database password.Leave a comment:
-
Ms Access security
Hi guys need a help please
I just tried to apply a security level to my access database. I never used it before. and actually it's applied to all my database.
I want to remove all the security and I don't want to use it anymore, but I made a mistake by removing the admin member from my admin users, and this has made my admin user just a regular users, and I can't clear my database from this security.
How can... -
ok thank you.
it worksLeave a comment:
-
viewing query subform based on text box value
Hai, need a help please.
i have a form to view the query subform
1. form name : form1
2. query subform name : subform1
3. textbox name : txtclass1
4. command button name : cmd1
i want to view my query based on the value in the textbox.
the field in my query are : noreg, class, M2A, M2E, M2M
if user insert the value "M2A0901" in the textbox then
...Code:"Select
-
yes....that's what i mean
thank you.it worksLeave a comment:
-
apply filter for date variable
hi guys
need your suggestion
how can i apply filter for my date variable data type
i have a form name transaction
and i have a text box on it named : start and finish
i need to apply filter my data using that 2 data.
i have to view data for the transaction date between start and finish date.
i used the command button to proceed it filter.
can u help me... -
thank you guys...
it works.Leave a comment:
No activity results to display
Leave a comment: