Search results

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

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

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

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

Hello people... I have a main form called frmCALCULATIE. On that mainform there is a subform called frmCALCULATIEVERSIE On the form frmCALCULATIEVERSIE there is also a subform called frmCALCULATIEREGEL. Besides the subform frmCALCULATIEVERSIE there is another subform on the main form which...

Hello again ;-) I have a pretty basic question but I just don't seem to find the anwser. I have a datasheet that looks like this: Main_ID | ID | Number 1 | 1 | 45 1 | 2 | 65 1 | 3 | 345 2 | 4 | 145 2 | 5 | 75 2 | 6 | 25 2 | 7 | 145 I want to "group" Main_ID so it looks like this: Main_ID |...

Hello everyone, I have a continious form with a picture of a delete button. When I press the button I want to see the currentrecord ID. To test this I simply use the code msgbox(me.ID.value) When I click on the unbound image the msgbox shows the first ID no matter wich row I click...

Hello, I want to send an order via email using the following code: DoCmd.SendObject acSendNoObject, , , "info@sosol.nl", , , "Onderwerp", strMessage, False This works fine. But I want an image as background for the mail. What do i have to put in the templatefile? Just the path to the .jpg file?

Hello, I have built an application in access 97 that orders articles. now i use this code to send data to outlook express 6: Private Sub cmdMail_Click() Dim strMessage As String strMessage = "Geachte Relatie," & vbCrLf & vbCrLf & "Ik zou graag het volgende willen bestellen:" & vbCrLf &...

Hello, I have to adjust a database for somebody who has developed it in access 97. I installed access 97 (next to my runnig version of 2007) but I cant open the database window. Holding the 'shift' key isnt working. I know the database starts from 'autoexec'. Can anybody please help. When I...

Hello everyone, I have searched the forum but I just haven't found quite what I am looking for. I have a form with one unbound texbox (txtZoekenOpTrefwoordCursusCode). My search function as shown below works great with 1 keyword. If Me.txtZoekenOpTrefwoordCursusCode = "" Or...

Hello, I want to import a .txt file into my access application. However there are 6 lines of comment I wish to delete from the textfile. I have a button on a form. when I press the button the 6 lines should be deleted. Does anybody have an idea how to go about this?

Hello, How can I get rid of the access logo (4 coulored puzzle looking thing in top left) when I deploy my programm?

I have a query that looks like this: TeamAway TeamHome Jury ---3----------6--------4 ---9----------4--------2 ---7----------8--------3 ---2----------3--------4 How do I get a horizontal max so my query looks like this: TeamAway TeamHome Jury Winner ---3----------6--------4--TeamHome...

Hello, I have a continious form containing data from the table "tblToernament". On that form there is a combobox containing teams that are stores in the table "tblTeams". The table looks like this: ID | TeamName 1 | Team01 2 | Team02 3 | Team03 4 | Team04 When I select, for example, Team02...

Hello, I have a very complex issue. First of all there is a table called "tblParTeam" wich contain the teamname and ID of teams partissepating in a certain Tournament. The tournemant data is kept in the table tblTournament. Each tournament contains a couple of variables: "Number of teams per...

Hello, I have a query containing a tekstfield called 'page' Here are some values of the field 'page': Page ----- no page 33 2.2 2.1 5.6 no page no page when I sort my query on page it looks like this:" Page ----- 2.1 2.2 33 5.6 no page no page no page However...it should look like this...