Search results

  1. J

    Sorting Problem

    Another sorting problem Mile-O-Phile, I will give it a try in English for this problem ;) Hi everybody, Problemsituation (see attachment): I have a report and it is grouped by 'Contractnummer'. I put everything under the header 'Contractnummer'. If I run the report then it will sort by...
  2. J

    Sorting Problem

    Okidoki... I will wait for him. Thanks, JiTS
  3. J

    Sorting Problem

    Need some Duch help... Hi, I need some help in Dutch. I am busy with reports now and it's too complicated to explain it in english. I am not able to search for Dutch people in this forum... If there are Dutch people over here who are good with reports, please reply. Thanks in advance!
  4. J

    Check box depending on value of text box

    Mile-O-Phile, Thank you very much... you are a genius! ;) *SMiLE* JiTS :D
  5. J

    Check box depending on value of text box

    Hi, Problemsituation (see attachment): I have a report with a couple of text boxes and one checkbox. Question: I want that the checkbox checks if the field (productcode) the text "VB" contains. If so then the checkbox will be checked (true). Own solution until so far: I added the following...
  6. J

    Another DLookup problem with 3 criteria

    FoFa, Yes, that's it! I was a little confused by all the characters in my written code. ;) Thanks for your time. *SMiLE* JiTS
  7. J

    Another DLookup problem with 3 criteria

    FoFa, Thanks for your reply. Contractnummer is numeric, that's true. You're code is not correct, because I get an error on the line: & '" And [Leverancierscode] = '" & Me.cboLeverancierscode & "'") = 0 Then I guess there is missing a quote (") but where I don't know. :confused:
  8. J

    Another DLookup problem with 3 criteria

    Hi, I searched the forum for this problem but my problem is still unique. :( Problemsituation (see attachment): I have a form (frmAanvoergegevens) with 3 fields: * Contractnummer - txtContractnummer - textbox - numerical * Productcode - cboProductcode - combo box - text * Leverancierscode -...
  9. J

    Delete query using linked tables

    Pat, Thanks for your reply. It is a very good advice to apply in my database. I am sure it will be useful for other users who are working with this forum. Two thumbs up! ;) *SMiLE* JiTS
  10. J

    Delete query using linked tables

    Hi, I have the same problem... kinda... :( Problemsituation (see attachment): I have a mainform (frmContracten) and a subform (fsubContractweken). These forms are connected to the tables tblContracten and tblContractweken. The primary key in both tables is 'Contractnummer'. Problem: If I...
  11. J

    Parameters in a QueryDef

    Pat, Thanks for your reply but I still have one question: Where do I have to put the following code: Can you give me more specific details please? My own solution: I guess it has to be in the query which I use for the form frmControl. Am I right?
  12. J

    Parameters in a QueryDef

    Well, maybe you can help me... :) I have two forms (frmInput and frmControl). Description: frmInput = Here you enter the order information frmControl = Here you enter more detail information about the order In both forms is 'OrderID' the primary key. If frmInput is filled in and you click on...
  13. J

    Combo box - custom validation rule

    Finally, it works but the code is not that good because I wrote it by myself. :) I use the following code: Private Sub txtDiameter_BeforeUpdate(Cancel As Integer) If IsNumeric(Me.txtDiameter) Or Me.txtDiameter = "Extra fijn" Or Me.txtDiameter = "Zeer fijn" Or Me.txtDiameter = "Fijn" Or...
  14. J

    Combo box - custom validation rule

    The solution is almost there, but it's not working yet. :) I put the following code behind the event NotInList of the combo box: Private Sub txtSize_NotInList(NewData As String, Response As Integer) If IsNumeric(NewData) Then MsgBox "The input is numeric.", vbInformation Response...
  15. J

    Combo box - custom validation rule

    Dave, Thanks for your reply, but it's not an answer on my question. It's allowed to choose one of the 3 options or to enter a size for example '52'. But it's not allowed to enter letters, only numbers. (see attachment) So it has to be something with adding a code behind BeforeUpdate to check...
  16. J

    Combo box - custom validation rule

    Hi, I have a question about a combo box issue: Situation: I have a combo box (Size). You can choose 'Small', 'Medium' or 'Large'. But you are also able to enter a size in numbers. The datatype of the combo box is text. Problem: When I am entering 'aaa' in the combo box, it will be saved...
  17. J

    DCount problems

    *bows in honour* :D Thanks for your help... it works... it really does! *LOL*
  18. J

    DCount problems

    [update] I changed the datatype from numerical to text and it works perfectly. But I still want to know if its possible to keep the datatype numerical. I guess that the DCount line will be different.
  19. J

    DCount problems

    The textbox in the form = txtAfleveringsbonnummer The table = tblAanvoergegevens The fieldname in the table = Afleveringsbonnummer The datatype of the fieldname is numerical. Example: I type into the textbox '4545'. I click on the next textbox and DCount will check if '4545' already exists in...
  20. J

    DCount problems

    Thanks for your advice. I am still waiting for an answer on my question, but in the meantime I will read more about DLookUp. BTW Sunnyvale is a really nice city... I lived there in 2000 at Lakeside Drive... very cool! :cool: Regards, JiTS
Back
Top Bottom