Recent content by henkus

This seems like a strange problem that really should work, but don't know why it doesn't... I have a report that's based on a query. The query uses group by functions. Short example: select Itemgroup, count(*) as TotalNr, sum(Turnover) as SumTurnover from Campaign_det group by Itemgroup; The...

I'm not so much asking for guidiance for this specific problem (I can delete on textfield at a time, thus eventually finding the incorrect one, checking the code and fixing it). I'm more asking in general how you error-search in a more effective way in the graphic part of Access. It's so much...

Hello, I have a contionous form with a bunch of textboxes with sum-formulas in the footer (example: "=Sum([PlanAmount])". This has worked like a charm for a long time. After adding a few more sum-boxes, suddenly all the boxes display "#Error", even the ones that worked before. If I remove all...

Control source field in properties of the TextBox /henkus

I suggest having on field in table that holds the price excl. VAT (PriceExclVAT), and one with the VAT (VAT) value (i.e. 0,175 or 0 or whatever). Calculated field then has formula: =[PriceExclVAT]*(1+[VAT]) If you change VAT or Price, the calculated field will instantly update to reflect the...

Hi, I populate a continous form with a bunch of textboxes. Some are from from query, and some are calculations based on the data in the recordset. How do I get Access to present a sum formula of one of the calculated fields? =sum([Box1]) works if [Box1] is in recordset, but not if it's a...

Perfect, thanks! /henkus

I'm checking for things in the afterupdate of the text-box. this event should fire before the insert into DB? Or are you saying I should do things like this in the afterupdate event of the form? Not possible, unfortunally. The form is actually allready a sub-form to a header of te campaign...

Hi, I have a Access 2003 DB, which is split in a backend and a frontend. Backend has two tables (which are relevant for this question): Articles (Artnr, Price and so on) CampaignWeek (Artnr, Week and so on) Artnr in Articles has a 1:N relation to Artnr in CampaignWeek. In a form, which has...

Ok, thanks! I now have a split database, where all users log on to the front with the same username. The front has a tables as links to the backend. The front is quite nicely locked down with the start up options. However, the backend is still open to all users that have access to the front...

Well, basically I'm hiding parts of the table structure from part of the users. I also prefer that the DB should not be openable if copied outside of my company's network... This was a good guideline. I've added everything in it, and also kept my own AD-security. Should make it a lot securer...

Problem is, that all users that have access to the DB use needs to enter this pwd -> could a user that knows te general pwd access columns he's not supposed to see in any way I didn't predict? I.e. I also need to protect parts of the db from certain users. This I've allready done, and this...

Try holding down shift key while opening the DB.

Hi, Acess2003 Multiuser enviroment Objective: Maintain an Access database, which is highly secured for normal users, while still having admin possibilities. Single sign-on would be nice, but I guess not absolutely necessary. Being quite new on Access, but with some experience with VB, I...