Recent content by airtabaki

Hello, I've got a project where I have to place a lot of identic installations over Belgium, now I have a table where I have stored all this installations: table: SITES key: SITE ID (here in I have also stored from when an installation was fully operational) Now I have another table with all...

Hello, I've got a mainform with there in some tabform; on some of these tab forms I've placed a tabular subform. What is now my problem; each time I open a tabForm with a tabular subform, my mainform scrolls down like only the tabular subform is visible. Is there a way to stop this

Hi, I have an access databank where I store some info. Now every week I need to have an update from 3 people of these info. What I have made is a querry that filters only the data that has to be updated; Now those 3 people can't work with Access. So I run the Querry and I copy - paste it to...

I've decided to foresee every report I have with the logo of my company. After adapting the first report my Database turned from 2 Mb into 15Mb, and my report turned really slow. It is not that I want to create it dynamically, it's rather the Word header functionality that I need on my reports...

HELP!! I've kind of the same problem, only I won't reach to a solution... can you help me? I've got the following phrase in my program: DoCmd.OpenReport stDocName, acViewPreview, "([SITE ID]= '002')" Normally this filter should work, because [SITE ID] is a member of the table SITES, but in...

RAC2, your solution works perfectly. Thank you very much. PHV, although the dates on the screen look the same, the data behind isn't the same. The counter will always see different records; this function won't work. But it was nice to learn. Thank you both very much

I have an Acces Databank where I store all the installations of our products. So I have a table named SITE (Primary key: SITE ID) where I store all the info of all the different locations where I have to install my products. Then for each site there could be some problems. This I store in my...

I've got a project in different phases. Now I don't really have a start day and a finsh day of each fase. But I know how long each fase takes and I know the amount of days between the beginning of each fase and the beginning of the project(which I don't know either) SO I've made a milepoint...

I work in a company where we buy with order forms (on paper). When I want to order something with a company, I've got to fill in such a paper: the coordinates of the company, the delivery adress, the parts you want to buy with their price and finally the total price. This system becomes really...

Hi, I've made a database and I wanted to create some reports. But he doesn't want to open my report neither in design vieuw, neither in print previeuw. The error message is "Printer unavailable". But my printer is as ready as can be (tested with other programs). So I took another default...

I have a database where all the info of my suppliers is stored. In our company we use special excel sheets to order some stuff. Till now we allways have to write down the adress of the suppliers on the excel sheet each time we want to order something. I want to optimise this system in Acces...

I have a simple database where I store all the adresses of all the people I know. Now I want to send a letter to all those people and I want to make a report that creates the adress labels on my envelop. Therefor I use special paper, but it's a bit expensive. So I want to print more adress...

I want to create a shortcut in my Excel sheet, so when I klick on it my excel file will open this file in my mediaplayer

I meant it a bit diffrent, but the code you gave me helped me to find the solution, thanks

I have a really simple question for programmers I think, I want to insert copies of an existant worksheet in my workbook by using VBA. Can any one help me please with the right fonctions.