Search results

Folks, i have a report that i designed to capture some detailed information and my users say its too detailed and they cant use it that way,so they want it scaled down to that very brief format as in the attached pdf file.I conquer with them but i cant seem get beyond what i did as every table...

Yap... Check this out.

Yap...i guess thats why i am reaping some pain~ in the a**. The DB has lasted for some time now and it captures lots and lots of staff, that i had to develop other separate dBs and just link them to it. i think you get the picture...

Thanks Pat,i guess when you see a db that looks de-normalised, it implies that once...at some time,normalisation had been carried out. Putting the FieldOfficeID in the contacts table is a very very good idea from you....and i think i have been overlooking it. I will give it a go,only that i...

No no no, thanks neileg and Len Boorman but your ideas kept me lingering about my db normalisation scheme which was not worth the time spent. The only thing i had to do was to change my query to look as in the image.That gave me the results i wanted.

rahulgty, In your VBA, i have had no glance at any bypass to A03 Macro Security!!! Why the post. Ghudson. Thanks for the regedit workarounds.It works fine both in access and Excel. I personally use WISE to package every thing.

Thanks ghudson for that ray of hope.Let me try to search again.

No it doesnt work. I simply dont want users of my applications to manualy go ahead and set security levels time and again since i create my applications with customised menubars and toolbars or without any.

Has any one found out a way to change Macro Security Levels!! Microsoft seems to have kept this as a secret. The code below given in the help files doesnt function. Application.AutomationSecurity = 1 or Application.AutomationSecurity = msoAutomationSecurityLow

Thanks. I will give that a go.

Thanks very much Neileg. As i quoted before, the question would be hard for any one to understand. Anyway the work districts bieng in the same table make it look de-normalised but thats the way it has to be because some of the guys work in more than one district or rather field Office. As per...

Attached is a sample of my db with tables,queries and a report. The Problem is deep but i will try to explain. Some of the contacts work in more than one field office implying that they work in either Work_District1 or Work_District1 or Work_District1 or two of them or three of them.(e.g Mr...

I was wondering, if there is any way i can develop my Geodatabase without the need for ArcEditor or ArcInfo?? I have just recieved my arcGIS 9.1 but it only came as ArcView(standalone licensee). I have been going through the geodatabase tutorial but i cant edit(i need more extra licensing) any...

Got it from here

Reason out the logic behind this chocolate Math!!! It tells your Age. :D 1) Pick the number of times you would like to have chocolate in a week(It should be more than 1 and less than 10). 2) Multiply the number by 2(Just to be bold) 3) Add 5 to it. 4) Multiply the result by 50 (I will wait...

Yes you need alot to change in there.I gave you the solution but if you just go and paste all that code in your project as it is, it wont work, thats why you need to internalise it and change where change is necessary. I changed alot of things about the names of the fields and form controls. May...

I tested it and It Does...GarageFlower. Be slow and internalise all i have done. And make sure that you have put in Data in the tblAssetsMain and Related records in the corresponding tables(tblEmployees and tblLocations) then see the output.

You just NEED INSERT,UPDATE and DELETE QUERIES under that command button. But i have some guidings for you below. I have attched a sample but i had to go deep into correcting your tables and Relationships. In your code page, goto Tools--->References---Microsoft DAO 3.6 Object Library. Select...

I have never dared for ADO in Access, since i know it does the same tasks in almost the same time frame with DAO. But i use ADO.NET in my .NET applications GarageFlower,attched is what i think you want and guided in the Code comments.

Here is an example. Inform me if it helped.