Search results

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...

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

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!

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

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...

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

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:

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 -...

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

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...

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?

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...

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...

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...

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...

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...

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

[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.

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...

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