Recent content by Rogue Programme

Cheers Craig, thanks for the comprehensive reply. I'll be giving everyone a copy of the front end for them to store localy. I'll also be adopting the front end auto update utility. Thanks again Mike

Hi David, yes the database is split. The back end holds the tables and the front end has everything else. I'll look into giving the users their own front end. is this just a case of the users taking a copy of the front end and storing it on their own drive? What about when i want to make...

The latter. Mike

The next morning it worked fine. Thanks for your reply Simon. Mike

Hi all I've made some changes to my existing database (v1.4) but now my users can't open the new version (v1.5). The database is split and I have relinked. The message they are getting is that they are trying to open exclusively or they don't have permission to open. I don't understand why all...

Thanks for your replies. jzwp22, the reason I had 2 forms was because although the data was stored in the same table; form 2 had data that would not be known until a later date. I would of created another table but because there was only a 1 to 1 relationship i thought I'd go down the 2 forms...

Hi, I have two forms linked to one table. The 2 forms are linked to eachother. I have a button on form 1 that opens form 2. However, if i click to go on form 2 without saving what i've input in form 1 I lose the data. My question - is there a way I can insert a piece of code in the buttons' on...

Hi, I have two forms linked to one table. The 2 forms are linked to eachother. I have a button on form 1 that opens form 2. However, if i click to go on form 2 without saving what i've input in form 1 I lose the data. My question - is there a way I can insert a piece of code in the buttons' on...

Hi, I have two forms linked to one table. The 2 forms are linked to eachother. I have a button on form 1 that opens form 2. However, if i click to go on form 2 without saving what i've input in form 1 I lose the data. My question - is there a way I can insert a piece of code in the buttons' on...

Brilliant, thankyou.

Sorry, i can't open it, i'm using Access 97.....

The following is produced by a query i've built.... 4a (2007 Jan - Jun) 5a (2008 Jan - Jun) 4b (2007 Jul - Dec 5b (2008 Jul - Dec) I need it in numerical order not alphabetical so it looks like this: 4a (2007 Jan - Jun) 4b (2007 Jul - Dec 5a (2008 Jan - Jun) 5b (2008 Jul - Dec) Any ideas

Hi guys, i'll try and explain this as best i can.... I have 2 tables: CurrentMonth PreviousMonth Both tables hold financial information by policy number. What i am doing is working out financial movement on a month on month basis. For example, if in previous month the financial position was...

This is the code i have but doesn't work.... Private Sub cmdnewuser_Click() On Error GoTo Err_cmdnewuser_Click Dim DocName As String Dim LinkCriteria As String DocName = "frmcomplaint" DoCmd.OpenForm DocName, , , LinkCriteria DoCmd.GoToRecord , , A_NEWREC...

I want to be able to open my main form with a command button that will automatically go to new record rather than record number 1. Can someone help?