Search results

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...

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...

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...

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?

Hi I have imported a 1 column table from an external source for the sole purpose of deleting duplicates. There are over 400,000 rows. What do i need to do to identify the duplicates? Thanks

Not sure what is happening here... I keep getting an error message saying 'No Current Record'...especially when trying to create a new form or report using wizard. I don't have this problem at home..only in work. Any ideas? Cheers

Is it possible to import data/tables from a Lotus Approach DB into an Access ? Mike

I have a report that counts the number of telephone calls per month and groups them depending on the type of call ie claims call or customer service call. I also want it to add them together and show a total at the bottom? Cheers Mike

Is it possible to export a report to, for example a word or powerpoint file? The report displays charts aswell as text. cheers

=[TxtActualScore]/[TxtMaxScore]*100............ is what i am using to give me a percentage. For example: (Actual Score) 8 / (Max Score) 9 x 100 = 88.9 % There is the possibility that in some cases the Actual Score and Max Score are not applicable. I thought that if i enter '0' in Max Score...

I have a query that throws out results by month. When i open the query i get the correct results however, the results are not in date order...for example: Instead of Jul-03, Aug-03, Sep-03 etc.... It's showing date in alphabetical order, for example: Aug-03, Jul-03, Sep-03! I have also...

I want to be able to Dbl Click an employee in a list box that will then open that employees record on another form... Does any know the On Dbl Click code i need to open the other form on that employees record? I have a command button that will do this when the employee is selected from the...

I have created a transparent label on a form footer that will appear when the user mousemoves over a command button... Example User moves mouse over command button. Form footer text appears "Go to Employee Details Screen" When user mousemoves off command button the footer text dissapears...

I have a search screen (frmsearch) which is linked to my main table (tblmain). On the search screen there is a list box which lists all employees. I can scroll up and down the list box or i can use a search facility that i have created which will narrow the list down. I also have a form...

I need to report on historical data that is stored on an access database. The reports are by team and by department. However if a member of staff in the interim has moved team/department how can i ensure that if i query historical data i retrieve the information as it was at that time before...

Hello all... I have created a report based on a query. The query has a parameter included so that i can specify certain criteria. I also want to add a chart to the report based on the same query so that it gives a visual variation of the results. (Chart wizard). When i insert the chart it...