Search results

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.

it seems you just copied all the code direct into your form without internalising it. Any way,Here we go... Try to first remove all the Error Trapping and All the Code that calls the macro. Also replace ID in the WHERE clauses with the Unique Identifier of the table tblAssetMain. Replace...

ohh my my...it seems that you never tried the solution i posted. Try it out GarageFlower. That implies that if it jams, i will need your vb code snippet, but you can also post your SQl statement.

Is your Menu Bar There? If not then Behind that command button, try this. Application.CommandBars("Menu Bar").Enabled = True DoCmd.ShowToolbar "Menu Bar", acToolbarYes Dim i As Integer For i = 1 To Application.CommandBars("Menu Bar").Controls.Count Application.CommandBars("Menu...

Nothing is impossible in Access. Go to the Property options of the form you want to open and put the Popup option to Yes. From Your Button Open your form as normal. You dont even need to move the sizes.

But pikou, even if you unchecked every thing in the startup options. There would be no problem. Press the shift key and Click to open your DB, then try to put a startup form(Display Form/Page). Or post some thing small.