Recent content by JiTS

Ok, thanks for the guideline... but can you give me a more specific solution for this issue?

Sorry, but that solution will not work. I still think that I need a loop to check if the next recordID exists in the list of records!?!

Hi, I have two forms in my database: Form1: list of records (which have the status 'open') Form2: shows details of chosen record in Form1 (status can be set on 'complete') When the status in Form2 is changed into 'complete' this record will disappear in Form1. If the status stays on 'open' the...

Advanced question Hi, I also use the code from ghudson and WindSailor but I have a question about it. I have a set of records which have the status 'open'. When you click on a record you see the details of the chosen record. If you keep the status on 'open' you go back to the set of records...

I found something about 'TOP 1'. Isn't that a better solution? Because with MAX I only get one record, but I need to get all the unique records with the latest user!?! ServiceNumber | User 1-551747091 | MKB_VERHUIZEN 1-551747092 | HOCKSC 1-551747093 | GRAALMANT etc. BTW I don't use the...

Hi, I am working on a report and I am stuck with the following problem: Here at work we use two tables. One for creating records and for the updates of the created records. In the attachment you see a part of the table 'updated'. What you see is one ServiceNumber (1-551747091) which is changed...

Hi, I would like compacting my database automatically with my task scheduler. In this forum I found the following topic with the solution... I thought: http://www.access-programmers.co.uk/...ad.php?t=98123 My database is only a .mdb Access 2000 file and contains a general password (access)...

Wow! ByteMyzer, That's the one I was looking for... many thanks from Amsterdam! :D

Hi, I have a problem with getting the right result with a query. To this topic I attached a part of my database including 2 queries. The queries are almost the same, except the first field. In query 1 is the total 'Group By' and in query 2 'Count'.The other fields are parameters, which are the...

Hey Banana, I think that's the solution... I've tried to apply it in my database but with no succes. Well, I am not a beginner in programming but the code which is used is a little too complicated for me. Maybe you can help me? :confused:

Banana, Sorry, but that's not the issue. The problem is to show the previous selected record in the list at the top. Or if the previous selected record is closed, the next one (which is open) should be on top of the list.

Well I don't know... I just have choosen for this method (by using a continuos form). :) I believe that this works but I can't trigger my problem. Do you know the code to find the next record in a query without using FindRecord or FindNext?

More details about my problem: If the list in frmRecordList is from 1 to 200 (1, 2, 3, etc.) then my code (OpenArgs) works perfectly. The OpenArgs property contains the ID of the selected record. In the picture (see attchment) you see a part of frmRecordList. As you can see is that not every...

Good morning! :) I have 2 forms (frmRecordList and frmRecordDetails). The form frmRecordList contains 400+ records with a field 'Status' set on "Open". Normally I choose a record in frmRecordList and frmRecordDetails shows the chosen record. In frmRecordDetails I am able to change a field...

To control Excel in my database I use the following code: objActiveWkb.Worksheets("Mutatiesoverzicht").Range("A2:C2").HorizontalAlignment = xlLeft By running the code I get the following error: "Unable to set the horizontal alignment property of the range class" I think the problem is the...