Search results for query: *

Thank you CClint - that's very helpful, it woks a treat.

Hi, I can make a week number - Format(Now,"ww") = 34 easy peasy... Does anyone know if I can go the other way round like Format(34,"dd/mm/yy", fistdayofweek) = 18/08/03 or something? Thanks in advance...

Do you have a Firewall in progress or even possibly a virus checker? This could be interfering with your progress. It may be an idea to try using a proprietory installation package like Installshield or Wise (there are others) because the supplied Deployment is p r e t t y basic, although this...

Hi, can anyone help me with this, I am using MSDE SQL7 and the Data environment within VB I have four seperate sql views (not related), that I want to place on one report, In Access I would use subreports but this isnt in VB6, I would like to avoid using Crystal if possible so if anyone has...

I Think the answer is No. Although I could be wrong.. I would suggest saving your data into a simple text file. and retrieve it again when needed, it is a very simple process: to write Open "C:\TEXTFILE.TXT" For Output As #1 Print "Whatever" Close #1 to read Open...

If you wish to trigger the lostfocus event from somewhere else you can use the Call command Call objTxtBox_LostFocus

Hi, can anyone help me with this, I have four seperate views which are not connected, that I want to place on one report, In Access I would use subreports but this isnt in VB, I would like to avoid using Crystal if possible so if anyone has an idea, I would be pleased to hear it. Thank very much

Hi, Maybe this will help, Place a label into the header and footer and leave them blank, then before you show or print the page, populate the label with a line like: ReportName.Sections(1).Controls("Label1").Caption = "This is the Title" Where ReportName = the name you have...

Not sure if I'm being too simplistic, but it looks like you need to organise the data before connecting the grid to it. So instead of connecting directly to your table, Create a View/Query which removes the blank items like - SELECT * FROM products WHERE Len(Code) > 0 or use Not isnull(Code)...