Search results

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...

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...

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...

Hy, We are working on a system to have the current vehicle status in our Access DB. The Idea is that the Drivers send us a Email (over the Navigation system on board) to a specific Email adress. Our DB reads the Inbox of that Emailadress and changes the Status of the Vehicle. The Emails, for...

Hy, I´m Trying to link the Outlook Kalender with Accesss. It can be done with the Extern data..... but when i link the Kalender Folder of Outlook I bekome a Kalender Table that hase the strukture like a Email Inbox :confused: with Subject, Body and sucht things. Is there a way to get the...

Hy, I´m working on the integration of our Access Db with Outlook and i figuret out how to do the most things :) but I have problems with creating appointments and contacts in specific Outlook Accounts (Its not about shared calenders or contact folders). I searched the Forum for the solution...

Hy, I have somekind of a Problem. The situation: I made a DB for our traffic disponents. They have 2 Main Terminals. Because of that there are two groups of Disponents. One is working on the first and the other on the second Terminal. Why am I saing this? Well. At the begining we had two...

Hy, Before several weeks i was tring to make a Form that looks like a Calender. During the proces of making it myself i fount this Form on the www: https://docs.google.com/open?id=0B6KQHxRvyHa0VzFGU2FpajRkOUk It works like it should but it has a error when changing the month :( Can someone help?

Hy, Is it possible to create a report that looks like a calender and that contains data for each date (if data is entered for that date)? If it is posible, how to make one? THX

Hy, I use this code to calculate the length of a SMS message. Me.Txtlange = Len(Nz(Me.SMStxt, 0)) But what event should I take to calculate it in real time when the user tipes in the message? I tried afterupdate, on change and other but it just calculates the lenght when the user press enter...

Hallo, I have to make a report where is a field with a Country name. Sometimes in the report there will be only one Country and sometimes more. The report has to make a automatic letter with the sentecne: "This report is for Slowenia, Italy and Germany" So if there is only one country it...

Good morning, We use a access application in our logistic company. One of our customers wants to have status information for his packages and he wants them in xml. We can export a xml file with the status information from our access app. At first the plan was to send them the xml file over...

Hallo, I have made a Access app that reads the Subject or the Message from my Gmail Inbox. It uses linked tables with outlook where the gmail account is set up. The app has to work 24/7 :( sometimes outlok crashes because of to many simulatneus requests. Sometames the app crashes or doesn´t do...

Hallo, Eveywhere on the Net I read that the bast way to run a MS Access application is to split it and to save the BE on a network and the FE on a local PC. OK. I have a application that is splitet from the begining but at the first months it was runing FE and BE from a network and i had no...

Hallo, Can I remove the warning message that aperas when the accdr file opens on a network? (Warning should be in the attachment) The mesage is very anoing :banghead: thx

Hallo, I searched over the net for ways to upload files from MS Access with VBA to an FTP server. The most solutions are about to use an Batch file that does that and call it from Access with a shell funktion. That won't be a problem but I´m just wondering if there is a newer threat to do that...

Hallo, is there a way to create linked tables to a MS Exchange Server without having Outlook open?

Is tehere a sample plan, method or something showing the best way to update a multyuser Access application. There could be thousands of solutions and i have some couple of Ideas how to make it but I don´t want to invent the weal again :banghead: THX