No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Hi experts, I'm using vba to do my coding. I have to check whether the data exists in the db or not. so I'd done this to check it. [code] Set rs = New ADODB.Recordset With rs .Open "pr_q", cn, adOpenKeyset, adLockOptimistic, adCmdTableDirect curr_year = Year(Date) q = 4 .MoveLast … |
|
Hi, i just want to ask why this error mean? InvalidOperationException was unhandled by user code The provider could not determine the String value. For example, the row was just created, the default for the String column was not available, and the consumer had not yet set a new String … |
|
i want to create a system that will trigger alert based on few condition, my condition is: the alert will trigger if there is a negative value for 2 consecutive years. example: 1)negative amount for 2005 2)negative amount for 2006 here is the code that i have for now and … |
|
anyone can help me to merge a data from potrait to landscape...or else dont hav any solution for this |
|
If there any solution on how to choose specific column..what is the code?? i'm using VB.Net [CODE] If e.Row.RowType = DataControlRowType.DataRow Then Dim CellValue As Decimal = Convert.ToDecimal(e.Row.Cells(4).Text) If CellValue < 5.0 Then e.Row.Cells(4).BackColor = Drawing.Color.Orange End If End If [/CODE] |
|
anyone can help me to separate a database horizontally instead of potrait. as example... BEFORE: Quarter 1=20 Quarter 2=10 Quarter 3=15 Quarter 4=35 AFTER: Q1 Q2 Q3 Q4 20 10 15 35 |
|
ello, just wanna ask if u all familiar on how to make a code using VB. Act I already call my database from access to appear on web based app, but to make it COLOUR on a specific box can not be done. Before this, I tried to make it … |
|
hi, may i know how to migrate excel file into access db, using macro @ vb? thank you |
|
i want to know the code to produce colour in a box of my DB thx |
|
hye, i have some problem regarding on how to make a specific box to be coloured. I just can find all to be coloured. N not the specific box i want..n else if u hav any link related pliz share...thx |
|
hello there, i just want to ask regarding on how to change a colour in a box in access VB Macro. by default sure will be in white, i want to build an alert to change it into a red box..or else any related link can i study more> |