Search results

Dale, The code should go in the on_click property of the commad button. HTH

Dale, Have you tried using code to requery instead of a macro? Firstly, where is the button that you use to update your subform. You must make sure that you reference the requery right if you have the button on the main form. [Forms].[mainformname].[subformname].[textboxname].requery To...

I would suggest having a listbox that enables the user to pick the criteria for the search. So the user can select "Mondays" and "CPR" or "Mondays", "Saturdays" and "MilitaryClearance". Basically any combination...... This is code from R.Hicks that will enable you to get the criteria from the...

Thanks for the reply Shacket.... Your suggestion works to the point that the first value is displayed in the combobox, but all the other txtboxes remain blank. I got it to work by combining two comboboxes that I had, that were each based on a seperate query. I then just combined the queries...

I have a combobox, which has many columns, and depending on what value I select in this combo it brings up relevant information in other txtboxes. How do I get the first value to appear in the combobox, and have its related txtboxes already filled with the related information? Basically...

Thanks Drew for the Code... I managed to get it partially working, I am now trying to get it to work for all my forms. Thnx Again, Irie

Drew, I have attempted to use what you suggested, but I am unclear as to how I should call the function. Could you show me the code for this... Thnx

Doug, I think I have done the code correctly, but could you check what I have, as I am getting errors.... Dim form1 As String, form2 As String form1 = "search" form2 = "renewalform" While fIsLoaded(form1) Or fIsLoaded(form2) DoEvents Wend If fIsLoaded(form1) Then Forms![entryform].Visible =...

Doug, One last question? How can I duplicate your code so that it will check to see if two different forms are open? Do I need to create a new function for the other form? Say: Function fIsLoaded2(ByVal strFormName2 As String) As Integer 'Returns a 0 if form is not open or a -1 if Open If...

Doug, THANK YOU, THANK YOU.... Absolutely Brilliant!!!! One less problem thats been buggin me for weeks. Thnx

ok, it looks like I had better give the full explanation...... I have a form which is based on a query. The purpose of this form is to see what licences are coming up for renewal. So when a user launches the renewalform from a mainform, they are prompted to enter the Month and Year they wish...

DjBummy, YOur suggestion works if I have originally arrived at the record form from the searchform. But if I arrive at the recordform directly from the mainform. Then I get an access error stating that the searchform is not open. So my question is.... Is it possible to create an IF statement...

Thanks Doug for the code, I am trying to incorporate the idea of using the tag into my code. If anyone else has a suggestion or comment please reply, Thnx

Denny, Thanks for the suggestion. I have thought about what you have said, and have realised that it could work. But the main problem though, is how do you pass on the information to the report, and the form at the same time? Does anyone else have any suggestions? Comments? Thnx

Using a button on a form, I use the following code to dictate what records appear in the report, basically whatever records are on the form. DoCmd.OpenReport "renewalreport", acViewPreview, , "[Renewal]=Forms![Renewalform]![Renewal]" My problem is that the form is a continuous form and...

Have you tried putting in the on_open event of the "Sponsors" form: DoCmd.GoToRecord , , acNewRec HTH

Doug, I am currently using the solution you suggested, but it doesn't work properly. As I have a main form which opens two other forms. A search form and a record form. The thing is that the search form also opens up the record form. So my problem is, if I open up the Searchform from the...

I am trying to program access to keep a form1 invisible, while form2 is open. What sort of code should I use to state: Dim isopen as String isopen = "form2" If isopen is open then Forms![form1].Visible = False Else Forms![form1].visible = True End If Can someone help me finish off this code...

I have a combobox which has multiple values repeated, how can I limit the list to show only one value, and no duplicates?? Thnx for any suggestions,

I have a combo box which contains duplicates of certain values. How can I filter the combo box so that only one value is shown? Thnx for any help or suggestions