Search results for query: *

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

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

I've got a table "Person" with the data of a person: Every person has a first name and a last name (2 primary keys of that table) Then I have a bound table "Project" where each project is specified. It has 2 bound fields, "responable project first name" and "responsable project last name". Each...

Probably it's been written before in here but I don't seem to find any that has to do with my little problem. I've written a macro that will make a sum of certain columns. Now when there is one value that is not a number the macro will crash. Is there an easy way to test of the data are all...

ActiveSheet.usedRange.count: Excel counts the used cells, I need to count the used rows. Is there a performant method to count the used rows... Or even better is there a way to find out in a performant way the largest rownumber of all the used cells

I 'm a contractor and often I make Excel sheets to handle the specifications of a project. These files have the folowing form: Nr/ Description work/ unity/ number/ price/ total price under this heading there are a 5000 rows for instance: 01/ installation / h / 5 / 28€ / 140€ 02/...

I've written some procedures who are called by the worksheet_changed event. I'm having problems with these events. Often they won't work no more and I don't know what could be the problem. Only when I close excel I can get them to work again. Even after just closing the I file it doesn't work...

My worksheet has to react when there is a change in the worksheet. This reaction is an adaptation of 3 fields. So I thought I use the event "on worksheet_change". Now my problem: the event will also occur when the worksheet is changed by the visual basic (3 times per change)... so my...

I have an Excel page where I've specified a print area and a pageheading. Now I've put an automatic filter on my data. When I want to print my FILTERED data the printer prints my data but prints also some other empty pages (with their heading) When I print my NON FILTERED page, he prints just as...

I'm counting a total in the footer of my report. Because it is a total with special conditions and calculations I'm making it in VBA. Now I'm having problems with couting the totals: Every time I count these records two times. Now I've readen the manual and the forum and I've discovered that it...