Search results

Thanks Paul, for the quick reponse. It works. I see I'm getting too tired. I'll let it be for today... Thanks again. Bye.

Hi, I just played around with that Loop statement. Somehow it doesn't add me columns if I use the similar syntax like before updating the column. Regards, Ben Public Sub TEST33() Dim i As Integer i = 10 Do While i < 21 DoCmd.RunSQL "ALTER Orders ADD COLUMN [" & i & "2013]" i = i + 1...

Hi all, I got a small problem here. Somehow I wrote the wrong syntax it doesn't update my columns 12013 and 22013. These columns got number values. Can someone help me please? Thanks in advance guys. Regards, Ben 'Vorzeichen ändern Public Sub TEST33() Dim i As Integer i = 1 Do While i < 3...

Thanks Paul, for the quick reply. It works. Regards, Ben

Dear all, can you tell me how I configure my Form Window to pop up as soon as I open my Access Database? Thanks in advance.

Thanks a lot for your help namliam. Now it worked. I will use this syntax in the future, it's really easier to read.

Thanks Paul, now it creates the query. But I can't open it. I guess the Group BY is somehow wrong. I have to include Reporting Month in the Group By statement. I guess I also have to write some kind of SUM for the Total Net Sales and Quantity part in the SELECT Statement?

Dear all, somehow this syntax is wrong: Public Sub My_TNS_Query() Dim strSQL As String Dim qdf As QueryDef strSQL = "SELECT [Profit Center].Division, Customers.[Customer Split], TEMP.Customer, Customers.[Reporting Names], TEMP.[Total Net Sales], TEMP.Quantity" & _ "FROM (TEMP LEFT JOIN...

Now it works, thank you very very much. Now I can stand in front my weired female manager tomorrow. You saved me. Thanks again. Have a nice night Paul. Regards, Ben

I attached it.

Sorry, really don't wanna be a pest. Now it doesn't aks me for a Parameter, it runs through. However it doesn't fill in the records under column Reporting Month with the value MyValue. The column is still blank.

I tried this: DoCmd.RunSQL "UPDATE Temp SET Reporting_Month = '" & MyValue & "'" Now it asks me to give a parameter for Reporting_Month. When I type in something it comes the Runtime Error 3037: Operation must use an updateable query. Somehow it doesn't recognize this MyValue variable...

Thanks for the quick respons Paul, unfortunately it's still not working. I've tried both also without the red signs.

Dear all, I got the following issue: I imported a Table named Temp with a Import Button. During the import I asked the USER to give also a reporting month as a variable MyValue (String). Data Table has a blank column named reporting month. How can I fill this column in this table Temp out of...

Thanks, now it works out. I will try now the Public Variable declaration Thanks again.

Hello Paul Eugin, first of all thanks for the quick answer. However it doesn't work out yet. Now it asks me to give a parameter for Actual_TNS_102013.Quantity and then for Actual_TNS_MyValue.Quantity Any idea how I can use this MyValue in a different Module, don't wanna to blow up the...

Dear all, I'm a greenhorn belongs to Access VBA. My intention was that a user can select a reporting month, then to select the import a file, which is saved as ACTUAL_TNS_MyValue. So far so good everything works. However if I want to work with this table through SQL UPDATE I can't reference to...