Search results

Got everything working :). One last question, is there a line of code i can run to get the record to update? I know it does this automatically but i need to so i can requery the position list box as soon as they leave the position textbox? EDIT: Used 'DoCmd.RunCommand acCmdSaveRecord' and it...

Hi, it was a incorrect query after all that! Sorry and thank you for help :)

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...

No, But I will! Thank you :). My main concern is how to interact with a data subsheet. I mean, is there a way to reference them? individual fields and records that is, (record = 2, field = cost for example?). I also take it that it wont be as simple as" = Avg ( [tblname]![field] ) " Also, is...

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...

They seem to only do sending a object, I need it too bbe a command in a toolbar that will get all the emails from the current table that is open (i.e Query).

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?

Ah the combo box is bound. It needs to contain the data on which company is head of that company. Hence the jump to record but only when needed.

Doesnt work :confused: What does the # represent?

Remember this time I need the button to jump to the record when the user clicks it and not on combo box. I copy and pasted the code by replacing ' rs.FindFirst "[Agent ID] = " & Str(Nz(Me![button], 0)) with rs.FindFirst "[Agent ID] = " & Str(Nz(Me![ParentCompany], 0)) doesnt work...

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?

done it, Last_Update.Value = Date as code worked! Thanks :)

Nope, that doesnt seem to work either. Its just if i change any data on the form, this this box to change to the latest date. :S

Bingo! :D Thank you. One more question, I also need a box to record when the record was last updated. Any idea why =Date() doesnt work in the afterupdate event? :confused:

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...

Ok, The table stores addresses, towns, names, etc. Both tables contain the same data. The ONLY difference is that some of these companys belong to other companys in the first table. So I have a secound table that contains all these 'sub companys' and a ID that tells it which company it belongs too.

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...