sorry, but how do I implement that in my script. I am lost, I am not really a VB professional... :-)
thanks...
alive84
Last Activity: Sep 5 '07, 10:11 AM
Joined: Jul 30 '07
Location:
-
Thanks for the ideas so far.
To Killer42:
No, there are also some, who have a Doctor as Title.
To Veena:
Thanks, I will try to use your input, but I am not really getting it why you are using SQL?
Thanks for the inputs.
Regards,...Leave a comment:
-
Splitting Text
Hi There,
I have written a little script that should splitt FirstName, Mr.Ms.Miss and LastName. However, the raw data I received with which I will have to use my VB script, is a bit more complicated, and I can't solve that challenge yet. I need some tips from experts. :-)
[code=vb]
'Uses the Excel VBA split function
Sub MyExcelSplitCel ls()
Dim TempArray As Variant
Dim rwIndex, colIndex... -
Oooo my god, I didn't know that SQL has this logic too, gosh...I am sorry, but that's now also something I will never ever forget. Thanks, its now working superb....Leave a comment:
-
[code=SQL]
SELECT tblContacts.Fir stName, tblContacts.Las tName, tblCostCenter.C ostCenter, tblCostCenter.O rgUnit, tblCostCenter.R egion, tblWorkstream.W orkstream, tblWorkstream.[Cap/Non-Cap], tblWork.EndDate , tblWork.StartDa te, tblWork.[Int/Ext], tblWork.FTE, tblWork.[Fix/T&M], tblWork.[TSU/NLA], tblVendor.Vendo r, tblContacts.Con tactID, tblOptionValueI ntExt.Text, tblOptionValueN LA.Text, tblOptionValueF ix.Text
FROM tblContacts,...Leave a comment:
-
the problem is that it shows me even Dates before 01.01.2007 when I am not entering anything in DateTo. However, when I enter a DateTo it shows me all records, where there is a DateTo in the Table. It would be neat, if it also shows me all records with DateFrom 01.01.2007 with an empty DateTo.
I have played around with the WHERE statement you gave me...but no solution yet.
thanks...Leave a comment:
-
Sorry, I mean that I could search all DateFrom without setting a DateTo, but it should also be possible to set a DateTo (if wanted). Both choices should be possible.
For example: I set DateFrom as 01.01.2007 Empty DateTo, and it shows me now all records where DateFrom is >01.01.2007 with an empty DateTo.
But it should also be possible when I give this input: DateFrom 01.01.2007 and DateTo 01.09.2007...Leave a comment:
-
Unfortunately not, because like that it shows me all records in the table. thanks...Leave a comment:
-
Once again, thanks to your help, I solved the first problem.
do you know, how I could change this WHERE part of my SQL-Query, so that it is optional to use "Date to"?
[code=SQL]
(((tblWork.Star tDate)>=forms!f rmReportDate!tx tDateFrom) And ((tblWork.EndDa te)<=forms!frmR eportDate!txtDa teTo));
[/code]
thanks,...Leave a comment:
-
Option Button Values and Date Creator Problems on a Report.
Hi there,
I have a two problems concerning option button values on a report and data report creator reports.
The situation:
I have three option value boxes two have 3 option and one has only two option buttons. They have values 1, 2, 3. Everything is standard. Now when I create the report, I have only the number for each record on the report, which is kind of ugly and not user-friendly. Is there a chance... -
Fish,
I have to appologize. Today in the morning I finally got, what you meant with subforms etc.
I am so sorry for my stupid questions. Thanks a lot for your patience.
Regards,
Sacha...Leave a comment:
-
hahahha...so, I actually need:
Add to Contact a second WorkID
For Example: Alive Miller, TimeSquare, CostCenter1, Workstream IT
End of the Month changes CostCenter. However, I want to track this in the future, so I want to know where he was working previously. Historization.
So he has two WorkID's but only one ContactID:
Alive Miller, TimeSquare, StartDate, EndDate, CostCenter1, WorkstreamIT...Leave a comment:
-
I see, sorry, I hoped this would make sense :-).
tblContacts
[code=ascii]
Field; Type; IndexInfo
ContactID, AutoNumber, PK
FirstName, Text,
etc.
tblContact 1---> N tblWork
WorkID, AutoNumber, PK
ContactID, Number, FK
StartDate, Date,
EndDate, Date,
WorkstreamID, Number, FK
OrgUnit, Text, FK
CostCenter, Text,
Region, Text,...Leave a comment:
-
Historization of Data
Hi folks,
I have (maybe) a challanging question. First, how does evertything look like:
I have a DB (of course) with relations like:
[code=text]
____________ _____________
| ContactsID | | WorkID |
| Name | 1 --------> N | Workstream | -----> Workstream
| Phone | | CostCenter... -
No, its already a new issue. Thanks to your help I could solve the first one. :-) I have closed it now.
Back to the ContactID has two WorkID Problem: Do you think I should open a new discussion?
I understand why I should implement a subform, the problem I have is how to create that "create 2ndWork ID button" (the code behind it). Somehow I have to tell this button to leave the information typed in Contacts and...Leave a comment:
-
Thanks Fish for this intensive help, I finally could solve the problem.
For the others: The Select-Statement works just fine, the problem in my case was just the relationships.
Regards and thanks,
Alive...Leave a comment:
-
Hi Fish,
Thanks, good hint, I will try to solve it step-by-step.
May I ask you another question:? I have a tbl_Contact and tbl_Work which are 1--N related. Now what I would like to implement is a button that adds to the Contact a 2nd Work-Information. Is that possible with SQL? Do you know the command? So that I could do some research.
Thanks a lot...Leave a comment:
-
SQL-Report Query Contains an Error, but where??
Hi folks,
I need once again your help. I have a long SQL-Report Query, which has an error build in, however, I do not see it at all. I have typed it with the SQL-Builder, not with the Wizard (don't like that Click and Go).
Does anybody see the mistake, error message: Syntax Error in FROM clause (great Error message) :-)
[code=SQL]
SELECT Contacts.FirstN ame, Contacts.LastNa me, CostCenter.Cost Center,... -
Nope, the Query isn't running right. The fields we are trying to include in our SQL-Query are empty (CostCenter.Reg ion and CostCenter.OrgU nit)....Leave a comment:
-
Thanks for the further elaboration. That made a lot of things very clear. The Query you gave me is working just fine in the SQL-Builder. Unfortunately, when I enter it in the form and do the steps and save the whole thing, it won't to what it should be doing. I don't receive an error, just a "bing-sound". Additionally, I can't change the CostCenter.
I was doing exactly how you described it. Sorry, I am still bothering you...Leave a comment:
No activity results to display
Leave a comment: