Recent content by baloos

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

I have used MS Access 2000 to develop this application. From experience, I have in past developments experienced random and seemingly untraceable errors, 1571 errors for example, other corruptions, and problems associated with the Project file becoming detached from the application, where you...

Thanks Paul, I have opened the log files. Nothing showing for the time that the application shut down, so, where do I go from here?? All the user's machines have Access 2000. Is it worth converting it to Access 2003, and using developer extensions, to release it to the client as a run time...

Doc Man, My client asked their IT people for the event logs, after another crash. The IT department sent them three fiiles.. sec020407.evt evt020407.evt sys020407.evt I have tried to open them using Wordpad, but it is all gobldygook! Is there a viewer application that will make sense of...

No. It is not running as an MDE. Thanks for replying though. I will appreciate any suggestions.

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

After further investigation on my part it seems that there are at least three different types of error that I need to cater for. DAO errors which can be referenced by the DBEngine.errors collection (and can contain more than one description). VBA errors who's description can be referenced by...

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

Actually, there is one more thing. If possible I need to pass this function an initial folder path. So that the dialog opens with a path pre-selected. Do you know how I might do that ?

That's great. Thanks for your help.

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