Search results

Yeah don't navigate through records. We have seperate Edit, New record and Search forms. I'll have a play with it Monday. Thanks for your help sir.

Ahh hang on, yes.. The form has a button to save the record with this code.. [code] Private Sub btnsave_Click() On Error GoTo Err DoCmd.RunCommand acCmdSaveRecord Exit Sub Err: MsgBox Err.Description End Sub [code] So I guess the update event is being triggered by the acCmdSaveRecord. How...

Hi, I have a select query.. SELECT [table1].[field1], [table1].[field2] FROM [table1] LEFT JOIN [table2] ON [table1].[field3]=[table2].[field1] WHERE [table2].[field2] = true and [table2].[field3] = false; which works fine and returns the results I want.. But I now want to make that into...

Hey, thanks for the update. I did however attempt that prior to posting. Access still prompts that the run command was canceled 'after' my msgbox..

Ahh I didn't think of using the update event :) Could you tell me what I should be using to suppress the update cancelled prompt? DoCmd.Setwarnings False doesn't seem to work.. Thanks!

OK thanks Peter I will have a play with what I have and see how it goes. Incidently, I removed the exit label as it seemed redundant code as I have nothing to clean after the error handler. I have an 'Exit Sub' before the error handler label so it should terminate before that. I noticed this...

Hi, I have a form for creating new records in a table which contains 2 individual check boxes (which store their boolean values in fields in the same table). What I want to do is allow the following conditions - True, True True, False False, True but prevent - False, False Is there...

You are a star :) So I'm guessing those three lines are in addition to all the other code, so it would look like this.. Private Sub ButtonUpRevision_Click() Dim iReply As Integer Dim dateString As String On Error GoTo ErrButtonUpRevision dateString = DATE iReply = MsgBox(Prompt:="Are...

Hi Peter, Thanks very much for your reply. That makes total sense and I will work that into my solution for sure. I do have another query though.. With the way I have built the sql queries, I assume I will need 'CurrentDb.Execute strsql, DbFailOnError' after each UPDATE query which could...

Hi, I am using a button to trigger an Update SQL statement. I'm worried about situations such as, it gets half way through and encouters an error updating a record - how I could recover from that. I'm assuming that it attempt to perform the update looking for records that may cause an error...

Each SOC (record) we generate for a machine has the same set of settings, and all must be completed, just with different values each time. Theres currently around 30 fields for each SOC which must have information entered. The fields although different for each machine, remain constant...

Thanks for the replies. Unfortunately alot of that goes over my head, so no I dont really see where its going :( I think more reading is in order. Also I'm not sure if you understand what it is we are doing with the database.. The database and information in it is purely to create a report...

I am about to embark on a new Database (my first). I've armed myself with a few books and I am working from an old database which we are trying to "improve" so if all else fails I will simply add to the current in the same way it is built, but I'm asking myself the question, is the current the...