Search results for query: *

Hi Duane It was something I was pursuing but having further researched it I believe your comments to be spot on. Sorry for any inconvenience and thank you for taking the time to answer.

Hi Duane When you convert an MDB to an MDE several changes are made, among them are Form and Report menu options are greyed-out and the wizards for creating new Forms and Reports are removed. It is indeed possible to reverse this behavior making those MDE Form and Report menu options NOT...

How can I use vba code and presumable some api to disable / enable all greyed out menu options in ms access 2003 mde database window? So that I can make and save changes in design view to forms and reports and create new forms and reports. I know vba code will not be accessible but that isn’t...

Hello strongm, thankyou for replying and thank you for all your help and advice both now and in the past. As always it’s much appreciated.

Hello strongm > why do you need to hide the application window I trying to develop a db which opens a popup modal form that places its own button in the taskbar and hides the Access window in the process, which is the look that’s requested for this project. The only stumbling point has been...

> The point is that you are still hiding the button. My question is why do you feel you need to do that? I did answer that and also tried to explain what I was doing here: So the main thing is I’m really trying to make the app window hidden, the button thing came about because it didn’t look...

Hello strongm, thanks for replying > why do you need to hide the Access application button whilst the form is showing To be honest and especially having read your explanation, the button approach is no good. It was a poorly thought out alternative to the invisible application window. If I...

Hello strongm and thank you for your reply I have been struggling to solve this flickering for days without success. If some extended windows style for the form won’t solve it and there’s no other way to show the app window invisible that won’t cause flicker then I have only one idea left but I...

With Access 2003 / WinXP I can resize the form / image without flicker (see Form2 in example). But when I hide the Access application window and try the same thing the image flickers (see Form1 in example). Trying to understand and solve the problem I notice the same flicker problem was...

I have an Access 2003 db on win XP. I’m trying to write code that will allow the Access application window to remain visible whilst hiding its taskbar button. To clarify, if necessary, the Access application window visible is its natural state and I don’t want to change that. I just want to...

hank you Andrzejek I will take a look and try to work it out.

I currently have three single arrays working but I would like to replace them with one 3 dimensional array. I have been trying without success for hours. Here is the working code for the three arrays: I need the code to achieve the same thing but using one 3 dimensional array instead of the...

I’m using MS Access 2003 with the WebBrowser control on my Form. When I click command button ‘cmdGo’ the code is supposed to navigate to the ‘URL’ replacing the variables with the values from the appropriate controls on the form. When the page has loaded it should return the ‘result_box’ inner...

>the CallWindowProc is the important hack that allows you to run a function in a DLL - so if LoadLibrary (and GetProcAddress) both succeed, then you need CallWindwoProc (or CreateThread, but that's a more complex call) to run the function Thank you for taking the time to reply to my question...

>Check the value of lb. If it is 0, then LoadLibrary failed. Spot on. Thank you. Am I correct in thinking then that the following and all related code is not needed in my example? Private Declare Function CallWindowProc Lib "user32" Alias "CallWindowProcA" (ByVal lpPrevWndFunc As Long, ByVal...

Thank you strongm for your reply >And your On Error Resume Next has masked where the actual error would arise I removed On Error Resume Next however if I enter an incorrect path or file name whilst no registration / unregistration occurs I still get the "Successful" msgbox when I should get...

I am using DllRegisterServer Entry Point and not regsvr32.exe to register / unregister dll and ocx. I have the following code on my Access 2003 Form. My question and problem is that I can't seem to get the "Unsuccessful" msgbox to work. Let me further explain the code looks right to me, and if...

I Have an Access Database and from it I open a VBA UserForm as modal (which I need), from this UserForm I click a button which opens an Access form as PopUp, Modal, Dialog which opens on Top of the UserForm (which I need and so far sounds OK) The problem is the Access form doesn't seem to stay...

Hi combo Everything I read was pointing that way, just couldn't believe it would be so. Thank you for your help.

I have VBA Userform Listbox in Access 2003 database and I can't work out how to set values for the column headers. I can set columnHeads = True which will show the heads above each column but they are empty ie they have no name in them, how to I put the name in them? I have looked at the...