Recent content by Reflex_ht

For now there are 6 Tables: tbl_DL_Salzburg_2012 tbl_DL_Salzburg_2013 tbl_DL_Munchen_2012 tbl_DL_Munchen_2013 tbl_DL_Ulm_2012 tbl_DL_Ulm_2013 I know now that there is no realy good reason for spliting the table :( but I wrote my first VBA code 9 months ago. I didn´t know it bether :( Because...

Hy, We have a huge Database (relative huge ;) ). Because of that I had to split the database on multiple tables to not lose performance. The main seperation is for every year and Terminal so I have now 6 tables with the same data and structure. Its making maintaining, changes and coding realy...

Hy, This is geting me nutts :banghead: I wrote a samll VBA in Outlok to send SMS messages over a ActiveSync connection beewten the Exchange server and a Phone. The code: Option Explicit Option Compare Text Sub Send_SMS(An As String, Nachricht As String) Dim olBody As String Dim objSMS As...

Thank you stopher :) The code is now like this: Option Explicit Option Compare Text Sub Status() On Error GoTo EH Dim ws As Workspace Dim db As DAO.Database Dim rsD As DAO.Recordset Dim DBEngige As Object Dim SourceMsg As String Dim Message As String Dim MsgCount As Integer Dim DestFolder As...

Hello, Out transport company wants to have a system with Status notifications using mobile phones. The idea: Drivers send an SMS to us with a specific code. The VBA in Outlook reads the SMS, identifies the record in our accdb over a ID and saves data in the accdb. In Outlook we are connected...

Thanks but it didn´t work with that :( even if I manualy export the table and save a export specification. I used a modified version of the Monoceros code and it worked greate :D

Hello, I'm trieng to export a Table to a CSV File. With a VBA like this: DoCmd.TransferText acExportDelim, , "tbl_Tradeshift", "C:\tbl_Tradeshift_CSV" & ".csv", True If I use for Specification "Standard output" I become this Error Message: "Runtime Error 3625" - The Specification "Standard...

Hallo, In the last Weeks we have a huge Problem with our Access DB and I can´t figure out what is wrong :( In a Form (Splitform) that displays data from a Table (it is not linked to another; the recrodsource changes depending on a value in a combo box) records sudently started to disapear...

Hy, We are working on a DB for our Personal. A part of the DB is the Vacation DB. We managed to make the Vacation DB in Access and also have made a Vacation Calender in Access. Now we are becoming Outlook with a Exchange Server :D giving us greate oppertunities. I planed and I know that it is...

OK It done :D and it seams to work :D In the Outlook VBA "ThisOutlookSession" with this code I determinate to run the Status module in Outlook if a new email komes in the Status Folder Inbox. Option Explicit Private WithEvents Items As Outlook.Items Private Sub Application_Startup() Dim...

Thanks :D I´m also to lazy for the Outlook VBA :( I´m not good enough in Access. Going on to Ooutlook VBA would be madnes ;) but learning little parts for just this function would seam to be worth of the "crazy ride" ;) A second Access app is also a "dirty" solution :( This function has to...

Thank you bouth for your suggestions! :) You have greate Ideas! I was also thinking about moving that function somwhere else. Outlook selection: Outlook can also seperate incoming emails into a specific SubFolder. With the Outlook rules it can be made that Outlook moves a "Status" Email into...

AAAAAAAAAAA Crap! I know it was to good to be truth :( The ="*$$*" without the LIKE didn´t recognise the email so that every one was just skiped and of course it then become faster :( It truly is faster than the old code but just slightly. It is remaining in the 10 Emails per second :(...

OK Could not wait to apply all that changes :D and it was worth of it :D I don´t know how to thank you. You realy helped my a lot! Now the code looks like this (in just one module) Option Explicit Public Function Status() 'On Error Resume Next Dim OlApp As Outlook.Application Dim Inbox As...

Thank you :D That kind of sugestionas are those I was Serching for :D I´m working with Acces for 6 Months so I realy have lots of things to learn. At the begining I was happy if my codes just did what i want to. Now with a growing DB the performance becomes more importand. Of course I regret...