Search results

Hi, I want my query to output an address in one field with carriage returns, where the address lines in the source table are held in individual fields. So I try... SELECT [Address1] & Chr$(13) & [Address2] & Chr$(13) & [Address3] etc.. This does not work. However, if I use a text box on a...

Hi, I am releasing a Runtime Access 2003 application. Am using the standard files ACCESSRT.MSI and ACCESSRT.CAB to install Runtime. Does anybody know a QUICK way of supressing the annoying security messages which pop up, when the application starts under this configuration? I don't want to...

Help ! The MS Access 2000 application I have developed for my remote client, when deployed, occasionally shutsdown with no error message and no clue as to why. There is no common pattern that I can establish. Compact and Repair makes no difference. Have tried re-writing objects that I suspect...

In my error handling I am referencing the DBengine.Errors collection to write trapped errors to a table, but it seems that some of the errors I trap are not included in this collection. :confused: I have noticed that errors which can be referenced by the DBengine.Errors collection have in...

Hi, Access 2000. I get error 2306 when using Docmd.OutputTo "There are too many rows to output, based on the limitation specified by the output format or by " my database. 19k rows to export. I am able to do this manually using the Export menu, but I need to do this programatically. What...

Hi, In my Access 2000 application, Alt Keys work correctly on command buttons on my forms, but on the menu they only seem to work intermittently. I cannot establish common circumstances in which they do or dont work. Any ideas apppreciated. Thank you.

Hi, I have the Cycle property set to 'Current Record' on my Forms, and so when you Tab, you cannot Tab into a New record. However if you use the Mouse Wheel, the form will still roll into a new record. I have generic code which allows my forms to be used for adding as well as editing...

I am trying to present a dialog box allowing my users to select a folder. Easy in Access 2k, xp, but in 97 am struggling. I don't think I can use CommonDialog control, because this appears to force them to select a file (not a folder). Is there an API call ? Any help appreciated, thanks

I am launching Windows Explorer from within my Access application, using the Shell command. Is there anyway that I can ensure that Explorer opens with the "Details" view in effect. I can find no documentation that refers to command-line options for Explorer. Any help would be appreciated...

I have lost the default Menu Bar from my installation of Access XP. I have tried repairing it. I have tried uninstalling and re-installing Access XP. I have even tried uninstalling and re-installing Office XP and still no Menu Bar. Other Office XP apps are fine. I am tearing my hair out here...

Thanks to those people who kindly helped me with my Launching Word problem. I have an Access 97 app which has been running fine, until I installed it on Win XP. When using .Execute() with Application.Filesearch I get the following error... Run-time error '-2144010224 (80350010)': Method...

Hi, I need to open a Word document from my Access 2k application. If I use the Shell function, it seems that I must specify the Path to Winword. My app may be installed on other computers where the Winword path wont always be the same. Is there a way of executing Word (where ever it is) or of...