Recent content by Jordan2000

what you could do is set up a table with usernames and premissions and make a colum with a flag if it has to startup when user log on. if you then make a check in a startup procedure you could check if the user has acces and wath screens the database has to open first. hope you understand what...

Thanks, It take a wil to incorperate it but now it is working fine.

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

It is posible that there is just a private sub in 1 of the pages of module. you can get rid of it by opening the VBA developer en look in the project. of the workbook that is generating the message,

Thanks, This wil help me to build the selection form. I want to give the usser a tool so he can select between diferent date's and catogories. and give a average salles between a average week and a action week. i build the query but you know the usser always want to build there one and is not...

The usser has only a runtime version

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 ?

(URL deleted as it is a dead link)

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