Recent content by NormDuffy

I use a similar piece of code that writes the errors to a table. I was looking for something simple like function.name or procedure.name or module.name just like you have App.Name or Err.Source. It would make programming much easier if all things were consistent. :) Often the question is do you...

Hi Guys Thanks for the feedback but perhaps I should explain a little more of what I was doing. The following code was my original code which works great if the objects are modules tables etc but Access97 has problems if you tray and copy a form that already exists. It generates an error and...

Sometimes access for reasons unknown will refuse to run some code on a form even if there are no errors in the code. I have found that it often solves these problems if I create a new database and import all the objects. Doing this on a regular basis during developement of large and complex...

I need to copy several objects to other databases. I have managed to do this but experience errors if the object already exists. The code below is a modified sample from Microsoft and it works, in that it deletes the object before the copy but it uses the OpenCurrentDatabase method to do...

Almost 2 years later but that Environ() function is priceless to me. So simple but so usefull. Thanks heaps

All should work but I think the IsLoaded() function will suit my needs the best. I knew I had seen the function somewhere. It is in the NorthWind sample database. Thanks everyone for the feedback.

I need to check if a form is already open. If it's not, I need to open it, otherwise carry on to the next step. I just need to know if there is a simple way to tell if it is open.

That would work but sendkeys is messy and sometimes the keys can be sent to the wrong menu/object and sometimes even to the wrong application if the user happens to alt tab or something during the running of the code. I would expect to find some property that could be set with a simple command...

I want to activate this option with vba code so I can show and hide some hidden tables forms modules etc. I hide some things so users are not tempted to play but I want to make them available to some users but hidden from others. Thanks Norm

* Reason I am using a 2nd DB is because I have to compact the the original DB to the local drive for efficent running. (this I have to do while the DB is closed). -- 2nd DB I am only using because I don't know of any other way to achieve this process. If all you need to do is compact the...

Thanks. That works. I thought there would be a sinmple way to do it but I searched through access help for ages and couldn't find it. Thanks again

Ok there has to be a way to do it but I can't find one. All I need to do is maximise Access when it opens. I can Maximize any window within acess but how do I Maximize the window for the whole application

Thanks Andrew I had considered this but it also apears difficult to rename a field. To keep the existing field name this action would require a new field to be created then updated to the old ID numbers. Then I would need to delete the old field and create a new one with the same name and then...

You may find this helpfull as a start. The qryElectronicCopiesOfPublication is a make table query that produces a table of only those on the database that have a valid email address. It creats 3 fields, the first is the email address and the others are the subject and body which it gets from...

I have a need to change an autonumber field in a table to a long integer type then to add another autonumber field as a key field. I can't find a way to change the field type. I can delete the field and add a new one which works great but I need to change the existing field properties first...