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...
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)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.