Search results

Can you elaborate further 1. How many tables do you have? 2. What are the fields in each Table?

Is it possible to populate the Field Names in the Combo Box, then create another Text Box to write the search criteria? ComboBox: [Where you can Select a Field] TextBox: [Where you can Input criteria] CommandButton: [To run the Query]

http://www.youtube.com/watch?v=CTiA_4Me0cI Hope this would help. Thanks to Mr. Richard Rost 599CD

http://www.youtube.com/watch?v=CTiA_4Me0cI Hope this would help. Thanks to Mr. Richard Rost 599CD

It's hard to figure out the structure of your form. Try to explore the function of Conditional Formatting in Design Tab.

It's hard to figure out the structure of you form. Try to explore the function of Conditional Formatting in Design Tab.

I have [BirthdayField] in a query. How am i going to write the criteria in order to filter only different dates with the same Month? Thank you guys!

What should be the maximum size of the form in order to fit in different screen resolution? Is there any way to make form automatically size with the screen?

Make sure that EquipmentType visible property was set to NO It works, i am using Access 2007 Private Sub EquipmentType_AfterUpdate() If Me.EquipmentType = "Secure Token" Then Me.[TokenSerialNumber].Visible = True Else Me.[TokenSerialNumber].Visible = False End If End Sub

Try to put it on AfterUpdate event.

If your subform is in datasheet view, you can sort each field in the column heading

Customer Table: Customer ID, Customer Name, Customer Address Invoice Table: Invoice ID, Customer ID, Date Shipped, Amount Product Table: Product ID, Price Order Table: Order ID, Invoice ID, Product ID, Description, Amount -----------------------------------------------------------------...

You will find Access more interesting if Spreadsheets could not help you anymore.

If you want to open the form in a new entry mode after the last field had been accomplished, Go to form property>Data Tab>Data Entry: Select Yes...... then to Event Tab>After Update>Macro Builder>Action>Select: Requery Otherwise if you want to totally close the form..... Action>Select: Close...