|
"The code is 42"... what is it?... I need a real source code which write by Visual Basic 6. hic... pls...
|
|
|
|
|
Is there a way to open a specific Access file using Excel Visual Basic. I have a PC that runs tasks 24/7/365 which moves files, creates new files using Microsoft Querry, send email reminders, but I cannot figure out how to open a specific Access file that contains an autoexec macro to handle all of the querry and reporting functions.
Any help would be greatly appreciated.
|
|
|
|
|
Found this link on MS Support, running a Access Macro from Excel, it uses DDE (Dynamic Data Exchange):
http://support.microsoft.com/default.aspx?scid=kb;en-us;131921
|
|
|
|
|
As my articles in datagrid has different status,so i want to differ them by different backcolor,that is i want a record displayed in datagrid changed its backcolor by its status.
Looking forward to your reply.
Thanks a lot!
|
|
|
|
|
You will have to do it in the ItemDataBound event. Every row that is created will fire this event before creating the actual row.
private grid_ItemDataBound(Byval sender as system.object, byval e as DataGridItemEventArgs) handles grid.ItemDataBound
If e.item.itemtype = ListItemType.Item or ListItemType.AlternatingItem then
'You can do this
dim r as TableCellCollection = e.item.Cells
r.item(0).BackColor = Color.Coral
'or
i = 0
e.item.cells(i).BackColor = Color.FireBrick
End if
end sub
Oops, I thought I was in the ASP.Net section. However, this still may be helpful.
Hope this helps,
Michael
I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious.
Vince Lombardi (1913-1970)
|
|
|
|
|
I have solved my problem by your hints.Perhaps I didn't express my problem very well. Anyhow,thanks a lot.
Following are my code:
Sub dgArticles_ItemDataBound(ByVal sender As Object, ByVal e As DataGridItemEventArgs)
Dim item As DataGridItem
For Each item In dgArticles.Items
'put your judge condition here
'assumed it return 1 and 2
Select Case CurrentStatus
Case "1"
item.BackColor = Color.Coral
Case "2"
item.BackColor = Color.Beige
Case Else
'do nothing
End Select
Next item
end sub
I hope I can get your help when i am in need on program.
May you happy!
|
|
|
|
|
Hi all,
I'm a masters student in psychology, have have a general grip on VB.net but I need to measure my participants' reaction time to high precision (i.e. accurate to the ms) and I need a bit of help. 
I've had it suggested that I use a timer control and make it count, but I'd much prefer to access the system clock more directly if possible. I'm currently using the vbtimer, and I also previously had it working with timegettime. Some general advice about the most precise way to do this, and what types or objects are involved would be brilliant.
Thanks!
|
|
|
|
|
The most accurate timer in the system is accessed by QueryPerformanceCounter and QueryPerformanceFrequency. You can refer to this[^] MSDN article on how to use it from VB.NET.
RageInTheMachine9532
|
|
|
|
|
i extract icons in size of 32 and display them in toolbars and pictureboxes but when saving ...problem
|
|
|
|
|
Hi
I want to save some icon that extracted from an exe file (using ExtractIconEx) but when I saved them the color of the saved is too less than original and in some cases the saved file is in gray
using imagelist couldn't repair it
who can help me?
|
|
|
|
|
Since you didn't include a code sample of what your doing, I have to ask:
Are you sure you pulling out ALL the icons? Apps store various sizes of the same image, including different color depths and grey scale versions.
RageInTheMachine9532
|
|
|
|
|
Can anyone suggest code to achieve postback of user input to the same html page (from a form)? Many thanks!
Signed,
A non-VB programmer !
Reed Eichner
reichner@satx.rr.com
|
|
|
|
|
There are three ways that you could achieve this (at least these are those methods that occur to me...):
1) Using Classic ASP, you set the post action of the form to the name of the same ASP page that generated the form.
2) Using ASP.NET, this happens by default.
3) Using JavaScript, handle the fields of the form in a JavaScript function that is called from the onClick of a button on the form.
There's one more possibility -- that I don't understand your question...
What a piece of work is man, how noble in reason, how infinite in faculties, in form and moving how express and admirable . . . and yet to me, what is this quintessence of dust? -- Hamlet, Act II, Scene ii.
|
|
|
|
|
Hai I am very new to VB.NET.I am retrieving the records from the Access Database and displaying it in a DataGrid using Data Form Wizard.I am retrieving only selected fields record.When I click on any of the row , I should get all its related field values in the text boxes which I designed mannually.I am confused whether to display the records in the data grid in this way or there is any other way.Also can any one please let me know how to get all the field values?
Thanks in Advance
I would really appreciate immediate reponse.
Anju
|
|
|
|
|
Hello, I am new to VBA (self taught) and I'm looking for a shortcut on writing an IF STATEMENT. I have an Excel spreadsheet that contains 3,070 rows of Bin Numbers. The report is similar to the below columns.
510250000 510250999
510251000 510251999
510252000 510252999
510253000 510253999
Soon I will receive a report on a daily basis, which will need to be bumped next to these bin numbers looking for a match.
I wrote the following IF STATEMENT
If strbin >= 510250000 and <= 510250999 _
or strbin >= 510251000 and <= 510251999 _
or strbin >= 510252000 and <= 510252999 _ then
Cells(irow, 1).Interior.ColorIndex = 34
As mentioned above, by the time I've completed the above statement I will have over 3,000 rows.
I would appreciate any feedback on a shortcut.
Thank you in advance for your help.
Fountain
|
|
|
|
|
Uhhh...Your IF statement doesn't have to be multiple ranges like that, because, so far, your range is 510250000 to 510252999, with no breaks between the ranges you listed!
What's the logic behind what you want to do? So far, all we've seen is that your coloring cells, but why? What determines what color the cell is going to be? And what is the problem that your having? Is it performance related?
RageInTheMachine9532
|
|
|
|
|
Hello fellow VB members :
I am student in college and learing VB , i have an old notebook that has only W98 and VB.
I have been reading about vb.net and wanted to seek your advise on how i can get access to VB.NET and check some of the codes that i have written for interactive forms tested out ....
like renting some space with a Internet provider and transfer these files across and check out....
|
|
|
|
|
Hai I am very new to VB.NET.I am retrieving the records from the Access Database and displaying it in a DataGrid using Data Form Wizard.I am retrieving only selected fields record.When I click on any of the row , I should get all its related field values in the text boxes which I designed mannually.I am confused whether to display the records in the data grid in this way or there is any other way.Also can any one please let me know how to get all the field values?
Thanks
Anju
|
|
|
|
|
Hello,
I have 2 very small vbs scripts that are fully tested and ready to go. Can someone convert them to an exe using vb.net for me please?
Joe
|
|
|
|
|
Well, there is no compiler for turning the script into an EXE. But you can encrypt the script using the Script Encoder Tool from Microsoft, found here[^].
RageInTheMachine9532
|
|
|
|
|
hello,
I gotta a question
if I insert an image to a rich text box
is there anyway to stop the ability to resize it?
|
|
|
|
|
Only if you set the Enabled property of the RichTextBox to False.
RageInTheMachine9532
|
|
|
|
|
Hi Guys,
I've got a problem while using APIs for printing text .
The problem: Every consecutive newline of text needs to
be printed with different fontsize and also some lines need
to printed in bold.
Well I have been using 'WritePrinter API'. (its one the APIs required for printing with WIN32 APIs);
Are there any APIs that manipulate the printers fontsize,fontbold ,etc output.
API wizards kindly help...
-SimSan
|
|
|
|
|
In between lines try
Printer.Font.** = ??
Printer.Font.** = **
or
Printer.FontBold = true
Printer.FontSize = 12
Note: even though members don't show up with Intellisense when you hit the period doesn't mean that they aren't there
hope this helps
If it's broken, I probably did it
bdiamond
|
|
|
|
|
Well I am printing a page directly
to the printer bypassing the driver.
WritePrinter is one of the APIs used
just to do that job.My collegue calls it
DOS printing; if that sounds familiar.
Printing with Printer object wouldnt
give a draft mode print....would it????
I came across SelectObject API ,but still
I dont get the required output.
-SimSan
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
