Search results

morning all, I need to create a button to open a MS word template (currently saved in the usual folder for word templates) - my DB skills (!) allow me to create a button that will open MS word, but for ease of use I would really like to be able to click on a button and have the template open...

the problem seemed to be with the form...i created a new form from scratch and the problem was no longer there. anyone got an explanation for this?

i reset an autonumber field using the method Pat desribed above (delete all records then compact)....this worked but now whenever i try ro add a new record via a form a warning box appears and says 'record cannot be updated'. once I click on OK then I can update the record freely. how can i...

Afternoon All, I've got another problem, no doubt simply solved by some access expert - I have a user defined, indexed unique reference number on a form. How can I get access to check whether a reference that is entered has not been used in a previous record? The way I have the form set up...

Problem sorted! in the query design view i had added another related table to bring through department names....i didn't actually need this - all i had to do instead was to type in the primary key number of the department rather than its name in the query in order to filter the records. the...

Pat, tried to update the table by altering info in the query itself - access would not allow this and said 'this record set is not updatable'.

Now that I have got a form using a query from a table is there any way I can allow the form to add records to the table? on the form properties I have set the 'allow additions' to yes but I still cannot add a new record.....anyone know where I am going wrong???

Thanks Pat, i've now set it up using a query on the original table - makes life a lot simpler!

how do i change the table that a form gets its data from? I want to keep exactly the same format and I have exactly the same table structure and field names.

Thanks John, that's sorted it out!!:D

I have the following code atached to a check box on a form - Private Sub Check63_Click() If IsNull([MitigatingAction7]) Then Me.Check63 = "No" Else If Me.Check63 = "yes" Then Me.Check63 = "No" Exit Sub Else If MsgBox("Is this action completed?"...

Cheers Howlsta, with some help from you and one of our highly paid developers the code is now - Private Sub Archive_Click() If IsNull([DateArchived]) Then If MsgBox("Are you sure you want to archive?", vbYesNo + vbQuestion, "Archive?") = vbYes Then [DateArchived] = Date...

I am trying to add a check box to a query that will indicate that a record is out of date and can then be archived by a query (to be done by a totally seperate procedure). I want to provide the user with a warning asking if they are sure that they want to do this - this I have done via the...

I have a form that displays summary information about a record - what can I do to open the relevant table at the same record to save the user opening the table and then scrolling down to the correct record? I've tried using a macro with GoToRecord but I can't seem to make it work.

I've created a report summarising some of the information on one of my tables - the problem is that record number three insists on appearing as the very last record - all other records are displayed in the order they should be.....what's gone wrong?

I was on an access course recently and the tutor did mention how to do this but, alas, i did not document his response! What I am trying to do is to create a primary key as an autonumber but have it in the format "2003/001" etc. :confused: