Search results

Probably a stupid question - but Is there a quick way to determine in code if a user is using Full version Access or Access Runtime Thanks

Probably a silly question - just me be lazy - is there a simple way to convert a MDA security file (Access V2) to an MDW (Access 97). Without having to retype all the groups, user names - import everything ..... I have inheritted an OLD (!!) database which was originnaly Access V2 - was...

Help - need to draw a table in access using verticle lines drawn dynamically at report run time using the On-Page event. Trouble is I don't know the verticle length in advance. I can use a verticle 'bottom' value = 18.3 to draw a line to just above my footer, but need it to stop at bottom of...

I know that it should be simple but I have a mental block today (like most days) I want to output the contents of a text field on a report - but to enclose it in brackets. I could use the format = (@@@@@) - but I do not know how long the text value is beforhand. Is there a simple way ...

Help please ! Trying to poke values into a Excel spreadsheet from Access table using OLE. Everything works fine (for several months)- software rolled out. But suddenly it has stopped working part way through the access table. I get an Error #1004. Anybody know what this error is? I can't...

Help please! I want to use the "Office Assistant - Balloon object" to promt users for a selection and run the apprpriate code. The following routine works upto a point but I have a problem with the 'Cancel' button. If the user selects a check box then Clicks "Cancel" it still runs as if the...

I am working on a database created by another person - who has long since departed. Most of the time its fine - but every now and again the cursor will play up when I am editing in the VBA code modules - the cursor just keeps back-spacing and deleting any spaces in the line I am editing. If I...

I am trying to modify an old database which as been converted to Access 97 but which was originaly coded by somebody else. He used the ".DefaultEditing" property in many places and I wish to convert to the new Access 97 equivalent commands - but its difficult to know what my predecessor was...