Search results

Ok, This is tricky to explain, bear with me. Basically, I have 3 levels of data: Company Department Contacts You choose the company first, then the department, then the contacts. I did this by having a sub form of contacts embedded in department and department embedded in company. Now...

I keep getting this error appear. "Update or CancelUpdate without AddNew or Edit" I sometimes get this when trying to use a combo(dropdown box) to select another record. I have found no examples of what causes it, it seems to be random but it always kicks in quite early. It relates to this...

What the best way to perform math functions on data in a table? I have a form and a subdatasheet in it. I want to be able to: Average out data in cells. I.E One field will have a list of numbers and I want to be able to average those out. The other is that i want to be able to check the...

I want to be able to create a email list from a query. I.E Say you need all the company's that meet certain criteria and then you have a list of company's complete with all the emails under 'email'. Is there a quick and easy way to export all these emails into the TO: field of outlook?

I have a drop down box displaying a list of names from the table. I want a button next to it so if needed the user can jump to that record. Is this possible?

Hi again :) This should be simple. I have a box which when checked should unenable a combo box and remove the current entry in the combo box. At the moment I have it so it writes " " into the combo box when its updated. But I have a problem, I cant change the text from outside the combo box...

I have two tables. Now other than the relationship they have the details are pretty much the same. The only reason they are in two tables is so i could could have a sub-record kinda thing. I have two forms one for sub and one for main. But there may be times I need all the records on screen for...

Hello, I want to have a form based on a query, and i want to be able to filter them down. I.E There are 100 people in the database (for example) and I want to be able to reduce them based on certain criteria. Say nationality. So all the records that form are one nationality until ii change it...