Search results

Thanks GHudson No luck yet, and it's getting to be a big problem. I'm hoping to find a way to capture errors globally, if they are not picked up within the specific module running when they occur. I have gone through your suggestions and: 1) It isn't possible to run the application in the...

Hello I've developed an Access database with lots of VBA code. I've just gotten to the stage of deploying it on users' computers running with Access Runtime. Clicking form buttons to run certain routines causes an error, and the generic error message "Execution of this application has stopped...

Thanks Pat I can certainly do that, although I'd like to keep the number of required files to a minimum if possible But is there another solution, or is this a known bug? I can't believe that embedding an image would add so many times its own size to the db. While writing this reply I just...

Hi I have a recurring problem when I add an image as a background to a form in Access 2000. The graphics file may be 100k or 200k on disk, but when added, the size of the .mdb file blows out by as much as 10Mb! As a result I gave up on it, and have a very functional, but boring looking...

Hi Key I just had a quick try, and changed the field names in a table using the following code. Thus uses DAO, the older way to handle data in Access. I haven't tried using ADO. Trying to change the data type in the same way resulted in an error. -------------------------------- Sub...

Hello I have a subform which is displayed in continuous format. For this problem though, I think it would be the same if it was a form, not a subform. Depending on the value of each record, I want to display different controls. For example, a combo box to set the value of a given field...

Brad Like you, I am no expert with SQL. When I have trouble with SQL code in Access, I copy the code, start a new Access query, and post the SQL code into the SQL view. You can then view it in the normal query design view. You will then either a) see what it is trying to do (in comparison to...

MSOffice Developer - VBA Productivity Tools Hello I have just installed Microsoft Office 2000 Developer on my machine. Office Developer includes all the usual Office programs, as well as a range of tools and code samples to help software developers working with office. The problem I'm...

DoH! Should have guessed that. thanks Dan

Hello A simple question today. The DoCmd.OpenForm command has 4 view options to open the form" acDesign acFormDS acNormal (default) acPreview Does anyone know what acFormDS stands for? I haven't been able to find an explanation in the online help or via the object browser. thanks Dan

Hi I'm not impressed with the printout that you get by selecting print in the Visual Basic editor in Access 2000. It prints the code with no margins at all, right up to the page edge. For Microsoft, I'm surprised that I don't even get the basic layout options that you'd find in NotePad or...

Hello all A couple of questions about DAO recordsets on which I'd love your help.. Firstly, how can I create a recordset which is based on the contents of a table but is not 'bound' to the table. I want to be able to delete records from the recordset without affecting the source table...

Thanks very much Pat & Alex Alex your code was very useful, and Pat that advice will save me lots of trouble down the track. I have changed approach, so the function to automatically populate the form with controls will only be used to update the forms, not in everyday use. cheers Dan

Hello I am developing an Access 2000 application in which forms are altered dynamically based on options chosen by the user. The CreateObject Function places checkboxes and other objects on a form, and this works fine. The key line of code is: Set ctlCheck = CreateControl(frm.Name...