Search results

Hi there, I got a question regarding te following. I am trying to make a running count in a query That should look like thise. Year Qourter Company Customers Wholesale Value Running Count 2009 Q1 15103 Customer 1 € 7.027,64 1 2009 Q1 15103 Customer 2 € 5.205,01 2 2009 Q1 15103 Customer 3 €...

Hello, I have a question on a Database I'am building. I need to make a Query that wil Compare Current YTD against Last YTD with Budgets and Outlook until End of Year, I have got one query that is showing Current YTD Fields like Dealer Gross Value Customer Margin Invoice Value our Margin or...

I am building a tool, This is wat is has to do. the usser can import anny data. this works fine. after that the usser has select wat to do with te data. like a consolidation on artikel ore week. year.. so the tool has to be dynamic. I know how to do the importing and make the query's but...

I only want the active screen on the toolbar. and all other screens like the DB screen and forms that are not active to be hidden on the toolbar. I hope you can understand it. else i wil make a screendump of what i want.

I am trying to make a module. that wil change the collor of any lable that is been selected with the mouse. Public Function lblBackcollor(optie As String) Dim hoverColor, leaveColor As Long hoverColor = RGB(255, 255, 0) leaveColor = "12632256" If optie = "1" Then hoverColor ElseIf optie =...

Hello, I am having a problem I have a few repports in excel and those have some sensitive data dat never ever is allowd to make a hard copy. i protected the sheets against selecting and copy. but no I need to protect a smal range of the repport to be protected against printing. like the rows...

Hello, I am working on a speedometer with a range setting. normal it would start at 0 but in this case the setof should be 80 only the values between the 80 ancd 110 should be visible. but fore some reason i ca'nt find the answer richt now. Can annyone help with this ?

In the company whe are migrating from NT4 with Access 97 to a XP And office 2003 enviroment. This couses some serrius Isues. one of them richt no is a Multi usser DB. 2 systems of XP and only one of them is able to run the DB. both instalations are the same. ... the DB is tested on more XP...

Good morning, I am having some kind of problem. A query in Acces that is used to find results in the DB is asking 2 time's te input. And there is no way that the input boxes is asking to do this twice.. here is the Query, SELECT tblHotlines.Hotlinenummer, tblHotlines.Vestigingsnummer...

Good morning/afternoon or evening, What is the best way to set up a global error handeling. We want to build 1 module that would handel all kind of error's like msgbox if input is not ok. Or yust 1 function is chrashing becouse somting is wrong. Whe whant to repport those errors in 1 Table. so...

I was wondering if it would be posible to add a wallpaper to the background of the MS access program. I am ussing Access 97

I' m trying to compare a value in the import table against a value in a other table to check if this dealer is already is imported. AantalRec = aantal("Tmp_Import") MsgBox (AantalRec) For i = 1 To AantalRec SQLQ1 = "SELECT Tmp_Import.[Dealernummer Vestiging]FROM TblDealer INNER JOIN...

I'am working on a existing Database in Access 97 and me was asked to build a Import function fore this database. The importing function is not the problem and this is already working. No i'am strugeling to get the validation of this data. Whe have a Excisting form where whe manual enter the...

I got a dataset and I am genarating a report. I need the sum of a qry <3 years and 4 years 5 years and older than >12 years But it is kind of dificult to put this in 1 qry. Is it posible to make that kind of Qry in Access ?? Data is like Years v1 v2 .... 0 32 45 1 12 42...

Ok I already wrote a macro to import xls files from a local ore remote dir. but no I want to keep record of files that where imported to the Database. And I dont want to upload files that already are in the DB. Becouse this is going to be a automated process on a daily basis. I alsow need a...