Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dafi
  • Order by date
  1. dafi

    Getting HDD partitions for multiple HDD in system

    I have a problem with linking the partition to the HDD that it belongs. So if I have 2 HDD I get a lot of "letters" and I would like to know how to retrieve them by HDD. It must work in Win98 .... I need it to be sure I get the correct HDD serial number that I want to use as key for...
  2. dafi

    Query that runs in Access but is not working in VB

    Well i tried with % instead *, . instead ! and is still not working. Actually on VB i use always . and not ! In fact i cannot get rid of call_listing since the where clause is part of a join-type query on 4 tables. I suppose it can be a problem with Len and Trim functions. Plus, there are the...
  3. dafi

    Query that runs in Access but is not working in VB

    the query looks like this: SELECT calls_listing.dialnumber FROM calls_listing WHERE (Len(Trim(calls_listing!dialnumber)) In (10,11)) And ((calls_listing!dialnumber) Like ('072*')); in Access where i wrote the query it executes fine. in VB where i have to use it returns no rows !!!!
  4. dafi

    Access query works fine unless is executed from VB application

    the query looks like this: SELECT calls_listing.dialnumber FROM calls_listing WHERE (Len(Trim(calls_listing!dialnumber)) In (10,11)) And ((calls_listing!dialnumber) Like ('072*')); in Access where i wrote the query it executes fine. in VB where i have to use it returns no rows !!!!
  5. dafi

    SMDR record format needed for kx TD,TA 1232,616,816 etc

    ok, thanks but no thanks LMAO
  6. dafi

    SMDR record format needed for kx TD,TA 1232,616,816 etc

    Hi, Well i did more than that since I have my own app that reads that info. The problem I have is that I have just ONE system, an old EASA 616.
  7. dafi

    SMDR record format needed for kx TD,TA 1232,616,816 etc

    My employer asked me to make an application that reads the SMDR logs from multiple Panasonic Systems (not all at the same time:) ) The problem is that i have only an old model EASA 616 that I was able to read and parse without problems. So I surfed the web and finally i found the installation...
  8. dafi

    Getting the new height of a textbox in CR(8) needed

    well, i've noticed that it was no answer for my question so I worked a little on the background and I've finnaly reached th solution. The solution is based on having an array containing the length of each character for (in may case) Times 12. How to do it ? simply make a new form, set font to...
  9. dafi

    Getting the new height of a textbox in CR(8) needed

    I have a section in my report that needs to have at least 12 lines(graphically) drawn. if the text that I superpose on the lines exceeds 12 lines I have to increase the number of drawn lines to create the "look". Ex: test test test ... .... ... test...
  10. dafi

    BERMUDA TRIANGLE IN MY REPORT - Executing 3 times a Format Section Sub

    I finnaly I made it work !!! I still don't know why it executes 3 times the sub, but I passed the problem. And the answer is NEVER try field_in_db_mapped_on_a_field_inreport.Value = True BUT YOU SHOULD field_in_db_mapped_on_a_field_inreport.Value = "True"
  11. dafi

    BERMUDA TRIANGLE IN MY REPORT - Executing 3 times a Format Section Sub

    Can anyone explain me why a sub that formats a section in the detail part is running three times per recorset or per row, i'm confused ? ? I needeed to do something like sub format_blahblah if field_in_db_mapped_on_a_field_inreport.Value = true other_field_in_report.SetText "ok it's...
  12. dafi

    This field name is not known ????

    I don't know what to say ... I have tested the query with Access and it worked smoothly. I copied the query and it worked ... I executed the query in VB and it worked... I know that is necessary only to be the fields in correct order for the CR component to run the report. It is .... So , I...
  13. dafi

    This field name is not known ????

    Hi, I have a problem CR keep saying me This field name is not known I use a query that can return null fields ... datcmd1.CommandText = "SELECT Meci_Program.ID, Meci_Program.ID_Meci, Meci_Program.ID_Etapa, Meci_Program.Pozitie_in_etapa, Meci_Program.Jucat, Meci_Program.Data_Meci...
  14. dafi

    HELP :) Counting group records for changing color of sections properly

    Well ,it worked, thank you !!! I created the counter, reset after group and is super cool !
  15. dafi

    HELP :) Counting group records for changing color of sections properly

    some explainig first. Since I didn't know how to change the background color of a box - i think it's a readonly attribute, I tried to do the trick with the backcolor ... pretty cool, but my information takes 1/2 of the page, centered, so it was necessary to add some boxes on left/right that are...
  16. dafi

    How to display the pic directly using OLE??

    I use CR8 and I don't know if .GIF's are showable ... for me it wasn't ... anyway, let's say .JPG in your section dblclick Sub blah...section_Formatting yourcontrol.FormattedPicture = LoadPicture("your_file.NOTGIF") ... I think that will work
  17. dafi

    HELP :) Counting group records for changing color of sections properly

    I have 2 sections with 2 different background colors (actually I drew 2 boxes with different colors) so it like the same thing ...) I grouped the information and now the problem is: there are odd number of records for each group and my "formula" for surpressing the section that I don't...
  18. dafi

    Global variable on 1 asp page

    I have a question ? I tried to open with Showopen and it says "The common dialog function failed during initialisation. This error often occurs when insufficient memory is available" and I have 90MBs available of 256 I run on w2000 server Can this be the problem ? on my pc at home...
  19. dafi

    CreateObject("MSComDlg.CommonDialog") problem

    I have a strange problem: here is a little code: set dialogul = Server.CreateObject("MSComDlg.CommonDialog") dialogul.Dialogtitle = "Atasare fisier" dialogul.filter = "Toate (*.*)|*.*|Excel (*.xls)|*.xls|Word (*.doc)|*.doc|Text (*.txt)|*.txt" dialogul.filterindex =...

Part and Inventory Search

Back
Top