Search results

Set the rowsource property of your combo box to: Select tablename.skill_ID, tablename.skill_name FROM tablename (replace tablename with the actual name of your table). Also set the column count property to 2 and make sure to put two sizes in the column width property, the first one being 0 to...

I would suggest to search for "normalization" first before carry on with your project as having 5 supplier fields goes against the rules of normalization and you will face more problems as you go along.

You can use a subform on the second tab and all related records to the patient will be displayed automatically. Try searching for subform and you will find several examples how you can achieve this.

Try to base your form on a query and then in the criteria row (in your query) for the doc_number field put [forms]![frmMain]![Combo151]

check out this link.

can you use a textbox instead? because it is much simpler to achieve what you're looking for i.e. Like "*" & "your search string" & "*"

the code is docmd.GoToRecord , , acNewRec

yes that can be done with a combo box on your form. Actually you shouldn't be entering data at table level. Also you may search on this forum for the OnNotInList event so that you can set up how to deal with entries which are not already in the list.

Thank you for your reply. Yes i think it's better to leave it as it. The reason that this database is for personal use and i am the sole user gives me more flexibility to leave things as they are. However, should someone come up with a better solution, it would be greatly appreciated if you...

Hi Stopher Many thanks for your reply. To be honest I have thought of crosstab queries, however I have two problems with it. The first I managed to sort out thanks to your link where i can include the column headings myself. However, my other problem is that the amounts in the crosstab query...

In the form's properties you can set the Data Entry Property to "Yes"

I have a small database which takes care of my stamps collection. The main entities of the database are stamps, collectors and themes. Although the structure of my data works good and with reliable performance, I have a question regarding the stamps entity with regards to normalization. Apart...

do you have more than 1 table in your query? if yes, did you create the correct relationship between the tables? Otherwise your SQL statement seems to be fine.

try using the onTimer and Time Interval which you can find under the events tab in the form properties.

you can use Me.ComboName.Column(number)

When you return to the Form View, try the "Size to Fit Form" which is under the Window Menu ... this usually sorts the issue.

You shouldn't be doing that to store this "calculated field" in your table. You do not even need to use an update query. In your query simply put FullName: [first_name] & " " & [last_name] in an empty column while in design view.

when you're in design view of your form, go to the view menu and select properties. The record source is the first property under the Data tab.

when you go to the design view of the form and check the "record source" property is it showing the old table new or the one you want?

is there a particular reason why you are trying to achieve this at query level? If you do this at form level you can easily implement it using cascading combo boxes.