Search results

I have two forms. Form one, based on a query Form two, based on specific record said query When form two closes I would like form one to refresh with any changes made to the table/record and update itself. Any advice.

Yeah they were not the real field names. Thanks a lot for that walk through, very helpful and worked a treat.

I have 2 tables like so: 1: ID Name NIID* 2: ID* NAME My form is based on Table 1, and has a combo box linked to the NIID field. I whish the drop down to displace the records table 2 and once selected his name to appear as the text in the combo box. Is that doable and how?

Ah I thought so :) That field is a grab of the time/date when a change is made. So on the form when ever a change is made VBA updates that field with the date.

Is the LatestUpdate the field titled: "Last Updated" or is it a property? I added the design view for the query also in the last post.

I can add the ID or Date field form the notes table.

I cannot use imageshack at work. I attached it instead however it has made it a little smaller... text might be hard to read, sorry.

Ignore that. I have double checked and it shows a record for each learner per update. I only want the latest update to be shown.

Should I upload a screenshot?

Thats great, however it does not show the most recent update, any way to sort which one it shows?

Hello, I have two tables. One is a list of clients and the second is for update notes. Each client may have several notes (one to many relationship). What I want is a query that will show each client and there most resent update... but still show the client even if they have no update. When I...

Okay I found the solution. For anyone thats interested: DoCmd.RunCommand acCmdUndo

Hello, I have a form that opens up a record for the user to view and edit. I would like the form to have a save and cancel button. The save button is fairly simple, save the record and close the form. I have struggling with the cancel button vba though. I want it to first, discount any...

Perfect, Thank you!!

Just go to it, I still want them to be able to use the navigation controls.

I have one form that has a listbox showing the results of a filter, which works fine. The list box has a doubleclick event that I want to open a form and then find a record on the form. I tried to following but it does not work. Any advice? With Forms!frmEmployerView.RecordsetClone...

Can someone explain briefly how multiuser access works in access. I have a database fe and be. The fe has forms and stuff. The thing is I do not want a user to be able to edit a record while another user is view it. Is this automatic or can I make it so?

I can work with that. Thank you very much!!!

Sorry the field wont be a field in the table, just a text boc on a form. I tried this but it seems to only return 1, even when their are 2 records: =[ep_POffered]-Count(DLookUp("[ID]","tbl_Placements","[EmpID] = " & [ID])) ep_POffered is a field in a table with a numerical value (the total...

Hello, My goal is to have a database with two tables and a form. The tables will be linked. The first table with have a field titled "Number of Positions" the table linked to it will be people that have positions. there will be a field in the first table titled "Number of positions remaining"...