Search results

Hi Ranman256, not sure if you're being sarcastic... But thank you for your answer however, my question was about your experience with windows api's and not another alternative for the msgbox.

Looking for a message box replacement i found one that looks very nice and is extremely flexible. It uses a lot of API Calls and in my experience having a lot of API Calls makes an application less robust. It crashes a lot and sometimes even corrupts the database. I must say that that is not my...

Try to determine if the filter you apply is really unique. Try to determine which ones you are missing and focus on that. What makes your filter hide this record? For a less foggy answer please provide more information or better yet a sample database describing the problem. HTH:D

If you are still having this problem... Before applying the sum you must have no more than 2 records. Since you are only interested in the sum of a particulair field, use a distinct of only that field and select the top 2 records. After that you can apply the sum and you will result in 22. HTH:D

A little more to think about: Public Function gcd(lngA As Long, lngB As Long) As Long ' Greatest Common Divider ' Euclides algorithme If lngB = 0 Then gcd = lngA Else gcd = gcd(lngB, lngA Mod lngB) End If End Function

42 or post a sample databases describing the problem. HTH:D

Ah... the big "C". That explains everything. Thanks for your contribution.

I have an actual understanding of the question of Life, The Universe And Everything, to which the answer is 42. Please donate to receive the actual question

Perhaps the query is lost in translation. Create a pass-through query and try again. HTH:D Weird.... i am sensing a weird feeling of deja-vu. All over again...

Perhaps the query is lost in translation. Create a pass-through query and try again. HTH:D

... or hit the escape key twice. Toggles special keyboard settings. HTH:D

Thanks for the responses. It is not that i need a solution to a Trim problem but i wasn't aware that there is another set of functions in Excel which you can utilize and i was wandering if Access has a similar additional set of functions. To which i was not aware... Thx!

I came accross this little gem. Apparently in Excel there are two(?) sets of functions available. Regular functions such as Trim() but also WorksheetFunction.Trim() The first removes all leading and trailing spaces. The second does the same and additionaly removes all double spaces in the...

use a group by clause and group on Max(My Date) and max(Alarm.Alarmstatus) Your duplicates will vanish as long as you leave the Alarm.Id out of it. If you need the Alarm.Id field, use the above query as a subquery to retrieve the additional fields. BTW, use the code tags to display your code...

Hi PaulA, Sometimes over time a database can get corrupted. Again sometimes just "Compact and Repair" can do the trick and sometimes you need to do the things you did and copy all objects from the old database to a new one. You're in luck that it still is an option. I haven't got the foggiest...

If you enter the database password, it means that you have activated the User Account Control. Which means that users can be added to the workgroup file. Apart from that you can encrypt the database which is a different way of protecting your data. In your case it looks like the database is not...

have you tried to remove the single quotes in your code?

There is no need to create a list of users. So you don't have to use the first function. It is good practise to store the encrypted password instead of the actual password. Below is an example "Encrypt" which encrypts the password and adds a salt. The resulting string can be stored in your...

If speed is an issue, you may want to stick with the recordset alternative: Private Sub Command0_Click() Dim MyDB As Database Dim MyRS As Recordset Set MyDB = CurrentDb Set MyRS = MyDB.OpenRecordset("Indies") MyRS.MoveLast MsgBox (MyRS.RecordCount)...

... or you are using fieldnames in your query that do not exist in the selected tables. Access thinks it is a query parameter. If you saved the query you can view the parameters of a query (Query1) in your immediate window like this: ?currentdb.QueryDefs("Query1").Parameters(0).Name if there...