|
|
hello all,
I need a help in VBA,
I have table in my MS access, with two fields, name and items
eg :
Name items
Ram | Book
Ram | Pen
Ram | Pencil
Raja | Book
I want to delete a particular rowfield from my table if the data repeats.
After deleting, i want the table to be like
Ram | Book
| Pen
| Pencil
Raj | Book
i dont want to repeat Ram
hope my doubt is clear
|
|
|
|
|
Actually u don't want display the ram repeatedly use SQL query Union, Union all, minus. or you can use condition and remove the name or same records.
|
|
|
|
|
Can i update 2nd and third ram with some particular value
|
|
|
|
|
Ya u can do it in 2 ways 1.permanently or 2.temp.
1. Update the database record using update statement.
2. use Condition statement replace value in front end.
|
|
|
|
|
You can use Update query i which u can set value.
Like :
Update table Set Name = "Demo" where Class = "null";
Regard
Anubhava Dimri
mailto: anubhava.prodata@gmail.com
|
|
|
|
|
Thanks friends...
but if i use the update command, all the three ram is replaced with some particular value. i want to retain first Ram just want replace second and third with some value or with blank space.
How to do these.
|
|
|
|
|
In where class use the more then one condition like
where name='Ram' and age=20;
like then that record only updated.
Ananda.
|
|
|
|
|
Sorry for disturbing.
My table name is General Issue table and the two fields are TestCaseName and TestScriptName. In TestCaseName column some testcases are same. i just want only one entry for particular test case.
The code i using is,
rs.Open "SELECT TestCaseName FROM [General Issue table]", oConnection
Do While (rs.EOF = False)
varTestCaseName_Repeat = rs.Fields(0).Value
rs.MoveNext
If (varTestCaseName_Repeat = rs.Fields(0)) Then
"here how to use update statement"
End If
Loop
|
|
|
|
|
Use this.
Dim Str As String
rs.Open "SELECT TestCaseName FROM [General Issue table]", oConnection
Do While (rs.EOF = False)
varTestCaseName_Repeat = rs.Fields(0).Value
rs.MoveNext
If (varTestCaseName_Repeat = rs.Fields(0)) Then
Str= "UPDATE TestCaseName SET name='" & value1 & "', age=" & value2 & " WHERE name='" & rs.Fields(0) & "' And age=" & rs.Fields(1) & ";"
rs.Open Str, oConnection
End If
Loop
Ananda
|
|
|
|
|
TO DELTE THAT RECORD WHAT U NEED DO IS TO SET UR DATABASE IN ORDER
NOT TO REPEAT A NAME.
FOR INSTANCE IF U ARE USING ADODC CONTROL
THE CODE WILL BE LIKE THESE
DIM RS AS NEW ADODB.RECORDSET
DIM CN AS NEW ADODB.CONNECTION
CN.CONNECTIONSTRING ="DATABASE PATH"
CN.OPEN
RS.OPEN "DELETE * FROM TABLENAME WHERE FIELDNAME='" & NAME & "'",CN
|
|
|
|
|
Hi
Help me.
- Use Visual Studio 2005
- As programming language, use C#
Merge SQLite data with HTML template. This action should be done using one 'Merge' button click.
Show merged document in webbrowser.
Save merged document to PDF.
- Merger
Replaces '##[fieldname]##' in the HTML template document with data from the corresponding
column of the SQLite table.
Create one new page in the document for each record in the SQLite table.
Thank you.
Regards,
Och-Erdene
|
|
|
|
|
Och-Erdene wrote: As programming language, use C#
So why are you also posting this in the VB forum?
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Because he's a lazy prat who wants his homework doing. He has posted it multiple times and multiple places.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Use a more descriptive subject line.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
i need to code a bot which auto post link to my forum.
what procedure should i use?
webclient?
also the bot should be coded to login the forum itself.
i had search google but i need is code as i just want to put a timer and auto post some generated content.
|
|
|
|
|
Sounds like a spam bot, so you shouldn't be getting any help.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Ditto to that.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
quit flame me.. i need it in my forum serious..
horaceloh
Administrator
ACT ACADEMY
帖数: 1015
Re: DAILY EOD (AFTER 9PM)
十一月 7, 2008, 7:37pm 引用 D20081107
回到顶部 D20081107.zip IP已被记录
Site Admin
Administrator
帖数: 1029
性别:
Re: DAILY EOD (AFTER 9PM)
回复 #1 - 十一月 11, 2008, 2:22pm 引用 D20081110
回到顶部 D20081110.zip
--------------------------------------------------------------------------------
~ Admin IP已被记录
Site Admin
Administrator
帖数: 1029
性别:
Re: DAILY EOD (AFTER 9PM)
回复 #2 - 十一月 11, 2008, 7:32pm 引用 D20081111
回到顶部 D20081111.zip
--------------------------------------------------------------------------------
~ Admin IP已被记录
horaceloh
Administrator
ACT ACADEMY
帖数: 1015
Re: DAILY EOD (AFTER 9PM)
回复 #3 - 十一月 12, 2008, 9:14pm 引用 D20081112
回到顶部 D20081112.zip IP已被记录
BL
Administrator
帖数: 10072
Re: DAILY EOD (AFTER 9PM)
回复 #4 - 十一月 14, 2008, 9:25am 引用 D20081113
回到顶部 D20081113.zip IP已被记录
horaceloh
Administrator
ACT ACADEMY
帖数: 1015
Re: DAILY EOD (AFTER 9PM)
回复 #5 - 十一月 14, 2008, 10:36pm 引用 D20081114
回到顶部 D20081114.zip IP已被记录
BL
Administrator
帖数: 10072
Re: DAILY EOD (AFTER 9PM)
回复 #6 - 十一月 17, 2008, 8:51pm 引用 D20081117
回到顶部 D20081117.zip IP已被记录
Site Admin
Administrator
帖数: 1029
性别:
Re: DAILY EOD (AFTER 9PM)
回复 #7 - 十一月 18, 2008, 9:14pm 引用 D20081118
回到顶部 D20081118.zip
--------------------------------------------------------------------------------
~ Admin IP已被记录
Site Admin
Administrator
帖数: 1029
性别:
Re: DAILY EOD (AFTER 9PM)
回复 #8 - 十一月 19, 2008, 7:45pm 引用 D20081119
回到顶部 D20081119.zip
--------------------------------------------------------------------------------
~ Admin IP已被记录
Site Admin
Administrator
帖数: 1029
性别:
Re: DAILY EOD (AFTER 9PM)
回复 #9 - 十一月 20, 2008, 8:11pm 引用 D20081120
回到顶部 D20081120.zip
--------------------------------------------------------------------------------
~ Admin IP已被记录
Site Admin
Administrator
帖数: 1029
性别:
Re: DAILY EOD (AFTER 9PM)
回复 #10 - 十一月 22, 2008, 7:27pm 引用 D20081121
i had to post those crap every day.. please help..
|
|
|
|
|
You're the one who created the very vague post about wanting to automate functionality in a bb - excuse us for being naive in that you were creating something beneficial to the world.
What the hell is your previous post about? Are there any details and explanations that you want to provide? Do you want to post any source so we can see what you're attempting to do, to better help?
No? Then you probably won't get any help esp. for the functionality you're asking for. Feel free to bash my score.
Cheers!
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
modified on Monday, November 24, 2008 10:35 AM
|
|
|
|
|
Well, I feel sorry for you but when you ask
syhs89 wrote: i need to code a bot which auto post link to my forum.
It suggests you want to log onto other people's forums and post a link to yours it does sound like a spam bot.
However, I expect the data will be held in a database so why not just add records to the database? It would be simpler and probably more secure.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
good idea.. let me check about my forum's mysql
|
|
|
|
|
i am sorry i dont have any source.. i just open a new vb.net project and dont know where to begin..
BTW, the mysql is far too complicated..
it contains some key(i dont know how to make it)
and the table for topic and post is different..
i scare i screw up the database.. lol
FYI, i need to do something like that..
http://wowps.org/forum/t2581-just_finished_making_ipb_post_bot.html[^]
but i need its code as i would need to set timer inverval like every 1 day
private sub somesub() handles timer1.tick
- get data from my pc
- login to forum
- post that attachment
end sub
i just dont understand what should i use.. webclient?
dont think so..
EDIT : sorry for my english.. i meant to get some link and post it AT my forum.. which means all posting will be on my forum..
modified on Monday, November 24, 2008 10:57 AM
|
|
|
|
|
First, a thanks for reading this and another if you decide to reply.
I basically am going to start a project that will take in a user-entered text in a text box and create from that an image for display on a LCD panel (pixel formatting)
Looking through VB specs, I come across the Graphics.DrawString method which "Draws the specified text string at the specified location with the specified Brush and Font objects" and will most likely employ CreateGraphics to put it up on screen for display preview. The formatting into the Pixel format will be done after confirmation and the end result is a string of bits to be sent to the LCD panel.
My question is to you, my great and intellegient friends, is : Am I approaching this in the best way or will I encounter some difficult problems and I should consider another approach now before I get too deeply entrenched in my path.
I wish to ask of all of your experience in this. I will try to answer any questions to my situation as afast as I can.
Thank you.
|
|
|
|
|
If you want to preivew the image on screen, then yes, you have to use DrawString to render the string to an Image (Bitmap) object so you can show it.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
