Search results

Hi everyone, I wanted to know if there is a way to compute the modulo in an sql expression created in VBA? Thank you in advance for your responses. :)

Thanks a lot for your help!!! Your link were really useful!

Hi everyone, I wanted to know if there's a way to implement a calendar in MS Access? In other words, I'd like to create a calendar that act the same way as the Outlook calendar? At first I tought about the calendar control 8.0, but we can't write anything in a square date of the calendar. So...

Great! It works finally! Thanks to you namliam! I appreciate!

Well, Now I have another problem with some inner join in another query! When I run this sql code in a regular query, it works fine! but when I try to use it to open a recordset, I get the error : "Join expression not supported" Here is my sql string in VBA: StrsqlSum = "SELECT...

Perfect! You were right namliam, I was missing 1 closing bracket. But now, when I run it, it does not give me any error but the recordset is empty. But when I run the sql statement in a Access Query, it work fine... I'll try to fix that!

Hi everyone, Here is my problem: I'm trying to open a recordset with the following Sql string Strsql = "SELECT DISTINCT Count([# dossier]) AS Nb_demandes, [Unité responsable] " & _ "FROM (SELECT [table installations 2005].[# dossier], [table installations 2005].[Unité responsable]...

Thanks a lot, That's exactly what I was looking for.... :D

Hi everyone, Does someone know how to determine the language of the OS using VBA? Thanks a lot for your responses! :D

Hi everyone, I'm trying to build a module that is verifying the references of my project and adjust them if necessary. It works quite good except when I try to remove the Missing References from the list. here is the code that I use to remove them: With Access.References...

Hi everyone, I try to implement a function that looks for broken references in my Access project, so that I won't need to modify the needed references for every workstation. Here's my problem: Where could I put the call of this function so that this code will run before trying to compile the...

all right, I manage to create the file. I first used the docmd.outputto method, and then reopen the file and adding to more worksheets. Thanks everyone for your help! I appreciate

This could be a possibility... May be I should create a template, and use it to create the file I want. I'll try that.

It is in fact quite simple, but in my case, I have to work with more than one worksheet (3 actually), and with the docmd.output method, it will create only one. do you think there could be a way to create more than one worksheet with the docmd.output?

ok, But I think it won't works for me, because I have to do some manipulation within it. That's why I cannot use that. :(

Hi, You can use this method: Dim MySize As Long MySize = FileLen(FilePath) ' Returns file length (bytes). Hope this will help!

Hi everyone, My problem is the following: I execute some queries, and at the end, I have to transfer the result in an Excel file that is not yet created. Here is my problem. I don't know how to create a new Excel file in VBA. I know how to open an existing one, but not creating one. I tried...

Hi, I'm not sure how you could make your query, but I know that you cannot use Sum() the way you want to use it. You should use Count(ColumnName). Your query could be something like : Select Count(ColumnName1), count(columnName2)... From PersonalInfo WHERE...

are the three fields in the same table? If they are, you could create a query that will have three Count (one on each field), and then, in your report, you would create a formula in the textbox or label you will use to display your result. The formula would be something like: =[query]![field1]...

all right, I have resolved my problem! We just have to look if the outbox is empty or not: If OlFolder.Items.Count = 0 Then 'Then the message has been sent. Else 'Handle the error with a message or anything else that suit you needs End If Thanks anyway!