Search results for query: *

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

Before converting the data to upper case or using masks to do it always ask the question. What if I want it in the correct case afterwards. It is easy to display the data in uppercase or lower case but extremely difficult to fix case problems at a later date. A little piece of code that i use...

Simple way is to create an append query and type the missing autonumber in the field name. Works great and is so simple and easy.

Ok you have an answer to the question of how to find a space in a string. Once you have found it, you normally want to do something based on that information. This is a piece of code I have written to strip off a word from the start of a string. I have some others that takes the end, middle, and...