Search results for query: *

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

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

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

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

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

I have a VBA UserForm in my Access 2003 database which displays the time elapsed. currently i have only coded it for hh mm ss (hours minutes seconds) I need the label to display the time as it elapses in the format 00:00:00:00 (hours minutes seconds and fractions of seconds ie 100ths of seconds...

I have an MS ACCESS 2002 database with a UserForm code as follows Option Compare Database Option Explicit Private Type POINTAPI x As Long y As Long End Type Private Type RECT Left As Long Top As Long Right As Long Bottom As Long End Type Private Type GUID Data1 As...

I Can’t get the Open File Dialog by Ken Getz to work in multiselect for large numbers of files. To be more precise it works, or at least I can’t seem to raise an error, when the multiselect flag is not used ie selecting a single file. It too works in multiselect for small number of files say 6...

I need help from someone with good VB/VBA knowledge to help edit/convert this code so that it compiles, is compatible and works in Access 2003. It fails to compile on the highlighted line? Option Compare Database Option Explicit Private Type CWPSTRUCT lParam As Long...

Can anyone help with the exact reverse of the following line. I tried inserting Not ! but i think I must be putting it in wrong place. if (email.indexOf("@") < 1 || email.lastIndexOf(".") < email.indexOf("@") + 2 || email.lastIndexOf(".") + 2 >= email.length) { alert ("I need this to show...

this is my code so far it finds all the manual page breaks in the file it is run on and splits them copying them into separate new files. the problem is the last page or pages that follow the final manual page break are not included. Option Explicit 'This goes in the Declarations section of...

I am trying to run the following batch file from a folder. The folder also contains the ffmpeg exe and any mp3 files and a subfolder named ‘files’. ffmpeg -f concat -i <( for f in *.mp3; do echo "file '$(pwd)/$f'"; done ) "files\concat.mp3” What should happen is whichever folder I choose to...

These are the form settings: Close Button = Yes ControlBox = Yes BorderStyle = Dialog MaxMinBitton = None The above setting gives me the Close button (X) but also the form ControlBox. If I change the settings to: Close Button = Yes ControlBox = No BorderStyle = Dialog MaxMinBitton = None...

The following code creates a popup menu with 7 options 1x, 1.5x etc. How do I create the following behavior… set one option, say 2x, to a variable as checked when the menu is first created and then when you click on another it becomes the only checked one and passes a value to the variable...

I have a Windows media player control, named windowsmediaplayer1, on an Access 2003 form. In the code I have Dim WMP as Object (have tried WindowsMediaPlayer with reference to OCX). I’m trying to remove 1) All playlists 2) Selected playlists (ie ones which I name) Have tried the following...

I have the following code which loops through one or more files and copys audio mp3 from mp4 files using ffmpeg. The code works but the problem is it opens a new ffmpeg window process for each file it processes and this is not good. Can any one show me how to do this in just one process ie one...

Can any one help me with ms access 2003 vba code to pull bonjour bonjour, bonjour. Bonjour from the following string. Note the code will need to allow for any combination of words and any number of periods (.) {"sentences":[{"trans":"bonjour bonjour, bonjour. ","orig":"good morning good...