Search results for query: *

I have put a drop down list based on a query on my data access page. The field displays the results of the query fine, however it will not let me add or edit any new text, you can do this on a normal form! Any help would be very much appreciated. I use Access 2002.

I have created a drop down list from a query and placed it on my data Access page. The query is based on a field on my table. It shows the query results but I can't add any new text to the field which I need to do. Can anyone help? What properties do I need to change? The query must then update...

Hi, I have created an Data Access Page in Access 2002. When I put the page on my external web space it does not work. I have tried putting the database on my web space too and changed the connection string of the data access page to point to the web url of the database. I know the path name is...

Sorry i hit the reply button by mistake

Hello, I had the exact same propblem. Basically the code is fine but runtime error 5981 means that the permissions settings for the word documents or the folder that they are in restrict saving/opening/creating etc. What you can do is go on to all related folders and change the permission...

Thanks i thought that may be the case but never mind. Thanks for your time anyway.

You could by the learning addition and depending on how good you are at coding you could use automation techniques to make excel do the chart and graph work. I know it can be done because i have done it myself. Im positive also that this website will help you if you do get stuck on code or even...

This can be modified to do what you want. 'Dim objects and variables Dim objWord As Object Dim strFile As String Dim strSaveAsFile As String 'Grab the Document name strFile = "\\universal4\databases\RAD\Templates Assessment Forms\Temp For Work Equipment Risk Assessment.doc" 'Launch...

Why dont you make a query? You could place all the fields you want to search by. For each or for several fields criteria you could put this [Enter Customer Name]. This Would siplay all the records matching what the user inputs into the query. It would take alot of programming and i mean alot to...

The mde database that i have has a form that we need but but we cant copy it to another mdb database because we have restricted access because its in mde format. HELP!!!!!!!!!! Thanks in advance Andy:-9

Scrap the way your doing it now. There is a feature in Access which is built in. Go on to the tools menu and then on security. Use the user level security wizard to set up accounts for your database for the different users of it. hope this is of help Andy:-9

You would certainly stop your database from crashing by converting it to access 2000. however i would recommend access 97 as access 2000 is relativley new and there are many annoying bugs not yet rectified yet. Go for 97 for a safe bet not only to make your database more stable but to make it...

AllformS.visible = true

Its not possible unless you download some patch code from download.com

simply no

Try Creating A query. In The Unique ID field Criteria Type [Enter Unique Id] Put the rest of the fields in the query and Save it. Then select the query and select autoform. Therefore everytime someone opens this form they will be asked for the unique ID. Only records mathing that number will be...

The message implys that code in your module is incorrect. Most likely the link to your forms has an invalid path. Try resetting the path and see what happens. Andy :-9

Make a new field in a query called No Of Days. Try linking this Query For the field named Date Due. In the Query criteria field for the No. Of Days field type [Enter No. of days]+Date() Make this field not showing. Put the rest of the fields in the query to show all the required records. Andy :-9

Run a module code to make the properties of the web toolbar to = false :-9

Does anybody know any code on: only quit an active documnent after the print jobs have finished. Currently my code does this. It opens a document prints it and quits word. However an error message occurs which says do you want to quit before printing is complete. Hope this is clear Andy Thanks...