Search results

I got an assignment from my supervisor and I am not getting it! :( I have a query (see result in attachment) with the following fields: tID, emailID, emailtype and EmailDate. Example: A customer (tID 1297542) sends an e-mail (emailtype 1) to the company on 2-8-2005. The company replies on...

Hi! :) I would like to show the worksheet tab name in a cell of that specific worksheet? Is this possible with a formula in a cell?!?

Hi, Every week I get a spreadsheet from a database. In this spreadsheet is a column 'DATE', see attachment. This column is filled with (many) dates but they are not correctly typed like DD-MM-YYYY. :( For example: 20051210 should be 10-12-2005 (DD-MM-YYYY). Is there a way to convert this...

Thanks for your time and many ideas about the weeknumber problem. At this moment I will use DatePart and I have more time I will figure out an other solution. BTW Big Bird from Sesame Street is called 'Pino' in The Netherlands... sounds funny for you I guess... *SMiLE* JiTS

Well, I am stuck again with my weeknumber problem... Mile-O-Phile, yes... you're right again! Damn... ;) [Problem] I would like to enter a weeknumber and the begin date and end date of that week will be saved in a table. For example: I enter weeknumber 1 and the dates 01-01-2004 and...

Mile-O-Phile: yes I asked my manager what he wants to fill in and he said the weeknumbers because he don't want to fill in dates. For example: He knows that the prices for week 1, 4 and 6 are $ 1, without knowing the exact date. The price is for monday thru friday. That's the story behind the...

Well, I changed my way of thinking and I am using your idea in my database now. At this moment I have another problem, which you can find in the 'Form' section of this forum. *SMiLE* JiTS :D

I am stuck with the function DCount... I have the following problem: I use: tblContracts ============ AutoID ContractID - numeric Week - numeric Price frmContract ======== txtContractID txtWeek txtPrice [Question] I would like to check if a contractID contains Week 0 (zero). Criteria...

Goodmorning Mile-O-Phile! Actually the form that you saw is a subform of a mainform. I attached a picture of the whole form including the subform. Maybe it will give you a better look to my problem... Thanks, JiTS ... damn, I still need some hot coffee!

Please take a look at the attachment. What you see is what I made with my current table tblContracts. I am wondering if it's still possible to create the situation just like the attachment with the new table tblContracts? Conclusion: What I want is that the user is able to fill in each week...

Ok... now: tblContracts ========= Contractnumber Week1 Week2 Week3 ... Week52 Solution: tblContracts ========= Contractnumber Weeknumber Price Better?!? ;) *SMiLE* JiTS :D

Hi, I am stuck with the following problem: [problemsituation] I have a table tblContracts with the fields week1, week2, week3... week52. In these fields are prices. I have a query for a report which shows the orderinput per week. [problem/question] In the query is a weeknumber present. I...

Hi, Problemsituation (see attachment): I have a subform to fill in the input and output items in our company. The fields you see will be saved in the table tblStock. Description of the fields: [IN] ITEM -> combo box with item names from table tblItems WEIGHT -> weight of the item # -> the...

First of all thanks for your reply. I found the solution for my problem at MSDN: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/mysubreportprintsonlyonecolumn.asp I am busy now to try it out... hopefully it helps. ;) *SMiLE* JiTS :D

Hi, Problemsituation (see attachment): Within a contract are many numbers (afleveringsbonnummers). These numbers will not display in more than one column, see figure 1. Own solution until so far: The data in the green shape is in the header of the group 'Contractnummer'. I put the text field...

First of all I am Dutch, not German (see quote)... and in The Netherlands you could say 'Dank je wel' or 'Bedankt'. Don't start with the bad words in Dutch because that's not very nice on this forum... :D *SMiLE* JiTS

No problem at all! *SMiLE* JiTS :D

Actually, I did not find it somewhere but I figured it out by myself I guess... :rolleyes: I will try to explain it to you. The next code is the same as an if statement in VB but you enter this code in the controlsource of your text box. =iif(expr;true;false) expr: this the expression true...

I got it! I added the following code in the controlsource of the page number textfield: This means if the report is more than one page then it will display the pages. *SMiLE* JiTS

Hi, I would like to display the page numbers on the pages of my report, but only if the report is more than one page. How to do this in the design and/or VB area?!? Thanks in advance, JiTS