|
Hai,
please help us in getting records from access database table to Excel sheet using Excel VBA programming.we have data in access database table and that data should be displayed in excel sheet(i.e., result page).Please help us in this query, we are new to VBA programming
|
|
|
|
|
Does it have to be VBA programming? You can't just use the built in excel stuff to pull it through the user interface?
|
|
|
|
|
Thanks for your quick response.
yes it has to be done in VBA programming.
We already written code, for storing data from excel sheet to Access database.But our final requirement is to get data from access database and display it in Excel sheet(i.e., result page).
Please do the needful, as soon as possible.
|
|
|
|
|
Try turning the code upside down....
Brad
Australian
- unknown PHP Developer on "Job Prospect"
Requirement: * Experience working with XML, XSL, XPath
Comment: and other things starting with X.
|
|
|
|
|
HI ALL,
CAN ANY ONE TELL ME WAT R THE WAYS TO CONVERT AN HTML PAGE INTO .ASPX PAGE.
LET ME EXPALIN IN DETAIL....
OUR WEBDESINGNER HAS DESIGNED A PAGE,HE HAS SLICED THE PAGE AND GAVE ME IT IN HTML FORMAT...
NOW I WANT TO CONVERT THAT PAGE INTO .ASPX PAGE .PLS TELL ME WAT R THE EASY WAYS TO CONVERT THEM INTO DOTNET PAGES...SO THAT THE ALIGNMENT DOESNOT CHANGE.AND FIT INTO ANY MONITER...
ITS VERY URGENT..PLS GIVE ARTICLES AND SUGGESTIONS...
THANKS IN ADVANCE.
BINO VARGHESE.V
|
|
|
|
|
Copy the HTML and paste it into the aspx page replacing the existing HTML tags. Be sure to keep the page declaration at the top and add an <asp:form> tag before you use any controls.
|
|
|
|
|
IS YOUR KEYBOARD STUCK ON CAPS LOCK?
Brad
Australian
- bryce on "Problems with Code Project"
*sigh* Maunder's been coding again...
|
|
|
|
|
IS YOUR KEYBOARD STUCK ON CAPS LOCK?
No just to get u ppls attention
|
|
|
|
|
BINO VARGHESE wrote: No just to get u ppls attention
Yes, that worked.
It also had the effect that I didn't read your post at all.
But, yes, you got my attention. Did that help?
---
single minded; short sighted; long gone;
|
|
|
|
|
How do I detect whether or not javascript is active via the use of the code behind.
Le Roux Viljoen
Web Developer
PCW New Media
South African Branch
www.pcwnewmedia.com
|
|
|
|
|
The code behind runs on the server so you'll probably find it difficult (read: impossible) to detect client-side capabilities.
|
|
|
|
|
The only way to detect if Javascript is available is by using Javascript.
Add a Javascript to the page that does something, for example navigate to a different page. If that doesn't happen, then Javascript is not available.
---
single minded; short sighted; long gone;
|
|
|
|
|
system.web.httprequest.browser[^]
There is an Javascript property which tells you whether the Requestor's browser is Javascript compatible.
Not sure how accurate it is tho.
|
|
|
|
|
That value is based on the user agent string that the browser sends, and it only reflects if the browser is capable of Javascript, not if it's actually enabled.
---
single minded; short sighted; long gone;
|
|
|
|
|
...would it be correct to assume that there is also a PHP forum somewhere in CP? If so can anyone pls direct me to the correct url.;)
Aim small, miss small
|
|
|
|
|
tatchung wrote: Since there is a hidden java forum in CP...
really !! show the url
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
Got it![^] I stumbled upon it last week...pity i was too timid that day to bookmark the url .
Aim small, miss small
|
|
|
|
|
iam sure if you do dome search on the forumid parameter
you will find someting Interesting just like this:
here^
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
I have made camp here for PHP questions (it is an ongoing battle).
Brad
Australian
- Bradml on "The ADOTD"
Hey all, did you just use/read an acronym? Pots it HERE, at the ADOTD[^]
|
|
|
|
|
Hi Guys I am trying to generate a random footnote everytime a page inside my site is loaded.
Trouble is my randomiser keeps staying with one index basically not doing anything
Please help!!!!
Heres my code for my Footnote:
private void SetFootnote()
{
try
{
SqlConnection conn = new SqlConnection(SqlDataSource1.ConnectionString.ToString());
conn.Open();
//Get the row and read into dataset
string query = "Select * From Footers;";
SqlDataAdapter adapter = new SqlDataAdapter(query, conn);
DataSet data = new DataSet();
adapter.Fill(data, "Footers");
conn.Close();
//Get a Random footnote and set
Random ran = new Random(0);
int rowIndex = ran.Next(data.Tables[0].Rows.Count - 1);
string footer = data.Tables[0].Rows[rowIndex][0].ToString();
FootNote.InnerHtml = footer;
//Close Connection
}
catch (Exception)
{
}
}
Le Roux Viljoen
Web Developer
PCW New Media
South African Branch
www.pcwnewmedia.com
|
|
|
|
|
Chona1171 wrote: Random ran = new Random(0);
You are creating a new Random object and feeds it the same random seed every time, so it will produce the same number sequence every time. Just don't supply any seed at all, and it will create a seed from the system timer.
Random ran = new Random();
---
single minded; short sighted; long gone;
|
|
|
|
|
Or to generate a truly uniuque number I can use the following random declaration
System.Random objRandom = new System.Random((int)System.DateTime.Now.Ticks % System.Int32.MaxValue);
Thank you
Le Roux Viljoen
Web Developer
PCW New Media
South African Branch
www.pcwnewmedia.com
|
|
|
|
|
You don't need a more unique value than the system timer that the parameterless constructor uses.
If you need better randomness than the Random class offers, use the random generator in the System.Security.Cryptography namespace.
---
single minded; short sighted; long gone;
|
|
|
|
|
hi guys,
i have a problem. I have two gridviewss say A and B. gridview A has many records. on selecting a particular record, tht record shud be moved in the gridview B. in this way gridview B has all records selected from A.How am i suppposed to do so. Need ur help.
Thnx in advance.
|
|
|
|
|
I just tried to look what's ASP.net & web development. Damn I created virtual directory for the project in IIS and everything's fine but when I try to create a new project it throws webserver reported the following error when attempting to create or open the web project located at the following URL:http://localhost/MYPROJ'. HTTP/1.1 500 Server Error'.
What I tried in .net command prompt :
1. ASPNET_REGIIS -i
2. iisreset
3. aspnet_regiis -s w3svc/1/root/myproj. [edit]
Nothing worked.
I have framework 2.0 installed , but I'm trying with VS2003. Any problem with that?
-- modified at 10:39 Sunday 15th April, 2007
Press: 1500 to 2,200 messages in just 6 days? How's that possible sir?
Dr.Brad :Well,I just replied to everything Graus did and then argued with Negus for a bit.
|
|
|
|