Search results

The rowsource of your combobox should look something like this. "SELECT field FROM table GROUP BY field" This will eliminate your duplicates. Keagan Quilty Kilbride, Newfoundland

If these fields need not be unique to each projection, then I would suggest that you store them only once in your primary table.

A couple of questions: What version of Access are you using? Are these relationships permanent or are they setup in the query window only? Have you tried establishing permanent relationships to these queries in the relationship layout? Keagan Quilty Kilbride, Newfoundland

Need more details. What exactly happens now when you click your search button? Keagan Quilty Kilbride, Newfoundland

In event Form_Current() combobox.rowsource = "SELECT .... FROM [tblAccounts] WHERE [tblAccounts]![fkClientID] = '" & fkClientID & "'" The thing is that the combobox needs to be requeried everytime you change records. Keagan Quilty Kilbride, Newfoundland

As near as I can tell (someone correct me if I'm wrong) the difference is that Form_Load executes before the form appears, and Form_Open runs after the form appears. Keagan Quilty Kilbride, Newfoundland

In the AfterUpdate of the combobox: If Me.ComboBox= "No" Then Me.FieldName.Visible = False Else Me.FieldName.visible = True End If Also put this in the OcCurrent Event of Form Keagan Quilty Kilbride, Newfoundland

That did the trick. Thank you very much. Keagan Quilty Kilbride, Newfoundland

Actually both fields should be text. Change your fields to text and then click the build button next to the InputMask Field. SSN and Phone Number should be there waiting for you Keagan Quilty Kilbride, Newfoundland

Is there any way of making fields invisible in datasheet view? I have a subform (datasheet) with ten combo boxes on it. However, no more than six of them should be visible at any one time, based on criteria provided on the main form. This form in tracking student attendance on a weekly basis...

An option group, by definition, cannot have more than one option checked. I would suggest that you delete your option group and simply place check boxes in a box. That way, you could have as many checked as you wanted.

What you need to do it to change the SourceObject of the subformbox to the name of whichever form you want displayed as the subform. I hope this is what you meant. I had trouble reading the AllCaps Keagan Quilty Kilbride, Newfoundland

kgcrowther, Instead of putting a checkbox on your report, insert an unbound textbox. In the control source for the textbox, use the IIF function to display what you want. I.E. =iif([fieldname]=Yes,"Complete","Incomplete") Sections are separated by commas. In the first section, you put in a...

The problem you're having is not with your code per se, but with your placement of it. You have this code in the BeforeUpdate event of your text box. It should be in the BeforeUpdate event of your FORM. Just like it says in Pat Hartman's quote. Keagan Quilty Kilbride,Newfoundland

Hi. I've been having a consistant problem with access 97, 2000. Every once in a while, for no apparent reason, some of my forms decide to ignore their event procedures or macros as the case may be. Is there any way of preventing this from happening? Keagan Quilty Kilbride, Newfoundland

That gives me an error Run Time Error '3601' Too few expected parameters. Expected 1. When I hit Debug, It highlights this line... mydb.execute MySQL I'm not quite sure of how to fix this. I put () around MySQL, and the only other parameters listed in the popup were optional. Keagan...

Option groups are meant so that only one option can be selected at once. If you want to be able to select more than one option at once, don't use Option groups. Use individual checkboxes. Keagan Quilty Kilbride, Newfoundland

Here Goes, For security purposes, I have a login screen in which users type in their names and passwords. The names and passwords are stored in a table, along with the date of their last login and the date they last changed their password. Question... How do I set a new value for the...

I have a form for new applicants to an education program. I need the form to generate student numbers when a new applicant is recorded. The student number should be in the form of the four digit year followed by a dash and then a sequential 5 digit number. i.e. "2001-00001" This organization...

Click on the Tools menu and choose Options. Click the Edit/Find Tab and where it says "Default Find/Replace Behaviour" change the option to "General Search". Click Apply or OK and exit your database. The next time you open it and do a search, it will automatically search any part of field...