Type: Posts; User: morbid.ivan
Search took 0.01 seconds.
SELECT a.ID, a.Name, b.ID, b.Name, b.Relationship FROM tbl_Name AS a
INNER JOIN tbl_Dependents AS b ON b.ID=a.ID
1 |James Hinrich
2 |Larch Hamster
Is there anyone has cr90dbexwin_en.zip?
I can't download it from: ftp://ftp.crystaldecisions.com/outgoing/ehf/cr90dbexwin_en.zip
How do I Import more than 1GB database?
Is it possible to do this with work bench?
Is it possible on Lost Focus if no value, clear format or simply blank?
Example : Mask Format "##/##/####"
With Value : "01/01/2015"
Without Value : "//"
How do I remove this "//" if no date...
As I type I need to have a slash char on count of 2 and 5 which is already done.
Now, my problem is when I press backspace I was stuck on this...
Is it possible password will based on date?
can you please show some examples? im not knowledgable about AES Encryption
is it possible to have a random login password each day based on date and time?
for security reasons.
How to generate date range quarterly.
option 1 - 1st quarter
option 2 - 2nd quarter
option 3 - 3rd quarter
option 4 - 4rt quarter
I choose "option 4"
Public Sub heightLister(cbo As ComboBox)
Dim iWeight As Integer
Dim iCtr As Integer
Dim iLoop As Integer
For iLoop = 4 To 6
How do I sort this out?
is it possible to have a custom autoincrement number that resets every year?
Reference : Adodb
Database : MySql
How to get the auto increment number after adding new record?
Thanks in advance
I solve the problem guys, by re-installing wamp server and finally database shown up.
I am having a problem on WAMP Server (PHPmyAdmin) when I open it, no database on list but still accessible.
When I try to create new database I am getting error "Unknown database" but in ODBC test...
- > Current child-form State (Maximized) let's call this "Form #1",
trying to open another form which is in (Normal) state,
the "Form #1" resizes into "Normal State" and it should not...
How to avoid form resizing when opening another form?
Take a look at this :
Dim rpt_Sql As String
rpt_Sql = "SELECT * From SQL_MAIN " _
& "INNER JOIN SQL_RELATE ON SQL_MAIN.BATCH = SQL_RELATE.BATCH " _
& "Where SQL_MAIN.BATCH='1'"
Thank you... I will wait for your respond.
Result I got :
Query still giving me same message. Cannot found
INNER JOIN SQL_RELATE ON SQL_MAIN.BATCH = SQL_RELATE.BATCH
WHERE SQL_MAIN.BATCH =1
LIMIT 0 , 30
I generated this from MySql, but when I put this on VB6 same error...
Nope, I don't know how.
Can please tell me how to do it?
[QUOTE=digitalShaman;4753955]where does the error pop up? is it in this line:
rs_Report.Open rpt_Sql, conn
? then it has got nothing to do with crystal reports.
The report opens based on query...
Public Function konektodata(strServer As String, uName As String, uPass) As Boolean
On Error GoTo errHandle
MyOdbcOption = optFoundRows + optVB + optBigPacket +...
The table exist. Check this out...
I am having a problem Joining 2 tables in crystal report 9.
Always showing : Remove Table
The database table "sql_relate" cannot be found.
Dim rs_Report As ADODB.Recordset
(Text Type) Primary field
Dim rsGEN As ADODB.Recordset
Dim sqlCriteria As String
Dim cNum As Long
Set rsGEN = New ADODB.Recordset
rsGEN.CursorLocation = adUseClient
rsGEN.CursorType = adOpenStatic
Is my approach is right, having a Front-end every user?
Nothing happens, still slow.
But when I've try to put the program where the back-end database located, I can filter more than 1000 records
less than 3 seconds.
Maybe the link between Back-end...
I split my Ms Access DB to Front-end to Back-end.
Total records stored is more than 30 thousand.
my problem is, when im generating unique number took 10 seconds.
my code :
Dim i As Long
I have a single line formula in my database table.
Field name : salFormula
"= (value 1 + value 2) * 3 / 2"
"= (value 1 + value 2 + value 3) / 2"
"= (value 1 - value 2) * 2"
How to bind combobox to datagrid?
Aside on Autonumber I also have another field to hold series number.
Series -- Name
------- > Going to insert record here (I need this to become E-004)
I am looking for icon set for vbalExplorer or toolbar.
size : 16x16 and 32x32
Thanks in advance
Need help about MDI child form.
How to avoid the current form from sending back? Like in MS Excel, when you "Find and Replace"
the 'FIND form' still visible without sending back.
I get your point. Thanks for the help.
My code now is :
Private Sub cmd_Gen_Click()
Dim dDate As Date
dDate = DateAdd("d", -1, dtPck.Value)
Private Sub Form_Load()
Function dAdd(ByVal dFrom As Date)
Dim i As Integer
i = 0
For i = 1 To 15
dFrom = DateAdd("d", 1, dFrom)
Click Here to Expand Forum to Full Width