Search results

Hi, I have placed an image control in a form but I want the image to be visible only when the value in the combo box is "Deceased". I am trying behind the combo box afterupdate: If Me.cboStatus.value="Deceased" Then Me.imgDeceased.visible=True Else Me.imgDeceased.visible=False End...

Hi, My other option was to change the line . Else 'Both start and end dates present.TO . ElseIf IsDate(Me.txtStartDate) and isDate(me.txtEndDate) THEN 'Both start and end dates present. It...

Hi, Please, the search form where I have txtAgeFrom and txtAgeTo is unbound. All other queries am running from this form are activated on click of a command button, and query results show up in another popup, which is bound to the query. I was hoping to do it in vb code behind the command...

Hi, I have two text boxes (txtAgeFrom and txtAgeTo). In the subform age is calculated and displayed in a text box (txtAge) but is not stored anywhere. I want the whereclause I could use to return persons whose age fall within the range specified in the two text boxes (txtAgeFrom and txtAgeTo)...

Hi, I needed just to replace my Else 'Both start and end dates present with ElseIf IsDate(Me.txtStartDate) And IsDate(Me.txtEndDate) Then 'Both start and end dates present. Thank you so much for your efforts. Stay well. Joseph

Hi, I wish I could do much more than what I have. Thanx. Joseph

Hi, That did not work either. I though the code caters would take care of that by including in it the If Not IsNull part in my initial code: If IsNull(Me.txtStartDate) Then If Not IsNull(Me.txtEndDate) Then 'End date, but no start. varWhere = "(" & strField & " <= " &...

Hi, I have two forms (frmMAIN and frmPersonsSub) that open side by side. I have field on the main form to query the second form (frmPersonSub), but I am having trouble with query or not querying with the date fields. What I have noticed is that I can run a few queries successfully but oftein I...

Thanx again. I'll have a look in both places. Stay well. Joseph

Hi, Thank you so much for pointing me to that link. It was so resourceful and as a result I took some time to go through most of those posts and I have decided to change my approach. In the attached sample, I have opted to only list names of persons in a tree control as opposed to the...

Hi, I still can't do much alone with ms access coding. I use many samples posted here, thanx to UA members. Something am working on is a database for law enforcement where i work and noticed that there's need for the treeview control to filter records in the subform frmPersonsSub based on...

Hi DCrake, I have attached a piece of what am working on for your scrutiny and advise. In this case, the main form is Frm_Files_Edit. Double-click the first or second record and Frm_FileCases opens in which there is a subform with the DateChange field which I want sorted by recent date...

Hi, I have a list of items in the continuous form. The last column holds date stamp to indicate when a record was modified. What I want is to ensure the recently modified record stays on top of the list of items. How can I do this for vb code/query? Joseph

Hi, I have two forms one of which is twice longer than the other. I want the shorter form to always stick to the right edge of the underlying longer form. How can I do this in code? By the way, I have set access window to hide, so only the two forms stay on my desktop. Joseph

Hi ghudson, I tried your code but no success. The sample am working on can be found on the following link: http://www.utteraccess.com/forum/Instant-Messenger-t1169381.html As indicated in my previews post, the error appears when you click the LogIn button without having selected User name...

Hi, Please, I need help to create an error trap in the following code which is behind a LogIn button. The txtSignIn is a combo box to select a user, error appears when user clicks a a LogIn button without selecting their name. DoCmd.OpenForm "frmUserInfo", , , "[UserName] = '" & Me.txtSignIn...

Please, I need help to figure out what am missing. The original code here is inteded to re-link tables to the front end automatically if both the FE and BE are in the same folder. Am trying to adopt the code for my use but am only ending up in the error "No table database has been found ..."...

Hi Namliam, Thanx for the code. I will try it out. Regards. Joseph

Hi, I have split my mdb database and I want to have them distributed to various remote place where there would be no network. The FE and BE will be in the same folder. What I need is a code that should re-link the BE. Tried to search this forum but could not find exact solution. I will...

Hi, I created an application to help in tracking cases at the office. Most of the stuff is appreciated except users were required to input record count (Case Folio) manually each time they open a new case. I realise I needed to include a DMax Function to automate creating a "Case Folio" but I...