Recent content by bodylojohn

Hello everybody.... In my application I can read mails from outlook. I search for a specific keyword in a string (message) and then I retrieve the line. Now I would like to search for a number that is always 6 digits long. So in the line I would like to retrieve numbers from 000000 to 999999...

Hello everybody, I have a form in an Access 2010 application containing a combobox. The combobox may contain duplicates (that's OK). However I would like to know how many (if any) duplicates consist for a certain value. So lets say I enter the value "TEST" in my combobox. Then I'd like a...

Thanks a bunch. I learned alot today. I had to add the "cdate" to get it to work. Very happy here!!!!!!

Here is my code: Private Sub btnZoek_Click() ZoekAflevering End Sub Private Sub ZoekAflevering() Dim ZoekFilter As String ZoekFilter = "1=1" If Trim(Nz(txtZoekBarcode.Value, "")) <> "" Then ZoekFilter = ZoekFilter + " and [Barcode] = '" & txtZoekBarcode.Value & "' " If...

No results!

You are right. I forgot the: me.filter = SearchDate me.filteron = true The code is run when i click a button. But the problem should be somewhere in my SearchDate condition

Hello Everybody, I have searched the net and this forum for an answer but I couldn't find it. I am trying to filter a continious form in MS Access 2003. The database field called [DeliverDate] and contains values like "23-7-2015 8:23:16" In the search field (textbox called txtSearchDate)...

Hello, I have developed an access program that will be used by 2 pc in a store. Can I simply put the .accdb file on a network drive and place a link to the .accdb file on both pc's? Or is there a better way to go about the issue of multiple users? Thanks in advance!!!

I am an idiot!!! I was looking at the wrong code.. It works great!!!! Thank you very much guys!!!!!

Thanks for your tip... but I am lost here ;-) I tried to put the code in the before_update event of the txtboxes... And that doesnt work either. I hope that you can help me a little bit more. Thanks again!

Hello, I have form containing 2 textboxes (txtsnelzoekenelementgroep and txtsnelzoekenelement) On the mainform there also is a subform called "frmSUB_ELEMENT" wich is a datasheet. The code below works when i put the "Call SnelZoekenElement" in the after update event of one of the two textboxes...

Hello, I have a table called tblELEMENT, consisting of ID, Element and sort The elements must be in a specific order. There for I have the field "sort" When I insert an Element between sort value 122 and 123 I want the new element to get the sort value 123 and everything that comes after 123...

Thank you very very much.. Exactly what I am looking for... And everybody who helped me with my other access problems.. THANK YOU TOO!!! I wish all off you a very happy and healthy 2010

Hello everyone, I have a mainform (frmMAIN) and on frmMAIN the is a subform (frmSUB1). frmSUB1 is a datasheet consisting out of 2 columns. Directly above frmSUB1 there are 2 txtboxes. Each txtbox filters on a column of the datasheet. So far this works great ;-). However.. when a user adjest...

I think I ALMOST solved it. I changed: Forms![frmCALCULATIE].Requery With Forms![frmCALCULATIE]![frmCALCULATIEVERSIE].RecordsetClone .FindFirst "CalculatieVersie_ID = " & Forms![frmCALCULATIE]![frmCALCULATIEVERSIE].Form![txtCalculatieVERSIE_ID].Value End With End Sub to...