Search results

OK sorry to come back to this one again but I have made it work in Excel but can't even begin to think of the code for Access. Here is the Excel code which should explain what I am trying to do. It is a huge loop that goes through every single record until it reaches the end (bascially column...

I have solved this now as I didn't have the function in the right place (should have been with the parent form).

I have a modal form which has a single record which is then linked to a sub-form on the same modal form. This all works fine and shows the relevant record and sub records but I want the modal form main record to change dependant on the record selected in the subform (which is basically order...

Yes makes perfect sense and I did just think I didn't need the extra field.

OK I think I have got it! Three fields Current, Proposed and New. The New field is created by looking at the current number (starting at 1) and seeing if there is anything in the corresponding priority and, if not it looks through all records in the Proposed field to see if there is another...

The best way to understand my confusion is to sit with a piece of paper and write the numbers 1 to 15 in one column and then in the next column write 1 adjacent to 7, 2 adjacent to 13 and 3 adjacent to 15 and then try to think how to number them all based on the new priorities for the three...

Thanks for the response. Yes there will be a field that is for the new number. Say field 1 has the numbers 1 - 100 and field 2 is used just to designate a new number (where relevant). So in field 1 the number might be 4 but in field 2 the new number would be 1. If that were the only change...

VBANET - I don't think your way (copied below) will work because they wouldn't start re-numbering after the point that priority 3 was changed to 1 but also above that point (because the current 1 and 2 will also move to 2 and 3. Also it may not be one number change (which should be quite...

JDRAW - I don't need to log changes as I was only planning on letting one user do this and it will be a task they will undertake perhaps once a fortnight or so. I would imagine the database will need locking to other users to do this.

The database will have password controls and no other user will be able to access the priority fields so it will be a password protected single button that provides this facility that will only be available to one person.

Only 1 person will be able to set the priorities and it will be done following a single review meeting - so a one-off exercise possibly fortnightly or monthly.

I have a table which has 2 fields 1) Project_Priority_Number and 2) Previous_Priority_Number. If there were 100 records these would be numbered 1-100 in the order that the user originally sets the priority (this number is in addition to the record ID number). I have created a form with code...

Thank - I ran the query again (tried a few attempts at different code but got there in the end). The key code that I have just put in that made the whole thing work was to Refresh the subform. That then updated the control with the query results. Thanks so much for your help.

OK - I will try to explain better. My main form has a customer number amongst other fields. The sub form populates with the further info pertaining to that customer number (from a different table which is linked to the main by Customer Number) and the user is allowed to add a record...

that should have read "event" not "even"

The query works and the code I am using to run again is: DoCmd.OpenQuery "Prospect K contacts - 09-01-14 Query", acViewNormal DoCmd.Close acQuery, "Prospect K contacts - 09-01-14 Query" I did it like this because I don't actually want to view the results of the query I just want them to...

Hi - I have a main form (let's call it MAINFORM), attached to that I have a sub-form (let's call it SUBFORM). In the SUBFORM there is a combo box which gets its list from a select query (lets call it QUERY1). I have a "ON CLICK" action to run the query. When I load MAINFORM and click on the...

I have a database with a button to call a modal form. On that form is a hyperlink to a website. I have set it as a hyperlink and set the "is hyperlink" to yes in the properties but when I click on it nothing happens. Even if I right click and ask it to go to the hyperlink nothing happens...

I have the following code as I have user/login tables. When the user logs on it creates a record in the relevant table, when they log off I want it to remove the user information. The code works fine for the first part but when I come to use it as part of the quit button code I am getting the...

I am a dumbo Paul! - it works a treat (after hours of complex code it was the stupidest of things I was requesting the 'value' rather than 'text' which was what was wrong). Believe me I have chastised myself enough but feel free to jump on the bandwagon!