|
If your going to use two databases like this and want to use the designers, you'll have to create a table link to the other database and treat it like an external data source. Only then will you be able to use the report designers to visually put the report together.
In Access, you haven't protected the data by putting it is a seperate file. All you've done is make it more difficult to write the code to use it.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Yes, import table is my final step that I used to solve the problem. But I don't want to do that. Wheter the table are link to the other mdb file but it seem that it store in the same file because any one can view its data. What i want to do is store the table and form, report in a difference file and link it together by using the code. Do you have any sugesstion? 
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
Yes. Access isn't designed to do that! It's a desktop database for simple database solutions. It wasn't designed to do what you want. If you want the data seperate from the presentation and business logic code, you're going to have to move it to either an MSDE or SQL Server solution.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi All,
I facing some problem in the write data to the database file. Basically, i want to write the data after i read it from text file(aa.txt), and then want to compare the databasr file with the orginal text file.
for example,
"comcode(0) = &H10
res = aa_i2c_read(aardvark, slave, 5, comcode(1), AA_I2C_NO_FLAGS)
s = Str(comcode(1)) + Str(comcode(2))"
I want the Str(comcode(1)) write to the database in low 1, and the Str(comcode(2)) in low 2 in the same database.
After finish write to the database, i want to compare the low by low with the original text file (aa.txt).
Anyone can give some exmple coding to solve this problem?
thanks.
|
|
|
|
|
hi there!i just want to ask if you can provide me or give me sample source code on how to select the datas from database to excel wherein the equivalent relaycode of relay monitoring data(relaycodes and their equivalent relay are in the database) will be put on the worksheet where the pivoted datas are. datas are already summed up using pivot table and in the sheet1(for example) of the worksheet.the problem s,how will i able to put the equivalent relaycodes in the sheet1 where the summed up datas are? please i really need your help..tnx
|
|
|
|
|
I try to debug, but to some extend, sometimes this error do occurs.
But sometimes it doesn't. I get this error, when i click on one of the graphs (which query the database), the result sets will repaint the graph and update itself. Any ideas why this happen ? Here's the error description..
AppName: msaccess.exe
AppVer: 11.0.5614.0
AppStamp:3f3c8e3c
ModName:owc10.dll
ModVer:10.0.5605.0
ModStamp:3f2eb3be
fDebug
Offset: 000efbd1
|
|
|
|
|
That's not an error. What you posted was a description of Access when it crashed. We need every word of the actual error message.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
That is the problem.
There isn't any actual error, which I find this very hard to debug.
Which is why I said, sometimes it crash and sometimes it doesn't.
Here's the behaviour from what I observed.
I basically retrieve data from the database, while retrieving, I Repaint the graph (Line chart). To my understanding, if the data takes longer to retrieve, it then have enough time to draw the graph as it moves along. But on some occasions, datasets are small, and it's done retrieving, but the front end doesn't have enough time to rePaint the chart. So any help I get is truly appreciated. I've been sleeping thinking about this day and night...
The program just crashed... 
|
|
|
|
|
Without seeing any code, it's going to be impossible to tell you want may be wrong.
How are you drawing the Graph? 3rd party control? MSGRAPH?
I haven't found any information in the MS KB articles about a problem like this in Access...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I'm using the OWC10.ChartSpace object to draw my charts.
It's being referenced to the OWC10.dll file.
|
|
|
|
|
Any code to go with that?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hello everyone,
I have been working on a Tic Tac Toe program off and on over the last few weeks. I am at a point where I need to add a save and load ability for high scores. I have no idea where to look to learn about saving your game or program - how to do it with a dialog or without a dialog box. If there is any documentation that could teach me how to program a save and load feature in my tic tac toe program - and other programs coming in the future - that would be awesome.
Thank you all! 
~Achithyn
Version of software: Visual Basic .NET 2003
|
|
|
|
|
oops, just to let everyone know, that was me :S lol - Must have cleared my cookies since the last time I was here. Thanks in advance for any help you may have!
~Achithyn
|
|
|
|
|
Here is the problem: i try to fire an event from an imageButton created dynamically. But the compiler won't let me do it.
It springs an error: 'Public Event Click(sender As Object, e As System.Web.UI.ImageClickEventArgs)' is an event, and cannot be called directly. Use a 'RaiseEvent' statement to raise an event.
I have seen it done in C#. Is there a VB.net solution? Simplified code below:
imports System
Imports System.Web.UI
Imports System.Web.UI.Webcontrols
public class domClss : Inherits System.Web.UI.Page
public myTable As System.Web.UI.WebControls.Table
sub Page_load(s as System.object, e as System.eventArgs) Handles mybase.load
if NOT page.isPostBack then
dim r as new TableRow()
dim c as new TableCell()
dim b as new System.Web.UI.WebControls.imageButton()
b.click = new System.Web.UI.ImageClickEventHandler(b_Click)
c.controls.add(b)
r.cells.add(c)
myTable.rows.add(r)
End if
End sub
Private void b_click(sender As System.Object, e As System.ImageClickEventArgs)
response.write ("button clicked")
end sub
End class
I certainly would appreciate some light on the problem.
Thanks in anticipation
Pyb
|
|
|
|
|
Changes to
Public myTable As New System.Web.UI.WebControls.Table
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If Not Page.IsPostBack Then
Dim r As New TableRow
Dim c As New TableCell
Dim b As New System.Web.UI.WebControls.ImageButton
AddHandler b.Click, AddressOf b_Click
c.Controls.Add(b)
r.Cells.Add(c)
myTable.Rows.Add(r)
End If
End Sub
Private Sub b_click(ByVal sender As System.Object, ByVal e As System.Web.UI.ImageClickEventArgs)
Response.Write("button clicked")
End Sub
Sanjay Sansanwal
www.sansanwal.com
|
|
|
|
|
Hi Sanjay,
That "addhandler ..." line made all the difference. After some tidying up, it all works like a charm. Great stuff, thanks for your help, you're a champ.
Obviously the way I saw it operate in C# is quite different. It seems that VB.Net is not the exact carbon copy of C# I thought it might be. By the way, which of these two languages would you say is the most useful?
Cheers,
Pyb
|
|
|
|
|
I am trying to use MATLAB for its graphing capabilities, and need to write a .MAT file using visual basic. How can i do this, or where can i find info to do this? thank you. this may be a very basic question, but i am an amatuer programmer, so any info will help.
|
|
|
|
|
murphypa wrote:
How can i do this, or where can i find info to do this?
You can google for MATLAB File Format[^]
The first entry in the search result looks like what you are looking for.
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
Not getting the response you want from a question asked in an online forum: How to Ask Questions the Smart Way!
|
|
|
|
|
I need to start an existing sql dts package to transform text data into a sql table. (I have no sql experience) The package is housed within sql server. I know the server name and package name. Can anyone help me with a .Net example? 
|
|
|
|
|
Try here.
How do you want to start your DTS Package today?
By Darren Green
http://www.databasejournal.com/features/mssql/article.php/1462561
|
|
|
|
|
I developed an application smart client to twirl in the net, when this application this twirling inside of my local net performace is excellent, however when I place it stops twirling using one link dedicated of 512kb the application is very slow in the client, have forms that they delay 40 seconds to be opened that they do not search given in the servers, or either use link not to search given to load in the screen.
You can help me?
|
|
|
|
|
Twirl????
What are you talking about? What does this app do?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi Dave, i am glad for your interesting.
The application was builded in VB .NET (smart client arquitecture) and i have some problems with performance when the client is running in remote locations (net bandwitdh 512kbs).
I already ready patterns and praticles and i thing that is very generics and i can not solve the problem.
However, if can help with some tick out trip i will very thankfully.
The problem consist in the net traffic (lazy response in fact). Exemple: one simple (a single form with a button, a textbox and one label) form take 30 seconds every time it is called.
Sorry about my bad english, i can explain again if necessary.
thanks a lot.
|
|
|
|
|
You haven't supplied any information as to what your form is doing. All I know is that your form takes 30 seconds to show up. Is this because your running your application from a remote location and downloading from the network somewhere? Is it because your code is doing somethin with the network? What is this app supposed to do?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Dave, this is my actually scennary:
I have a database and a components server in my local server. Internal clients can access this component server at 10 mb local network. In this case, the performance of my clients is excellent.
This is the problem scennary:
I have remote clients running this application and accessing this component server through a WAN at 512kb (ADSL) and the performance is very slow.
To try fix this problem a have builded a simple test application (File-New) and set a button, textbox and a label into this (nothing was codified) and try to execute this app in my remote clients, and the performance keep very slow.
The test app in most simple that is possible, running in a remote client.
I hope that you have understanding the problem.
tanxs
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
