Comments by ebie147 (Top 42 by date)

that identifier won't be seen by them but it will be stored in the database, really need a way to get this working

so basically 3 or more people will be capturing data in a database, and it should automatically give them a reference, this reference should consist of a DR+ autonumber

Hi will this help when working with database with 3 people working on it?

so how would i do this in Microsoft Access?

so for instance in table 2 i got the following
ID Number=12345
creditor1=test
Instalment1=123
creditor2= test1
instalment2=123

then i want those 2 instalments to add where the id number is 12345 in table 1 and insert it in table 1 where
total instalment=246

im using access 2010,
what i am trying to do is this
total Instalment(table1) = instalment amount(table2) where id Number =

note that instalment amount(table 2) consist of a lot of records
also the table has a relationship of one to many
so it should only add the instalment amount(table 2) where the id number matches the id number in table 1

what makes it hard is that it only needs to add the creditors installment for that id number of the person

i have played around but can't seem to come around to anything

OMG DUDE its working THANK You
what i did was add the [ ] by bank name and changed
cmd.Parameters.AddWithValue("IDNumber", txtvalueid.Tag)

to
cmd.Parameters.AddWithValue("IDNumber", txtvalueid.Text)

i have added the [ ] by bank names and now im getting this error:-
An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll

Additional information: Parameter ?_29 has no default value.

still getting syntax error with the ? and with their parameter name

sql.Append("[Account Holder Name] = ?, Bank Name= ?, ")
sql.Append("[Account Type] = ?, [Account Number] = ?,")
sql.Append("[Branch Code]=?,[Gross Salary]=?,")
sql.Append("[Nett Salary]=?,[Spouse Gross]=?,")
sql.Append("[Spouse Nett]=?,[Total Income]=?,")
sql.Append("[Funeral Cover]=?,[Medical Aid]=?,")
sql.Append("[Life Insurance]=?,[Groceries]=?,")

i changed the "?" with their parameter name, is this correct or should i leave them as "?"

still receiving syntax error
An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll

Additional information: Syntax error in UPDATE statement.

would sql work with oledb?

all columns are strings

yes some of them are empty but that shouldn't cause a syntax error? or am i wrong?

and this is what happens when i add the the [ ] around all the column names
An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll

Additional information: Syntax error (missing operator) in query expression '',[Bank Name]='',[Account Type]='',[Account Number]='',[Branch Code]='',[Gross Salary]='',[Nett Salary]='',[Spouse Gross]='',[Spouse Nett]='',[Total Income]='',[Funeral Cover]='',[Medical Aid]='',[Life Insurance]='',[Groceries]='',[Rent/Bond]='',[School f'.

An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll

Additional information: Syntax error (missing operator) in query expression '',Bank Name='',Account Type='',Account Number='',Branch Code='',Gross Salary='',Nett Salary='',Spouse Gross='',Spouse Nett='',Total Income='',Funeral Cover='',Medical Aid='',Life Insurance='',Groceries='',Rent/Bond='',School fees='',Transport='',Clothing='.

this is what comes up when i tried adding the [ ].

what do you mean by dump the command string? and no they all strings

here is the error i get:-

An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll

Additional information: Syntax error in UPDATE statement.

what you mean?

hi, whats your email maybe i can explain more in private?

heres an example of what the activation key gives me when i run the program
QkNBRUM1QkZDMkJBMDA1MDU2QzAwMDAxMDA1MDU2QzAwMDA4MDAwMDAwMDAwMDAwMDBFMA==

Okay thanks, or it would help me alot

so what you saying is that it gets a serial key from .Ini files , registry ,Private profile, and Mac Address(s)?

from a user desktop, but now i need to create a program that can give the user a serial from the activation server

I still dont understand what you mean, sorry i'm abit noob at coding still

can you explain in more simpler terms?

so what how would you go around creating an activation for this serial?

yeah i know it takse your macs address and converts it, but to what is it converting to?

lol if i would want to crack his system then how would i have gotten the source code?

doesnt make sense now hey

are you going to tell me or not?

he said i should figure it out...

Hi
the reason why i want it, is because me and a friend was busy with an activation project, he added the following activation and gave me a serial key with it, now I'd like to know how he got it, because i don't seem to get it(im still noob at programming) thats the reason why i need to know

Public Function base64Encode(ByVal sData As String) As String
Try
Dim encData_byte As Byte() = New Byte(sData.Length - 1) {}
encData_byte = System.Text.Encoding.UTF8.GetBytes(sData)
Dim encodedData As String = Convert.ToBase64String(encData_byte)
Return (encodedData)
Catch ex As Exception
Throw (New Exception("Error in base64Encode " & ex.Message))
End Try
End Function

Public Function base64Decode(ByVal sData As String) As String
Try
Dim encoder As New System.Text.UTF8Encoding()
Dim utf8Decode As System.Text.Decoder = encoder.GetDecoder()
Dim todecode_byte As Byte() = Convert.FromBase64String(sData)
Dim charCount As Integer = utf8Decode.GetCharCount(todecode_byte, 0, todecode_byte.Length)
Dim decoded_char As Char() = New Char(charCount - 1) {}
utf8Decode.GetChars(todecode_byte, 0, todecode_byte.Length, decoded_char, 0)
Dim result As String = New [String](decoded_char)
Return (result)
Catch ex As Exception
Throw (New Exception("Error in base64Decode " & ex.Message))
End Try
End Function

i hope that will help?

Public Function base64Encode(ByVal sData As String) As String
Try
Dim encData_byte As Byte() = New Byte(sData.Length - 1) {}
encData_byte = System.Text.Encoding.UTF8.GetBytes(sData)
Dim encodedData As String = Convert.ToBase64String(encData_byte)
Return (encodedData)
Catch ex As Exception
Throw (New Exception("Error in base64Encode " & ex.Message))
End Try
End Function

Public Function base64Decode(ByVal sData As String) As String
Try
Dim encoder As New System.Text.UTF8Encoding()
Dim utf8Decode As System.Text.Decoder = encoder.GetDecoder()
Dim todecode_byte As Byte() = Convert.FromBase64String(sData)
Dim charCount As Integer = utf8Decode.GetCharCount(todecode_byte, 0, todecode_byte.Length)
Dim decoded_char As Char() = New Char(charCount - 1) {}
utf8Decode.GetChars(todecode_byte, 0, todecode_byte.Length, decoded_char, 0)
Dim result As String = New [String](decoded_char)
Return (result)
Catch ex As Exception
Throw (New Exception("Error in base64Decode " & ex.Message))
End Try
End Function