Search results

yes, but i'm not sure how to post the database

I'm just using a single form. But I think i need all of the code because i need it to tell the user if they've already closed that file or not. I am a total loss....

Yes the query does include the Files table..I have left work so I will continue with this tomorrow. I really appreciate all your help today. I may be calling on you again tomorrow, LOL Thanks Again!

yes I am but my record source is a query

ok it worked one time but now i'm getting that Write Conflict error box...don't understand why

dah...i guess i need to add the SQL stmt...

i have added that code and this is the error i'm getting: error: Command Text was not set for the command object here is the code again: Private Sub cmdCloseFile_Click() On Error GoTo Err_cmdCloseFile_Click Dim Result Dim rst As ADODB.Recordset Dim adocmd As ADODB.Command Set adocmd = New...

you are absolutely right, now that i think about it. i guess i want to update the same record.

yes here it is.... SELECT Files.FileNo, Files.DateOpened, (RTrim(Attorney.FName) & ' ' & RTrim(Attorney.LName)) AS Attorney, (RTrim(Secretary.FName) & ' ' & RTrim(Secretary.LName)) AS Secretary, Files.FileName, Files.Dept, Files.Description, Files.Status FROM (dbo_tbl_Files AS Files INNER...

yes, i have a query that does that and say for instance. The user opened a file on 1/22/2008 and it has an "active" status. on 12/4/2008 the user closes the file and now it has a "closed" status. But when the user runs the report for a particular atty it still shows that record that was...

i have some forms and some reports in an access application. Ok, this is what i have: i have a form that adds a new file and then i have a form that closes a file. and then i have some reports that users will run that shows "active" files and that shows "closed" files. Once they open a new...