Search results

Hi, Can anyone tell me why it is that when i have written a DB on one machine using Access 2003 and then subsequently put that DB on to another machine i get an error relating to unsafe expressions? why does this happen and is there a away in which can stop this error message from appearing...

Hi to one and all, I am a newbie to this site as i am trying to learn more about access. However I do build and run a few Websites and one of them has a Bulletin Board. I have email verification enabled upon this which ensures the address is real. The Password to gain access to the site for...

I have previousely looked at this DB but it does not have the ability to show multiple images on one form from one record. My form will have anything from one image up to Eight images all coming from one record! It is my hope that it is possible to show all 8 at the same time. Bev

The way to do this is with a report. Write your standard letter as you would in word but leave the customer specific detail out. Put this data intot he body of the report in design view. You now need to add text boxes that are linked to the records in question. this will print your standard...

Hi, I too do not know how to use VBA, there is however a Microsoft Press book called Access 2000 VBA that can be obtained from the microsoft webiste. Unfortunately i have not yet found the same for Access 2003. Hope this helps Bev

Hi all, Firstly may I thank all of you in advance for looking at my thread and helping me if you can. I have created a DB that has one table that is imported from a .CSV file with approximately 2000 records. There are a few forms that are used to view the results of Query's because I am using...

just another message to see if anyone has come up with a solution for me? or any guidance to where i may find a solution? Thank you again Bev

I am happy with the button being on a form and i am happy that the code works. What i am saying is that once i have entered the password to unlock the shift key, It DOES NOT revert to being locked afterwards unless i access the button again and input an incorrect password. Bev

Hi Eric, I have just een doing exactly what you are trying and indeed i was trying to use a Macro. Thanks to a chap from this forum i have got my DB working fantastically but i used an OnClick event procedure instead of a macro to do the work! and i take my data directly from a .CSV file and...

I have seen this before and many similar examples that are either on this site or another. However it is not quite what i am looking for. I may have up to 8 different images per record and i would like to show all 8 at the same time when viewing this record. here is a screen shot of what i...

More Info, I have just been trying a few things and have come across the following: If I select the command button and enter the correct password then the DB will allow me to bypass the Startup options every time I opent he DB. However if i then click ont he command button again and enter an...

Hi, I have used the code and when I click on my command button I am prompted to enter the password as directed. my problem is that I can still hold down the shift key to bypass the startup form? Please advise me what it is that I am doing wrong? Thankyou Bev.

In addition to the above, take a look at Ghudsons thread with regards to disabling the Shift keyon startup. it seems wuite popular. http://www.access-programmers.co.uk/forums/showthread.php?t=36043&highlight=Disable+SHIFT+open Bev

Hi, I have just come across your thread and would liek to guide you to another post on this site that i have used and found verry usefull. If you use this code, then when you open your DB you will not see the DB window at all! this way the end user cannot use any of the toolbars or play with...

Hi all, Firstly may I thank all of you in advance for looking at my thread and helping me if you can. I have created a DB that has one table that is imported from a .CSV file with approximately 2000 records. There are a few forms that are used to view the results of Query's because I am using...

:o :o :o :o :o :o OK so now i feel really stupid. Not only am i replying almost immediately to my own post but i have also figured it out! isnt is strange that when you step away from what you have been going at for hours you immediately find the solution? Thank you anyway. Bev

Hi, I thank everyone in advance if they can help me with this. What i would like to do is display the record number on my form in between the record navigation buttons that i have allready added. I can hear poeple now saying, " why dont i display the navigation buttons in the form...

IR MOON, Thank you for your input, i shall give it a try once i have looked at otehr areas of my DB that i would like to finish. Tonys solution has done the trick for me and because when i use my DB i need to ensure that i start with a fresh slate each time then deleting the table is what i...

Tony, I have tried your solutiona nd am pleased to say that it has worked for me :rolleyes: Thank you. I really must start learning more coding instead of relying upon the front end! Thank you again. Bev

Tony, Sorry i have not replied earlier, Thankyou for your solution, I shall try this and see how i get on. I shall let you know if this works for me or not. Thanks Bev